Neeraja created DRILL-457:
-----------------------------
Summary: SQL parse error in joining 2 Hive tables
Key: DRILL-457
URL: https://issues.apache.org/jira/browse/DRILL-457
Project: Apache Drill
Issue Type: Bug
Reporter: Neeraja
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)
--
This message was sent by Atlassian JIRA
(v6.2#6252)
