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)