set hive.vectorized.execution.enabled=false;
set hive.mapred.mode=nonstrict;

DROP TABLE IF EXISTS `dec_n1`;

CREATE TABLE `dec_n1`(name string, value decimal(8,4));

LOAD DATA LOCAL INPATH '../../data/files/dec.txt' INTO TABLE `dec_n1`;

DROP TABLE IF EXISTS parq_dec_n1;

CREATE TABLE parq_dec_n1(name string, value decimal(5,2)) STORED AS PARQUET;

DESC parq_dec_n1;

INSERT OVERWRITE TABLE parq_dec_n1 SELECT name, value FROM `dec_n1`;

SELECT * FROM parq_dec_n1;

SELECT value, count(*) FROM parq_dec_n1 GROUP BY value ORDER BY value;

TRUNCATE TABLE parq_dec_n1;

INSERT OVERWRITE TABLE parq_dec_n1 SELECT name, NULL FROM `dec_n1`;

SELECT * FROM parq_dec_n1;

DROP TABLE IF EXISTS parq_dec1;

CREATE TABLE parq_dec1(name string, value decimal(4,1)) STORED AS PARQUET;

DESC parq_dec1;

LOAD DATA LOCAL INPATH '../../data/files/dec.parq' INTO TABLE parq_dec1;

SELECT VALUE FROM parq_dec1;

DROP TABLE `dec_n1`;
DROP TABLE parq_dec_n1;
DROP TABLE parq_dec1;