Delete Partition From Table

alter table <table_name> drop partition (<partition_spec>);

alter table <table_name> drop partition (<partition_spec>);

#!/bin/bash

# Delete Partition From Table
alter table {{table_name}} drop partition ({{partition_spec}});

import subprocess

# Delete Partition From Table
# Make sure to replace <placeholders> with actual values
def run_command():
    cmd = [
        "alter",
        "table",
        "<table_name>",
        "drop",
        "partition",
        "(<partition_spec>);"
    ]
    
    try:
        print(f"Executing: {' '.join(cmd)}")
        subprocess.run(cmd, check=True)
    except subprocess.CalledProcessError as e:
        print(f"Error: {e}")
    except FileNotFoundError:
        print("Error: alter not found. Please install it first.")

if __name__ == "__main__":
    run_command()