• Home
  • Archive
  • Tools
  • Contact Us

The Customize Windows

Technology Journal

  • Cloud Computing
  • Computer
  • Digital Photography
  • Windows 7
  • Archive
  • Cloud Computing
  • Virtualization
  • Computer and Internet
  • Digital Photography
  • Android
  • Sysadmin
  • Electronics
  • Big Data
  • Virtualization
  • Downloads
  • Web Development
  • Apple
  • Android
Advertisement
You are here: Home » Install Apache Drill on Ubuntu 16.04 LTS Single Cloud Server

By Abhishek Ghosh August 9, 2017 4:21 pm Updated on August 9, 2017

Install Apache Drill on Ubuntu 16.04 LTS Single Cloud Server

Advertisement

Apache Drill is SQL Query Engine for Hadoop, NoSQL, Cloud Storage and file systems including HBase, MongoDB, MapR-DB, HDFS, MapR-FS, Amazon S3, Azure Blob Storage, Google Cloud Storage, Swift, NAS and local files. As example, we can join a collection in MongoDB with a directory of event logs in Hadoop. Apache Drill features JSON data model which enables queries on complex and nested data. Drill has extensions to SQL to easily query complex data. We can install Apache Drill on single cluster or multiple cluster. Here is how to install Apache Drill on Ubuntu 16.04 LTS single cloud server. Drillbit is Drill’s daemon which runs on each node of the cluster using ZooKeeper for all communication in the cluster. Drillbit which receives the request from the client is called Foreman.

 

Install Apache Drill on Ubuntu 16.04 LTS Single Cloud Server

 

Follow our basic server setup guide to create a user with root privilege and enable other optional basic security.

We need Java, so run :

Advertisement

---

Vim
1
2
3
apt update
apt updgrade
apt install default-jdk

Test :

Vim
1
java -version

Now we need to update newest version of Apache Drill :

Vim
1
http://www.apache.org/dyn/closer.cgi/drill/

Example commands :

Vim
1
2
3
4
5
6
cd /temp
wget http://getdrill.org/drill/download/apache-drill-1.11.0.tar.gz
cp apache-drill-1.11.0.tar.gz /usr/local
cd /usr/local
tar -xzvf apache-drill-1.11.0.tar.gz
mv apache-drill-1.11.0 drill

Update ~/.bashrc file with following contents :

Vim
1
2
3
4
#DRILL STARTS
export DRILL_HOME=/usr/local/drill
export PATH=$PATH:$DRILL_HOME/bin
#DRILL ENDS

Source :

Vim
1
source ~/.bashrc

To run drill agent, run these commands :

Vim
1
2
sudo chmod -R 777 /usr/local/drill
sqlline -u jdbc:drill:zk=local

To verify Drill installation, run the following command :

Vim
1
jps

Use the following command to log into Drill Command Prompt :

Vim
1
sqlline -u jdbc:drill:zk=local

To start the Drill shell in embedded mode, we will use the drill-embedded command which will use a jdbc connection string and identifies the local node as the ZooKeeper node. So we will navigate to the Drill installation directory (/usr/local/drill in our case) and run the following commands :

Vim
1
root@lalala:/usr/local/drill# bin/drill-embedded

Drill will run on port 8047 :

Vim
1
netstat -nlpt|grep 8047

To exit the Drill shell, we need to run !quit as command.

To install Drill on nodes, we need to configure a cluster ID and add Zookeeper information. We need install Apache ZooKeeper :

Vim
1
apt install zookeeperd

ZooKeeper will be started as a daemon listening on port 2181 :

Vim
1
sudo netstat -nlpt | grep ':2181'

I am not describing those steps for cluster configuration as it can be a separate guide in future and optional for test purpose. You can access the Apache Drill Web Interface with this address pattern :

Vim
1
http://IP.ADDRESS:8047

Install Apache Drill on Ubuntu 16-04 LTS Single Cloud Server

Rest you can read from Apache Drill’s official documentation.

Tagged With ubuntu install apache-drill , drill command for ubuntu , CERZ , apache drill start web service ubuntu , apache drill in ubuntu12 04 download , apache drill commands in ubuntu , apache drill 16 04 , 983W , 4UQ4 , 2BFS

This Article Has Been Shared 253 Times!

Facebook Twitter Pinterest

Abhishek Ghosh

About Abhishek Ghosh

Abhishek Ghosh is a Businessman, Surgeon, Author and Blogger. You can keep touch with him on Twitter - @AbhishekCTRL.

Here’s what we’ve got for you which might like :

Articles Related to Install Apache Drill on Ubuntu 16.04 LTS Single Cloud Server

  • Steps To Install Nginx Plus on Ubuntu Server (HP Cloud)

    Here Are the Steps To Install Nginx Plus on Ubuntu Server Running on HP Cloud. Nginx Plus is the Paid Version of Nginx with Extra Features.

  • Installing Local Data Lake on Ubuntu Server : Part 1

    Here is Part 1 of Installing Local Data Lake on Ubuntu Server With Hadoop, Spark, Thriftserver, Jupyter etc To Build a Prediction System.

  • Integration of Apache Hadoop With OpenStack Swift

    The Topic Integration of Apache Hadoop With OpenStack Swift Is Not Exactly New. You Can Follow Our Guide Specially For Handling OpenStack.

  • Install Apache Mahout : Ubuntu 16.04 For Machine Learning Dev

    Here Is How To Install Apache Mahout On Ubuntu 16.04 For Machine Learning Development. We Can Install & Integrate Mahout With Spark, Hadoop.

  • IBM Analytics Demo Cloud : Free Hadoop, Ambari With SSH

    IBM Analytics Demo Cloud is intended to learn Hadoop, Ambari, BigSQL free of cost with SSH access & web console. Here is how to get started.

Additionally, performing a search on this website can help you. Also, we have YouTube Videos.

Take The Conversation Further ...

We'd love to know your thoughts on this article.
Meet the Author over on Twitter to join the conversation right now!

If you want to Advertise on our Article or want a Sponsored Article, you are invited to Contact us.

Contact Us

Subscribe To Our Free Newsletter

Get new posts by email:

Please Confirm the Subscription When Approval Email Will Arrive in Your Email Inbox as Second Step.

Search this website…

 

Popular Articles

Our Homepage is best place to find popular articles!

Here Are Some Good to Read Articles :

  • Cloud Computing Service Models
  • What is Cloud Computing?
  • Cloud Computing and Social Networks in Mobile Space
  • ARM Processor Architecture
  • What Camera Mode to Choose
  • Indispensable MySQL queries for custom fields in WordPress
  • Windows 7 Speech Recognition Scripting Related Tutorials

Social Networks

  • Pinterest (24.3K Followers)
  • Twitter (5.8k Followers)
  • Facebook (5.7k Followers)
  • LinkedIn (3.7k Followers)
  • YouTube (1.3k Followers)
  • GitHub (Repository)
  • GitHub (Gists)
Looking to publish sponsored article on our website?

Contact us

Recent Posts

  • Is it Good to Run Apache Web server and MySQL Database on Separate Cloud Servers? March 27, 2023
  • Advantages of Cloud Server Over Dedicated Server for Hosting WordPress March 26, 2023
  • Get Audiophile-Grade Music on Your Smartphone March 25, 2023
  • Simple Windows Security and Privacy Checklist for 2023 March 24, 2023
  • 7 Best Artificial Intelligence (AI) Software March 24, 2023

About This Article

Cite this article as: Abhishek Ghosh, "Install Apache Drill on Ubuntu 16.04 LTS Single Cloud Server," in The Customize Windows, August 9, 2017, March 28, 2023, https://thecustomizewindows.com/2017/08/install-apache-drill-ubuntu-16-04-lts-single-cloud-server/.

Source:The Customize Windows, JiMA.in

PC users can consult Corrine Chorney for Security.

Want to know more about us? Read Notability and Mentions & Our Setup.

Copyright © 2023 - The Customize Windows | dESIGNed by The Customize Windows

Copyright  · Privacy Policy  · Advertising Policy  · Terms of Service  · Refund Policy

We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies.
Do not sell my personal information.
Cookie SettingsAccept
Manage consent

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.
CookieDurationDescription
cookielawinfo-checkbox-analytics11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional11 monthsThe cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy11 monthsThe cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.
Functional
Functional cookies help to perform certain functionalities like sharing the content of the website on social media platforms, collect feedbacks, and other third-party features.
Performance
Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.
Analytics
Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc.
Advertisement
Advertisement cookies are used to provide visitors with relevant ads and marketing campaigns. These cookies track visitors across websites and collect information to provide customized ads.
Others
Other uncategorized cookies are those that are being analyzed and have not been classified into a category as yet.
SAVE & ACCEPT