YangLei created PHOENIX-6651:
--------------------------------
Summary: !primarykeys cannot list t
Key: PHOENIX-6651
URL: https://issues.apache.org/jira/browse/PHOENIX-6651
Project: Phoenix
Issue Type: Bug
Components: queryserver
Affects Versions: 5.0.0
Reporter: YangLei
Hi experts.
when I ran !primarykeys in the cmd line of sqlline-thin.py, it listed no
information of the table.
while it did list primary key infomation in the cmd line of sqlline.py.
Is this expected or a bug, or some configuration issue? Could you help to check?
0: jdbc:phoenix:thin:url=http://localhost:876> !primarykeys FN2.GROUPCHATINFO
+------------+--------------+-------------+--------------+----------+----------+
| TABLE_CAT | TABLE_SCHEM | TABLE_NAME | COLUMN_NAME | KEY_SEQ | PK_NAME |
+------------+--------------+-------------+--------------+----------+----------+
+------------+--------------+-------------+--------------+----------+----------+
+
0: jdbc:phoenix:> !primarykeys FN2.GROUPCHATINFO
+------------+--------------+----------------+--------------+----------+----------+--------------+------------+------------+--------------+----------+------+
| TABLE_CAT | TABLE_SCHEM | TABLE_NAME | COLUMN_NAME | KEY_SEQ |
PK_NAME | ASC_OR_DESC | DATA_TYPE | TYPE_NAME | COLUMN_SIZE | TYPE_ID |
VIEW |
+------------+--------------+----------------+--------------+----------+----------+--------------+------------+------------+--------------+----------+------+
| | FN2 | GROUPCHATINFO | CHATID | 1 |
| A | 12 | VARCHAR | null | 12 | |
+------------+--------------+----------------+--------------+----------+----------+--------------+------------+------------+--------------+----------+------+
0: jdbc:phoenix:>
Thanks
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
