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

DROP TABLE IF EXISTS DECIMAL_5_txt;
DROP TABLE IF EXISTS DECIMAL_5;

CREATE TABLE DECIMAL_5_txt(key decimal(10,5), value int)
ROW FORMAT DELIMITED
   FIELDS TERMINATED BY ' '
STORED AS TEXTFILE;

LOAD DATA LOCAL INPATH '../../data/files/kv7.txt' INTO TABLE DECIMAL_5_txt;

CREATE TABLE DECIMAL_5(key decimal(10,5), value int)
STORED AS ORC;

INSERT OVERWRITE TABLE DECIMAL_5 SELECT * FROM DECIMAL_5_txt;

SELECT key FROM DECIMAL_5 ORDER BY key;

SELECT DISTINCT key FROM DECIMAL_5 ORDER BY key;

explain SELECT cast(key as decimal) FROM DECIMAL_5;
SELECT cast(key as decimal) FROM DECIMAL_5;

SELECT cast(key as decimal(6,3)) FROM DECIMAL_5;

DROP TABLE DECIMAL_5_txt;
DROP TABLE DECIMAL_5;