hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jesus Camacho Rodriguez (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-15994) Grouping function error when grouping sets are not specified
Date Tue, 21 Feb 2017 10:37:44 GMT

    [ https://issues.apache.org/jira/browse/HIVE-15994?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15875757#comment-15875757
] 

Jesus Camacho Rodriguez commented on HIVE-15994:
------------------------------------------------

[~ashutoshc], can you take a look? This is an issue that is happening when grouping function
is used with plain group by (a case that is trivial but apparently valid, and that was not
covered in the original implementation). Thanks

> Grouping function error when grouping sets are not specified
> ------------------------------------------------------------
>
>                 Key: HIVE-15994
>                 URL: https://issues.apache.org/jira/browse/HIVE-15994
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 2.2.0
>            Reporter: Carter Shanklin
>            Assignee: Jesus Camacho Rodriguez
>         Attachments: HIVE-15994.patch
>
>
> hive> select grouping(c1), lead(c2) over(partition by grouping(c1)) from e011_01 group
by c1, c2;
> FAILED: SemanticException Failed to breakup Windowing invocations into Groups. At least
1 group must only depend on input columns. Also check for circular dependencies.
> Underlying error: org.apache.hadoop.hive.ql.parse.SemanticException: Line 1:48 Arguments
length mismatch 'c1': grouping() requires 2 argument, got 1



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message