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