Hive
zanlinux
这个作者很懒,什么都没留下…
展开
-
查询存在A表但不存在B表
SELECT t1.nameFROM table1 t1LEFT JOIN table2 t2 ON t2.name = t1.nameWHERE t2.name IS NULL原创 2020-11-26 17:31:33 · 164 阅读 · 0 评论 -
Hive两表count除法
select 100 * different / total from (select count(*) as different from a, b where ........) t1, (select count(*) as total from a where .......) t2原创 2020-11-26 10:45:57 · 2657 阅读 · 1 评论