[DRILL-457] SQL parse error in joining 2 Hive tables

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Implemented
• Fix Version/s: 0.4.0
• Assignee: Unassigned
• Reporter: Neeraja
• Created: 26/Mar/14 23:41
• Updated: 31/Jul/14 06:33
• Resolved: 27/Mar/14 06:34

Description

Below is a join query I tried between 2 hive tables (TPC-H schema). Queries on single tables just work fine.
SELECT c.c_custkey, o.o_totalprice FROM hive.customer as c join hive.orders as o on c.c_custkey = o.o_custkey;

I get the error as below.
Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id: "cfdd6849-5971-455d-a397-cc921963846b"
endpoint {
address: "ubuntu"
user_port: 31010
control_port: 31011
data_port: 31012
}
error_type: 0
message: "Failure while parsing sql. < IllegalArgumentException:[ duplicate key: hive ]"
]Error: exception while executing query (state=,code=0)