blob: 95621246ee9e77b59acd240fcb5e6fb80ca64909 [file] [log] [blame]
--! qt:dataset:src1
-- SORT_QUERY_RESULTS
CREATE TABLE src1_rot13_iof(key STRING, value STRING)
STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.udf.Rot13InputFormat'
OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.udf.Rot13OutputFormat';
DESCRIBE EXTENDED src1_rot13_iof;
SELECT * FROM src1;
INSERT OVERWRITE TABLE src1_rot13_iof SELECT * FROM src1;
SELECT * FROM src1_rot13_iof;