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

SET hive.vectorized.execution.enabled=true;
set hive.fetch.task.conversion=none;

-- The kv1 input file has 2 data fields, so when the 3 field struct is deserialized,
-- the premature end will put a NULL in field #3.
create table string_fields_n0(strct struct<a:int, b:string, c:string>)
row format delimited
  fields terminated by '\t'
  collection items terminated by '\001';

load data local inpath '../../data/files/kv1.txt'
overwrite into table string_fields_n0;

EXPLAIN VECTORIZATION EXPRESSION
SELECT strct, strct.a, strct.b, strct.c FROM string_fields_n0 LIMIT 10;

SELECT strct, strct.a, strct.b, strct.c FROM string_fields_n0 LIMIT 10;


create table char_fields_n0(strct struct<a:int, b:char(10), c:char(10)>)
row format delimited
  fields terminated by '\t'
  collection items terminated by '\001';

load data local inpath '../../data/files/kv1.txt'
overwrite into table char_fields_n0;

EXPLAIN VECTORIZATION EXPRESSION
SELECT strct, strct.a, strct.b, strct.c FROM char_fields_n0 LIMIT 10;

SELECT strct, strct.a, strct.b, strct.c FROM char_fields_n0 LIMIT 10;


create table varchar_fields_n0(strct struct<a:int, b:varchar(5), c:varchar(5)>)
row format delimited
  fields terminated by '\t'
  collection items terminated by '\001';

load data local inpath '../../data/files/kv1.txt'
overwrite into table varchar_fields_n0;

EXPLAIN VECTORIZATION EXPRESSION
SELECT strct, strct.a, strct.b, strct.c FROM varchar_fields_n0 LIMIT 10;

SELECT strct, strct.a, strct.b, strct.c FROM varchar_fields_n0 LIMIT 10;