lipzhu opened a new pull request #24840: [SPARK-27998][SQL] Column alias should support quote string URL: https://github.com/apache/spark/pull/24840 ## What changes were proposed in this pull request? According to the ANSI SQL standard, column alias can be double quote string but SparkSQL only support backquote string. ```sql SELECT au_fname AS "First name", au_lname AS 'Last name', city AS City, state, zip 'Postal code' FROM authors; ``` However, SparkSQL's syntax is different from others DB engines. - MySQL support Backquote(``), Single quote (''), Double quote(""). - SQL Server support Single quote (''), Double quote(""). - Teradata, Oracle, PostgreSQL only support Double quote(""). ## How was this patch tested? Pass the Jenkins with the updated test cases.
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
