How to list the added vertical partition of a table


  • Hi all,

    I have created a table with vertical partition using  “CREATE TABLE ... PARTITIONED BY BUCKETS (MyPartitionField)” and added a couple of partitions using “ALTER TABLE ... ADD PARTITION("PartitionValue1")”.

    But I could not figure out how to view the added partition value items. It is appreciated if anyone could advise what is the command to list the added partitions of a table.


    Saturday, October 1, 2016 7:14 AM


All replies