Skip to main content

How to get oldest partition in a table.

  • Aug 10, 2017 3:21 PM UTC
  • 1 reply
  • 9 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
    • Aug 10, 2017 3:37 PM UTC

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

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement