Naresh P R created HIVE-27280:
---------------------------------

             Summary: 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
         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)

Reply via email to