CODEWITHSUNDEEP
partitioningvertica
Swathi8038
Swathi8038

Reputation: 96

How to find out which columns make up the partitioning key of a partitioned table in Vertica

I have a vertica table which is partitioned by one of its column I need to view which column the table is partitioned by, is there any system table which stores these information.

Upvotes: 1

Views: 1311

Answers (1)

IgorB
IgorB

Reputation: 126

you can use "tables" system table for example:

dbadmin=> select partition_expression from tables where table_name ilike 'products';
           partition_expression
------------------------------------------
 date_trunc('month', PRODUCTS.CREATEDATE)

Upvotes: 4

Related Questions