背景:找到价格字段不为空,有效的数据条数
执行:
select count(1), l_date from raw_kafka_item_dt0 where price is not null and price!='' and l_date>='2016-02-10'
and l_date<'2016-02-17' group by l_date ;
查看数据没有结果
执行:
select count(1), l_date from raw_kafka_item_dt0 where (price is null or price='') and l_date>='2016-02-10' and l_date<'2016-02-17' group by l_date ;
发现结果数据条数小于该分区总的数据条数
执行:
原因是price为double类型,调整为: