You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by "anci_sun@yahoo.com" <an...@yahoo.com> on 2018/11/05 10:14:12 UTC

Efficiency of too many grouping sets

Dears,
    I had taken a SELECT script with 90 sets in one GROUPING, and there was a serious data skewing problem.
    Was it concerned with the too many GROUPING SETS and how to solve it?
    ( I couldn't simply set hive.groupby.skewindata to true because there were some COUNT(DISTINCT ...) in it)
    Thanks!
Regards,
    孙志禹