hive_simple_csv.sql

drop table simple_csv;

create external table simple_csv(
  field1 string,
  field2 string,
  field3 string,
  field4 string,
  field5 string,
  field6 string,
  field7 string,
  field8 string,
  field9 string,
  field10 string    
)
row format delimited fields terminated by ',' 
stored as textfile 
location '/test/simple_csv'
--TBLPROPERTIES('skip.header.line.count'='1');
;