You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Ayush Saxena (Jira)" <ji...@apache.org> on 2024/12/23 08:38:00 UTC
[jira] [Commented] (HIVE-28679) Uppercase function name grouping get SemanticException
[ 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)