--! qt:dataset:src
set hive.mapred.mode=nonstrict;

CREATE table rcfile_unionTable (b STRING, c STRING)
ROW FORMAT SERDE
  'org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe'
STORED AS RCFILE;

FROM src
INSERT OVERWRITE TABLE rcfile_unionTable SELECT src.key, src.value LIMIT 10;

SELECT * FROM (
SELECT b AS cola FROM rcfile_unionTable
UNION ALL
SELECT c AS cola FROM rcfile_unionTable) s ORDER BY cola ASC;