[jira] [Created] (FLINK-31865) Flink hive parser support order by non select column

[yunfan (Jira)]

yunfan created FLINK-31865:
------------------------------

             Summary: Flink hive parser support order by non select column
                 Key: FLINK-31865
                 URL: https://issues.apache.org/jira/browse/FLINK-31865
             Project: Flink
          Issue Type: Improvement
          Components: Connectors / Hive
            Reporter: yunfan


This issure can reproduced by the follow sql:
{code:java}
select name from tableA order by id{code}
b is not a column in select clause. The error message like follows

 
{code:java}
Caused by: org.apache.hadoop.hive.ql.parse.SemanticException: Line 1:37 Invalid 
table alias or column reference 'id': (possible column names are: name)
    at 
org.apache.flink.table.planner.delegation.hive.copy.HiveParserSemanticAnalyzer.genAllExprNodeDesc(HiveParserSemanticAnalyzer.java:2328)
    at 
org.apache.flink.table.planner.delegation.hive.copy.HiveParserSemanticAnalyzer.genAllExprNodeDesc(HiveParserSemanticAnalyzer.java:2259)
    at 
org.apache.flink.table.planner.delegation.hive.HiveParserCalcitePlanner.genOBLogicalPlan(HiveParserCalcitePlanner.java:1650)
    at 
org.apache.flink.table.planner.delegation.hive.HiveParserCalcitePlanner.genLogicalPlan(HiveParserCalcitePlanner.java:2788)
    at 
org.apache.flink.table.planner.delegation.hive.HiveParserCalcitePlanner.logicalPlan(HiveParserCalcitePlanner.java:283)
    ... 55 more{code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)