Help Center/ Data Lake Insight/ SQL Syntax Reference (Kuala Lumpur Region)/ Spark SQL Syntax Reference/ Syntax for Partitioning a Table/ Updating Partitioned Table Data (Only OBS Tables Supported)
Updated on 2023-03-06 GMT+08:00
View PDF
Share

Updating Partitioned Table Data (Only OBS Tables Supported)

Function

This statement is used to update the partition information about a table in the Metastore.

Syntax

1
 
MSCK REPAIR TABLE table_name;

Or

ALTER TABLE table_name RECOVER PARTITIONS;

Keyword

  • PARTITIONS: partition information
  • SERDEPROPERTIES: Serde attribute

Parameters

Table 1 Parameter description

Parameter

Description

table_name

Table name

partition_specs

Partition fields

obs_path

OBS path

Precautions

  • This statement is applied only to partitioned tables. After you manually add partition directories to OBS, run this statement to update the newly added partition information in the metastore. The SHOW PARTITIONS table_name statement can be used to query the newly-added partitions.
  • The partition directory name must be in the specified format, that is, tablepath/partition_column_name=partition_column_value.

Example

Run the following statements to update the partition information about table ptable in the Metastore:

1
 
MSCK REPAIR TABLE ptable;

Or

ALTER TABLE ptable RECOVER PARTITIONS;