/tags/release-0.0.0-rc0/hive/external/ql/src/test/queries/clientpositive/input4_cb_delim.q
text | 4 lines | 3 code | 1 blank | 0 comment | 0 complexity | 9d8fb0e1e6ca16846ded518bec25f51f MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0
- CREATE TABLE INPUT4_CB(KEY STRING, VALUE STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\002' LINES TERMINATED BY '\012' STORED AS TEXTFILE;
- LOAD DATA LOCAL INPATH '../data/files/kv1_cb.txt' INTO TABLE INPUT4_CB;
- SELECT INPUT4_CB.VALUE, INPUT4_CB.KEY FROM INPUT4_CB;