[
https://issues.apache.org/jira/browse/HIVE-27280?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ASF GitHub Bot updated HIVE-27280:
----------------------------------
Labels: pull-request-available (was: )
> Query on View fails in SemanticAnalyzer if view select has grouping sets
> ------------------------------------------------------------------------
>
> Key: HIVE-27280
> URL: https://issues.apache.org/jira/browse/HIVE-27280
> Project: Hive
> Issue Type: Bug
> Reporter: Naresh P R
> Assignee: Dayakar M
> Priority: Major
> Labels: pull-request-available
> Attachments: test14.q
>
>
> View definition is not getting rewritten for grouping UDF columns with proper
> table alias causing compilation issues with following trace.
> {code:java}
> java.lang.RuntimeException: Expression in GROUPING function not present in
> GROUP BY
> at
> org.apache.hadoop.hive.ql.parse.SemanticAnalyzer$2.post(SemanticAnalyzer.java:3429)
> at org.antlr.runtime.tree.TreeVisitor.visit(TreeVisitor.java:66)
> at org.antlr.runtime.tree.TreeVisitor.visit(TreeVisitor.java:60)
> at org.antlr.runtime.tree.TreeVisitor.visit(TreeVisitor.java:60)
> at
> org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.rewriteGroupingFunctionAST(SemanticAnalyzer.java:3438)
> at
> org.apache.hadoop.hive.ql.parse.CalcitePlanner$CalcitePlannerAction.internalGenSelectLogicalPlan(CalcitePlanner.java:4743)
> at
> org.apache.hadoop.hive.ql.parse.CalcitePlanner$CalcitePlannerAction.genSelectLogicalPlan(CalcitePlanner.java:4505)
> at
> org.apache.hadoop.hive.ql.parse.CalcitePlanner$CalcitePlannerAction.genLogicalPlan(CalcitePlanner.java:5173)
> {code}
> Attached Repro file : [^test14.q]
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
