Forrest logo
back to the alter tool

odps-table:tldr:900c2

odps-table: Delete partition from a table.
$ alter table ${table_name} drop partition (${partition_spec});
try on your machine

This command is used to drop a specific partition from a table in a database.

Here's an explanation of the command components:

  • alter table: This is the statement used to modify the structure of a table.
  • ${table_name}: This placeholder should be replaced with the actual name of the table you want to modify. For example, if the table name is "orders", you would write "alter table orders".
  • drop partition: This is the part of the command that specifies you want to drop a partition from the table.
  • (${partition_spec}): This is the partition specification that identifies the specific partition you want to drop. You need to replace ${partition_spec} with the details of the partition you want to remove. The partition specification typically includes information like the partition name or the values that define the range of the partition.

By executing this command with the appropriate table name and partition specification, you can remove a partition from the specified table in the database.

This explanation was created by an AI. In most cases those are correct. But please always be careful and never run a command you are not sure if it is safe.
back to the alter tool