Hadoop - Hive - Load data from csv/xls files
We know that Hadoop helps to store mass data, process and analyze the same very fast. It is not easy for non java developers to extract and analyze the data from Hadoop framework but with the development of Hive any non java database developers can easily do the data analysis quickly. Hive is developed in Facebook labs and the syntax is more similar to all other Structured Query Languages such as Oracle , SQL server, MySQL etc. Pig which I have explained in my previous post can consider as alternative to Hive. Pig was developed at Yahoo! about the same time Facebook was developing Hive. Hive is used for OLAP purpose than the OLTP whereas Pig is considered as ETL language for Hadoop. To illustrate the Hive syntax and use, I thought it is best to load the data from Adventureworks DW database. I followed below steps to load data from Adventureworks database to file and to Hadoop eco system. 1. Pull the records from required tables to xlsx files 2. Browse the csv file from Hadoo
Contact us for industrial soundproofing acoustic treatment.
ReplyDeleteIndustrial Noise Control Solutions
More impressive Blog!!! Its more useful for us...Thanks for sharing with us...
ReplyDeleteBig Data Training in Chennai
Big Data Training in Bangalore
Big Data Online Course
Big Data Course in Coimbatore
This is really informative blog, I have to thank for your efforts. Waiting for more post like this.
ReplyDeleteData Analytics Courses in Chennai
Data Analytics courses in Bangalore
Data Analytics courses in Coimbatore
Hadoop Admin Training in Chennai
Great Post!!! thanks for sharing.
ReplyDeleteWhy is Big Data Important?
How to Learn Big Data?