[
https://issues.apache.org/jira/browse/HIVE-28679?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17907788#comment-17907788
]
Ayush Saxena commented on HIVE-28679:
-------------------------------------
Works for me on Hive-4.1, Seems like Hive-3.x issue, We have marked Hive-3.x as
EOL, We aren't supporting that now, Upgrade to Hive-4 & this should go
https://lists.apache.org/thread/3j6xxyxqqn55xv4pskp7djylqo2knmpo
> 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
> Priority: Major
>
> 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)
