edureka!

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: