The query returns the following result:id|hg_array_filter-+-1|{} 2|{21,22,23}(2 rows)HG_ARRAY_SORT Description:Applies a LAMBDA expression to the input arrays to generate a sort-key array.The function then sorts the first ...
参数说明 参数 描述 hg_anon hg_anon是Hologres内部封装的扩展函数，您需要调用该扩展函数才能开启数据脱敏功能。tablename 需要脱敏的列所在的表名称。col_name 需要脱敏的列名称。label_name 系统预设的脱敏函数，您可以使用 SHOW hg_...
Syntax for MaxCompute projects that use the two-layer model ALTER DATABASE database SET hg_experimental_auto_load_foreign_schema_mapping=' hologres_schema:odps_foreign_server.mc_project,[.]';Versions earlier than Hologres ...
hg_wait_until_rebalance_warehouse_done 函数可以直到指定计算组处于 Running 状态时，再返回结果：select hg_wait_until_rebalance_warehouse_done(' warehouse_name ',timeout_seconds);其中 timeout_seconds：非必填。代表返回超时时间...
This topic describes system tables that are relevant to the dynamic table feature of Hologres.System table Description hologres.hg_dynamic_table_properties Stores the metadata of dynamic tables.hologres.hg_dynamic_table_...
查看用户访问计算组权限 命令格式 使用如下SQL查看当前实例下所有的计算组的用户权限信息：SELECT*FROM hologres.hg_warehouse_users;参数说明 hg_warehouse_users表主要包含的字段信息如下：字段 字段类型 说明 示例 warehouse_name TEXT ...
see Distribution key.hg_binlog_event_type BIGINT The type of operation recorded in the current binary log.This field is a system field.The hg_binlog_event_type field has the following valid values:INSERT=5,which indicates ...
all dynamic tables in the current instance,and the data lineage and storage details of dynamic tables,along with how to manage state tables.Query the structure of a dynamic table Syntax SELECT hg_dump_script('[schema_name....
partition_tables AS(SELECT DISTINCT p1.table_namespace,p1.table_name FROM hologres.hg_table_properties p1 WHERE p1.property_key='logical_partition_columns' AND EXISTS(SELECT 1 FROM hologres.hg_table_properties p2 WHERE p2....
time write(Fixed Plan accelerated)Supported Unsupported Unsupported Batch write(not Fixed Plan accelerated)Supported Supported(V4.0+)(Requires enabling hg_warehouse_enable_use_local_resource)Supported(V4.0+)(Requires ...
In Hologres V2.0 and later,the PG_STAT_ACTIVITY view is upgraded to the HG_STAT_ACTIVITY view.The HG_STAT_ACTIVITY view is an extension of the PG_STAT_ACTIVITY view.You can use the HG_STAT_ACTIVITY view to query more ...
off Hologres从V1.3.25版本开始，hg_experimental_enable_fixed_dispatcher_for_update 废弃使用，即符合条件的UPDATE语句会默认使用Fixed Plan，但UPDATE多行记录需要配置 set hg_experimental_enable_fixed_dispatcher_for_multi_values=...
hg_experimental_auto_analyze_start_time Auto-Analyze在每天运行的开始时间 说明 需要与 end_time 是同一时区，并且 start time 要小于等于 end_time。V1.1.54及以上版本 00:00+0800 修改为仅需要在0～6点执行Auto-Analyze，白天内外部表...
查询结果 slot_name|property_key|property_value-+-+-hg_replication_slot_1|plugin|hgoutput hg_replication_slot_1|publication|hg_publication_test_1 hg_replication_slot_1|parallelism|1(3 rows)参数 说明 slot_name Replication ...
pipeline_hg38/cf55a2d1-572c-4490-8edf-07656802a79b/call-GatherBamFiles/NA12878.hg38.ready.bam.bai","output_filename":"NA12878.hg38.vcf.gz","contamination":null,"ref_fasta_index":"oss:/genomics-public-data-shanghai/broad-...
自Hologres V2.0版本起，通过存储过程（hg_insert_overwrite）实现该功能；自V3.1版本起，进一步支持原生INSERT OVERWRITE语法，提升了使用的便捷性和效率。功能对比 针对不同类型的表，采用不同方案进行INSERT OVERWRITE存在一定差异，...
如果SQL语句中有较多单引号，可以将$符号置于SQL语句前后，通过$query_sql$改写（推荐使用该用法，操作更简便）自动实现单引号转义，用法如下：CALL HG_CREATE_TABLE_LIKE('table_name',$query_sql$[,'partition_clause'])old_table_name：...
Query historical tasks Note Data in the hologres.hg_query_log and hologres.hg_serverless_computing_query_log views is retained for one month.Starting from Hologres V2.1.18,you can use the hologres.hg_serverless_computing_...
query_log and hologres.hg_serverless_computing_query_log retain data for the last 30 days.Only successfully executed SQL jobs incur charges.Failed jobs are not billed.Query resource usage Starting with Hologres V2.1.18,...
Hologres从 V1.3版本开始提供表统计信息日志系统表（hologres.hg_table_info）按日收集实例内表的统计信息，帮助您对实例中的表信息进行查看、分析，以便您可以根据这些信息采取优化措施。本文将会介绍在Hologres中如何查看表统计信息并...
Usage notes The optimizer_cte_inlining parameter has a higher priority than the hg_cte_strategy parameter.If you set optimizer_cte_inlining=off,the CTE strategy is forced to `REUSE`.In this case,the setting of the `hg_cte_...
mirroring_guc_hg_computing_resource='[serverless|local]',][data_mirroring_guc_hg_experimental_serverless_computing_required_cores=' num ',]-设置索引[data_mirroring_clustering_key='[columnName{:asc]}[,.]]',][data_mirroring_...
列出所有没有设置Distribution Key的表 SELECT DISTINCT table_namespace AS schema,table_name AS tables FROM hologres.hg_table_properties a WHERE property_key='storage_format' AND NOT EXISTS(SELECT 1 FROM hologres.hg_table_...
通过 hg_stat_activity 查看 您可以通过 hg_stat_activity 系统视图查看正在运行中的刷新任务，在 hg_stat_activity 中不同的刷新模式显示存在差异：全量刷新：会展示INSERT语句。增量刷新：会展示Refresh任务。通过 监控指标查看刷新任务 ...
or DROP DYNAMIC TABLE[CASCADE]command,Hologres automatically moves them to the table recycle bin.Tables in the recycle bin are stored in a separate schema named hg_recyclebin.The table's name,data,properties,and indexes ...