Apache Hive : Hive table creating and data loading Example on traffic_violation Data

Hive table creating and data loading  Example on traffic_violation Data

 

create table traffic_violation(date_of_stop String,time_of_stop timestamp,agency String,subagency String,description String,location String,latitude String,longitude float,accident String,belts String,personal String,property_damage String,fatal String,commercial String,hazmat String,commercial_vechicle String,alcohol String,work_zone String,state String,vehicle_Type String,year int,make String,model String,color String,violation_type String,charge bigint,article String,contribted_to_accident String,race String,gender String,driver_city String,driver_state String,dl_state String,arrest_type String,geolocation String)
row format delimited
fields terminated by ','
stored as textfile;

 Load data in your table

 

load data local inpath '/root/manish/Traffic_Violations.csv' overwrite into table traffic_violation;

 Downloads file traffic_violation Data

Posted by : DataScience99.com 03:06 Tags : Hive Tutorials

Subscribe by Email

Follow Updates Articles from This Blog via Email