| --! qt:dataset:src | |
| dfs ${system:test.dfs.mkdir} ${system:test.tmp.dir}/tmpsepatest; | |
| CREATE TABLE separator_test | |
| ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde' | |
| WITH SERDEPROPERTIES ("separatorChar" = "|","quoteChar"="\"","escapeChar"=" | |
| ") | |
| STORED AS TEXTFILE | |
| LOCATION 'file:${system:test.tmp.dir}/tmpsepatest' | |
| AS | |
| SELECT * FROM src where key = 100 limit 1; | |
| dfs -cat ${system:test.tmp.dir}/tmpsepatest/000000_0; | |
| drop table separator_test; |