Calcite's parser use JavaCC and the built in keywords are configured hard-code, so there is no way to change this. An quote character may be a better choice.
Jeff Zhang <[email protected]>于2019年4月2日 周二下午9:15写道： > Thanks Amit. I'd like to keep my system compatible with hive sql, but > unfortunately hive use default as its default database name. Is there any > way to customize calcite's parser to allow user to use default ? > > Amit Weitzner <[email protected]> 于2019年4月2日周二 下午6:36写道： > > > Hi Jeff, > > > > "default" is a reserved keyword in calcite parser. > > > > If you'll add quoting to default it will work: > > select * from "default".table_1 > > select * from `default`.table_1 > > > > The quotation marks depend on your configuration in the calcite parser > (the > > default is "). > > > > Hope this helps, > > Amit > > > > > > On Tue, Apr 2, 2019 at 12:08 PM Jeff Zhang <[email protected]> wrote: > > > > > Hi Folks, > > > > > > I try to integrate calcite into our product, and found that I can not > use > > > default as the database name. (select * from default.table_1) > > > > > > I will hit the following error. Is there any way that I can use default > > as > > > database name ? Thanks > > > > > > org.apache.calcite.sql.parser.SqlParseException: Encountered "from > > default" > > > at line 1, column 10. > > > Was expecting one of: > > > <EOF> > > > "ORDER" ... > > > "LIMIT" ... > > > "OFFSET" ... > > > "FETCH" ... > > > "FROM" <IDENTIFIER> ... > > > "FROM" <QUOTED_IDENTIFIER> ... > > > "FROM" <BACK_QUOTED_IDENTIFIER> ... > > > "FROM" <BRACKET_QUOTED_IDENTIFIER> ... > > > "FROM" <UNICODE_QUOTED_IDENTIFIER> ... > > > "FROM" "LATERAL" ... > > > "FROM" "(" ... > > > "FROM" "UNNEST" ... > > > "FROM" "TABLE" ... > > > "," ... > > > "AS" ... > > > <IDENTIFIER> ... > > > <QUOTED_IDENTIFIER> ... > > > <BACK_QUOTED_IDENTIFIER> ... > > > <BRACKET_QUOTED_IDENTIFIER> ... > > > <UNICODE_QUOTED_IDENTIFIER> ... > > > "UNION" ... > > > "INTERSECT" ... > > > "EXCEPT" ... > > > "MINUS" ... > > > > > > > > > at > > > > > > > > > org.apache.calcite.sql.parser.impl.SqlParserImpl.convertException(SqlParserImpl.java:355) > > > at > > > > > > > > > org.apache.calcite.sql.parser.impl.SqlParserImpl.normalizeException(SqlParserImpl.java:143) > > > at > org.apache.calcite.sql.parser.SqlParser.parseQuery(SqlParser.java:156) > > > > > > -- > > > Best Regards > > > > > > Jeff Zhang > > > > > > > > -- > Best Regards > > Jeff Zhang >
