Skip to main content

How to get oldest partition in a table.

  • August 10, 2017
  • 1 reply
  • 7 views
rishireddy

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.

    1 reply

    TomM
    Forum|alt.badge.img
    • TomM
    • Participating Frequently
    • August 10, 2017

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

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement