[CALCITE-5123] Calcite errors on columns starting with a digit

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Workaround

Environment

Calcite 1.30.0 on Java 11. Ran the example PySpark using Python 3.9 with Spark 3.1.2

Language

Python java spark

• Assignee: Unassigned
• Reporter: Laurens Versluis
• Created: 28/Apr/22 07:43
• Updated: 28/Apr/22 08:30
• Resolved: 28/Apr/22 08:30

Description

Not sure if this is related solely to Spark:

 

Parsing the following query errors in Calcite:

public static void main(String[] args) throws SqlParseException {
    String sqlQuery = "SELECT a AS 1a FROM FakeTable";
    SqlParser.create(sqlQuery, SparkSqlDialect.DEFAULT.configureParser(SqlParser.config())).parseQuery();
} 

Exception in thread "main" org.apache.calcite.sql.parser.SqlParseException: Encountered "1" at line 1, column 13.

However, Spark does accept such queries: