SHOW_TIME_LINE

Function

Displays the effective or archived Hudi timelines and details of a specified instant time.

Syntax

• Viewing the list of effective timelines of a table:

  call show_active_instant_list(table => '[table_name]');

• Viewing the list of effective timelines after a timestamp in a table:

  call show_active_instant_list(table => '[table_name]', instant => '[instant]');

• Viewing information about an instant that takes effect in a table:

  call show_active_instant_detail(table => '[table_name]', instant => '[instant]');

• Viewing the list of archived instant timelines in a table:

  call show_archived_instant_list(table => '[table_name]');

• Viewing the list of archived instant timelines after a timestamp in a table:

  call show_archived_instant_list(table => '[table_name]', instant => '[instant]');

• Viewing information about archived instants in a table:

  call show_archived_instant_detail(table => '[table_name]', instant => '[instant]');

Parameter Description

Example

call show_active_instant_detail(table => 'hudi_table1', instant => '20230913144936897');

Permission Requirements

Metadata service provided by DLI

• SQL permissions:

  database	table
  None	SELECT

• Fine-grained permission: dli:table:select

Metadata services provided by LakeFormation. Refer to the LakeFormation documentation for details on permission configuration.

System Response

You can check if the job status is successful, view the job result, and review the job logs to confirm if there are any exceptions.