You need to change s3 to s3n in the URI: See the discussion in the comments of this blog post:
http://drill.apache.org/blog/2014/12/09/running-sql-queries-on-amazon-s3/ Hopefully that helps. Let me know if you are still having problems. On Tue, Sep 22, 2015 at 8:47 AM, Andries Engelbrecht < [email protected]> wrote: > Scott, > > In your SP configuration change "connection": "s3://sccapachedrill/ > <s3://sccapachedrill/> <s3://sccapachedrill/ <s3://sccapachedrill/>>”, to > "connection": "s3://sccapachedrill/ <s3://sccapachedrill/> “, > I think you may have misunderstood the instructions on the page. > > > Also when querying the metadata in S3 you are better of to use show files > instead of show tables. > > In some cases I used core-site.xml with the credentials and placed it in > $DRILL_HOME/conf > > See if this works for you. > > > —Andries > > > > On Sep 21, 2015, at 7:29 PM, scott cote <[email protected]> wrote: > > > > Drillers, > > > > I run a User Group for MongoDB and am attempting to demonstrate the > ability to join data in S3 with data located in a MongoDB Collection. > Unfortunately, I am unable to properly query a csv file that I placed in S3. > > > > As reference, I am using the MapR S3 page. Followed directions with one > modification: one may not place a hyphen within the name of the bucket or > the name of the storage plugin. Doing so blows up the sql parser…. So > with that deviation, I did everything else listed on that page. They > system is configured per > https://drill.apache.org/blog/2014/12/09/running-sql-queries-on-amazon-s3/ > < > https://drill.apache.org/blog/2014/12/09/running-sql-queries-on-amazon-s3/ > > > > > > Problem: > > > > The s3sccapachedrill storage plugin shows enabled and I can switch to is > for use, but viewing a list of files/tables returns an empty list, and > attempting to query a specific file by name cases stack traces. > > > > > > Inside this email are the following key pieces of information: > > > > 1. Command/Response of using Apache Drill to access S3 csv log files. > > 2. Configuration of s3sccapachedrill storage plugin > > 3. Path to the s3 file in the sccapachedrill bucket > > 4. Contents of my hadoop_excludes.txt > > 5. View of the end of the sqlline.log > > > > > > Please let me know what I should change? > > > > Thanks, > > > > SCott > > Scott C. Cote > > [email protected] <mailto:[email protected]> > > 972.672.6484 > > > > > > =====>>>>> Part 1 <<<<========= > > What I see when I request for a list of databases: > > > > > > 0: jdbc:drill:zk=local> show databases; > > +---------------------------+ > > | SCHEMA_NAME | > > +---------------------------+ > > | INFORMATION_SCHEMA | > > | cp.default | > > | dfs.default | > > | dfs.root | > > | dfs.tmp | > > | s3sccapachedrill.default | > > | s3sccapachedrill.root | > > | s3sccapachedrill.tmp | > > | sys | > > +---------------------------+ > > 9 rows selected (0.083 seconds) > > > > > > Here is what I see when I request a list of tables (first sign of > trouble): > > > > > > 0: jdbc:drill:zk=local> use s3sccapachedrill; > > +-------+-----------------------------------------------+ > > | ok | summary | > > +-------+-----------------------------------------------+ > > | true | Default schema changed to [s3sccapachedrill] | > > +-------+-----------------------------------------------+ > > 1 row selected (0.069 seconds) > > 0: jdbc:drill:zk=local> show tables; > > +--+ > > | | > > +--+ > > +--+ > > No rows selected (1.504 seconds) > > > > > > Here is what I see when I try to query a specific file in s3 - > oletv_server_event.log.2014-12-16-10-55.csv > > > > 0: jdbc:drill:zk=local> select * from > s3sccapachedrill.root.`oletv_server_event.log.2014-12-16-10-55.csv`; > > Sep 16, 2015 12:07:22 PM > org.apache.calcite.sql.validate.SqlValidatorException <init> > > SEVERE: org.apache.calcite.sql.validate.SqlValidatorException: Table > 's3sccapachedrill.root.oletv_server_event.log.2014-12-16-10-55.csv' not > found > > Sep 16, 2015 12:07:22 PM org.apache.calcite.runtime.CalciteException > <init> > > SEVERE: org.apache.calcite.runtime.CalciteContextException: From line 1, > column 15 to line 1, column 30: Table > 's3sccapachedrill.root.oletv_server_event.log.2014-12-16-10-55.csv' not > found > > Error: PARSE ERROR: From line 1, column 15 to line 1, column 30: Table > 's3sccapachedrill.root.oletv_server_event.log.2014-12-16-10-55.csv' not > found > > > > > > [Error Id: fc5d792b-2336-40e2-b89f-df3a593e090d on > macbookair-7f99.home:31010] (state=,code=0) > > > > > > See “Part 3” for the full http url for the file. > > > > =====>>>>> Part 2 <<<<========= > > > > Here is the configuration that I’m using for the s3sccapachedrill > storage plugin > > > > > > { > > "type": "file", > > "enabled": true, > > "connection": "s3://sccapachedrill/ <s3://sccapachedrill/>", > > "workspaces": { > > "root": { > > "location": "/", > > "writable": false, > > "defaultInputFormat": null > > }, > > "tmp": { > > "location": "/tmp", > > "writable": true, > > "defaultInputFormat": null > > } > > }, > > "formats": { > > "psv": { > > "type": "text", > > "extensions": [ > > "tbl" > > ], > > "delimiter": "|" > > }, > > "csv": { > > "type": "text", > > "extensions": [ > > "csv" > > ], > > "delimiter": "," > > }, > > "tsv": { > > "type": "text", > > "extensions": [ > > "tsv" > > ], > > "delimiter": "\t" > > }, > > "parquet": { > > "type": "parquet" > > }, > > "json": { > > "type": "json" > > }, > > "avro": { > > "type": "avro" > > } > > } > > } > > > > =====>>>>> Part 3 <<<<========= > > Here is the path to the s3 file > > > > > https://s3-us-west-2.amazonaws.com/sccapachedrill/oletv_server_event.log.2014-12-16-10-55.csv > < > https://s3-us-west-2.amazonaws.com/sccapachedrill/oletv_server_event.log.2014-12-16-10-55.csv > > > > > > > > =====>>>>> Part 4 <<<<========= > > Here is the contents of my hadoop_excludes.txt > > > > asm > > jackson > > mockito > > log4j > > logging > > slf4j > > jetty > > jasper > > jersey > > eclipse > > common > > guava > > servlet > > parquet > > > > =====>>>>> Part 5 <<<<========= > > A view of the end of the sqlline.log where the command to view the file > as a table blew up looks like: > > > > > > 2015-09-16 12:07:22,093 [2a065e36-7ead-e8a3-70f3-5a9bf12c4abe:foreman] > INFO o.a.d.e.planner.sql.DrillSqlWorker - User Error Occurred > > org.apache.drill.common.exceptions.UserException: PARSE ERROR: From line > 1, column 15 to line 1, column 30: Table > 's3sccapachedrill.root.oletv_server_event.log.2014-12-16-10-55.csv' not > found > > > > > > [Error Id: fc5d792b-2336-40e2-b89f-df3a593e090d ] > > at > org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:523) > ~[drill-common-1.1.0.jar:1.1.0] > > at > org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:181) > [drill-java-exec-1.1.0.jar:1.1.0] > > at > org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:903) > [drill-java-exec-1.1.0.jar:1.1.0] > > at > org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:242) > [drill-java-exec-1.1.0.jar:1.1.0] > > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > [na:1.8.0_45] > > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > [na:1.8.0_45] > > at java.lang.Thread.run(Thread.java:745) [na:1.8.0_45] > > Caused by: org.apache.calcite.tools.ValidationException: > org.apache.calcite.runtime.CalciteContextException: From line 1, column 15 > to line 1, column 30: Table > 's3sccapachedrill.root.oletv_server_event.log.2014-12-16-10-55.csv' not > found > > at > org.apache.calcite.prepare.PlannerImpl.validate(PlannerImpl.java:176) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > > at > org.apache.calcite.prepare.PlannerImpl.validateAndGetType(PlannerImpl.java:185) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > > at > org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateNode(DefaultSqlHandler.java:428) > ~[drill-java-exec-1.1.0.jar:1.1.0] > > at > org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateAndConvert(DefaultSqlHandler.java:188) > ~[drill-java-exec-1.1.0.jar:1.1.0] > > at > org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:157) > ~[drill-java-exec-1.1.0.jar:1.1.0] > > at > org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:178) > [drill-java-exec-1.1.0.jar:1.1.0] > > ... 5 common frames omitted > > Caused by: org.apache.calcite.runtime.CalciteContextException: From line > 1, column 15 to line 1, column 30: Table > 's3sccapachedrill.root.oletv_server_event.log.2014-12-16-10-55.csv' not > found > > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native > Method) ~[na:1.8.0_45] > > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) > ~[na:1.8.0_45] > > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > ~[na:1.8.0_45] > > at java.lang.reflect.Constructor.newInstance(Constructor.java:422) > ~[na:1.8.0_45] > > at > org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:348) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > > at > org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:689) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > > at > org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:674) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > > at > org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:3750) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > > at > org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:106) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > > at > org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:86) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > > at > org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:874) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > > at > org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:863) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > > at > org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2745) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > > at > org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2730) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > > at > org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:2953) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > > at > org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > > at > org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:86) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > > at > org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:874) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > > at > org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:863) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > > at org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:210) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > > at > org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:837) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > > at > org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:552) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > > at > org.apache.calcite.prepare.PlannerImpl.validate(PlannerImpl.java:174) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > > ... 10 common frames omitted > > Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Table > 's3sccapachedrill.root.oletv_server_event.log.2014-12-16-10-55.csv' not > found > > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native > Method) ~[na:1.8.0_45] > > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) > ~[na:1.8.0_45] > > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > ~[na:1.8.0_45] > > at java.lang.reflect.Constructor.newInstance(Constructor.java:422) > ~[na:1.8.0_45] > > at > org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:348) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > > at > org.apache.calcite.runtime.Resources$ExInst.ex(Resources.java:457) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > > ... 28 common frames omitted > > 2015-09-16 12:07:22,095 [2a065e36-7ead-e8a3-70f3-5a9bf12c4abe:foreman] > INFO o.a.drill.exec.work.foreman.Foreman - State change requested. > PENDING --> FAILED > > org.apache.drill.exec.work.foreman.ForemanException: Unexpected > exception during fragment initialization: PARSE ERROR: From line 1, column > 15 to line 1, column 30: Table > 's3sccapachedrill.root.oletv_server_event.log.2014-12-16-10-55.csv' not > found > > > > > > [Error Id: fc5d792b-2336-40e2-b89f-df3a593e090d ] > > at > org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:253) > [drill-java-exec-1.1.0.jar:1.1.0] > > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > [na:1.8.0_45] > > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > [na:1.8.0_45] > > at java.lang.Thread.run(Thread.java:745) [na:1.8.0_45] > > Caused by: org.apache.drill.common.exceptions.UserException: PARSE > ERROR: From line 1, column 15 to line 1, column 30: Table > 's3sccapachedrill.root.oletv_server_event.log.2014-12-16-10-55.csv' not > found > > > > > > [Error Id: fc5d792b-2336-40e2-b89f-df3a593e090d ] > > at > org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:523) > ~[drill-common-1.1.0.jar:1.1.0] > > at > org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:181) > ~[drill-java-exec-1.1.0.jar:1.1.0] > > at > org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:903) > [drill-java-exec-1.1.0.jar:1.1.0] > > at > org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:242) > [drill-java-exec-1.1.0.jar:1.1.0] > > ... 3 common frames omitted > > Caused by: org.apache.calcite.tools.ValidationException: > org.apache.calcite.runtime.CalciteContextException: From line 1, column 15 > to line 1, column 30: Table > 's3sccapachedrill.root.oletv_server_event.log.2014-12-16-10-55.csv' not > found > > at > org.apache.calcite.prepare.PlannerImpl.validate(PlannerImpl.java:176) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > > at > org.apache.calcite.prepare.PlannerImpl.validateAndGetType(PlannerImpl.java:185) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > > at > org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateNode(DefaultSqlHandler.java:428) > ~[drill-java-exec-1.1.0.jar:1.1.0] > > at > org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateAndConvert(DefaultSqlHandler.java:188) > ~[drill-java-exec-1.1.0.jar:1.1.0] > > at > org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:157) > ~[drill-java-exec-1.1.0.jar:1.1.0] > > at > org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:178) > ~[drill-java-exec-1.1.0.jar:1.1.0] > > ... 5 common frames omitted > > Caused by: org.apache.calcite.runtime.CalciteContextException: From line > 1, column 15 to line 1, column 30: Table > 's3sccapachedrill.root.oletv_server_event.log.2014-12-16-10-55.csv' not > found > > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native > Method) ~[na:1.8.0_45] > > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) > ~[na:1.8.0_45] > > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > ~[na:1.8.0_45] > > at java.lang.reflect.Constructor.newInstance(Constructor.java:422) > ~[na:1.8.0_45] > > at > org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:348) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > > at > org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:689) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > > at > org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:674) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > > at > org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:3750) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > > at > org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:106) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > > at > org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:86) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > > at > org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:874) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > > at > org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:863) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > > at > org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2745) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > > at > org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2730) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > > at > org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:2953) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > > at > org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > > at > org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:86) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > > at > org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:874) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > > at > org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:863) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > > at org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:210) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > > at > org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:837) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > > at > org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:552) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > > at > org.apache.calcite.prepare.PlannerImpl.validate(PlannerImpl.java:174) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > > ... 10 common frames omitted > > Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Table > 's3sccapachedrill.root.oletv_server_event.log.2014-12-16-10-55.csv' not > found > > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native > Method) ~[na:1.8.0_45] > > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) > ~[na:1.8.0_45] > > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > ~[na:1.8.0_45] > > at java.lang.reflect.Constructor.newInstance(Constructor.java:422) > ~[na:1.8.0_45] > > at > org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:348) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > > at > org.apache.calcite.runtime.Resources$ExInst.ex(Resources.java:457) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > > ... 28 common frames omitted > > 2015-09-16 12:07:22,096 [2a065e36-7ead-e8a3-70f3-5a9bf12c4abe:foreman] > INFO o.a.drill.exec.work.foreman.Foreman - foreman cleaning up. > > 2015-09-16 12:07:22,106 [Client-1] INFO > o.a.d.j.i.DrillResultSetImpl$ResultsListener - [#18] Query failed: > > org.apache.drill.common.exceptions.UserRemoteException: PARSE ERROR: > From line 1, column 15 to line 1, column 30: Table > 's3sccapachedrill.root.oletv_server_event.log.2014-12-16-10-55.csv' not > found > > > > > > [Error Id: fc5d792b-2336-40e2-b89f-df3a593e090d on > macbookair-7f99.home:31010] > > at > org.apache.drill.exec.rpc.user.QueryResultHandler.resultArrived(QueryResultHandler.java:118) > [drill-java-exec-1.1.0.jar:1.1.0] > > at > org.apache.drill.exec.rpc.user.UserClient.handleReponse(UserClient.java:111) > [drill-java-exec-1.1.0.jar:1.1.0] > > at > org.apache.drill.exec.rpc.BasicClientWithConnection.handle(BasicClientWithConnection.java:47) > [drill-java-exec-1.1.0.jar:1.1.0] > > at > org.apache.drill.exec.rpc.BasicClientWithConnection.handle(BasicClientWithConnection.java:32) > [drill-java-exec-1.1.0.jar:1.1.0] > > at org.apache.drill.exec.rpc.RpcBus.handle(RpcBus.java:61) > [drill-java-exec-1.1.0.jar:1.1.0] > > at > org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:233) > [drill-java-exec-1.1.0.jar:1.1.0] > > at > org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:205) > [drill-java-exec-1.1.0.jar:1.1.0] > > at > io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:89) > [netty-codec-4.0.27.Final.jar:4.0.27.Final] > > at > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339) > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > > at > io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324) > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > > at > io.netty.handler.timeout.IdleStateHandler.channelRead(IdleStateHandler.java:254) > [netty-handler-4.0.27.Final.jar:4.0.27.Final] > > at > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339) > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > > at > io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324) > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > > at > io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:103) > [netty-codec-4.0.27.Final.jar:4.0.27.Final] > > at > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339) > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > > at > io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324) > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > > at > io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:242) > [netty-codec-4.0.27.Final.jar:4.0.27.Final] > > at > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339) > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > > at > io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324) > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > > at > io.netty.channel.ChannelInboundHandlerAdapter.channelRead(ChannelInboundHandlerAdapter.java:86) > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > > at > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339) > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > > at > io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324) > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > > at > io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:847) > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > > at > io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:131) > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > > at > io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:511) > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > > at > io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:468) > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > > at > io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:382) > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > > at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:354) > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > > at > io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:111) > [netty-common-4.0.27.Final.jar:4.0.27.Final] > > at java.lang.Thread.run(Thread.java:745) [na:1.8.0_45] > >
