hive处理脏数据_hive insert overwrite table 脏数据-CSDN博客

网站介绍:文章浏览阅读768次。INSERT OVERWRITE table ods.js_beauty_tmpSELECT *from ods.js_beauty_tmpWHERE map_lat != ‘’AND map_lng != ‘’AND map_lat IS NOT NULLAND map_lng IS NOT NULLAND map_lat != 0AND map_lng != 0AND map_lat not like ‘-%’AND map_lng not like ‘-%’and city !=_hive insert overwrite table 脏数据