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

--! qt:dataset:src1
--! qt:dataset:src
set hive.compute.query.using.stats=false;
set hive.strict.checks.cartesian.product=false;
set hive.cli.print.header=true;
set hive.explain.user=false;
set hive.fetch.task.conversion=none;
SET hive.vectorized.execution.enabled=true;
set hive.llap.io.enabled=false;
set hive.mapred.mode=nonstrict;
set hive.auto.convert.join=true;

CREATE TABLE orc_create_staging_n0 (
  str STRING,
  mp  MAP<STRING,STRING>,
  lst ARRAY<STRING>,
  strct STRUCT<A:STRING,B:STRING>
) ROW FORMAT DELIMITED
    FIELDS TERMINATED BY '|'
    COLLECTION ITEMS TERMINATED BY ','
    MAP KEYS TERMINATED BY ':';

LOAD DATA LOCAL INPATH '../../data/files/orc_create.txt' OVERWRITE INTO TABLE orc_create_staging_n0;

CREATE TABLE orc_create_complex_n0 (
  str STRING,
  mp  MAP<STRING,STRING>,
  lst ARRAY<STRING>,
  strct STRUCT<A:STRING,B:STRING>,
  val string
) STORED AS ORC tblproperties("orc.row.index.stride"="1000", "orc.stripe.size"="1000", "orc.compress.size"="10000");

INSERT OVERWRITE TABLE orc_create_complex_n0
SELECT orc_create_staging_n0.*, '0' FROM orc_create_staging_n0;

set hive.llap.io.enabled=true;

EXPLAIN VECTORIZATION DETAIL
SELECT * FROM orc_create_complex_n0;

SELECT * FROM orc_create_complex_n0;

EXPLAIN VECTORIZATION DETAIL
SELECT str FROM orc_create_complex_n0;

SELECT str FROM orc_create_complex_n0;

EXPLAIN VECTORIZATION DETAIL
SELECT strct, mp, lst FROM orc_create_complex_n0;

SELECT strct, mp, lst FROM orc_create_complex_n0;

EXPLAIN VECTORIZATION DETAIL
SELECT lst, str FROM orc_create_complex_n0;

SELECT lst, str FROM orc_create_complex_n0;

EXPLAIN VECTORIZATION DETAIL
SELECT mp, str FROM orc_create_complex_n0;

SELECT mp, str FROM orc_create_complex_n0;

EXPLAIN VECTORIZATION DETAIL
SELECT strct, str FROM orc_create_complex_n0;

SELECT strct, str FROM orc_create_complex_n0;

EXPLAIN VECTORIZATION DETAIL
SELECT strct.B, str FROM orc_create_complex_n0;

SELECT strct.B, str FROM orc_create_complex_n0;

set hive.llap.io.enabled=false;

EXPLAIN VECTORIZATION DETAIL
INSERT INTO TABLE orc_create_complex_n0
SELECT orc_create_staging_n0.*, src1.key FROM orc_create_staging_n0 cross join src src1 cross join orc_create_staging_n0 spam1 cross join orc_create_staging_n0 spam2;

INSERT INTO TABLE orc_create_complex_n0
SELECT orc_create_staging_n0.*, src1.key FROM orc_create_staging_n0 cross join src src1 cross join orc_create_staging_n0 spam1 cross join orc_create_staging_n0 spam2;

EXPLAIN VECTORIZATION DETAIL
select count(*) from orc_create_complex_n0;

select count(*) from orc_create_complex_n0;

set hive.llap.io.enabled=true;

EXPLAIN VECTORIZATION DETAIL
SELECT distinct lst, strct FROM orc_create_complex_n0;

SELECT distinct lst, strct FROM orc_create_complex_n0;

EXPLAIN VECTORIZATION DETAIL
SELECT str, count(val)  FROM orc_create_complex_n0 GROUP BY str;

SELECT str, count(val)  FROM orc_create_complex_n0 GROUP BY str;

EXPLAIN VECTORIZATION DETAIL
SELECT strct.B, count(val) FROM orc_create_complex_n0 GROUP BY strct.B;

SELECT strct.B, count(val) FROM orc_create_complex_n0 GROUP BY strct.B;

EXPLAIN VECTORIZATION DETAIL
SELECT strct, mp, lst, str, count(val) FROM orc_create_complex_n0 GROUP BY strct, mp, lst, str;

SELECT strct, mp, lst, str, count(val) FROM orc_create_complex_n0 GROUP BY strct, mp, lst, str;