Phoenix sqlline无法查询系统表SYSTEM.FUNCTION

Question

我知道Apache Phoenix会将所有函数元数据存储在SYSTEM.FUNCTION中，但当我使用以下语句执行查询时，它会抛出异常。

0: jdbc:phoenix:10.1.226.15:2181> 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)

或

0: jdbc:phoenix:10.1.226.15:2181> select * from FUNCTION;
Error: ERROR 601 (42P00): Syntax error. Encountered "FUNCTION" at line 1, column 15. (state=42P00,code=601)
org.apache.phoenix.exception.PhoenixParserException: ERROR 601 (42P00): Syntax error. Encountered "FUNCTION" at line 1, column 15.

表函数存在于系统模式中，但不能查询，另一方面，系统模式中的表目录可以执行语句并检索正确的数据。

0: jdbc:phoenix:10.1.226.15:2181> !tables
+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------+
|                TABLE_CAT                 |               TABLE_SCHEM                |                TABLE_NAME                |                TABLE_TYPE                |                 REMARKS            |
+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------+
|                                          | SYSTEM                                   | CATALOG                                  | SYSTEM TABLE                             |                                    |
|                                          | SYSTEM                                   | FUNCTION                                 | SYSTEM TABLE                             |                                    |
|                                          | SYSTEM                                   | SEQUENCE                                 | SYSTEM TABLE                             |                                    |
|                                          | SYSTEM                                   | STATS                                    | SYSTEM TABLE                             |                                    |
+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------+



0: jdbc:phoenix:10.1.226.15:2181> select * from system.catalog;
+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------+
|                TENANT_ID                 |               TABLE_SCHEM                |                TABLE_NAME                |               COLUMN_NAME                |              COLUMN_FAMILY         |
+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------+
|                                          | SYSTEM                                   | CATALOG                                  |                                          |                                    |
|                                          | SYSTEM                                   | CATALOG                                  | ARRAY_SIZE                               | 0                                  |
|                                          | SYSTEM                                   | CATALOG                                  | BUFFER_LENGTH                            | 0                                  |
....

有人能解释一下原因吗？

Answer 1

与select一样，function也是一个保留关键字。如果您想引用该表，请将其括在引号中(而且它也会区分大小写)。