blob: deaca0ebd2b6a3ce47ca0a8a616264be037d412e [file] [log] [blame]
set hive.vectorized.execution.enabled=true;
-- HIVE-18191
create table cd
(
cd_demo_sk int,
cd_gender string,
cd_marital_status string,
cd_purchase_estimate int,
cd_credit_rating string,
cd_dep_count int,
cd_dep_employed_count int,
cd_dep_college_count int
)
partitioned by
(
cd_education_status string
);
alter table cd add partition (cd_education_status='Primary');
insert into table cd partition (cd_education_status='Primary') values (1, 'M', 'M', 500, 'Good', 0, 0, 0);
explain vectorization detail
analyze table cd partition (cd_education_status) compute statistics;
analyze table cd partition (cd_education_status) compute statistics;