Henry Robinson created SPARK-24125: -------------------------------------- Summary: Add quoting rules to SQL guide Key: SPARK-24125 URL: https://issues.apache.org/jira/browse/SPARK-24125 Project: Spark Issue Type: Improvement Components: SQL Affects Versions: 2.4.0 Reporter: Henry Robinson
As far as I can tell, Spark SQL's quoting rules are as follows: * {{`foo bar`}} is an identifier * {{'foo bar'}} is a string literal * {{"foo bar"}} is a string literal The last of these is non-standard (usually {{"foo bar"}} is an identifier), and so it's probably worth mentioning these rules in the 'reference' section of the [SQL guide|http://spark.apache.org/docs/latest/sql-programming-guide.html#reference]. I'm assuming there's not a lot of enthusiasm to change the quoting rules, given it would be a breaking change, and that backticks work just fine as an alternative. -- This message was sent by Atlassian JIRA (v7.6.3#76005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org