[jira] [Created] (DRILL-5118) Select Query Limit is not working in Drill 1.8
Gopal Nagar created DRILL-5118: -- Summary: Select Query Limit is not working in Drill 1.8 Key: DRILL-5118 URL: https://issues.apache.org/jira/browse/DRILL-5118 Project: Apache Drill Issue Type: Bug Components: Client - CLI, Client - HTTP Affects Versions: 1.8.0 Reporter: Gopal Nagar Hi All, Drill 1.8.0 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 and I have put limit 100 in query. But after displaying the 100 rows on Drill CLI, Query doesn't terminated and it doesn't go back to CLI prompt and keep processing the data in Background. Please help. Join Query -- select t1.col FROM hive.table1 as t1 join hive.table2 as t2 on t1.col = t2.col limit 100; -- 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=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-4959) Drill 1.8 not able to connect to S3
[ https://issues.apache.org/jira/browse/DRILL-4959?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15607484#comment-15607484 ] Gopal Nagar commented on DRILL-4959: Hi Uwe L. Korn, Could you please provide some update on this issue ? Thanks & Regards, Gopal Nagar > Drill 1.8 not able to connect to S3 > --- > > Key: DRILL-4959 > URL: https://issues.apache.org/jira/browse/DRILL-4959 > Project: Apache Drill > Issue Type: Bug >Affects Versions: 1.8.0 >Reporter: Gopal Nagar > > Hi Team, > I have followed below details to integrate Drill with AWS S3. Query keep > running for hours and doesn't display any output (I am querying only 2 row > file from S3). > Reference link > --- > https://abhishek-tiwari.com/post/reflections-on-apache-drill > https://drill.apache.org/docs/s3-storage-plugin/ > Query Format (Tried from UI & CLI) > > select * from `s3`.`hive.csv` LIMIT 10; > select * from `s3`.`bucket_name/hive.csv` LIMIT 10; > After seeing below log, I tried including jets3t-0.9.3.jar in jars directory > but it doesn't fix my problem. > Log Details > -- > 2016-10-24 17:00:02,461 [27f1c1ec-d82e-ba2a-2840-e7104320418f:foreman] INFO > o.a.drill.exec.work.foreman.Foreman - Query text for query id > 27f1c1ec-d82e-ba2a-2840-e7104320418f: select * from `s3`.`hive.csv` LIMIT 10 > 2016-10-24 17:00:02,479 [drill-executor-39] ERROR > o.a.d.exec.server.BootStrapContext - > org.apache.drill.exec.work.foreman.Foreman.run() leaked an exception. > java.lang.NoClassDefFoundError: org/jets3t/service/S3ServiceException -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Comment Edited] (DRILL-4959) Drill 1.8 not able to connect to S3
[ https://issues.apache.org/jira/browse/DRILL-4959?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15604842#comment-15604842 ] Gopal Nagar edited comment on DRILL-4959 at 10/25/16 10:40 AM: --- Hi, Really appreciate your quick response. I have used s3a:// in URL and now it's working fine. Only my concern is that simple select query work fine but when i use and join it doesn't work. Below is sample query and the link where i got this syntax. Could you please advise how to fix this issue ? And can you send me some document where i can find the query syntax. Query - select * from `s3-poc`.`poc1.csv` as a INNER join `s3-poc`.`poc2.csv` as b on a.name = b.name https://abhishek-tiwari.com/post/reflections-on-apache-drill Thanks & Regards, Gopal Nagar was (Author: gopalnaga...@gmail.com): Hi, Really appreciate your quick response. I have used s3a:// in URL and now it's working fine. Only my concern is that simple select query work fine but when i use and join it doesn't work. Below is sample query and the link where i got this syntax. Could you please advise how to fix this issue ? And can you send me some document where i can find the query syntax. Query - select * from `s3-poc`.`poc1.csv` as a INNER join `s3-poc`.`poc2.csv` on a.name = b.name https://abhishek-tiwari.com/post/reflections-on-apache-drill Thanks & Regards, Gopal Nagar > Drill 1.8 not able to connect to S3 > --- > > Key: DRILL-4959 > URL: https://issues.apache.org/jira/browse/DRILL-4959 > Project: Apache Drill > Issue Type: Bug >Affects Versions: 1.8.0 >Reporter: Gopal Nagar > > Hi Team, > I have followed below details to integrate Drill with AWS S3. Query keep > running for hours and doesn't display any output (I am querying only 2 row > file from S3). > Reference link > --- > https://abhishek-tiwari.com/post/reflections-on-apache-drill > https://drill.apache.org/docs/s3-storage-plugin/ > Query Format (Tried from UI & CLI) > > select * from `s3`.`hive.csv` LIMIT 10; > select * from `s3`.`bucket_name/hive.csv` LIMIT 10; > After seeing below log, I tried including jets3t-0.9.3.jar in jars directory > but it doesn't fix my problem. > Log Details > -- > 2016-10-24 17:00:02,461 [27f1c1ec-d82e-ba2a-2840-e7104320418f:foreman] INFO > o.a.drill.exec.work.foreman.Foreman - Query text for query id > 27f1c1ec-d82e-ba2a-2840-e7104320418f: select * from `s3`.`hive.csv` LIMIT 10 > 2016-10-24 17:00:02,479 [drill-executor-39] ERROR > o.a.d.exec.server.BootStrapContext - > org.apache.drill.exec.work.foreman.Foreman.run() leaked an exception. > java.lang.NoClassDefFoundError: org/jets3t/service/S3ServiceException -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Comment Edited] (DRILL-4959) Drill 1.8 not able to connect to S3
[ https://issues.apache.org/jira/browse/DRILL-4959?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15604842#comment-15604842 ] Gopal Nagar edited comment on DRILL-4959 at 10/25/16 10:38 AM: --- Hi, Really appreciate your quick response. I have used s3a:// in URL and now it's working fine. Only my concern is that simple select query work fine but when i use and join it doesn't work. Below is sample query and the link where i got this syntax. Could you please advise how to fix this issue ? And can you send me some document where i can find the query syntax. Query - select * from `s3-poc`.`poc1.csv` as a INNER join `s3-poc`.`poc2.csv` on a.name = b.name https://abhishek-tiwari.com/post/reflections-on-apache-drill Thanks & Regards, Gopal Nagar was (Author: gopalnaga...@gmail.com): Hi, Really appreciate your quick response. I have used s3a:// in URL and now it's working fine. Only my concern is that simple select query work fine but when i use and join it doesn't work. Below is sample query and the link where i got this syntax. Could you please advise how to fix this issue ? And can you send me some document where i can find the query syntax. Query - select * from `s3-pocjanssen`.`poc1.csv` as a INNER join `s3-pocjanssen`.`poc2.csv` on a.name = b.name https://abhishek-tiwari.com/post/reflections-on-apache-drill Thanks & Regards, Gopal Nagar > Drill 1.8 not able to connect to S3 > --- > > Key: DRILL-4959 > URL: https://issues.apache.org/jira/browse/DRILL-4959 > Project: Apache Drill > Issue Type: Bug >Affects Versions: 1.8.0 >Reporter: Gopal Nagar > > Hi Team, > I have followed below details to integrate Drill with AWS S3. Query keep > running for hours and doesn't display any output (I am querying only 2 row > file from S3). > Reference link > --- > https://abhishek-tiwari.com/post/reflections-on-apache-drill > https://drill.apache.org/docs/s3-storage-plugin/ > Query Format (Tried from UI & CLI) > > select * from `s3`.`hive.csv` LIMIT 10; > select * from `s3`.`bucket_name/hive.csv` LIMIT 10; > After seeing below log, I tried including jets3t-0.9.3.jar in jars directory > but it doesn't fix my problem. > Log Details > -- > 2016-10-24 17:00:02,461 [27f1c1ec-d82e-ba2a-2840-e7104320418f:foreman] INFO > o.a.drill.exec.work.foreman.Foreman - Query text for query id > 27f1c1ec-d82e-ba2a-2840-e7104320418f: select * from `s3`.`hive.csv` LIMIT 10 > 2016-10-24 17:00:02,479 [drill-executor-39] ERROR > o.a.d.exec.server.BootStrapContext - > org.apache.drill.exec.work.foreman.Foreman.run() leaked an exception. > java.lang.NoClassDefFoundError: org/jets3t/service/S3ServiceException -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (DRILL-4959) Drill 1.8 not able to connect to S3
[ https://issues.apache.org/jira/browse/DRILL-4959?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15604842#comment-15604842 ] Gopal Nagar commented on DRILL-4959: Hi, Really appreciate your quick response. I have used s3a:// in URL and now it's working fine. Only my concern is that simple select query work fine but when i use and join it doesn't work. Below is sample query and the link where i got this syntax. Could you please advise how to fix this issue ? And can you send me some document where i can find the query syntax. Query - select * from `s3-pocjanssen`.`poc1.csv` as a INNER join `s3-pocjanssen`.`poc2.csv` on a.name = b.name https://abhishek-tiwari.com/post/reflections-on-apache-drill Thanks & Regards, Gopal Nagar > Drill 1.8 not able to connect to S3 > --- > > Key: DRILL-4959 > URL: https://issues.apache.org/jira/browse/DRILL-4959 > Project: Apache Drill > Issue Type: Bug >Affects Versions: 1.8.0 >Reporter: Gopal Nagar > > Hi Team, > I have followed below details to integrate Drill with AWS S3. Query keep > running for hours and doesn't display any output (I am querying only 2 row > file from S3). > Reference link > --- > https://abhishek-tiwari.com/post/reflections-on-apache-drill > https://drill.apache.org/docs/s3-storage-plugin/ > Query Format (Tried from UI & CLI) > > select * from `s3`.`hive.csv` LIMIT 10; > select * from `s3`.`bucket_name/hive.csv` LIMIT 10; > After seeing below log, I tried including jets3t-0.9.3.jar in jars directory > but it doesn't fix my problem. > Log Details > -- > 2016-10-24 17:00:02,461 [27f1c1ec-d82e-ba2a-2840-e7104320418f:foreman] INFO > o.a.drill.exec.work.foreman.Foreman - Query text for query id > 27f1c1ec-d82e-ba2a-2840-e7104320418f: select * from `s3`.`hive.csv` LIMIT 10 > 2016-10-24 17:00:02,479 [drill-executor-39] ERROR > o.a.d.exec.server.BootStrapContext - > org.apache.drill.exec.work.foreman.Foreman.run() leaked an exception. > java.lang.NoClassDefFoundError: org/jets3t/service/S3ServiceException -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Created] (DRILL-4959) Drill 8.1 not able to connect to S3
Gopal Nagar created DRILL-4959: -- Summary: Drill 8.1 not able to connect to S3 Key: DRILL-4959 URL: https://issues.apache.org/jira/browse/DRILL-4959 Project: Apache Drill Issue Type: Bug Affects Versions: 1.8.0 Reporter: Gopal Nagar Hi Team, I have followed below details to integrate Drill with AWS S3. Query keep running for hours and doesn't display any output (I am querying only 2 row file from S3). Reference link --- https://abhishek-tiwari.com/post/reflections-on-apache-drill https://drill.apache.org/docs/s3-storage-plugin/ Query Format (Tried from UI & CLI) select * from `s3`.`hive.csv` LIMIT 10; select * from `s3`.`bucket_name/hive.csv` LIMIT 10; After seeing below log, I tried including jets3t-0.9.3.jar in jars directory but it doesn't fix my problem. Log Details -- 2016-10-24 17:00:02,461 [27f1c1ec-d82e-ba2a-2840-e7104320418f:foreman] INFO o.a.drill.exec.work.foreman.Foreman - Query text for query id 27f1c1ec-d82e-ba2a-2840-e7104320418f: select * from `s3`.`hive.csv` LIMIT 10 2016-10-24 17:00:02,479 [drill-executor-39] ERROR o.a.d.exec.server.BootStrapContext - org.apache.drill.exec.work.foreman.Foreman.run() leaked an exception. java.lang.NoClassDefFoundError: org/jets3t/service/S3ServiceException -- 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] [Comment Edited] (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 edited comment on DRILL-4910 at 9/29/16 5:31 AM: - 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 showing output then why UI doesn't display 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. was (Author: gopalnaga...@gmail.com): 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 > 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] [Updated] (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:all-tabpanel ] Gopal Nagar updated DRILL-4910: --- Attachment: drillbit.log > 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] [Updated] (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: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)
[jira] [Updated] (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: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 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] 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 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] -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (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: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 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] 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 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] -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (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: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 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] 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. 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 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] -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[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)
