数据仓库服务 GaussDB(DWS)-Hudi系统函数:pg_show_custom_settings()

时间:2025-02-12 15:04:42

pg_show_custom_settings()

描述:查询Hudi外表参数设置详情。

返回值类型:setof record

示例:

 1 2 3 4 5 6 7 8 9101112
SELECT * FROM pg_show_custom_settings();                        name                        |      setting      | unit |      category      |        short_desc        | extra_desc | context | vartype | source  | min_val | max_val | enumvals | boot_val | reset_val | sourcefile | sourceline----------------------------------------------------+-------------------+------+--------------------+--------------------------+------------+---------+---------+---------+---------+---------+----------+----------+-----------+------------+------------ hoodie.public.hudi_mor_ft.consume.ending.timestamp | 20230404172329544 |      | Customized Options | GUC placeholder variable |            | user    | string  | session |         |         |          |          |           |            | hoodie.public.hudi_mor_ft.consume.mode             | incremental       |      | Customized Options | GUC placeholder variable |            | user    | string  | session |         |         |          |          |           |            | hoodie.public.hudi_mor_ft.consume.start.timestamp  | 20230404172329543 |      | Customized Options | GUC placeholder variable |            | user    | string  | session |         |         |          |          |           |            |(3 rows)
support.huaweicloud.com/sqlreference-910-dws/dws_06_0359.html