[jira] [Created] (HIVE-28679) Uppercase function name grouping get SemanticException

[Ethan Feng (Jira)]

Ethan Feng created HIVE-28679:
---------------------------------

             Summary: Uppercase function name grouping get SemanticException
                 Key: HIVE-28679
                 URL: https://issues.apache.org/jira/browse/HIVE-28679
             Project: Hive
          Issue Type: Bug
          Components: Hive
    Affects Versions: 3.1.3
            Reporter: Ethan Feng


You can easily reproduce this by the following SQL.

 
create table T1(key string,value string);

SELECT key, value,grouping(key), grouping(value)
FROM T1
GROUP BY ROLLUP(key,value);

SELECT key, value,GROUPING(key), grouping(value)
FROM T1
GROUP BY ROLLUP(key,value);
 
You'll get an error tell that
"FAILED: SemanticException [Error 10015]: Line 1:18 Arguments length mismatch 
'key': grouping() requires at least 2 argument, got 1"



--
This message was sent by Atlassian Jira
(v8.20.10#820010)