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

SagaTmac — Thu, 17 Feb 2022 08:38:14 GMT

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

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

aquilodran — Thu, 17 Feb 2022 15:22:23 GMT

Hi Yang,

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

Regards,

Ariel Q.

question Re: Why !primarykeys does not work in sqlline-thin.py in Support Questions

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

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