hive sql sum求和返回NULL

Question

使用hive sql求文本文件中金额的总和

文本文件weex.txt
"42" "2017-01-01" "优惠券使用金额" "53084.00"
"47" "2017-01-01" "司机奖励补贴成本" "550.00"

将weex.txt load到hdfs中

sql语句

select sum(amount) from weex;
和select sum(double(amount)) from weex;都尝试了仍然返回NULL

hive的建表语句

create table weex(id int, s_day string, cost_type string, amount double, createtime string, updatetime string) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t';

Answer 1

数据格式错误