[DRILL-4947] Multiple inner join drill query fails to return result

• Type: Bug
• Status: Open
• Priority: Blocker
• Resolution: Unresolved
• Affects Version/s: 1.8.0, 1.9.0
• Component/s: Execution - RPC, Functions - Drill, Query Planning & Optimization, Storage - JDBC

Environment

RHEL 6.4
32 Cores 256GB RAM
2.6.32-358.el6.x86_64

• Flags: Important
• Assignee: Unassigned
• Reporter: Tushar Pathare
• Created: 15/Oct/16 12:57
• Updated: 18/Oct/16 20:20

Description

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>