Support Questions
Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Innovation Accelerator group hub.

describe phoenix table to find primary key

Super Guru

I created a phoenix table with 100 columns. I forgot what the primary key for the table. The primary key was build with at least 5 to 6 columns, can't say for sure. Any easy way to have phoenix tell me what the primary key is on a table?

4 REPLIES 4

Rising Star

The `SYSTEM.CATLOG` table contains a column called `KEY_SEQ`. If this contains an integer, it's a key column. E.g.

SELECT column_name FROM system.catalog WHERE table_name = '{{ your table name }}' AND key_seq IS NOT NULL;

Cloudera Employee

You can try :

0: jdbc:phoenix:> !primarykeys $TABLE_NAME
+------------+--------------+-------------+------------------------+----------+----------+--------------+------------+------------+-+
| TABLE_CAT  | TABLE_SCHEM  | TABLE_NAME  |      COLUMN_NAME       | KEY_SEQ  | PK_NAME  | ASC_OR_DESC  | DATA_TYPE  | TYPE_NAME  | |
+------------+--------------+-------------+------------------------+----------+----------+--------------+------------+------------+-+
|            | $SCHEMA      | $TABLE      | col1                   | 1        | PK       | A            | 12         | VARCHAR    | |
|            | $SCHEMA      | $TABLE      | col2                   | 2        | PK       | A            | 12         | VARCHAR    | |
+------------+--------------+-------------+------------------------+----------+----------+--------------+------------+------------+-+

New Contributor

This doesn't work 

Community Manager

@Sunny93 as this is an older post, you would have a better chance of receiving a resolution by starting a new thread. This will also be an opportunity to provide details specific to your environment that could aid others in assisting you with a more accurate answer to your question. You can link this thread as a reference in your new post.



Regards,

Vidya Sargur,
Community Manager


Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.
Learn more about the Cloudera Community: