[jira] [Commented] (DRILL-4910) Apache Drill 1.8 UI doesn't display Hive join query results
[ https://issues.apache.org/jira/browse/DRILL-4910?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15635297#comment-15635297 ] Gopal Nagar commented on DRILL-4910: Hi Faraaz, Could you please take a look and respond back ? Appreciate your help. Thanks & Regards, Gopal Nagar > 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 > Attachments: drillbit.log > > > 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)
[jira] [Commented] (DRILL-4910) Apache Drill 1.8 UI doesn't display Hive join query results
[ https://issues.apache.org/jira/browse/DRILL-4910?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15551483#comment-15551483 ] Gopal Nagar commented on DRILL-4910: Hi Faraaz, Did you get chance to look into this issue ? Appreciate your help. Thanks & Regards, Gopal Nagar > 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 > Attachments: drillbit.log > > > 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)
[jira] [Commented] (DRILL-4910) Apache Drill 1.8 UI doesn't display Hive join query results
[ https://issues.apache.org/jira/browse/DRILL-4910?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15531842#comment-15531842 ] Gopal Nagar commented on DRILL-4910: Hi Faraaz, Drill has been installed on a AWS node which has 32 GB RAM and 80 GB storage. I didn't specify memory separately to Drill. I am trying to join two tables have rows 4607818 & 14273378 respectively. Please find attached drillbit.log file as well. Only my confusion here is Drill CLI is working fine with this data and giving output then why UI is not giving output and throwing error. While running query from UI, if i cancel it from background then UI immediately display result. I believe i am missing some configuration (which is holding o/p in buffer and after cancellation display result) here and need your help. Appreciate your help. > 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)
[jira] [Commented] (DRILL-4910) Apache Drill 1.8 UI doesn't display Hive join query results
[ https://issues.apache.org/jira/browse/DRILL-4910?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15530260#comment-15530260 ] Khurram Faraaz commented on DRILL-4910: --- How much data (number of rows) do you have in your join tables ? Can you please share the stack trace from drillbit.log file and the details of memory that was provided to Drill ? > 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)
