--! qt:dataset:src
--! qt:dataset:part

set hive.vectorized.execution.enabled=false;
set hive.mapred.mode=nonstrict;
set mapred.max.split.size=100;
set mapred.min.split.size=1;
set hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat;

DROP TABLE orc_createas1a;
DROP TABLE orc_createas1b;
DROP TABLE orc_createas1c;

CREATE TABLE orc_createas1a (key INT, value STRING)
    PARTITIONED BY (ds string);
INSERT OVERWRITE TABLE orc_createas1a PARTITION (ds='1')
    SELECT * FROM src;
INSERT OVERWRITE TABLE orc_createas1a PARTITION (ds='2')
    SELECT * FROM src;

EXPLAIN CREATE TABLE orc_createas1b
    STORED AS ORC AS
    SELECT * FROM src;

CREATE TABLE orc_createas1b
    STORED AS ORC AS
    SELECT * FROM src;

EXPLAIN SELECT * FROM orc_createas1b ORDER BY key LIMIT 5;

SELECT * FROM orc_createas1b ORDER BY key LIMIT 5;

EXPLAIN
    CREATE TABLE orc_createas1c
    STORED AS ORC AS 
        SELECT key, value, PMOD(HASH(key), 50) as part
        FROM orc_createas1a;
CREATE TABLE orc_createas1c
    STORED AS ORC AS 
        SELECT key, value, PMOD(HASH(key), 50) as part
        FROM orc_createas1a;

SELECT SUM(HASH(c)) FROM (
    SELECT TRANSFORM(key, value) USING 'tr \t _' AS (c)
    FROM orc_createas1a
) t;
SELECT SUM(HASH(c)) FROM (
    SELECT TRANSFORM(key, value) USING 'tr \t _' AS (c)
    FROM orc_createas1c
) t;

DROP TABLE orc_createas1a;
DROP TABLE orc_createas1b;
DROP TABLE orc_createas1c;