[
https://issues.apache.org/jira/browse/DRILL-457?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13948942#comment-13948942
]
Neeraja commented on DRILL-457:
-------------------------------
This issue is resolved with the recent build.
> 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)
