You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Gopal Nagar (JIRA)" <ji...@apache.org> on 2016/09/28 07:24:21 UTC
[jira] [Created] (DRILL-4910) Apache Drill 1.8 UI doesn't display
Hive join query results
Gopal Nagar created DRILL-4910:
----------------------------------
Summary: 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.
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)