Setting up Apache Phoenix and query HBase using it | Big Data Hadoop Tutorial | Lecture 37

This lecture is all about setting up Apache Phoenix and query HBase using it where we have started the HBase service and ran Phoenix query engine to submit SQL commands on top of HBase tables. We have created HBase table using DDL command and used UPSERT commands to ingest the table and retrieved the data using SELECT.

Below are the commands to kick off the preinstalled Phoenix. (If you are using Hadoop 2.5 or earlier then you may just watch this tutorial as Phoenix will not be available on these Hadoop versions and there is no easy of doing it.)

su root
cd /usr/hdp/current/phoenix-client/bin
python sqlline.py

!tables

CREATE TABLE IF NOT EXISTS employees(
emp_id INTEGER NOT NULL,
emp_name VARCHAR,
job_title VARCHAR
CONSTRAINT my_pk PRIMARY KEY (emp_id)
);

!tables

UPSERT INTO employees VALUES(101,'Rajesh','Developer');
UPSERT INTO employees VALUES(102,'John','Accountant');
UPSERT INTO employees VALUES(103,'Sham','Admin');
UPSERT INTO employees VALUES(104,'Trisha','CEO');
UPSERT INTO employees VALUES(105,'Kevin','Librarian');
UPSERT INTO employees VALUES(106,'Emma','Developer');
UPSERT INTO employees VALUES(107,'Vinod','Clerk');
UPSERT INTO employees VALUES(108,'Bella','Accountant');
-------------------------------------------------------------------------------------------------------------------

In the previous lecture we have seen Apache Phoenix which is a SQL Skin for Apache HBase where we have discussed what is Apache Phoenix, where it sits on the Hadoop Ecosystem and some main features of Phoenix.
-----------------------------------------------------------------------------------------------------------------------

HDP Sandbox Installation links:

Oracle VM Virtualbox: https://download.virtualbox.org/virtualbox/6.1.32/VirtualBox-6.1.32-149290-Win.exe

HDP Sandbox link: https://archive.cloudera.com/hwx-sandbox/hdp/hdp-2.6.5/HDP_2.6.5_virtualbox_180626.ova

HDP Sandbox installation guide: https://hortonworks.com/tutorial/sandbox-deployment-and-install-guide/section/1/

-------------------------------------------------------------------------------------------------------------

Also check out similar informative videos in the field of cloud computing:


What is Big Data: https://youtu.be/-BoykjY5nKg


How Cloud Computing changed the world: https://youtu.be/lf2lQAyW2b4

What is Cloud? https://youtu.be/DeCMeA9Xm2g

Top 10 facts about Cloud Computing that will blow your mind! https://youtu.be/hmxNJEQ4XVY

Audience

This tutorial is made for professionals who are willing to learn the basics of Big Data Analytics using Hadoop Ecosystem and become a Hadoop Developer. Software Professionals, Analytics Professionals, and ETL developers are the key beneficiaries of this course.

Prerequisites

Before you start proceeding with this course, I am assuming that you have some basic knowledge to Core Java, database concepts, and any of the Linux operating system flavors.

---------------------------------------------------------------------------------------------------------------------------

Check out our full course topic wise playlist on some of the most popular technologies:

SQL Full Course Playlist-
https://youtube.com/playlist?list=PL6UwySlcwEYISVLQlYi3W6rGCIo9sJM0J


PYTHON Full Course Playlist-
https://youtube.com/playlist?list=PL6UwySlcwEYJgM4eUQOvR1KAWryFYcclq

Data Warehouse Playlist-

https://youtube.com/playlist?list=PL6UwySlcwEYKxi-fQHLkVYDZrJcBawZA9


Unix Shell Scripting Full Course Playlist-
https://youtube.com/playlist?list=PL6UwySlcwEYIZGsbXnUxsojD0yeUA67lb

--------------------------------------------------------------------------------------------------------------------------
Don't forget to like and follow us on our social media accounts which are linked below.

Facebook-
https://www.facebook.com/ampcode

Instagram-
https://www.instagram.com/ampcode_tutorials/

Twitter-
https://twitter.com/ampcodetutorial

Tumblr-
ampcode.tumblr.com

-------------------------------------------------------------------------------------------------------------------------

Channel Description-

AmpCode provides you e-learning platform with a mission of making education accessible to every student. AmpCode will provide you tutorials, full courses of some of the best technologies in the world today.By subscribing to this channel, you will never miss out on high quality videos on trending topics in the areas of Big Data & Hadoop, DevOps, Machine Learning, Artificial Intelligence, Angular, Data Science, Apache Spark, Python, Selenium, Tableau, AWS , Digital Marketing and many more.

#bigdata #datascience #technology #dataanalytics #datascientist #hadoop #hdfs #hdp #mongodb #cassandra #hbase #nosqldatabase #nosql #pyspark #spark