Search code examples
apache-drill

Does Apache Drill Support Excel Files (.xls)

I am trying to query for excel files (.xls) through dfs storage plugin:-

select * from dfs.`E:/Demos/Sample.xls`;

But It throwing some error:--

org.apache.drill.common.exceptions.UserRemoteException: VALIDATION ERROR: From line 1, column 15 to line 1, column 17: Table 'dfs.E:/Demos/Sample.xls' not found SQL Query null

Same Problem with Ms Access file. if i query through some Microsoft Access(.accdb)files, It throwing error.

My Question is :- Whether Apache Drill Supports Excel and Ms Access Files or not.???

Solution

  • There is a storage plugin for Apache Drill available that supports querying Excel files: https://github.com/bizreach/drill-excel-plugin