drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jinfeng Ni (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-5327) Hash aggregate can return empty batch which can cause schema change exception
Date Sat, 05 Aug 2017 00:13:00 GMT

    [ https://issues.apache.org/jira/browse/DRILL-5327?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16115149#comment-16115149
] 

Jinfeng Ni commented on DRILL-5327:
-----------------------------------

I run tpcds- q66 on tpcds-sf1 text dataset on 1.11.0 on a cluster of 2 nodes, and the query
failed with a different error which seems to also related to schema change.
{code}
Error: SYSTEM ERROR: IllegalStateException: Failure while reading vector.  Expected vector
class of org.apache.drill.exec.vector.NullableIntVector but was holding vector class org.apache.drill.exec.vector.NullableVarCharVector,
field= w_warehouse_name(VARCHAR(200):OPTIONAL) [$bits$(UINT1:REQUIRED), w_warehouse_name(VARCHAR(200):OPTIONAL)
[$offsets$(UINT4:REQUIRED)]]
{code}

With the patch for DRILL-5546, the q66 run successfully in multiple times.

{code}
+-----------------------+--------------------+-----------+--------------------+----------+----------------+----------------+--------+-----------------------+-----------------------+-----------------------+-----------------------+-----------------------+-----------------------+-----------------------+----------------------+-----------------------+-----------------------+----------------------+-----------------------+------------------------+------------------------+------------------------+------------------------+------------------------+------------------------+------------------------+------------------------+------------------------+------------------------+------------------------+------------------------+-----------------------+-----------------------+-----------------------+-----------------------+-----------------------+-----------------------+-----------------------+----------------------+----------------------+-----------------------+----------------------+-----------------------+
|   w_warehouse_name    | w_warehouse_sq_ft  |  w_city   |      w_county      | w_state  |
  w_country    | ship_carriers  | year1  |       jan_sales       |       feb_sales       |
      mar_sales       |       apr_sales       |       may_sales       |       jun_sales  
    |       jul_sales       |      aug_sales       |       sep_sales       |       oct_sales
      |      nov_sales       |       dec_sales       | jan_sales_per_sq_foot  | feb_sales_per_sq_foot
 | mar_sales_per_sq_foot  | apr_sales_per_sq_foot  | may_sales_per_sq_foot  | jun_sales_per_sq_foot
 | jul_sales_per_sq_foot  | aug_sales_per_sq_foot  | sep_sales_per_sq_foot  | oct_sales_per_sq_foot
 | nov_sales_per_sq_foot  | dec_sales_per_sq_foot  |        jan_net        |        feb_net
       |        mar_net        |        apr_net        |        may_net        |        jun_net
       |        jul_net        |       aug_net        |       sep_net        |        oct_net
       |       nov_net        |        dec_net        |
+-----------------------+--------------------+-----------+--------------------+----------+----------------+----------------+--------+-----------------------+-----------------------+-----------------------+-----------------------+-----------------------+-----------------------+-----------------------+----------------------+-----------------------+-----------------------+----------------------+-----------------------+------------------------+------------------------+------------------------+------------------------+------------------------+------------------------+------------------------+------------------------+------------------------+------------------------+------------------------+------------------------+-----------------------+-----------------------+-----------------------+-----------------------+-----------------------+-----------------------+-----------------------+----------------------+----------------------+-----------------------+----------------------+-----------------------+
| Bad cards must make.  | 621234             | Fairview  | Williamson County  | TN       |
United States  | ZOUROS,ZHOU    | 1998   | 1.7895281680000003E7  | 2.105534367E7         |
1.494257482E7         | 1.6786960909999996E7  | 2.9326997819999997E7  | 1.771871621E7    
    | 2.128628804E7         | 4.156471438000001E7  | 4.39726708E7          | 3.636744521E7
        | 5.921482304000004E7  | 7.160199778999999E7   | null                   | NaN    
               | null                   | null                   | null                  
| null                   | null                   | null                   | null        
          | null                   | null                   | null                   | 1.872240875E7
        | 2.1751827040000007E7  | 1.5031942330000002E7  | 1.551366257E7         | 2.867464643E7
        | 1.9541069490000002E7  | 2.141437321E7         | 4.615270391000001E7  | 4.655948892E7
       | 3.913212232E7         | 6.467676385000001E7  | 7.453110485999998E7   |
| Conventional childr   | 977787             | Fairview  | Williamson County  | TN       |
United States  | ZOUROS,ZHOU    | 1998   | 1.999983924E7         | 1.2437056879999999E7  |
1.5585710529999994E7  | 2.750616177E7         | 2.4131745499999996E7  | 1.7114174979999997E7
 | 1.718943811E7         | 3.587620927E7        | 3.850794516E7         | 4.673179192E7  
      | 5.229720881E7        | 6.4427886379999995E7  | null                   | NaN      
             | null                   | null                   | null                   |
null                   | null                   | null                   | null          
        | null                   | null                   | null                   | 2.1857524939999998E7
 | 1.391978779E7         | 1.5579168019999996E7  | 2.668792055E7         | 2.4782953539999995E7
 | 1.7879288519999996E7  | 1.8694541619999997E7  | 3.737911198E7        | 3.946605507999999E7
 | 4.90502998E7          | 5.518650689E7        | 7.322130477000001E7   |
| Doors canno           | 294242             | Fairview  | Williamson County  | TN       |
United States  | ZOUROS,ZHOU    | 1998   | 1.583061318E7         | 2.0871955020000003E7  |
2.040936734E7         | 2.4405087869999997E7  | 2.1985274009999998E7  | 1.5283262570000002E7
 | 1.479048741E7         | 3.485467343E7        | 4.220699558E7         | 4.4218854550000004E7
 | 6.120834945E7        | 5.426903902000001E7   | null                   | NaN           
        | null                   | null                   | null                   | null
                  | null                   | null                   | null               
   | null                   | null                   | null                   | 1.756375361E7
        | 2.113350114E7         | 1.932301847E7         | 2.8898458470000006E7  | 2.5131198009999994E7
 | 1.612344184E7         | 1.3890433170000002E7  | 3.843285613E7        | 4.385424222999999E7
 | 5.0041018510000005E7  | 6.526011776000001E7  | 5.8429935760000005E7  |
| Important issues liv  | 138504             | Fairview  | Williamson County  | TN       |
United States  | ZOUROS,ZHOU    | 1998   | 2.0980321179999996E7  | 1.417435864E7         |
1.8756915189999998E7  | 1.658665833E7         | 1.8656897029999994E7  | 2.4979233810000002E7
 | 1.9602412300000004E7  | 3.936814522E7        | 4.1149182800000004E7  | 4.083197007000001E7
  | 7.322537116000003E7  | 6.358706866000001E7   | null                   | NaN          
         | null                   | null                   | null                   | null
                  | null                   | null                   | null               
   | null                   | null                   | null                   | 2.1363019459999993E7
 | 1.5933266760000002E7  | 1.832847682E7         | 1.706125381E7         | 1.980431299E7 
       | 2.688301643E7         | 2.0240164240000002E7  | 4.179461697000001E7  | 4.082932107000001E7
 | 4.426378027000001E7   | 7.959791007999998E7  | 6.530625318000001E7   |
| null                  | null               | Fairview  | Williamson County  | TN       |
United States  | ZOUROS,ZHOU    | 1998   | 2.107754961E7         | 1.7189227050000004E7  |
1.7404323700000003E7  | 1.8908102909999996E7  | 1.6285662420000002E7  | 1.8500778700000003E7
 | 1.7322239259999994E7  | 3.644408868999999E7  | 4.2712381879999995E7  | 3.5181388559999995E7
 | 6.750091281E7        | 6.4034387639999956E7  | null                   | NaN           
        | null                   | null                   | null                   | null
                  | null                   | null                   | null               
   | null                   | null                   | null                   | 2.155171713E7
        | 1.912509567E7         | 1.6574806870000001E7  | 2.0705973540000007E7  | 1.6545966379999999E7
 | 2.048446054E7         | 1.712386645E7         | 3.929974493999999E7  | 4.763222143000001E7
 | 3.615190025999999E7   | 7.358634230000001E7  | 6.968475126999998E7   |
+-----------------------+--------------------+-----------+--------------------+----------+----------------+----------------+--------+-----------------------+-----------------------+-----------------------+-----------------------+-----------------------+-----------------------+-----------------------+----------------------+-----------------------+-----------------------+----------------------+-----------------------+------------------------+------------------------+------------------------+------------------------+------------------------+------------------------+------------------------+------------------------+------------------------+------------------------+------------------------+------------------------+-----------------------+-----------------------+-----------------------+-----------------------+-----------------------+-----------------------+-----------------------+----------------------+----------------------+-----------------------+----------------------+-----------------------+
5 rows selected (18.071 seconds)
{code}

It seems that the patch for DRILL-5546 fixed the problem.



> Hash aggregate can return empty batch which can cause schema change exception
> -----------------------------------------------------------------------------
>
>                 Key: DRILL-5327
>                 URL: https://issues.apache.org/jira/browse/DRILL-5327
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Functions - Drill
>    Affects Versions: 1.10.0
>            Reporter: Chun Chang
>            Assignee: Jinfeng Ni
>         Attachments: 271dbe08-c725-8e82-b6ea-53e9dab64e8b.sys.drill
>
>
> Hash aggregate can return empty batches which cause drill to throw schema change exception
(not handling this type of schema change). This is not a new bug. But a recent hash function
change (a theoretically correct change) may have increased the chance of hitting this issue.
I don't have scientific data to support my claim (in fact I don't believe it's the case),
but a regular regression run used to pass fails now due to this bug. My concern is that existing
drill users out there may have queries that used to work but fail now. It will be difficult
to explain why the new release is better for them. I put this bug as blocker so we can discuss
it before releasing 1.10.
> {noformat}
> /root/drillAutomation/framework-master/framework/resources/Advanced/tpcds/tpcds_sf1/original/text/query66.sql
> Query: 
> -- start query 66 in stream 0 using template query66.tpl 
> SELECT w_warehouse_name, 
>                w_warehouse_sq_ft, 
>                w_city, 
>                w_county, 
>                w_state, 
>                w_country, 
>                ship_carriers, 
>                year1,
>                Sum(jan_sales)                     AS jan_sales, 
>                Sum(feb_sales)                     AS feb_sales, 
>                Sum(mar_sales)                     AS mar_sales, 
>                Sum(apr_sales)                     AS apr_sales, 
>                Sum(may_sales)                     AS may_sales, 
>                Sum(jun_sales)                     AS jun_sales, 
>                Sum(jul_sales)                     AS jul_sales, 
>                Sum(aug_sales)                     AS aug_sales, 
>                Sum(sep_sales)                     AS sep_sales, 
>                Sum(oct_sales)                     AS oct_sales, 
>                Sum(nov_sales)                     AS nov_sales, 
>                Sum(dec_sales)                     AS dec_sales, 
>                Sum(jan_sales / w_warehouse_sq_ft) AS jan_sales_per_sq_foot, 
>                Sum(feb_sales / w_warehouse_sq_ft) AS feb_sales_per_sq_foot, 
>                Sum(mar_sales / w_warehouse_sq_ft) AS mar_sales_per_sq_foot, 
>                Sum(apr_sales / w_warehouse_sq_ft) AS apr_sales_per_sq_foot, 
>                Sum(may_sales / w_warehouse_sq_ft) AS may_sales_per_sq_foot, 
>                Sum(jun_sales / w_warehouse_sq_ft) AS jun_sales_per_sq_foot, 
>                Sum(jul_sales / w_warehouse_sq_ft) AS jul_sales_per_sq_foot, 
>                Sum(aug_sales / w_warehouse_sq_ft) AS aug_sales_per_sq_foot, 
>                Sum(sep_sales / w_warehouse_sq_ft) AS sep_sales_per_sq_foot, 
>                Sum(oct_sales / w_warehouse_sq_ft) AS oct_sales_per_sq_foot, 
>                Sum(nov_sales / w_warehouse_sq_ft) AS nov_sales_per_sq_foot, 
>                Sum(dec_sales / w_warehouse_sq_ft) AS dec_sales_per_sq_foot, 
>                Sum(jan_net)                       AS jan_net, 
>                Sum(feb_net)                       AS feb_net, 
>                Sum(mar_net)                       AS mar_net, 
>                Sum(apr_net)                       AS apr_net, 
>                Sum(may_net)                       AS may_net, 
>                Sum(jun_net)                       AS jun_net, 
>                Sum(jul_net)                       AS jul_net, 
>                Sum(aug_net)                       AS aug_net, 
>                Sum(sep_net)                       AS sep_net, 
>                Sum(oct_net)                       AS oct_net, 
>                Sum(nov_net)                       AS nov_net, 
>                Sum(dec_net)                       AS dec_net 
> FROM   (SELECT w_warehouse_name, 
>                w_warehouse_sq_ft, 
>                w_city, 
>                w_county, 
>                w_state, 
>                w_country, 
>                'ZOUROS' 
>                || ',' 
>                || 'ZHOU' AS ship_carriers, 
>                d_year    AS year1, 
>                Sum(CASE 
>                      WHEN d_moy = 1 THEN ws_ext_sales_price * ws_quantity 
>                      ELSE 0 
>                    END)  AS jan_sales, 
>                Sum(CASE 
>                      WHEN d_moy = 2 THEN ws_ext_sales_price * ws_quantity 
>                      ELSE 0 
>                    END)  AS feb_sales, 
>                Sum(CASE 
>                      WHEN d_moy = 3 THEN ws_ext_sales_price * ws_quantity 
>                      ELSE 0 
>                    END)  AS mar_sales, 
>                Sum(CASE 
>                      WHEN d_moy = 4 THEN ws_ext_sales_price * ws_quantity 
>                      ELSE 0 
>                    END)  AS apr_sales, 
>                Sum(CASE 
>                      WHEN d_moy = 5 THEN ws_ext_sales_price * ws_quantity 
>                      ELSE 0 
>                    END)  AS may_sales, 
>                Sum(CASE 
>                      WHEN d_moy = 6 THEN ws_ext_sales_price * ws_quantity 
>                      ELSE 0 
>                    END)  AS jun_sales, 
>                Sum(CASE 
>                      WHEN d_moy = 7 THEN ws_ext_sales_price * ws_quantity 
>                      ELSE 0 
>                    END)  AS jul_sales, 
>                Sum(CASE 
>                      WHEN d_moy = 8 THEN ws_ext_sales_price * ws_quantity 
>                      ELSE 0 
>                    END)  AS aug_sales, 
>                Sum(CASE 
>                      WHEN d_moy = 9 THEN ws_ext_sales_price * ws_quantity 
>                      ELSE 0 
>                    END)  AS sep_sales, 
>                Sum(CASE 
>                      WHEN d_moy = 10 THEN ws_ext_sales_price * ws_quantity 
>                      ELSE 0 
>                    END)  AS oct_sales, 
>                Sum(CASE 
>                      WHEN d_moy = 11 THEN ws_ext_sales_price * ws_quantity 
>                      ELSE 0 
>                    END)  AS nov_sales, 
>                Sum(CASE 
>                      WHEN d_moy = 12 THEN ws_ext_sales_price * ws_quantity 
>                      ELSE 0 
>                    END)  AS dec_sales, 
>                Sum(CASE 
>                      WHEN d_moy = 1 THEN ws_net_paid_inc_ship * ws_quantity 
>                      ELSE 0 
>                    END)  AS jan_net, 
>                Sum(CASE 
>                      WHEN d_moy = 2 THEN ws_net_paid_inc_ship * ws_quantity 
>                      ELSE 0 
>                    END)  AS feb_net, 
>                Sum(CASE 
>                      WHEN d_moy = 3 THEN ws_net_paid_inc_ship * ws_quantity 
>                      ELSE 0 
>                    END)  AS mar_net, 
>                Sum(CASE 
>                      WHEN d_moy = 4 THEN ws_net_paid_inc_ship * ws_quantity 
>                      ELSE 0 
>                    END)  AS apr_net, 
>                Sum(CASE 
>                      WHEN d_moy = 5 THEN ws_net_paid_inc_ship * ws_quantity 
>                      ELSE 0 
>                    END)  AS may_net, 
>                Sum(CASE 
>                      WHEN d_moy = 6 THEN ws_net_paid_inc_ship * ws_quantity 
>                      ELSE 0 
>                    END)  AS jun_net, 
>                Sum(CASE 
>                      WHEN d_moy = 7 THEN ws_net_paid_inc_ship * ws_quantity 
>                      ELSE 0 
>                    END)  AS jul_net, 
>                Sum(CASE 
>                      WHEN d_moy = 8 THEN ws_net_paid_inc_ship * ws_quantity 
>                      ELSE 0 
>                    END)  AS aug_net, 
>                Sum(CASE 
>                      WHEN d_moy = 9 THEN ws_net_paid_inc_ship * ws_quantity 
>                      ELSE 0 
>                    END)  AS sep_net, 
>                Sum(CASE 
>                      WHEN d_moy = 10 THEN ws_net_paid_inc_ship * ws_quantity 
>                      ELSE 0 
>                    END)  AS oct_net, 
>                Sum(CASE 
>                      WHEN d_moy = 11 THEN ws_net_paid_inc_ship * ws_quantity 
>                      ELSE 0 
>                    END)  AS nov_net, 
>                Sum(CASE 
>                      WHEN d_moy = 12 THEN ws_net_paid_inc_ship * ws_quantity 
>                      ELSE 0 
>                    END)  AS dec_net 
>         FROM   web_sales, 
>                warehouse, 
>                date_dim, 
>                time_dim, 
>                ship_mode 
>         WHERE  ws_warehouse_sk = w_warehouse_sk 
>                AND ws_sold_date_sk = d_date_sk 
>                AND ws_sold_time_sk = t_time_sk 
>                AND ws_ship_mode_sk = sm_ship_mode_sk 
>                AND d_year = 1998 
>                AND t_time BETWEEN 7249 AND 7249 + 28800 
>                AND sm_carrier IN ( 'ZOUROS', 'ZHOU' ) 
>         GROUP  BY w_warehouse_name, 
>                   w_warehouse_sq_ft, 
>                   w_city, 
>                   w_county, 
>                   w_state, 
>                   w_country, 
>                   d_year 
>         UNION ALL 
>         SELECT w_warehouse_name, 
>                w_warehouse_sq_ft, 
>                w_city, 
>                w_county, 
>                w_state, 
>                w_country, 
>                'ZOUROS' 
>                || ',' 
>                || 'ZHOU' AS ship_carriers, 
>                d_year    AS year1, 
>                Sum(CASE 
>                      WHEN d_moy = 1 THEN cs_ext_sales_price * cs_quantity 
>                      ELSE 0 
>                    END)  AS jan_sales, 
>                Sum(CASE 
>                      WHEN d_moy = 2 THEN cs_ext_sales_price * cs_quantity 
>                      ELSE 0 
>                    END)  AS feb_sales, 
>                Sum(CASE 
>                      WHEN d_moy = 3 THEN cs_ext_sales_price * cs_quantity 
>                      ELSE 0 
>                    END)  AS mar_sales, 
>                Sum(CASE 
>                      WHEN d_moy = 4 THEN cs_ext_sales_price * cs_quantity 
>                      ELSE 0 
>                    END)  AS apr_sales, 
>                Sum(CASE 
>                      WHEN d_moy = 5 THEN cs_ext_sales_price * cs_quantity 
>                      ELSE 0 
>                    END)  AS may_sales, 
>                Sum(CASE 
>                      WHEN d_moy = 6 THEN cs_ext_sales_price * cs_quantity 
>                      ELSE 0 
>                    END)  AS jun_sales, 
>                Sum(CASE 
>                      WHEN d_moy = 7 THEN cs_ext_sales_price * cs_quantity 
>                      ELSE 0 
>                    END)  AS jul_sales, 
>                Sum(CASE 
>                      WHEN d_moy = 8 THEN cs_ext_sales_price * cs_quantity 
>                      ELSE 0 
>                    END)  AS aug_sales, 
>                Sum(CASE 
>                      WHEN d_moy = 9 THEN cs_ext_sales_price * cs_quantity 
>                      ELSE 0 
>                    END)  AS sep_sales, 
>                Sum(CASE 
>                      WHEN d_moy = 10 THEN cs_ext_sales_price * cs_quantity 
>                      ELSE 0 
>                    END)  AS oct_sales, 
>                Sum(CASE 
>                      WHEN d_moy = 11 THEN cs_ext_sales_price * cs_quantity 
>                      ELSE 0 
>                    END)  AS nov_sales, 
>                Sum(CASE 
>                      WHEN d_moy = 12 THEN cs_ext_sales_price * cs_quantity 
>                      ELSE 0 
>                    END)  AS dec_sales, 
>                Sum(CASE 
>                      WHEN d_moy = 1 THEN cs_net_paid * cs_quantity 
>                      ELSE 0 
>                    END)  AS jan_net, 
>                Sum(CASE 
>                      WHEN d_moy = 2 THEN cs_net_paid * cs_quantity 
>                      ELSE 0 
>                    END)  AS feb_net, 
>                Sum(CASE 
>                      WHEN d_moy = 3 THEN cs_net_paid * cs_quantity 
>                      ELSE 0 
>                    END)  AS mar_net, 
>                Sum(CASE 
>                      WHEN d_moy = 4 THEN cs_net_paid * cs_quantity 
>                      ELSE 0 
>                    END)  AS apr_net, 
>                Sum(CASE 
>                      WHEN d_moy = 5 THEN cs_net_paid * cs_quantity 
>                      ELSE 0 
>                    END)  AS may_net, 
>                Sum(CASE 
>                      WHEN d_moy = 6 THEN cs_net_paid * cs_quantity 
>                      ELSE 0 
>                    END)  AS jun_net, 
>                Sum(CASE 
>                      WHEN d_moy = 7 THEN cs_net_paid * cs_quantity 
>                      ELSE 0 
>                    END)  AS jul_net, 
>                Sum(CASE 
>                      WHEN d_moy = 8 THEN cs_net_paid * cs_quantity 
>                      ELSE 0 
>                    END)  AS aug_net, 
>                Sum(CASE 
>                      WHEN d_moy = 9 THEN cs_net_paid * cs_quantity 
>                      ELSE 0 
>                    END)  AS sep_net, 
>                Sum(CASE 
>                      WHEN d_moy = 10 THEN cs_net_paid * cs_quantity 
>                      ELSE 0 
>                    END)  AS oct_net, 
>                Sum(CASE 
>                      WHEN d_moy = 11 THEN cs_net_paid * cs_quantity 
>                      ELSE 0 
>                    END)  AS nov_net, 
>                Sum(CASE 
>                      WHEN d_moy = 12 THEN cs_net_paid * cs_quantity 
>                      ELSE 0 
>                    END)  AS dec_net 
>         FROM   catalog_sales, 
>                warehouse, 
>                date_dim, 
>                time_dim, 
>                ship_mode 
>         WHERE  cs_warehouse_sk = w_warehouse_sk 
>                AND cs_sold_date_sk = d_date_sk 
>                AND cs_sold_time_sk = t_time_sk 
>                AND cs_ship_mode_sk = sm_ship_mode_sk 
>                AND d_year = 1998 
>                AND t_time BETWEEN 7249 AND 7249 + 28800 
>                AND sm_carrier IN ( 'ZOUROS', 'ZHOU' ) 
>         GROUP  BY w_warehouse_name, 
>                   w_warehouse_sq_ft, 
>                   w_city, 
>                   w_county, 
>                   w_state, 
>                   w_country, 
>                   d_year) x 
> GROUP  BY w_warehouse_name, 
>           w_warehouse_sq_ft, 
>           w_city, 
>           w_county, 
>           w_state, 
>           w_country, 
>           ship_carriers, 
>           year1 
> ORDER  BY w_warehouse_name
> LIMIT 100
> Failed with exception
> java.sql.SQLException: UNSUPPORTED_OPERATION ERROR: Hash aggregate does not support schema
changes
> Fragment 0:0
> [Error Id: 9af86933-491e-4ae4-b848-bf66cb4464f9 on atsqa6c88.qa.lab:31010]
> 	at org.apache.drill.jdbc.impl.DrillCursor.nextRowInternally(DrillCursor.java:489)
> 	at org.apache.drill.jdbc.impl.DrillCursor.next(DrillCursor.java:593)
> 	at oadd.org.apache.calcite.avatica.AvaticaResultSet.next(AvaticaResultSet.java:215)
> 	at org.apache.drill.jdbc.impl.DrillResultSetImpl.next(DrillResultSetImpl.java:140)
> 	at org.apache.drill.test.framework.DrillTestJdbc.executeQuery(DrillTestJdbc.java:218)
> 	at org.apache.drill.test.framework.DrillTestJdbc.run(DrillTestJdbc.java:101)
> 	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
> 	at java.util.concurrent.FutureTask.run(FutureTask.java:262)
> 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
> 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> 	at java.lang.Thread.run(Thread.java:744)
> Caused by: oadd.org.apache.drill.common.exceptions.UserRemoteException: UNSUPPORTED_OPERATION
ERROR: Hash aggregate does not support schema changes
> Fragment 0:0
> [Error Id: 9af86933-491e-4ae4-b848-bf66cb4464f9 on atsqa6c88.qa.lab:31010]
> 	at oadd.org.apache.drill.exec.rpc.user.QueryResultHandler.resultArrived(QueryResultHandler.java:123)
> 	at oadd.org.apache.drill.exec.rpc.user.UserClient.handle(UserClient.java:343)
> 	at oadd.org.apache.drill.exec.rpc.user.UserClient.handle(UserClient.java:88)
> 	at oadd.org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:274)
> 	at oadd.org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:244)
> 	at oadd.io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:89)
> 	at oadd.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339)
> 	at oadd.io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324)
> 	at oadd.io.netty.handler.timeout.IdleStateHandler.channelRead(IdleStateHandler.java:254)
> 	at oadd.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339)
> 	at oadd.io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324)
> 	at oadd.io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:103)
> 	at oadd.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339)
> 	at oadd.io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324)
> 	at oadd.io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:242)
> 	at oadd.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339)
> 	at oadd.io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324)
> 	at oadd.io.netty.channel.ChannelInboundHandlerAdapter.channelRead(ChannelInboundHandlerAdapter.java:86)
> 	at oadd.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339)
> 	at oadd.io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324)
> 	at oadd.io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:847)
> 	at oadd.io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:131)
> 	at oadd.io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:511)
> 	at oadd.io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:468)
> 	at oadd.io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:382)
> 	at oadd.io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:354)
> 	at oadd.io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:111)
> 	... 1 more
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message