Categories:

System functions (System Information)

SYSTEM$DATABASE_REFRESH_PROGRESS , SYSTEM$DATABASE_REFRESH_PROGRESS_BY_JOB — Deprecated

SYSTEM$DATABASE_REFRESH_PROGRESS 函数系列可用于查询各个维度的数据库刷新状态:

  • SYSTEM$DATABASE_REFRESH_PROGRESS 返回一个 JSON 对象，该对象按名称指示辅助数据库的当前刷新状态。
  • SYSTEM$DATABASE_REFRESH_PROGRESS_BY_JOB 返回一个 JSON 对象，该对象通过刷新查询指示辅助数据库的当前刷新状态。

Note

这些函数返回过去 14 天内的数据库刷新活动。

语法

SYSTEM$DATABASE_REFRESH_PROGRESS( '<secondary_db_name>' )

SYSTEM$DATABASE_REFRESH_PROGRESS_BY_JOB( '<query_id>' )

实参

secondary_db_name

辅助数据库的名称。如果辅助数据库是当前会话中的活动数据库，则此实参可选。

请注意，整个名称必须放在单引号内。

query_id

ID of the database refresh query. The query ID can be obtained from the History History tab page in the web interface.

输出

该函数在 JSON 对象中返回以下元素：

Column NameData TypeDescription
phaseNameTEXTName of the replication phases completed (or in progress) so far. For the list of phases, see the usage notes.
resultNameTEXTStatus of the replication phase.
startTimeUTCNUMBERTime when the replication phase began. Format is epoch time.
endTimeUTCNUMBERTime when the phase finished, if applicable. Format is epoch time.
detailsVARIANTA separate JSON object that shows the total number of bytes in the data refresh as well as the number of bytes copied so far in the phase. If the refresh statement previously failed or was cancelled and was initiated again, the object indicates the number of bytes skipped in the second attempt. The details object is included in the Copying Primary Data and Copying Replica Data phase information.

使用说明

  • 仅返回账户管理员（具有 ACCOUNTADMIN 角色）的结果。
  • 以下是所处理订单中的阶段列表：
    1. SECONDARY_UPLOADING_INVENTORY
    2. PRIMARY_UPLOADING_METADATA
    3. PRIMARY_UPLOADING_DATA
    4. SECONDARY_DOWNLOADING_METADATA
    5. SECONDARY_DOWNLOADING_DATA
    6. COMPLETED / FAILED / CANCELED

示例

下面的示例检索指定辅助数据库的当前刷新状态。结果以 JSON 对象返回：

SELECT SYSTEM$DATABASE_REFRESH_PROGRESS('mydb');

以下示例检索与上一个示例中相同的详细信息，但结果被分隔为关系列，时间戳被转换为 TIMESTAMP_LTZ：

SELECT value:phaseName::string AS "Phase",
  value:resultName::string AS "Result",
  TO_TIMESTAMP_LTZ(value:startTimeUTC::numeric,3) AS "startTime",
  TO_TIMESTAMP_LTZ(value:endTimeUTC::numeric,3) AS "endTime",
  value:details AS "details"
  FROM table(flatten(INPUT=> PARSE_JSON(SYSTEM$DATABASE_REFRESH_PROGRESS('mydb1'))));

下面的示例检索指定数据库刷新查询的状态。结果以 JSON 对象返回：

SELECT SYSTEM$DATABASE_REFRESH_PROGRESS_BY_JOB('4cbd7187-51f6-446c-9814-92d7f57d939b');

以下示例检索与上一个示例中相同的详细信息，但结果被分隔为关系列，时间戳被转换为 TIMESTAMP_LTZ：

SELECT value:phaseName::string AS "Phase",
  value:resultName::string AS "Result",
  TO_TIMESTAMP_LTZ(value:startTimeUTC::numeric,3) AS "startTime",
  TO_TIMESTAMP_LTZ(value:endTimeUTC::numeric,3) AS "endTime",
  value:details AS "details"
  FROM TABLE(FLATTEN(input=> PARSE_JSON(SYSTEM$DATABASE_REFRESH_PROGRESS_BY_JOB('4cbd7187-51f6-446c-9814-92d7f57d939b'))));