| set hive.mapred.mode=nonstrict; | |
| DROP TABLE IF EXISTS DECIMAL_TRAILING_n0; | |
| CREATE TABLE DECIMAL_TRAILING_n0 ( | |
| id int, | |
| a decimal(10,4), | |
| b decimal(15,8) | |
| ) | |
| ROW FORMAT DELIMITED | |
| FIELDS TERMINATED BY ',' | |
| STORED AS TEXTFILE; | |
| LOAD DATA LOCAL INPATH '../../data/files/kv10.txt' INTO TABLE DECIMAL_TRAILING_n0; | |
| SELECT * FROM DECIMAL_TRAILING_n0 ORDER BY id; | |
| DROP TABLE DECIMAL_TRAILING_n0; |