[DRILL-3802] Throw unsupported error for ROLLUP/GROUPING

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.3.0
• Component/s: Query Planning & Optimization
• Assignee: Jinfeng Ni
• Reporter: Victoria Markman
• Reviewer: Victoria Markman
• Created: 18/Sep/15 17:02
• Updated: 06/Feb/17 12:07
• Resolved: 22/Oct/15 04:28

Description

I believe that this is the cause of assertions in TPCDS #36, #67

SELECT Sum(ss_net_profit) / Sum(ss_ext_sales_price) AS 
gross_margin, 
i_category, 
i_class, 
Grouping(i_category) + Grouping(i_class) AS 
lochierarchy, 
Rank() 
OVER ( 
partition BY Grouping(i_category)+Grouping(i_class), CASE 
WHEN Grouping( 
i_class) = 0 THEN i_category END 
ORDER BY Sum(ss_net_profit)/Sum(ss_ext_sales_price) ASC) AS 
rank_within_parent 
FROM store_sales, 
date_dim d1, 
item, 
store 
WHERE d1.d_year = 2000 
AND d1.d_date_sk = ss_sold_date_sk 
AND i_item_sk = ss_item_sk 
AND s_store_sk = ss_store_sk 
AND s_state IN ( 'TN', 'TN', 'TN', 'TN', 
'TN', 'TN', 'TN', 'TN' ) 
GROUP BY rollup( i_category, i_class ) 
ORDER BY lochierarchy DESC, 
CASE 
WHEN lochierarchy = 0 THEN i_category 
END, 
rank_within_parent
LIMIT 100;
Error: SYSTEM ERROR: AssertionError: Internal error: invariant violated: conversion result not null
[Error Id: 6afae7ce-c426-44f3-a600-aa34ab7632a1 on ucs-node5.perf.lab:31010] (state=,code=0)
java.sql.SQLException: SYSTEM ERROR: AssertionError: Internal error: invariant violated: conversion result not null
[Error Id: 6afae7ce-c426-44f3-a600-aa34ab7632a1 on ucs-node5.perf.lab:31010]
at org.apache.drill.jdbc.impl.DrillCursor.nextRowInternally(DrillCursor.java:247)
at org.apache.drill.jdbc.impl.DrillCursor.loadInitialSchema(DrillCursor.java:290)
at org.apache.drill.jdbc.impl.DrillResultSetImpl.execute(DrillResultSetImpl.java:1359)
at org.apache.drill.jdbc.impl.DrillResultSetImpl.execute(DrillResultSetImpl.java:74)
at net.hydromatic.avatica.AvaticaConnection.executeQueryInternal(AvaticaConnection.java:404)
at net.hydromatic.avatica.AvaticaStatement.executeQueryInternal(AvaticaStatement.java:351)
at net.hydromatic.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:338)
at net.hydromatic.avatica.AvaticaStatement.execute(AvaticaStatement.java:69)
at org.apache.drill.jdbc.impl.DrillStatementImpl.execute(DrillStatementImpl.java:86)
at sqlline.Commands.execute(Commands.java:841)
at sqlline.Commands.sql(Commands.java:751)
at sqlline.SqlLine.dispatch(SqlLine.java:738)
at sqlline.SqlLine.runCommands(SqlLine.java:1641)
at sqlline.Commands.run(Commands.java:1304)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:36)
at sqlline.SqlLine.dispatch(SqlLine.java:734)
at sqlline.SqlLine.initArgs(SqlLine.java:544)
at sqlline.SqlLine.begin(SqlLine.java:587)
at sqlline.SqlLine.start(SqlLine.java:366)
at sqlline.SqlLine.main(SqlLine.java:259)
Caused by: org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: AssertionError: Internal error: invariant violated: conversion result not null

Issue Links

• relates to: DRILL-3962 Add support of ROLLUP, CUBE, GROUPING SETS, GROUPING, GROUPING_ID, GROUP_ID support