Help Center/ Data Lake Insight/ Hudi SQL Syntax Reference/ DLI Hudi SQL Syntax Reference/ Hudi CALL COMMAND Syntax/ SHOW_INVALID_PARQUET
Updated on 2025-02-22 GMT+08:00
View PDF
Share

SHOW_INVALID_PARQUET

Function

Checks the damaged parquet file in the execution path.

Syntax

call show_invalid_parquet(path => 'path')

Parameter Description

Table 1 Parameter descriptions

Parameter

Description

Mandatory

path

Path of the FS to be queried

Yes

Example

call show_invalid_parquet(path => 'obs://path/hudi_table/dt=2021-08-28');

Caveats

  • This command is not supported when the metadata service provided by DLI is used.

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.

Parent topic: Hudi CALL COMMAND Syntax