[DRILL-2238] Unsupported join on OR yields rough CannotPlanException (vs. cleaner unsupported-feature message)

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 0.8.0
• Component/s: Query Planning & Optimization, SQL Parser
• Assignee: Sean Hsuan-Yi Chu
• Reporter: Daniel Barclay
• Created: 13/Feb/15 00:12
• Updated: 01/Apr/15 15:18
• Resolved: 26/Feb/15 16:06

Description

The unsupported combination of joining using a condition with an OR yields an internal CannotPlanException (with a dump of the plan):

org.apache.drill.exec.rpc.RpcException: RelOptPlanner.CannotPlanException: Node [rel#4217:Subset#3.LOGICAL.ANY([]).[]] could not be implemented; planner state:
Root: rel#4217:Subset#3.LOGICAL.ANY([]).[]
Original rel:
...

Eventually this should instead use some kind of unsupported-combination error.

Issue Links

• relates to: DRILL-2167 Order by on a repeated index from the output of a flatten on large no of records results in incorrect results