Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-4947

Multiple inner join drill query fails to return result

Attach filesAttach ScreenshotAdd voteVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

    • Flags:
      Important

      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>

        Attachments

        1. drilllog_jira
          2.97 MB
          Tushar Pathare
        2. Screen Shot 2016-10-15 at 4.00.33 PM.png
          68 kB
          Tushar Pathare
        3. Screen Shot 2016-10-15 at 4.12.16 PM.png
          200 kB
          Tushar Pathare
        4. Screen Shot 2016-10-15 at 4.12.31 PM.png
          230 kB
          Tushar Pathare
        5. Screen Shot 2016-10-15 at 4.12.40 PM.png
          233 kB
          Tushar Pathare
        6. Screen Shot 2016-10-15 at 4.12.48 PM.png
          226 kB
          Tushar Pathare
        7. Screen Shot 2016-10-15 at 4.12.55 PM.png
          218 kB
          Tushar Pathare
        8. Screen Shot 2016-10-15 at 4.13.03 PM.png
          229 kB
          Tushar Pathare
        9. Screen Shot 2016-10-15 at 4.13.11 PM.png
          224 kB
          Tushar Pathare
        10. Screen Shot 2016-10-15 at 4.13.21 PM.png
          240 kB
          Tushar Pathare
        11. Screen Shot 2016-10-15 at 4.13.29 PM.png
          61 kB
          Tushar Pathare

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              tpathare Tushar Pathare

              Dates

              • Created:
                Updated:

                Issue deployment