Options

How to get oldest partition in a table.

Hi,
I need to delete the oldest partition in a table whenever the disk space crosses certain limit.
So could anyone help me out how to get oldest partition in a table so that i could drop that particular partition.

Comments

  • Options

    try select projection_name, partition_key from partitions order by partition_key desc;

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file