CREATE TABLE IF NOT EXISTS some_scheme.some_table_by_text (col_01 string, col_02 string,col_03 string) ROW FORMAT DELIMITED FIELDS TERNIMATED BY '\t' LINES TERMINATED BY '\n' STORED AS TEXTFILE;
"A CSVSerde based on OpenCSV has been added. This Serde works for most CSV data, but does not handled embedded newlines. To use the Serde, specify the fully qualified class name org.apache.hadoop.hive.serde2.OpenCSVSerde."
CREATE TABLE IF NOT EXISTS some_scheme.some_table_by_text (col_01 string, col_02 string,col_03 string) ROW FORMAT DELIMITED FIELDS TERNIMATED BY '\t' LINES TERMINATED BY '\n' STORED AS TEXTFILE;