blob: e30d6901fa334b426af40373def451d52c211393 [file] [log] [blame]
dfs ${system:test.dfs.mkdir} ${system:test.tmp.dir}/test_sp_chars_decimal;
dfs -copyFromLocal ../../data/files/test_sp_chars_decimal.csv ${system:test.tmp.dir}/test_sp_chars_decimal/;
create external table test_sp_chars_decimal (id int, value decimal) ROW FORMAT DELIMITED
FIELDS TERMINATED BY ',' location '${system:test.tmp.dir}/test_sp_chars_decimal';
select * from test_sp_chars_decimal;
select distinct(value) from test_sp_chars_decimal;