[jira] [Created] (HIVE-8242) Investigate test failures when hive.multigroupby.singlereducer and hive.optimize.multigroupby.common.distincts are set to false [Spark Branch]

["Chao (JIRA)" <ji...@apache.org>]

Chao created HIVE-8242:
--------------------------

             Summary: Investigate test failures when hive.multigroupby.singlereducer and hive.optimize.multigroupby.common.distincts are set to false [Spark Branch]
                 Key: HIVE-8242
                 URL: https://issues.apache.org/jira/browse/HIVE-8242
             Project: Hive
          Issue Type: Bug
          Components: Spark
            Reporter: Chao
            Priority: Minor


Currently, we rely on setting {{hive.optimize.multigroupby.common.distincts}} and {{hive.multigroupby.singlereducer}} to false to enable some groupby related tests. However, some other tests may fail because of this change. For instance, in {{groupby10.q}}, the last test will fail with exception:

{noformat}
FAILED: SemanticException [Error 10022]: DISTINCT on different columns not supported with skew in data
{noformat}

Since when {{hive.groupby.skewindata}} is set to true and {{hive.optimize.multigroupby.common.distincts}} is set to false, the distinct keyword is not supported.

There may be other issues like this. This JIRA is created to collect these issues, and ideally, find out why they fail.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)