SELECT key, COUNT(*) FROM ( SELECT key, value, COUNT( * ) FROM src GROUP BY key, value ) a GROUP BY key;
HIVE 0.11版本的bug
原文：http://blog.csdn.net/lgcssx/article/details/40483515
