ql/src/test/queries/clientpositive/partition_ctas.q

--! qt:dataset:src

EXPLAIN
CREATE TABLE partition_ctas_1 PARTITIONED BY (key) AS
SELECT value, key FROM src where key > 200 and key < 300;

CREATE TABLE partition_ctas_1 PARTITIONED BY (key) AS
SELECT value, key FROM src where key > 200 and key < 300;

DESCRIBE FORMATTED partition_ctas_1;

EXPLAIN
SELECT * FROM partition_ctas_1 where key = 238;

SELECT * FROM partition_ctas_1 where key = 238;

CREATE TABLE partition_ctas_2 PARTITIONED BY (value) AS
SELECT key, value FROM src where key > 200 and key < 300;

EXPLAIN
SELECT * FROM partition_ctas_2 where value = 'val_238';

SELECT * FROM partition_ctas_2 where value = 'val_238';

EXPLAIN
SELECT value FROM partition_ctas_2 where key = 238;

SELECT value FROM partition_ctas_2 where key = 238;

CREATE TABLE partition_ctas_diff_order PARTITIONED BY (value) AS
SELECT value, key FROM src where key > 200 and key < 300;

EXPLAIN
SELECT * FROM partition_ctas_diff_order where value = 'val_238';

SELECT * FROM partition_ctas_diff_order where value = 'val_238';

CREATE TABLE partition_ctas_complex_order PARTITIONED BY (c0, c4, c1) AS
SELECT concat(value, '_0') as c0,
       concat(value, '_1') as c1,
       concat(value, '_2') as c2,
       concat(value, '_3') as c3,
       concat(value, '_5') as c5,
       concat(value, '_4') as c4
FROM src where key > 200 and key < 240;

-- c2, c3, c5, c0, c4, c1
EXPLAIN
SELECT * FROM partition_ctas_complex_order where c0 = 'val_238_0';

SELECT * FROM partition_ctas_complex_order where c0 = 'val_238_0';