Apache Hadoop : Hive table creating and data loading Example on Crime Data

Hive table creating and data loading  Example on Crime Data

create table Crimedata(id int,case_number String,date String, block 

String,iucr int,primary_type String,description String,location_description 

String,arrest String,domestic String,beat int,district int,ward 

int,community_area int,fbi_code int,x_coordinate bigint,y_coordinate 

bigint,year int,update_on timestamp,latitude float,longitude float,location 

float)

row format delimited
fields terminated by ','
stored as textfile;

load data local inpath '/root/data/crimes_-_2001_to_present.csv' overwrite

into table crimedata;



Downloads file Crime Data

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

Subscribe by Email

Follow Updates Articles from This Blog via Email