[DRILL-882] Join between hive table and parquet file fail

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Component/s: Query Planning & Optimization
• Assignee: Jinfeng Ni
• Reporter: Ramana Inukonda Nagaraj
• Created: 31/May/14 00:13
• Updated: 12/Jul/14 22:24
• Resolved: 12/Jul/14 22:24

Description

The following query fails with a cannot plan error

select p.p_partkey
from hive.part p, `tpch-multi/partsupp` ps
where p.p_partkey = ps.ps_partkey
and p.p_size = 41
order by p.p_partkey
limit 20;

The below queries work fine implying nothing is wrong with the source

select p.p_partkey
from hive.part p;

select ps.ps_partkey from `tpch-multi/partsupp` ps;

The same query also works when both sides of join is from parquet or hive. Its only when they are different that I get the below cannot plan error.

message: "Failure while parsing sql. < CannotPlanException:[ Node [rel#2666:Subset#26.PHYSICAL.SINGLETON([]).[]] could not be implemented; planner state: