[ https://issues.apache.org/jira/browse/SPARK-33410?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Yuming Wang updated SPARK-33410: -------------------------------- Description: This pr add support resolve SQL query reference a column by an alias, for example: ```sql select id + 1 as new_id, new_id + 1 as new_new_id from range(5); ``` Teradata and snowflake support this feature: [https://docs.teradata.com/reader/e79ET77~NzPDz~Ykinj44w/MKSYuTyx2UJWXzdHJf3~sQ] [https://www.mssqltips.com/sqlservertutorial/9292/snowflake-regular-expression-alias-and-ilike] was: This pr add support resolve SQL query reference a column by an alias, for example: ```sql select id + 1 as new_id, new_id + 1 as new_new_id from range(5); ``` Teradata support this feature: https://docs.teradata.com/reader/e79ET77~NzPDz~Ykinj44w/MKSYuTyx2UJWXzdHJf3~sQ > Resolve SQL query reference a column by an alias > ------------------------------------------------ > > Key: SPARK-33410 > URL: https://issues.apache.org/jira/browse/SPARK-33410 > Project: Spark > Issue Type: Sub-task > Components: SQL > Affects Versions: 3.1.0 > Reporter: Yuming Wang > Priority: Major > > This pr add support resolve SQL query reference a column by an alias, for > example: > ```sql > select id + 1 as new_id, new_id + 1 as new_new_id from range(5); > ``` > Teradata and snowflake support this feature: > [https://docs.teradata.com/reader/e79ET77~NzPDz~Ykinj44w/MKSYuTyx2UJWXzdHJf3~sQ] > [https://www.mssqltips.com/sqlservertutorial/9292/snowflake-regular-expression-alias-and-ilike] -- This message was sent by Atlassian Jira (v8.3.4#803005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org