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

Incorrect error message reporting schema change when streaming aggregation and hash join are disabled

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

Details

    Description

      alter session set `planner.enable_streamagg` = false;
      alter session set `planner.enable_hashjoin` = false;

      0: jdbc:drill:schema=dfs> select  t1.a1,
      . . . . . . . . . . . . >         t1.b1,
      . . . . . . . . . . . . >         count(distinct t1.c1) as distinct_c1,
      . . . . . . . . . . . . >         count(distinct t2.c2) as distinct_c2,
      . . . . . . . . . . . . >         sum(t1.a1) as sum_a1,
      . . . . . . . . . . . . >         count(t1.c1) as count_a1,
      . . . . . . . . . . . . >         count(*) as count_star
      . . . . . . . . . . . . > from
      . . . . . . . . . . . . >         t1,
      . . . . . . . . . . . . >         t2
      . . . . . . . . . . . . > where
      . . . . . . . . . . . . >         t1.a1 = t2.a2 and t1.b1 = t2.b2
      . . . . . . . . . . . . > group by
      . . . . . . . . . . . . >         t1.a1,
      . . . . . . . . . . . . >         t1.b1,
      . . . . . . . . . . . . >         t2.a2,
      . . . . . . . . . . . . >         t2.b2
      . . . . . . . . . . . . > order by
      . . . . . . . . . . . . >         t1.a1,
      . . . . . . . . . . . . >         t1.b1,
      . . . . . . . . . . . . >         t2.a2,
      . . . . . . . . . . . . >         t2.b2
      . . . . . . . . . . . . > ;
      +------------+------------+-------------+-------------+------------+------------+------------+
      |     a1     |     b1     | distinct_c1 | distinct_c2 |   sum_a1   |  count_a1  | count_star |
      +------------+------------+-------------+-------------+------------+------------+------------+
      Query failed: SYSTEM ERROR: Hash aggregate does not support schema changes
      
      Fragment 0:0
      
      [10ee2422-d13c-4405-a4b6-a62358f72995 on atsqa4-134.qa.lab:31010]
      
        (org.apache.drill.exec.exception.SchemaChangeException) Hash aggregate does not support schema changes
      

      copy/paste reproduction

      select  t1.a1,
              t1.b1,
              count(distinct t1.c1) as distinct_c1,
              count(distinct t2.c2) as distinct_c2,
              sum(t1.a1) as sum_a1,
              count(t1.c1) as count_a1,
              count(*) as count_star
      from
              t1,
              t2
      where
              t1.a1 = t2.a2 and t1.b1 = t2.b2
      group by
              t1.a1,
              t1.b1,
              t2.a2,
              t2.b2
      order by
              t1.a1,
              t1.b1,
              t2.a2,
              t2.b2
      ;
      

      Attachments

        1. t1.parquet
          0.5 kB
          Victoria Markman
        2. t2.parquet
          0.5 kB
          Victoria Markman

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            seanhychu Sean Hsuan-Yi Chu
            vicky Victoria Markman
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment