[
https://issues.apache.org/jira/browse/HIVE-28679?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17907794#comment-17907794
]
Ethan Feng commented on HIVE-28679:
-----------------------------------
Thanks for your response. Do you know what Jira issue might be relevant to this
issue in Hive-4.1?
> 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)
