Why !primarykeys does not work in sqlline-thin.py

[#1]

I started a apache phoenix query server, phonenix version is apache-phoenix-5.0.0-HBase-2.0-bin

All other functions work well in the cmd line of sqlline-thin.py. But when I tried to get the primary key of a table, its just listed nothing. 

0: jdbc:phoenix:thin:url=http://localhost:876> !primarykeys FN2.TESTYL2
+------------+--------------+-------------+--------------+----------+----------+
| TABLE_CAT | TABLE_SCHEM | TABLE_NAME | COLUMN_NAME | KEY_SEQ | PK_NAME |
+------------+--------------+-------------+--------------+----------+----------+
+------------+--------------+-------------+--------------+----------+----------+

when I tried in phoenix cmd line sqlline.py, it works well.

do you know why the thin phoenix query server cannot find the primary key?

thanks

Yang

[#2 · Accepted solution]

Hi Yang,

I would suggest you to open a support ticket for this one.

Regards,

Ariel Q.