DROP TABLE IF EXISTS avro_dec_old; | |
CREATE TABLE `avro_dec_old`( | |
`name` string COMMENT 'from deserializer', | |
`value` decimal(4,1) COMMENT 'from deserializer') | |
STORED AS AVRO; | |
DESC avro_dec_old; | |
LOAD DATA LOCAL INPATH '../../data/files/dec_old.avro' into TABLE avro_dec_old; | |
select value from avro_dec_old; | |
DROP TABLE avro_dec_old; |