Data set

100,Kamini,india,edureka


NOTE: Save this data to a file for e.g; data


Hive Command:

==>CREATE TABLE Employee (id INT, name String,country String,company String) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',';

==>LOAD DATA LOCAL INPATH '/home/edureka/Desktop/data' INTO table Employee;

==>Select * from Employee;


Screen shot of output: