Saturday, November 21, 2015

Apache Drill : Run query through Microsoft Excel

In this short demo I will demonstrate you how to setup Drill with Microsoft Excel and execute the query.I this example I am using Microsoft Excel 2011 edition.
1.Download Apache drill from
2.Extract at some location and start drill into embedded mode using $DRILL_HOME/bin/drill-embedded
3.Download and configure MapR Drill ODBC driver according to your env
4.update the ODBC datasource configuration as follows
5. open MS Excel, go to data-> get external data-> new databse query -> select drill datasource
6. click test query to run your query.
Post a Comment