在使用hql时遇上了一个问题,执行以下语句时报错:
SELECT
sum(row_count),city,province
FROM tmp_active2_group_type_ip_20110815 where province='四川省'
GROUP BY city LIMIT 1000;
错误信息为:
FAILED: Error in semantic analysis: Line 1:49 Expression not in GROUP BY key province' from HUB
将以上hql语句改为:
SELECT
sum(row_count),city,province
FROM tmp_active2_group_type_ip_20110815
GROUP BY city,province;
则执行正常。
SELECT
sum(row_count),city,province
FROM tmp_active2_group_type_ip_20110815 where province='四川省'
GROUP BY city LIMIT 1000;
错误信息为:
FAILED: Error in semantic analysis: Line 1:49 Expression not in GROUP BY key province' from HUB
将以上hql语句改为:
SELECT
sum(row_count),city,province
FROM tmp_active2_group_type_ip_20110815
GROUP BY city,province;
则执行正常。