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!