Apache Hadoop : Hive Table Creating

Hive is a data warehouse infrastructure tool to process structured data in Hadoop. It resides on top of Hadoop to summarize Big Data, and makes querying and analyzing easy.


Overview on Hive Table

create table consumer_complaints (date timestamp,product String,sub_product String,Issue String,Company_response_to_consumer
String,Timely_response String,Consumer_disputed String,ComplaintID int)

row format delimited

fields terminated by ','

lines terminated by'\n'
stored as textfile;

load data local inpath '/root/manish/Consumer_Complaints.csv' overwrite into table consumer_complaints;

Downloads

Consumer_Complaints

Posted by : DataScience99.com 11:25 Tags : Hive Tutorials

Subscribe by Email

Follow Updates Articles from This Blog via Email