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]

Reply via email to