Support Questions
Find answers, ask questions, and share your expertise

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

New Contributor

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

1 ACCEPTED SOLUTION

Cloudera Employee

Hi Yang,

 

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

 

Regards,

Ariel Q.

View solution in original post

1 REPLY 1

Cloudera Employee

Hi Yang,

 

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

 

Regards,

Ariel Q.

; ;