blob: 2e4d73d75c80cb91dccde0a01db04c0980182bf4 [file] [log] [blame]
set hive.mapred.mode=nonstrict;
DROP TABLE stored_as_custom_text_serde;
CREATE TABLE stored_as_custom_text_serde(key string, value string) STORED AS customtextserde;
LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE stored_as_custom_text_serde;
SELECT * FROM stored_as_custom_text_serde ORDER BY key, value;
DROP TABLE stored_as_custom_text_serde;