[DRILL-1921] Throw unsupported error message some set operators that are not currently supported

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.8.0
• Component/s: SQL Parser
• Assignee: Sean Hsuan-Yi Chu
• Reporter: Victoria Markman
• Created: 02/Jan/15 22:31
• Updated: 28/Dec/15 22:40
• Resolved: 08/Feb/15 03:28

Description

Throw unsupported error message for these operators: (instead of "Could not be implemented error below")

INTERSECT
EXCEPT
UNION
CROSS JOIN

Query failed: Query failed: Unexpected exception during fragment initialization: Node [rel#517133:Subset#3.LOGICAL.ANY([]).[]] could not be implemented; planner state:

Enhacement requests in Jira for these above mentioned operators:

INTERSECT       DRILL-1308
MINUS                No enhancement request ( not recognized in grammar)
EXCEPT             No enhancement request
UNION                DRILL-1169
CROSS JOIN     DRILL-786

Issue Links

• duplicates: DRILL-2016 Remove "multiset" data type from supported grammar
• duplicates: DRILL-2115 Disable function CARDINALITY in grammar
• is depended upon by: DRILL-2016 Remove "multiset" data type from supported grammar
• is depended upon by: DRILL-1308 CannotPlanException for TPC-DS query 8 due to large IN-list and Intersect operation
• is depended upon by: DRILL-2068 Disable Implicit Cross Join with Condition on the same table (e.g., select ... from a, b where a._1 = a._2)
• is depended upon by: DRILL-1986 Natural join query returns wrong result
• is depended upon by: DRILL-2115 Disable function CARDINALITY in grammar
• is depended upon by: DRILL-2057 Disable TINYINT, SMALLINT & REAL data type in grammar