REFRESH_SOURCE_TABLE_METADATA¶

Description

The stored procedure REFRESH_SOURCE_TABLE_METADATA updates the partitions information of the desired source table.

Syntax

REFRESH_SOURCE_TABLE_METADATA (
      database_name : varchar
    , base_view_name : varchar
    , case_sensitive_partition_scan : boolean
)

database_name: name of the database where the view is.
base_view_name: name of the target base view.
case_sensitive_partition_scan (optional): if there exists Hive-style partitions, the procedure will analyze those partitions which name in the file system matches the name defined in the Presto table. If this parameter is set to true, this comparison will be case sensitive. Default value: false.

Note

Currently, this feature is only supported for base views created using the Denodo embedded MPP or PrestoDB data sources.

The procedure returns this field:

procedure_status: Success if the procedure executed correctly, Failure otherwise.

Privileges Required

The user that executes this procedure must have at least WRITE privileges on view and EXECUTE privileges on the targeted data source.

Example

CALL REFRESH_SOURCE_TABLE_METADATA('db', 'test_view');

This will update the partitions information on the source table pointed by test_view.

USER MANUALS