Updated on 2022-11-18 GMT+08:00

CALL

Syntax

CALL procedure_name ( [ name => ] expression [, ...] )

Description

This statement is used to invoke a specified stored procedure.

The stored procedure is provided by each connector to implement data operations or management tasks. For example, a system connector allows a stored procedure to cancel a running query. Some data sources, such as PostgreSQL, have their own stored procedures, which are different from those defined by the connector and cannot be invoked by CALL.

Check and update the partition arrays in MetaStore. There are three modes.

  • ADD: synchronizes the partition system that exists in the file system but does not exist in MetaStore to MetaStore.
  • DROP: drops the partitions that exist in the metadata table but do not exist in the file system.
  • FULL: performs both ADD and DROP operations.

Example

CALL system.create_empty_partition(
    schema_name => 'web',
    table_name => 'page_views',
    partition_columns => ARRAY['ds', 'country'],
    partition_values => ARRAY['2020-07-19', 'UK']);
Stored procedure supported by Hive Connector.
system.sync_partition_metadata(schema_name, table_name, mode)