Install Apache Drill on Ubuntu 14.04

Hi guys,

Today, we are going to install Apache Drill. It is a framework which allows to run ad-hoc queries on any data sources. These data sources can be mongodb, hbase, csv file, json file, etc. Lets start with its installation

First, Install Oracle JDK 1.7 on your machine, for this follow this link [https://www.digitalocean.com/community/tutorials/how-to-install-java-on-ubuntu-with-apt-get]

 

1) Download it on ubuntu using “wget http://getdrill.org/drill/download/apache-drill-0.9.0.tar.gz

2) Create directory for its installations “sudo mkdir -p /opt/drill

3) Unzip it into its installation directory “sudo tar -xvzf apache-drill-0.9.0.tar.gz -C /opt/drill

4) Open its directory “cd /opt/drill/apache-drill-0.9.0

5) Run it using “bin/sqlline -u jdbc:drill:zk=local

6) Lets query some json files, download json file [http://media.mongodb.org/zips.json?_ga=1.139282992.2048111731.1429111258] and save it to “/home/yourusername/zips.json

7) Query this file using “SELECT * from dfs.`/home/yourusername/zips.json`

Cheers

Advertisements

0 Responses to “Install Apache Drill on Ubuntu 14.04”



  1. Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s





%d bloggers like this: