Thanks for confirmation, Ankit.
> On Aug 31, 2016, at 3:36 AM, Ankit Singhal <ankitsingha...@gmail.com> wrote: > > bq. Is this documented somewhere ? > not as such, https://phoenix.apache.org/language/index.html#quoted_name is > generally for case sensitive identifier(and to allow some special characters) > and same can be used for keywords. > > bq. Looks like tokens in phoenix-core/src/main/antlr3/PhoenixSQL.g would give > us good idea. > Yes Ted, you are right . Phoenix keywords are the tokens in > phoenix-core/src/main/antlr3/PhoenixSQL.g > > > >> On Sun, Aug 21, 2016 at 8:33 PM, Ted Yu <yuzhih...@gmail.com> wrote: >> Looks like tokens in phoenix-core/src/main/antlr3/PhoenixSQL.g would give us >> good idea. >> >> Experts please correct me if I am wrong. >> >>> On Sun, Aug 21, 2016 at 7:21 AM, Aaron Molitor <amoli...@splicemachine.com> >>> wrote: >>> Thanks, Ankit, that worked. >>> >>> And on the heels of Ted's question... Are the reserved words documented >>> (even if just a list) somewhere, I've been looking at this page: >>> http://phoenix.apache.org/language/index.html -- it feels like where I >>> should find a list like that, but I don't see it explicitly called out. >>> >>> -Aaron >>>> On Aug 21, 2016, at 09:04, Ted Yu <yuzhih...@gmail.com> wrote: >>>> >>>> Ankit: >>>> Is this documented somewhere ? >>>> >>>> Thanks >>>> >>>>> On Sun, Aug 21, 2016 at 6:07 AM, Ankit Singhal <ankitsingha...@gmail.com> >>>>> wrote: >>>>> Aaron, >>>>> >>>>> you can escape check for reserved keyword with double quotes "" >>>>> >>>>> SELECT * FROM SYSTEM."FUNCTION" >>>>> >>>>> Regards, >>>>> Ankit Singhal >>>>> >>>>>> On Fri, Aug 19, 2016 at 10:47 PM, Aaron Molitor >>>>>> <amoli...@splicemachine.com> wrote: >>>>>> Looks like the SYSTEM.FUNCTION table is names with a reserved word. Is >>>>>> this a known bug? >>>>>> >>>>>> >>>>>> 0: jdbc:phoenix:stl-colo-srv073.splicemachine> !tables >>>>>> +------------+--------------+-------------+---------------+----------+------------+----------------------------+-----------------+--------------+-----------------+---------------+---------------+-----------------+------------+-----------+ >>>>>> | TABLE_CAT | TABLE_SCHEM | TABLE_NAME | TABLE_TYPE | REMARKS | >>>>>> TYPE_NAME | SELF_REFERENCING_COL_NAME | REF_GENERATION | INDEX_STATE >>>>>> | IMMUTABLE_ROWS | SALT_BUCKETS | MULTI_TENANT | VIEW_STATEMENT | >>>>>> VIEW_TYPE | INDEX_TYP | >>>>>> +------------+--------------+-------------+---------------+----------+------------+----------------------------+-----------------+--------------+-----------------+---------------+---------------+-----------------+------------+-----------+ >>>>>> | | SYSTEM | CATALOG | SYSTEM TABLE | | >>>>>> | | | | >>>>>> false | null | false | | >>>>>> | | >>>>>> | | SYSTEM | FUNCTION | SYSTEM TABLE | | >>>>>> | | | | >>>>>> false | null | false | | >>>>>> | | >>>>>> | | SYSTEM | SEQUENCE | SYSTEM TABLE | | >>>>>> | | | | >>>>>> false | null | false | | >>>>>> | | >>>>>> | | SYSTEM | STATS | SYSTEM TABLE | | >>>>>> | | | | >>>>>> false | null | false | | >>>>>> | | >>>>>> | | TPCH | CUSTOMER | TABLE | | >>>>>> | | | | >>>>>> false | null | false | | >>>>>> | | >>>>>> | | TPCH | LINEITEM | TABLE | | >>>>>> | | | | >>>>>> false | null | false | | >>>>>> | | >>>>>> | | TPCH | NATION | TABLE | | >>>>>> | | | | >>>>>> false | null | false | | >>>>>> | | >>>>>> | | TPCH | ORDERS | TABLE | | >>>>>> | | | | >>>>>> false | null | false | | >>>>>> | | >>>>>> | | TPCH | PART | TABLE | | >>>>>> | | | | >>>>>> false | null | false | | >>>>>> | | >>>>>> | | TPCH | PARTSUPP | TABLE | | >>>>>> | | | | >>>>>> false | null | false | | >>>>>> | | >>>>>> | | TPCH | REGION | TABLE | | >>>>>> | | | | >>>>>> false | null | false | | >>>>>> | | >>>>>> | | TPCH | SUPPLIER | TABLE | | >>>>>> | | | | >>>>>> false | null | false | | >>>>>> | | >>>>>> +------------+--------------+-------------+---------------+----------+------------+----------------------------+-----------------+--------------+-----------------+---------------+---------------+-----------------+------------+-----------+ >>>>>> 0: jdbc:phoenix:stl-colo-srv073.splicemachine> select * from >>>>>> SYSTEM.FUNCTION; >>>>>> Error: ERROR 604 (42P00): Syntax error. Mismatched input. Expecting >>>>>> "NAME", got "FUNCTION" at line 1, column 22. (state=42P00,code=604) >>>>>> org.apache.phoenix.exception.PhoenixParserException: ERROR 604 (42P00): >>>>>> Syntax error. Mismatched input. Expecting "NAME", got "FUNCTION" at line >>>>>> 1, column 22. >>>>>> at >>>>>> org.apache.phoenix.exception.PhoenixParserException.newException(PhoenixParserException.java:33) >>>>>> at >>>>>> org.apache.phoenix.parse.SQLParser.parseStatement(SQLParser.java:111) >>>>>> at >>>>>> org.apache.phoenix.jdbc.PhoenixStatement$PhoenixStatementParser.parseStatement(PhoenixStatement.java:1280) >>>>>> at >>>>>> org.apache.phoenix.jdbc.PhoenixStatement.parseStatement(PhoenixStatement.java:1363) >>>>>> at >>>>>> org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1434) >>>>>> at sqlline.Commands.execute(Commands.java:822) >>>>>> at sqlline.Commands.sql(Commands.java:732) >>>>>> at sqlline.SqlLine.dispatch(SqlLine.java:807) >>>>>> at sqlline.SqlLine.begin(SqlLine.java:681) >>>>>> at sqlline.SqlLine.start(SqlLine.java:398) >>>>>> at sqlline.SqlLine.main(SqlLine.java:292) >>>>>> Caused by: MismatchedTokenException(65!=99) >>>>>> at >>>>>> org.apache.phoenix.parse.PhoenixSQLParser.recoverFromMismatchedToken(PhoenixSQLParser.java:360) >>>>>> at >>>>>> org.apache.phoenix.shaded.org.antlr.runtime.BaseRecognizer.match(BaseRecognizer.java:115) >>>>>> at >>>>>> org.apache.phoenix.parse.PhoenixSQLParser.parseNoReserved(PhoenixSQLParser.java:9969) >>>>>> at >>>>>> org.apache.phoenix.parse.PhoenixSQLParser.identifier(PhoenixSQLParser.java:9936) >>>>>> at >>>>>> org.apache.phoenix.parse.PhoenixSQLParser.from_table_name(PhoenixSQLParser.java:9589) >>>>>> at >>>>>> org.apache.phoenix.parse.PhoenixSQLParser.table_factor(PhoenixSQLParser.java:6244) >>>>>> at >>>>>> org.apache.phoenix.parse.PhoenixSQLParser.table_ref(PhoenixSQLParser.java:6066) >>>>>> at >>>>>> org.apache.phoenix.parse.PhoenixSQLParser.table_list(PhoenixSQLParser.java:6002) >>>>>> at >>>>>> org.apache.phoenix.parse.PhoenixSQLParser.parseFrom(PhoenixSQLParser.java:5967) >>>>>> at >>>>>> org.apache.phoenix.parse.PhoenixSQLParser.single_select(PhoenixSQLParser.java:4595) >>>>>> at >>>>>> org.apache.phoenix.parse.PhoenixSQLParser.unioned_selects(PhoenixSQLParser.java:4697) >>>>>> at >>>>>> org.apache.phoenix.parse.PhoenixSQLParser.select_node(PhoenixSQLParser.java:4763) >>>>>> at >>>>>> org.apache.phoenix.parse.PhoenixSQLParser.oneStatement(PhoenixSQLParser.java:789) >>>>>> at >>>>>> org.apache.phoenix.parse.PhoenixSQLParser.statement(PhoenixSQLParser.java:508) >>>>>> at >>>>>> org.apache.phoenix.parse.SQLParser.parseStatement(SQLParser.java:108) >>>>>> ... 9 more >
