BWvxpZXf

1CREATE EXTERNAL TABLE IF NOT EXISTS TABLENAME
2(row INT, row1 STRING, row2 STRING, row3 STRING, row4 INT) 
3ROW FORMAT DELIMITED 
4FIELDS TERMINATED BY ','
5STORED AS TEXTFILE
6LOCATION '${INPUT}/Topic/data/'
7TBLPROPERTIES ("skip.header.line.count "="1");
8
9select * from TABLENAME limit 100;