You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Tushar Pathare (JIRA)" <ji...@apache.org> on 2016/10/18 20:20:58 UTC
[jira] [Commented] (DRILL-4947) Multiple inner join drill query
fails to return result
[ https://issues.apache.org/jira/browse/DRILL-4947?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15586559#comment-15586559 ]
Tushar Pathare commented on DRILL-4947:
---------------------------------------
This is related to following issue
https://community.mapr.com/thread/10461
> 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, Storage - JDBC
> Affects Versions: 1.8.0, 1.9.0
> Environment: RHEL 6.4
> 32 Cores 256GB RAM
> 2.6.32-358.el6.x86_64
> Reporter: Tushar Pathare
> Priority: Blocker
> Attachments: Screen Shot 2016-10-15 at 4.00.33 PM.png, Screen Shot 2016-10-15 at 4.12.16 PM.png, Screen Shot 2016-10-15 at 4.12.31 PM.png, Screen Shot 2016-10-15 at 4.12.40 PM.png, Screen Shot 2016-10-15 at 4.12.48 PM.png, Screen Shot 2016-10-15 at 4.12.55 PM.png, Screen Shot 2016-10-15 at 4.13.03 PM.png, Screen Shot 2016-10-15 at 4.13.11 PM.png, Screen Shot 2016-10-15 at 4.13.21 PM.png, Screen Shot 2016-10-15 at 4.13.29 PM.png, drilllog_jira
>
>
> 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)