[haritaraka12078@cxln4 ~]$ hadoop fs -put -p student.txt
[haritaraka12078@cxln4 ~]$ hadoop fs -cat student.txt
subhash|800|1990
venkat|100|1991
ram|300|1992
subhash|200|1993
Kamesh|400|1994
Prasad|500|1995
Vamsi|600|1996
adimulam|900|1997
--------------------------------------------------------------------------------------------------------------------------
load data inpath '/user/haritaraka12078/student.txt' overwrite into table student;
--------------------------------------------------------------------------------------------------------------------------
LOAD DATA LOCAL inpath '/home/haritaraka12078/student.txt' INTO TABLE student3;
--------------------------------------------------------------------------------------------------------------------------
insert into table student3 values('prabhutaraka',200,10000);
--------------------------------------------------------------------------------------------------------------------------
insert into table student3(id, year) values(200,10000);
--------------------------------------------------------------------------------------------------------------------------
insert into mhtprabhu.emp_sample select * from venkat_db.pet_owners limit 20;
--------------------------------------------------------------------------------------------------------------------------
