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

    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. t2.parquet
          0.5 kB
          Victoria Markman
        2. t1.parquet
          0.5 kB
          Victoria Markman

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: