[jira] [Created] (DRILL-4947) Multiple inner join drill query fails to return result

["Tushar Pathare (JIRA)" <ji...@apache.org>]

Tushar Pathare created DRILL-4947:
-------------------------------------

             Summary: Multiple inner join drill query fails to return result
                 Key: DRILL-4947
                 URL: https://issues.apache.org/jira/browse/DRILL-4947
             Project: Apache Drill
          Issue Type: Bug
          Components: Execution - RPC, Functions - Drill, Query Planning & Optimization
    Affects Versions: 1.8.0, 1.9.0
         Environment: RHEL 6.4 
32 Cores 256GB RAM
            Reporter: Tushar Pathare
            Priority: Blocker


Huge query fails to return results.
The query is related to a couple of data bases in the ORACLE DB.
We are using ojdbc7.jar as 3rd party jars
The query looks has about 11 inner joins or joins
The Query and Planning page just mentions 
Major fragment showing all the columns 'SENDING'


Minor Fragment ID	Host Name	Start	End	Runtime	Max Records	Max Batches	Last Update	Last Progress	Peak Memory	State
0-0	SENDING	SENDING	SENDING	SENDING	SENDING	SENDING	SENDING	SENDING	SENDING	SENDING


the last log is as below 

016-10-15 15:11:24,924 [27fde379-3cf4-c429-8d42-470f55c5fead:foreman] DEBUG o.a.d.exec.rpc.control.WorkEventBus - Adding fragment status listener for queryId 27fde379-3cf4-c429-8d42-470f55c5fead.
2016-10-15 15:11:24,924 [27fde379-3cf4-c429-8d42-470f55c5fead:foreman] DEBUG o.a.drill.exec.work.foreman.Foreman - Submitting fragments to run.
2016-10-15 15:11:24,927 [27fde379-3cf4-c429-8d42-470f55c5fead:foreman] DEBUG o.a.drill.exec.ops.FragmentContext - Getting initial memory allocation of 113000000
2016-10-15 15:11:24,928 [27fde379-3cf4-c429-8d42-470f55c5fead:foreman] DEBUG o.a.drill.exec.ops.FragmentContext - Fragment max allocation: 930093368854
2016-10-15 15:11:24,932 [27fde379-3cf4-c429-8d42-470f55c5fead:foreman] DEBUG o.a.d.e.work.batch.IncomingBuffers - Came up with a list of 0 required fragments.  Fragments {}
2016-10-15 15:11:24,941 [27fde379-3cf4-c429-8d42-470f55c5fead:foreman] DEBUG o.a.drill.exec.work.foreman.Foreman - 27fde379-3cf4-c429-8d42-470f55c5fead: State change requested STARTING --> RUNNING
2016-10-15 15:11:24,942 [27fde379-3cf4-c429-8d42-470f55c5fead:foreman] DEBUG o.a.drill.exec.work.foreman.Foreman - Fragments running.
2016-10-15 15:11:25,265 [27fde379-3cf4-c429-8d42-470f55c5fead:frag:0:0] DEBUG o.a.d.e.p.i.s.RemovingRecordBatch - Created.
2016-10-15 15:11:25,390 [27fde379-3cf4-c429-8d42-470f55c5fead:frag:0:0] DEBUG o.a.d.e.p.i.s.RemovingRecordBatch - Created.

<doesnt proceed from here>



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)