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
)
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
.