统计符合条件的去重过的数量 – – count distinct if case – 伸展代码舒适区 – 博客园 (cnblogs.com)
-
HIVE SQL COUNT(DISTINCT * 按条件去重
COUNT(DISTINCT CASE WHEN ******* THEN cid END), COUNT(DISTINCT CASE WHEN ******* THEN cid …
COUNT(DISTINCT CASE WHEN ******* THEN cid END), COUNT(DISTINCT CASE WHEN ******* THEN cid …