search

dbeaver / dbeaver

Free universal database tool and SQL client
https://dbeaver.io
Apache License 2.0
40.31k stars 3.48k forks source link

Vertica: How to view existing partitions of the vertica table? #3307

Open BETEP0K1 opened 6 years ago

BETEP0K1 commented 6 years ago

In Vertica table can be divided into partitions for examlle: CREATE TABLE trade ( tdate DATE NOT NULL, tsymbol VARCHAR(8) NOT NULL, ttime TIME) PARTITION BY EXTRACT(year FROM tdate);

How in dbeaver I can see information about existing partitions of the table?

BETEP0K1 commented 6 years ago

in other SQL clients, this information is displayed as a table in projection properties menu

serge-rider commented 6 years ago

It is not yet supported. Could you post some more info (how should it look like).

BETEP0K1 commented 6 years ago

bookmarks bar of the Projection. There is bookmark Partitions image In bookmark Partitions I can see properties of Partitions, in particular, Partition Key field image