[jira] [Resolved] (DRILL-457) SQL parse error in joining 2 Hive tables

["Neeraja (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-457?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Neeraja resolved DRILL-457.
---------------------------

    Resolution: Implemented

> 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)