Create Hive table From File in HDFS- Lab Training with Assignment: bigtable in HIVE, load data CSV
WARM WELCOME TO OUR CHANNEL
Welcome Guys !! [big data platform]
Today this is our first lab training in which we have gone through basic overview of hive structure as creating database, Creating table in hive, getting structure of hive table and fetching records through HiveQL.
We will be doing more hands on: do subscribe our channel for more videos. Please find the below link for Big Data overview.
https://goo.gl/JpKTMm
I have given the assignment details below, please try to do these in your spare time with your machine.
Hadoop Basic Assignment 1: HIVE
1. Create txt file as below
Input Data
Employee.txt - has the following columns - EmpID, Name, Band, DepartmentID, Salary
Employee.txt
A1001,Ramesh,B1,IT,40000
A1002,Ganesh,B2,HR,35000
A1003,Latha,B1,HR,30000
A1008,Shirish,B2, IT,55000
A1009,Shibu,B2, MKTG,48000
2. Create a database in hive.
3. Create a table employee to store data in employee.txt under your created database.
4. List the structure of employee table
5. List data in employee table using select statement (make sure that the output has column headers)
DROP THE COMMENTS BELOW IF YOU HAVE ANY DOUBTS
Hope you Guys had liked this video and found this helpful if yes so please Hit on SUBSCRIBE button. There is a lot of videos are coming for you guys.
Check out our website : http://www.technofun.tk/
Don''t Forget To Check Out These Videos[You Gotta Watch These At-least Once]
Most Recent Upload: https://goo.gl/7AaULr
Most Popular Upload: https://goo.gl/5216JU
ᴛᴇᴄʜɴᴏғᴜɴ : https://goo.gl/pgHBBI
**************Likes & Subscribe ***************
**************HELP US TO GROW**************
**************SUPPORT NEEDED***************
Follow me on Facebook:- https://www/facebook.com/AdminSumi
Follow me on Instagram:- / sumitbutola
Facebook Page:- / bemysidefreely
TAKE CARE YOU TUBERS & STAY BLESSED :)