SET hive.vectorized.execution.enabled=false;

DROP TABLE IF EXISTS `dec`;

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

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

ANALYZE TABLE `dec` COMPUTE STATISTICS FOR COLUMNS value;
DESC FORMATTED `dec` value;

DROP TABLE IF EXISTS avro_dec;

CREATE TABLE avro_dec(
  name string,
  value decimal(5,2))
COMMENT 'just drop the schema right into the HQL'
STORED AS AVRO;

DESC avro_dec;

INSERT OVERWRITE TABLE avro_dec SELECT name, value FROM `dec`;

SELECT * FROM avro_dec;

DROP TABLE IF EXISTS avro_dec1;

CREATE TABLE avro_dec1(
  name string,
  value decimal(4,1))
COMMENT 'just drop the schema right into the HQL'
STORED AS AVRO;

DESC avro_dec1;

LOAD DATA LOCAL INPATH '../../data/files/dec.avro' INTO TABLE avro_dec1;

SELECT value FROM avro_dec1;

DROP TABLE `dec`;
DROP TABLE avro_dec;
DROP TABLE avro_dec1;