I followed instructions from http://drill.apache.org/blog/2014/12/09/running-sql-queries-on-amazon-s3/ to configure s3 plugin on an embedded drill instance. I have one file, test.json, in my s3 bucket. It seems that drill is able to connect to the s3 bucket but unable to "see" test.json file on it.
0: jdbc:drill:zk=local> show schemas; *+----------------------------------+* *| ** SCHEMA_NAME ** |* *+----------------------------------+* *| *INFORMATION_SCHEMA * |* *| *cp.default * |* *| *dfs.default * |* *| *dfs.ob-tes * |* *| *dfs.root * |* *| *dfs.tmp * |* *| *s3-drill-tempalert-demo.default * |* *| *s3-drill-tempalert-demo.root * |* *| *sys * |* *+----------------------------------+* 0: jdbc:drill:zk=local> use `s3-drill-tempalert-demo`.`root`; *+-------+-----------------------------------------------------------+* *| ** ok ** | ** summary ** |* *+-------+-----------------------------------------------------------+* *| *true * | *Default schema changed to [s3-drill-tempalert-demo.root] * |* *+-------+-----------------------------------------------------------+* 1 row selected (0.076 seconds) 0: jdbc:drill:zk=local> select * from dfs.`/test.json`; Jun 14, 2015 4:43:32 PM org.apache.calcite.sql.validate.SqlValidatorException <init> SEVERE: org.apache.calcite.sql.validate.SqlValidatorException: Table 'dfs./test.json' not found Jun 14, 2015 4:43:32 PM org.apache.calcite.runtime.CalciteException <init> SEVERE: org.apache.calcite.runtime.CalciteContextException: From line 1, column 15 to line 1, column 17: Table 'dfs./test.json' not found *Error: PARSE ERROR: From line 1, column 15 to line 1, column 17: Table 'dfs./test.json' not found* *[Error Id: 21fe88be-e60a-451a-9abe-32ea3c27ce70 on 192.168.2.110:31010 <http://192.168.2.110:31010>]* * (org.apache.calcite.tools.ValidationException) org.apache.calcite.runtime.CalciteContextException: From line 1, column 15 to line 1, column 17: Table 'dfs./test.json' not found* I've also tried the following queries, but got the same error: select * from dfs.`/test.json`; What am I doing wrong? Is s3 not supported on embedded drill? Omar
