CREATE EXTERNAL TABLE IF NOT EXISTS student2
    > (sno INT,sname STRING,age INT,sex STRING)   
    > ROW FORMAT DELIMITED                        
    > FIELDS TERMINATED BY ‘\t‘                   
    > STORED AS TEXTFILE                          
    > LOCATION ‘/user/external‘;    

 LOAD DATA LOCAL INPATH ‘/home/hadoop/data/student1.txt‘ INTO TABLE student1;