blob: 371a0d12046343e3eb6ad87a8a3194a0fad011a1 [file] [log] [blame]
SET hive.vectorized.execution.enabled=true;
set hive.fetch.task.conversion=none;
create table testdatatypetable
(c1 int, c2 boolean, c3 double, c4 string,
c5 array<int>, c6 map<int,string>, c7 map<string,string>,
c8 struct<r:string,s:int,t:double>,
c9 tinyint, c10 smallint, c11 float, c12 bigint,
c13 array<array<string>>,
c14 map<int, map<int,int>>,
c15 struct<r:int,s:struct<a:int,b:string>>,
c16 array<struct<m:map<string,string>,n:int>>,
c17 timestamp,
c18 decimal(16,7),
c19 binary,
c20 date,
c21 varchar(20),
c22 char(15),
c23 binary
) partitioned by (dt STRING);
load data local inpath '../../data/files/datatypes.txt' into table testdatatypetable PARTITION (dt='20090619');
explain vectorization detail
select
c1, c2, c3, c4, c5 as a, c6, c7, c8, c9, c10, c11, c12, c1*2,
sentences(null, null, null) as b, c17, c18, c20, c21, c22, c23 from testdatatypetable limit 1;