drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gopal Nagar (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-4910) Apache Drill 1.8 UI doesn't display Hive join query results
Date Wed, 28 Sep 2016 08:21:20 GMT

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

Gopal Nagar updated DRILL-4910:
-------------------------------
    Description: 
Hi All,

I am using Apache Drill 1.8.0 on AWS EMR and joining two hive tables. Below is sample query.
This working fine in Drill CLI but giving below error after running few minutes. If i try
simple select query (select t1.col from hive.table t1) it works fine in both Drill CLI and
UI. Only problem with join query.

If i cancel the join query from background, it displays results in UI. This is very strange
situation.

Join Query 
--------------
select t1.col FROM hive.table1 as t1 join hive.table2 as t2 on t1.col = t2.col limit 1000;

Error
-------
Query Failed: An Error Occurred org.apache.drill.common.exceptions.UserRemoteException: SYSTEM
ERROR: RpcException: Data not accepted downstream. Fragment 1:4 [Error Id: 0b5ed2db-3653-4e3a-9c92-d0a6cd69b66e
on ip-172-31-16-222.us-west-2.compute.internal:31010]

  was:
Hi All,

I am using Apache Drill 1.8.0 on AWS EMR and joining two hive tables. Below is sample query.
This working fine in Drill CLI but giving below error after running few minutes. If i try
simple select query (select t1.col from hive.table t1) it works fine in both Drill CLI and
UI. Only problem with join query.

If i cancel this join query from background. It displays the result.

Join Query 
--------------
select t1.col FROM hive.table1 as t1 join hive.table2 as t2 on t1.col = t2.col limit 1000;

Error
-------
Query Failed: An Error Occurred org.apache.drill.common.exceptions.UserRemoteException: SYSTEM
ERROR: RpcException: Data not accepted downstream. Fragment 1:4 [Error Id: 0b5ed2db-3653-4e3a-9c92-d0a6cd69b66e
on ip-172-31-16-222.us-west-2.compute.internal:31010]


> Apache Drill 1.8 UI doesn't display Hive join query results
> -----------------------------------------------------------
>
>                 Key: DRILL-4910
>                 URL: https://issues.apache.org/jira/browse/DRILL-4910
>             Project: Apache Drill
>          Issue Type: Bug
>            Reporter: Gopal Nagar
>
> Hi All,
> I am using Apache Drill 1.8.0 on AWS EMR and joining two hive tables. Below is sample
query. This working fine in Drill CLI but giving below error after running few minutes. If
i try simple select query (select t1.col from hive.table t1) it works fine in both Drill CLI
and UI. Only problem with join query.
> If i cancel the join query from background, it displays results in UI. This is very strange
situation.
> Join Query 
> --------------
> select t1.col FROM hive.table1 as t1 join hive.table2 as t2 on t1.col = t2.col limit
1000;
> Error
> -------
> Query Failed: An Error Occurred org.apache.drill.common.exceptions.UserRemoteException:
SYSTEM ERROR: RpcException: Data not accepted downstream. Fragment 1:4 [Error Id: 0b5ed2db-3653-4e3a-9c92-d0a6cd69b66e
on ip-172-31-16-222.us-west-2.compute.internal:31010]



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message