SHOW PARTITIONS / PARTITION

Note

SDK methods: listPartitions.

SHOW PARTITIONS FROM table_name;    -- List all partitions of a table
SHOW PARTITION p_name ON TABLE t_name;

Returns PARTITION (VARCHAR); this is a partition name, not an entity count.