Hi, Can you please try following instruction here [1] once.? Also after configuration you can try to list tables by "show databases" to make sure setup is fine.
And the query should be: SELECT * FROM s3.`./data/part-r-001` LIMIT 100 [1]: https://drill.apache.org/docs/s3-storage-plugin/ Thanks, Sorabh ________________________________ From: Bo Qiang <[email protected]> Sent: Monday, February 5, 2018 9:17 PM To: [email protected] Subject: Apache drill validation error, table not found I have been trying to use Apache drill to query data in s3 buckets. Inside of Drill Explorer, I met the following errors: ERROR [HY000] [MapR][Drill] (1040) Drill failed to execute the query: SELECT * FROM `s3`.`default`.`./data/part-r-001` LIMIT 100 [30034]Query execution error. Details:[ VALIDATION ERROR: From line 1, column 15 to line 1, column 18: Table 's3.default../data/part-r-001' not found SQL Query null [Error Id: fa18496f-038f-46b1-9d3f-c40809511768 on 10.23.58.220:31010] ] at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader) at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior) at DrillExplorer.DROdbcProvider.GetStatmentColumns(String in_query) The part-r-001 file are of ORC format. Is there anything fix? Thanks a lot!
