Does Apache Drill Support Excel Files (.xls)

0
votes

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.???

4
apache-drill

4 Answers

2
votes

Also there is an open PR for Excel plugin in Apache Drill (https://github.com/apache/drill/pull/1749), so most likely it will be available in Drill 1.17.

1
votes

Drill doesn't currently support querying MS Excel or Access files directly.

Someone asked a similar question on Drill's mailing list and Andries gave him the following answer:

You can use the Drill ODBC driver, and then query Drill using MS Query or the same way you would query another DB engine through an ODBC DSN.

1
votes

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

1
votes

This feature is now integrated into Drill.