Configure Info

sys_log_roll_interval=DAY
lake_compaction_interval_ms_on_success=10000
tablet_sched_consecutive_full_clone_delay_sec=180
net_use_ipv6_when_priority_networks_empty=false
lake_compaction_disable_ids=
enable_sql_blacklist=false
routine_load_task_timeout_second=60
azure_adls2_path=
brpc_short_connection=false
tablet_collect_timeout_seconds=60
enable_http_async_handler=true
tablet_reshard_max_parallel_tablets=10240
max_allowed_in_element_num_of_delete=10000
finish_transaction_default_lock_timeout_ms=1000
label_keep_max_num=1000
consistency_tablet_meta_check_interval_ms=7200000
max_stream_load_timeout_second=259200
max_partition_number_per_table=100000
quorum_publish_wait_time_ms=5000
port_connectivity_check_timeout_ms=10000
black_host_penalty_min_ms=500
otlp_exporter_grpc_endpoint=
metadata_journal_skip_bad_journal_ids=
star_client_list_timeout_seconds=30
compound_predicate_flatten_threshold=512
export_checker_interval_second=5
lake_ingest_slowdown_threshold=100
azure_blob_path=
yarn_client_path=/data/deploy/starrocks/fe/lib/yarn-client/hadoop/bin/yarn
mv_create_partition_batch_interval_ms=1000
key_rotation_days=7
storage_usage_soft_limit_percent=90
flat_json_column_max=100
enable_statistics_collect_profile=false
enable_plan_feature_collection=false
lake_use_combined_txn_log=false
spark_load_submit_timeout_second=300
memory_tracker_interval_seconds=60
enable_refresh_hive_partitions_statistics=true
http_max_chunk_size=8192
default_replication_num=1
enable_iceberg_custom_worker_thread=false
statistic_cache_thread_pool_size=5
storage_usage_soft_limit_reserve_bytes=214748364800
iceberg_metadata_disk_cache_capacity=2147483648
dump_log_modules=[query]
feature_log_roll_size_mb=1024
small_file_dir=/data/deploy/starrocks/fe/small_files
binlog_ttl_second=1800
pipe_default_poll_interval_s=300
port_connectivity_check_retry_times=3
sys_log_format=plaintext
loads_history_sync_interval_second=60
tablet_collect_interval_seconds=60
connector_table_query_trigger_task_schedule_interval=30
azure_blob_shared_key=
enable_trace_historical_node=false
jdbc_meta_default_cache_enable=false
query_explain_level=NORMAL
stream_load_task_keep_max_second=259200
aws_s3_path=
mv_refresh_fail_on_filter_data=true
default_mv_refresh_immediate=true
azure_blob_endpoint=
enable_safe_mode=false
query_port=9030
routine_load_task_consume_second=15
lake_fullvacuum_parallel_partitions=16
gcp_gcs_service_account_private_key=
authentication_ldap_simple_user_search_attr=uid
query_queue_v2_schedule_strategy=SWRR
enable_hms_events_incremental_sync=false
prepared_transaction_default_timeout_second=86400
enable_routine_load_lag_time_metrics=false
ssl_force_secure_transport=false
max_distribution_pruner_recursion_depth=100
enable_https=false
tablet_sched_slot_num_per_path=8
enable_groovy_debug_server=false
enable_task_history_archive=true
statistic_auto_collect_histogram_interval=3600
enable_mv_automatic_active_check=true
statistic_predicate_columns_persist_interval_sec=60
lake_enable_fullvacuum=false
default_statistics_output_row_count=1
disable_hadoop_load=false
mysql_service_nio_enable_keep_alive=true
statistic_full_statistics_failure_tolerance_ratio=0.05
pipe_scheduler_interval_millis=1000
tablet_reshard_history_job_keep_max_ms=259200000
group_provider=[]
enable_metric_calculator=true
http_max_header_size=32768
mv_max_rows_per_refresh=100000000
default_mv_partition_refresh_strategy=adaptive
lake_autovacuum_detect_vaccumed_version=true
sys_log_dir=/data/deploy/starrocks/fe/log
authentication_ldap_simple_server_port=389
enable_auto_tablet_distribution=true
pipe_listener_interval_millis=1000
brpc_inner_reuse_pool=true
max_mv_refresh_failure_retry_times=1
histogram_max_sample_row_count=10000000
profile_log_delete_age=1d
mv_max_partitions_num_per_refresh=64
max_historical_automated_cluster_snapshot_jobs=100
tablet_create_timeout_second=10
export_max_bytes_per_be_per_task=268435456
authorization_enable_column_level_privilege=false
merge_commit_be_assigner_balance_factor_threshold=0.1
profile_info_format=default
big_query_log_roll_interval=DAY
tablet_sched_max_not_being_scheduled_interval_ms=900000
enable_hms_parallel_process_evens=true
enable_sync_statistics_load=false
connector_table_query_trigger_analyze_max_pending_task_num=100
publish_version_interval_ms=10
log_cleaner_disk_usage_threshold=80
max_varchar_length=1048576
edit_log_port=9010
enable_routine_load_lag_metrics=false
gcp_gcs_impersonation_service_account=
semi_sync_collect_statistic_await_seconds=30
tablet_checker_partition_batch_num=500
authentication_ldap_simple_bind_root_pwd=
tablet_sched_pk_index_rebuild_threshold_seconds=172800
azure_adls2_oauth2_tenant_id=
tablet_reshard_job_scheduler_interval_ms=10
iceberg_metadata_cache_disk_path=/data/deploy/starrocks/fe/caches/iceberg
enable_qe_slow_log=true
thrift_backlog_num=1024
jwt_required_issuer=[]
lake_ingest_slowdown_ratio=0.1
aws_s3_region=
proc_profile_collect_time_s=120
enable_show_external_catalog_privilege=true
bdbje_replica_ack_timeout_second=10
enable_materialized_view_text_based_rewrite=true
enable_colocate_restore=false
lake_fullvacuum_partition_naptime_seconds=86400
binlog_max_size=9223372036854775807
load_profile_collect_interval_second=0
ignore_meta_check=false
hdfs_file_system_expire_seconds=300
period_of_auto_resume_min=5
enable_mv_query_context_cache=true
max_show_proc_transactions_entry=2000
enable_task_info_mask_credential=true
http_backlog_num=1024
statistics_sample_ndv_estimator=DUJ1
iceberg_metadata_memory_cache_capacity=0
lake_autovacuum_stale_partition_threshold=12
flat_json_null_factor=0.3
locale=zh_CN.UTF-8
tablet_reshard_target_size=1073741824
custom_config_dir=/conf
audit_log_roll_num=90
cloud_native_hdfs_url=
thrift_rpc_retry_times=3
qe_max_connection=4096
backup_plugin_path=/tools/trans_file_tool/trans_files.sh
collect_stats_io_tasks_per_connector_operator=4
edit_log_roll_num=50000
ui_queries_sql_statement_max_length=128
automated_cluster_snapshot_interval_seconds=600
enable_file_bundling=true
lake_publish_delete_txnlog_max_threads=16
remote_file_metadata_load_concurrency=32
warehouse_idle_check_interval_seconds=60
lake_compaction_score_upper_bound=2000
load_parallel_instance_num=1
min_graceful_exit_time_second=15
enable_predicate_columns_collection=true
task_runs_max_history_number=10000
max_task_runs_threads_num=512
enable_collect_full_statistic=true
log_cleaner_check_interval_second=300
max_agent_tasks_send_per_be=10000
checkpoint_timeout_seconds=86400
skip_whole_phase_lock_mv_limit=5
thrift_max_recursion_depth=64
tablet_sched_always_force_decommission_replica=false
audit_log_json_format=false
azure_adls2_oauth2_client_id=
http_async_threads_num=4096
enable_background_refresh_resource_table_metadata=false
mysql_service_kill_after_disconnect=true
load_straggler_wait_second=300
desired_max_waiting_jobs=1024
enable_range_distribution=false
task_ttl_second=86400
consistency_check_start_time=23
routine_load_unstable_threshold_second=3600
master_sync_policy=SYNC
max_scalar_operator_optimize_depth=256
lake_compaction_interval_ms_on_failure=60000
http_web_page_display_hardware=true
alter_max_worker_threads=4
lake_vacuum_immediately_partition_ids=
internal_log_roll_interval=DAY
feature_log_roll_num=5
thrift_server_max_worker_threads=4096
arrow_flight_port=-1
bdbje_log_level=INFO
agent_task_resend_wait_time_ms=5000
lake_enable_tablet_creation_optimization=false
lake_compaction_simple_selector_threshold_versions=10
mv_use_creator_based_authorization=true
checkpoint_only_on_leader=false
lake_enable_batch_publish_version=true
dns_cache_ttl_seconds=60
iceberg_table_refresh_expire_sec=86400
jwt_principal_field=sub
oauth2_required_issuer=
query_cost_prediction_service_address=http://localhost:5000
plugin_enable=true
alter_scheduler_interval_millisecond=10000
materialized_view_refresh_ascending=false
authorization_enable_priv_collection_cache=true
max_download_task_per_be=0
replica_sync_policy=SYNC
azure_adls2_endpoint=
enable_backup_materialized_view=false
oauth2_required_audience=
routine_load_kafka_timeout_second=12
max_get_partitions_meta_result_count=100000
db_used_data_quota_update_interval_secs=300
big_query_log_dir=/data/deploy/starrocks/fe/log
enable_collect_warehouse_metrics=true
max_load_timeout_second=259200
big_query_log_delete_age=7d
default_mv_refresh_mode=pct
max_graceful_exit_time_second=60
yarn_config_dir=/data/deploy/starrocks/fe/lib/yarn-config
merge_commit_idle_ms=3600000
bdbje_replay_cost_percent=150
enable_experimental_rowstore=false
max_query_retry_time=2
statistic_auto_collect_large_table_interval=43200
aws_s3_iam_role_arn=
enable_persistent_index_by_default=true
dump_log_delete_age=7d
label_keep_max_second=259200
thrift_client_timeout_ms=5000
metadata_journal_max_batch_size_mb=10
enable_pipeline_load=true
lake_compaction_warehouse=default_warehouse
brpc_connection_pool_size=16
min_load_timeout_second=1
max_routine_load_batch_size=4294967296
lock_manager_lock_table_num=256
meta_delay_toleration_second=300
gcp_gcs_endpoint=
lake_compaction_history_size=20
mysql_nio_backlog_num=1024
authorization_enable_admin_user_protection=false
tablet_delete_timeout_second=2
metadata_journal_ignore_replay_failure=true
statistic_auto_collect_predicate_columns_threshold=32
edit_log_write_slow_log_threshold_ms=2000
check_consistency_default_timeout_second=600
query_detail_explain_level=COSTS
log_roll_size_mb=1024
gcp_gcs_use_compute_engine_service_account=true
iceberg_table_refresh_threads=128
enable_create_partial_partition_in_batch=false
group_provider_refresh_thread_num=4
max_small_file_size_bytes=1048576
slow_query_analyze_threshold=5000
oauth2_jwks_url=
enable_check_db_state=true
profile_log_dir=/data/deploy/starrocks/fe/log
tablet_sched_disable_colocate_balance=false
hive_meta_load_concurrency=4
capacity_used_percent_high_water=0.75
authentication_ldap_simple_bind_base_dn=
plugin_dir=/data/deploy/starrocks/fe/plugins
enable_task_run_fe_evaluation=true
query_queue_v2_concurrency_level=4
lake_balance_tablets_threshold=0.15
dict_collect_thread_pool_size=16
disable_load_job=false
txn_rollback_limit=100
tablet_sched_balance_load_disk_safe_threshold=0.5
enable_temporary_table_statistic_collect=true
max_planner_scalar_rewrite_num=100000
broker_load_default_timeout_second=14400
oauth2_connect_wait_timeout=300
partition_hash_join_min_cardinality_rate=0.3
backup_job_default_timeout_ms=86400000
tablet_sched_min_clone_task_timeout_sec=180
remote_file_cache_ttl_s=86400
enable_query_cost_prediction=false
iceberg_metadata_cache_max_entry_size=0
jwt_required_audience=[]
stream_load_task_keep_max_num=1000
storage_usage_hard_limit_reserve_bytes=107374182400
hive_meta_cache_refresh_interval_s=60
enable_auth_check=true
statistic_analyze_status_keep_second=259200
mv_plan_cache_thread_pool_size=8
statistic_auto_collect_small_table_size=5368709120
enable_materialized_view_metrics_collect=true
log_register_and_unregister_query_id=false
black_host_connect_failures_within_time=5
task_runs_timeout_second=14400
sys_log_json_profile_max_string_length=104857600
merge_commit_be_assigner_schedule_interval_ms=5000
max_task_consecutive_fail_count=10
dict_collect_thread_pool_for_lake_size=4
mv_refresh_try_lock_timeout_ms=30000
thrift_rpc_timeout_ms=10000
star_client_read_timeout_seconds=15
lake_autovacuum_max_previous_versions=0
statistic_sample_collect_rows=200000
ssl_cipher_blacklist=
materialized_view_min_refresh_interval=60
default_automatic_bucket_size=1073741824
enable_statistic_collect_on_update=true
bdbje_reset_election_group=false
dynamic_partition_enable=true
statistic_partition_healthy_v2=true
ssl_truststore_password=
statistic_sample_collect_partition_size=300
enable_sql_digest=false
gcp_gcs_path=
alter_max_worker_queue_size=4096
lake_batch_publish_min_version_num=1
statistic_manager_sleep_time_sec=60
mv_rewrite_consider_data_layout_mode=enable
enable_dict_optimize_routine_load=false
load_checker_interval_second=5
azure_blob_sas_token=
azure_adls2_oauth2_client_secret=
statistic_analyze_task_pool_size=3
privilege_max_role_depth=16
hive_meta_cache_ttl_s=86400
ignore_materialized_view_error=false
enable_replicated_storage_as_default_engine=true
statistics_min_sample_row_ratio=0.01
mv_max_bytes_per_refresh=21474836480
lock_manager_enable_resolve_deadlock=false
report_queue_size=100
max_tolerable_backend_down_num=0
internal_log_dir=/data/deploy/starrocks/fe/log
enable_statistic_collect=true
enable_dict_optimize_stream_load=true
ssl_keystore_location=
statistic_collect_too_many_version_sleep=600000
min_routine_load_lag_for_metrics=10000
max_partitions_in_one_batch=4096
deploy_serialization_queue_size=-1
max_create_table_timeout_second=600
statistic_auto_analyze_start_time=00:00:00
enable_parser_context_cache=true
transaction_stream_load_coordinator_cache_capacity=4096
tmp_dir=/data/deploy/starrocks/fe/temp_dir
spark_home_default_dir=/data/deploy/starrocks/fe/lib/spark2x
dump_log_dir=/data/deploy/starrocks/fe/log
external_table_commit_timeout_ms=10000
export_task_pool_size=5
enable_execute_script_on_frontend=true
export_task_default_timeout_second=7200
query_detail_cache_time_nanosecond=30000000000
sys_log_level=INFO
mysql_service_io_threads_num=4
enable_trigger_analyze_job_immediate=true
transaction_stream_load_coordinator_cache_expire_seconds=900
empty_load_as_error=true
proc_profile_mem_enable=true
enable_reuse_spark_column_statistics=true
thrift_rpc_strict_mode=true
iceberg_worker_num_threads=8
jwt_jwks_url=
lake_compaction_max_tasks=-1
enable_display_shadow_partitions=false
oauth2_client_id=
enable_automatic_bucket=true
enable_manual_collect_array_ndv=false
enable_hudi_lib_internal_metadata_table=true
mv_active_checker_interval_seconds=60
black_host_history_sec=120
log_cleaner_disk_util_based_enable=false
routine_load_pulsar_timeout_second=12
https_port=8443
max_column_number_per_table=10000
query_queue_v2_num_rows_per_slot=4096
max_running_rollup_job_num_per_table=1
max_routine_load_task_num_per_be=16
statistic_auto_collect_small_table_interval=0
tablet_sched_disable_balance=false
azure_adls2_oauth2_oauth2_client_endpoint=
thrift_server_queue_size=4096
spark_load_default_timeout_second=86400
iceberg_metadata_disk_cache_expiration_seconds=604800
aws_s3_endpoint=
lake_publish_version_max_threads=512
big_query_log_modules=[query]
spark_launcher_log_dir=/data/deploy/starrocks/fe/log/spark_launcher_log
enable_desensitize_query_dump=false
enable_paimon_refresh_manifest_files=false
enable_sql_desensitize_in_log=false
enable_mv_automatic_repairing_for_broken_base_tables=true
profile_process_threads_num=2
tablet_sched_disable_colocate_overall_balance=true
lake_warehouse_max_compute_replica=3
enable_udf=true
proc_profile_cpu_enable=true
enable_materialized_view_external_table_precise_refresh=true
enable_show_materialized_views_include_all_task_runs=true
statistic_auto_collect_sample_threshold=0.3
enable_collect_query_detail_info=false
max_bucket_number_per_partition=1024
ranger_user_ugi=false
bdbje_reserved_disk_size=536870912
statistic_update_interval_sec=86400
lake_compaction_score_selector_min_score=10.0
proc_profile_file_retained_days=1
auto_increment_cache_size=100000
enable_experimental_gin=false
lock_manager_enabled=true
flat_json_sparsity_factory=0.3
merge_commit_executor_threads_num=4096
brpc_send_plan_fragment_timeout_ms=60000
enable_sync_tablet_stats=true
enable_table_name_case_insensitive=false
sys_log_delete_age=7d
connector_table_query_trigger_analyze_max_running_task_num=2
lake_batch_publish_max_version_num=10
proc_profile_jstack_depth=128
http_max_initial_line_length=4096
stream_load_default_timeout_second=600
qe_slow_log_ms=5000
enable_mv_refresh_collect_profile=false
cloud_native_storage_type=S3
enable_experimental_vector=false
enable_experimental_temporary_table=true
enable_use_table_sample_collect_statistics=true
star_mgr_meta_sync_interval_sec=600
star_client_write_timeout_seconds=30
enable_audit_sql=true
profile_process_blocking_queue_size=256
authentication_chain=[native]
max_hive_partitions_per_rpc=5000
heartbeat_mgr_blocking_queue_size=1024
histogram_mcv_size=100
metadata_enable_recovery_mode=false
enable_shuffle_load=true
oauth2_auth_server_url=
enable_vectorized_file_load=true
audit_log_delete_age=30d
dump_log_roll_num=10
query_queue_v2_cpu_costs_per_slot=1000000000
tablet_sched_balance_load_score_threshold=0.1
enable_starrocks_external_table_auth_check=true
max_mv_refresh_try_lock_failure_retry_times=3
max_per_node_grep_log_limit=500000
allow_system_reserved_names=false
enable_query_queue_v2=false
enable_active_materialized_view_schema_strict_check=false
jdbc_connection_pool_size=8
enable_auto_collect_array_ndv=false
max_agent_task_threads_num=4096
max_upload_task_per_be=0
run_mode=shared_nothing
meta_dir=/data/deploy/starrocks/fe/meta
statistic_auto_collect_max_predicate_column_size_on_sample_strategy=16
oauth2_redirect_url=
lake_compaction_selector=ScoreSelector
edit_log_type=BDB
history_job_keep_max_second=604800
hms_events_batch_size_per_rpc=500
default_master_key=
azure_use_native_sdk=true
lock_checker_enable_deadlock_check=false
enable_internal_sql=true
enable_materialized_view=true
enable_iceberg_metadata_disk_cache=false
slow_lock_print_stack=true
es_state_sync_interval_second=10
mv_global_context_cache_max_size=5000
hive_meta_store_timeout_s=10
heartbeat_mgr_threads_num=8
statistic_load_max_partition_filter_num=1000
statistic_partition_health__v2_threshold=0.95
starmgr_grpc_timeout_seconds=5
primary_key_disk_schedule_time=3600
partition_recycle_retention_period_secs=1800
thrift_max_frame_size=16384000
max_small_file_number=100
slot_manager_response_thread_pool_size=16
tablet_sched_storage_cooldown_second=-1
enable_auto_collect_statistics=true
max_scalar_operator_flat_children=10000
mysql_server_version=8.0.33
mv_refresh_default_planner_optimize_timeout=30000
enable_new_publish_mechanism=false
enable_experimental_mv=true
statistic_max_full_collect_data_size=107374182400
frontend_address=0.0.0.0
ignore_invalid_privilege_authentications=false
sys_log_enable_compress=false
table_keeper_interval_second=30
json_file_size_limit=4294967296
internal_log_json_format=false
storage_usage_hard_limit_percent=95
enable_fast_schema_evolution_in_share_data_mode=true
audit_log_modules=[slow_query, query]
iceberg_metadata_memory_cache_expiration_seconds=86500
query_queue_slots_estimator_strategy=MAX
meta_sync_force_delete_shard_meta=false
max_mv_task_run_meta_message_values_length=8
profile_log_roll_interval=DAY
spark_resource_path=
enable_mv_refresh_extra_prefix_logging=true
internal_log_modules=[base, statistic]
lake_compaction_allow_partial_success=true
feature_log_roll_interval=DAY
background_refresh_metadata_interval_millis=600000
arrow_token_cache_expire_second=259200
recover_with_empty_tablet=false
enable_concurrent_parse_optimization=false
brpc_min_evictable_idle_time_ms=120000
background_refresh_metadata_time_secs_since_last_access_secs=86400
loads_history_retained_days=30
max_broker_load_job_concurrency=20
enable_statistic_collect_on_first_load=true
lake_autovacuum_partition_naptime_seconds=180
metadata_journal_queue_size=1000
dynamic_partition_check_interval_seconds=600
aws_s3_access_key=
enable_print_sql=false
hdfs_read_buffer_size_kb=8192
internal_log_roll_num=90
cluster_name=StarRocks Cluster
audit_log_enable_compress=false
lake_compaction_simple_selector_threshold_seconds=300
replication_max_parallel_replica_count=10240
enable_online_optimize_table=true
sys_log_verbose_modules=[]
background_refresh_file_metadata_concurrency=4
enable_colocate_mv_index=true
enable_sync_publish=true
http_slow_request_threshold_ms=5000
task_runs_concurrency=4
shard_group_clean_threshold_sec=3600
enable_mv_post_image_reload_cache=true
min_bytes_per_broker_scanner=67108864
tablet_sched_max_clone_task_timeout_sec=7200
refresh_dictionary_cache_thread_num=2
max_routine_load_task_concurrent_num=5
statistic_collect_interval_sec=600
ssl_cipher_whitelist=
task_check_interval_second=60
max_stream_load_batch_size_mb=100
max_backend_down_time_second=3600
heartbeat_retry_times=3
lake_enable_ingest_slowdown=true
tablet_reshard_max_split_count=1024
statistic_full_collect_buffer=20971520
replication_max_parallel_data_size_mb=1048576
statistics_max_multi_column_combined_num=10
enable_materialized_view_spill=true
connector_table_query_trigger_analyze_large_table_interval=43200
load_profile_info_reserved_num=500
max_spm_cache_baseline_size=1000
eliminate_shuffle_load_by_replicated_storage=true
replication_transaction_timeout_sec=86400
max_mysql_service_task_threads_num=4096
task_min_schedule_interval_s=10
enable_http_validate_headers=false
memory_tracker_enable=true
insert_load_default_timeout_second=3600
authentication_ldap_simple_ssl_conn_allow_insecure=true
enable_local_replica_selection=false
enable_token_check=true
show_execution_groups=true
enable_strict_storage_medium_check=false
enable_fast_schema_evolution=true
max_dynamic_partition_num=500
stream_load_profile_collect_threshold_second=0
connector_table_query_trigger_analyze_small_table_rows=10000000
hms_process_events_parallel_num=4
heartbeat_timeout_second=5
enable_legacy_compatibility_for_replication=false
enable_schedule_insert_query_by_row_count=true
metadata_ignore_unknown_operation_type=false
merge_commit_txn_state_dispatch_retry_times=3
label_clean_interval_second=14400
tablet_sched_checker_interval_seconds=20
enable_statistic_cache_refresh_after_write=false
access_control=native
port_connectivity_check_interval_sec=60
brpc_reuse_addr=true
export_running_job_num_limit=5
max_running_txn_num_per_db=1000
default_big_load_profile_threshold_second=300
log_cleaner_disk_usage_target=60
audit_log_roll_interval=DAY
aws_s3_use_instance_profile=false
txn_latency_metric_report_groups=
histogram_collect_bucket_ndv_mode=none
spark_dpp_version=4.1.0-rc01
clear_stale_stats_interval_sec=43200
jdbc_connection_idle_timeout_ms=600000
arrow_token_cache_size=1024
connector_table_query_trigger_analyze_small_table_interval=7200
metadata_ignore_unknown_subtype=false
brpc_idle_wait_max_time=10000
consistency_check_cooldown_time_second=86400
lake_remove_partition_thread_num=8
safe_mode_checker_interval_sec=5
ext_dir=/data/deploy/starrocks/fe/lib
privilege_max_total_roles_per_user=64
adaptive_choose_instances_threshold=32
transaction_clean_interval_second=30
consistency_check_end_time=4
statistic_use_meta_statistics=true
thrift_rpc_max_body_size=-1
tablet_sched_colocate_balance_wait_system_stable_time_s=900
statistic_auto_analyze_end_time=23:59:59
slow_lock_threshold_ms=3000
slow_lock_stack_trace_reserve_levels=15
proc_profile_file_retained_size_bytes=2147483648
jdbc_minimum_idle_connections=1
sys_log_roll_mode=SIZE-MB-1024
transaction_state_print_partition_info=true
default_mv_partition_refresh_number=1
enable_profile_log=true
statistic_predicate_columns_ttl_hours=24
mv_async_reload_wait_timeout_second=180
http_port=8030
max_bdbje_clock_delta_ms=5000
warehouse_idle_check_enable=false
query_deploy_threadpool_size=80
alter_table_timeout_second=86400
hive_meta_cache_refresh_min_threads=50
remote_file_cache_refresh_interval_s=60
merge_commit_txn_state_dispatch_retry_interval_ms=200
tablet_sched_colocate_balance_high_prio_backends=[]
dict_collect_reject_policy=ignore
enable_mv_refresh_sync_refresh_mergeable=false
dump_log_roll_interval=DAY
tablet_stat_update_interval_second=300
enable_mv_refresh_query_rewrite=false
tablet_sched_max_scheduling_tablets=10000
tablet_report_drop_tablet_delay_sec=120
lock_checker_interval_second=30
sys_log_warn_modules=[]
tablet_sched_max_migration_task_sent_once=1000
azure_adls2_sas_token=
profile_log_roll_size_mb=1024
profile_info_reserved_num=500
tablet_sched_repair_delay_factor_second=60
hdfs_write_buffer_size_kb=1024
catalog_metadata_cache_size=500
thrift_max_message_size=1073741824
big_query_log_roll_num=10
statistic_cache_columns=100000
profile_log_roll_num=5
oauth2_principal_field=sub
task_runs_ttl_second=604800
tablet_sched_be_down_tolerate_time_s=900
aws_s3_use_aws_sdk_default_behavior=false
sys_log_json_max_string_length=1048576
transform_type_prefer_string_for_varchar=true
tablet_sched_max_balancing_tablets=500
hms_events_polling_interval_ms=5000
oauth2_token_server_url=
statistic_collect_query_timeout=3600
ssl_keystore_password=
mv_query_context_cache_max_size=1000
enable_mv_automatic_inactive_by_base_table_changes=true
sys_log_to_console=false
deploy_serialization_thread_pool_size=-1
sys_log_roll_num=10
mv_plan_cache_max_size=1000
drop_backend_after_decommission=true
statistic_check_expire_partition=true
replication_interval_ms=100
arrow_flight_sql_connection_query_wait_timeout_ms=10000
enable_alter_struct_column=true
aws_s3_secret_key=
jdbc_meta_default_cache_expire_sec=600
histogram_buckets_size=64
lake_autovacuum_parallel_partitions=8
mv_auto_analyze_async=true
arrow_max_service_task_threads_num=4096
authentication_ldap_simple_server_host=
ssl_key_password=
catalog_trash_expire_second=3600
broker_client_timeout_ms=120000
enable_mv_list_partition_for_external_table=false
statistic_dict_columns=100000
starmgr_grpc_server_max_worker_threads=1024
max_query_queue_history_slots_number=0
tablet_checker_lock_time_per_cycle_ms=1000
routine_load_scheduler_interval_millisecond=10000
enable_materialized_view_concurrent_prepare=true
max_load_initial_open_partition_number=32
slow_lock_log_every_ms=3000
ignore_task_run_history_replay_error=false
statistic_sample_collect_ratio_threshold_of_first_load=0.1
enable_mv_global_context_cache=true
start_with_incomplete_meta=false
bdbje_lock_timeout_second=1
azure_adls2_oauth2_use_managed_identity=false
rpc_port=9020
log_cleaner_audit_log_min_retention_days=3
task_runs_queue_length=500
catalog_try_lock_timeout_ms=5000
tablet_write_log_history_sync_interval_sec=60
ssl_truststore_location=
statistic_auto_collect_use_full_predicate_column_for_sample=true
statistic_auto_collect_small_table_rows=10000000
internal_log_delete_age=7d
lake_enable_balance_tablets_between_workers=true
create_table_max_serial_replicas=128
lake_compaction_default_timeout_second=86400
enable_load_volume_from_conf=true
metadata_journal_max_batch_cnt=100
lake_fullvacuum_meta_expired_seconds=172800
log_plan_cancelled_by_crash_be=true
enable_collect_tablet_num_in_show_proc_backend_disk_path=true
lake_background_warehouse=default_warehouse
enable_decimal_v3=true
authentication_ldap_simple_ssl_conn_trust_store_path=
expr_children_limit=10000
low_cardinality_threshold=255
authentication_ldap_simple_ssl_conn_trust_store_pwd=
merge_commit_gc_check_interval_ms=60000
lake_compaction_sorter=ScoreSorter
enable_http_detail_metrics=false
http_worker_threads_num=0
cloud_native_meta_port=6090
jaeger_grpc_endpoint=
lake_autovacuum_grace_period_minutes=30
mv_plan_cache_expire_interval_sec=86400
stream_load_max_txn_num_per_be=-1
gcp_gcs_service_account_email=
enable_cloud_native_persistent_index_by_default=true
oauth2_client_secret=
priority_networks=127.0.0.1/32
lake_remove_table_thread_num=4
enable_background_refresh_connector_metadata=true
query_cost_predictor_healthchk_interval=30
azure_adls2_shared_key=
audit_log_dir=/data/deploy/starrocks/fe/log
bdbje_heartbeat_timeout_second=30
max_mv_check_base_table_change_retry_times=10
replication_max_parallel_table_count=100
aws_s3_external_id=
authentication_ldap_simple_bind_root_dn=
feature_log_delete_age=3d
statistic_auto_collect_ratio=0.8
feature_log_dir=/data/deploy/starrocks/fe/log
files_enable_insert_push_down_schema=true
histogram_sample_ratio=0.1
vectorized_load_enable=true
tablet_sched_colocate_be_down_tolerate_time_s=43200
replica_ack_policy=SIMPLE_MAJORITY
auth_token=
gcp_gcs_service_account_private_key_id=
bdbje_cleaner_threads=1
tablet_sched_num_based_balance_threshold_ratio=0.5
dict_collect_queue_size=4096
lake_compaction_simple_selector_min_versions=3

Variable Info

SQL_AUTO_IS_NULL=false
activate_all_roles_on_login=false
agg_in_filter_limit=1024
allow_default_partition=false
allow_hive_without_partition_filter=true
always_collect_low_card_dict=false
always_collect_low_card_dict_on_lake=false
ann_params=
array_low_cardinality_optimize=true
arrow_flight_proxy=
arrow_flight_proxy_enabled=true
audit_execute_stmt=true
authentication_policy=*,,
auto_increment_increment=1
autocommit=true
back_pressure_back_rounds=3
back_pressure_throttle_time_upper_bound=300
big_query_log_cpu_second_threshold=480
big_query_log_scan_bytes_threshold=10737418240
big_query_log_scan_rows_threshold=1000000000
big_query_profile_threshold=30s
broadcast_right_table_scale_factor=10.0
broadcast_row_limit=15000000
catalog=default_catalog
cbo_cte_force_reuse_limit_without_order_by=true
cbo_cte_force_reuse_node_count=2000
cbo_cte_max_limit=10
cbo_cte_reuse=true
cbo_cte_reuse_rate=1.15
cbo_debug_alive_backend_number=0
cbo_decimal_cast_string_strict=true
cbo_derive_join_is_null_predicate=true
cbo_derive_range_join_predicate=false
cbo_disabled_rules=
cbo_enable_dp_join_reorder=true
cbo_enable_greedy_join_reorder=true
cbo_enable_histogram_join_estimation=true
cbo_enable_intersect_add_distinct=true
cbo_enable_low_cardinality_optimize=true
cbo_enable_low_cardinality_optimize_for_join=true
cbo_enable_predicate_subfield_path=true
cbo_enable_single_node_prefer_two_stage_aggregate=true
cbo_eq_base_type=decimal
cbo_json_v2_dict_opt=true
cbo_json_v2_rewrite=true
cbo_materialized_view_rewrite_candidate_limit=12
cbo_materialized_view_rewrite_related_mvs_limit=16
cbo_materialized_view_rewrite_rule_output_limit=3
cbo_max_reorder_node=50
cbo_max_reorder_node_use_dp=10
cbo_max_reorder_node_use_exhaustive=4
cbo_max_reorder_node_use_greedy=16
cbo_prepare_metadata_thread_pool_size=16
cbo_prune_json_subfield=true
cbo_prune_json_subfield_depth=20
cbo_prune_shuffle_column_rate=0.1
cbo_prune_subfield=true
cbo_push_down_aggregate=global
cbo_push_down_aggregate_mode=0
cbo_push_down_aggregate_on_broadcast_join=true
cbo_push_down_aggregate_on_broadcast_join_row_count_limit=250000
cbo_push_down_aggregate_with_multi_column_stats=true
cbo_push_down_distinct=global
cbo_push_down_distinct_below_window=true
cbo_push_down_distinct_limit=4096
cbo_push_down_groupingset=true
cbo_push_down_groupingset_reshuffle=true
cbo_push_down_topn_limit=1000
cbo_reorder_threshold_use_exhaustive=6
cbo_rewrite_monotonic_minmax_aggregation=true
cbo_use_correlated_join_estimate=true
cbo_use_correlated_predicate_estimate=true
cbo_use_histogram_evaluate_list_partition=false
cbo_use_lock_db=false
cbo_use_nth_exec_plan=0
character_set_client=utf8
character_set_connection=utf8
character_set_database=utf8
character_set_results=utf8
character_set_server=utf8
choose_execute_instances_mode=LOCALITY
chunk_size=4096
cngroup_low_watermark_cpu_used_permille=600
cngroup_low_watermark_running_query_count=8
cngroup_resource_usage_fresh_ratio=0.5
cngroup_schedule_mode=standard
collation_connection=utf8_general_ci
collation_database=utf8_general_ci
collation_server=utf8_general_ci
column_view_concat_bytes_limit=4294967296
column_view_concat_rows_limit=-1
computation_fragment_scheduling_policy=COMPUTE_NODES_ONLY
connector_huge_file_size=536870912
connector_incremental_scan_ranges_size=500
connector_io_tasks_per_scan_operator=16
connector_io_tasks_slow_io_latency_ms=50
connector_max_split_size=67108864
connector_remote_file_async_queue_size=1000
connector_remote_file_async_task_size=4
connector_scan_use_query_mem_ratio=0.3
connector_sink_compression_codec=uncompressed
connector_sink_spill_mem_limit_threshold=0.5
connector_sink_target_max_file_size=1073741824
consistent_hash_virtual_number=256
count_distinct_column_buckets=1024
count_distinct_implementation=default
cross_join_cost_penalty=1000000
custom_query_id=
data_skew_row_percentage_threshold=0.2
datacache_evict_probability=100
datacache_sharing_work_period=600
decimal_overflow_to_double=false
default_authentication_plugin=mysql_native_password
default_rowset_type=alpha
default_storage_engine=InnoDB
default_table_compression=lz4_frame
default_tmp_storage_engine=InnoDB
disable_colocate_join=false
disable_colocate_set=false
disable_function_fold_constants=false
disable_generated_column_rewrite=false
disable_join_reorder=false
disable_spill_to_local_disk=false
disable_table_stats_from_metadata_for_single_table=true
div_precision_increment=4
dynamic_overwrite=false
enable_adaptive_sink_dop=true
enable_agg_spill_preaggregation=true
enable_aggregation_pipeline_share_limit=true
enable_analyze_phase_prune_columns=false
enable_array_distinct_after_agg_opt=true
enable_async_profile=true
enable_big_query_log=true
enable_bucket_aware_execution_on_lake=true
enable_cbo_based_mv_rewrite=true
enable_cbo_table_prune=false
enable_cbo_view_based_mv_rewrite=false
enable_collect_table_level_scan_stats=true
enable_color_explain_output=true
enable_column_expr_predicate=true
enable_connector_adaptive_io_tasks=true
enable_connector_async_list_partitions=false
enable_connector_deploy_scan_ranges_background=true
enable_connector_incremental_scan_ranges=true
enable_connector_sink_global_shuffle=true
enable_connector_sink_spill=true
enable_connector_sink_writer_scaling=true
enable_connector_split_io_tasks=true
enable_constant_execute_in_fe=true
enable_cost_based_multi_stage_agg=true
enable_count_distinct_rewrite_by_hll_bitmap=true
enable_count_star_optimization=true
enable_cross_join=true
enable_datacache_async_populate_mode=true
enable_datacache_io_adaptor=true
enable_datacache_sharing=true
enable_defer_project_after_topn=true
enable_delta_lake_column_statistics=false
enable_desensitize_explain=false
enable_dialect_downgrade=true
enable_distinct_agg_over_window=true
enable_distinct_column_bucketization=false
enable_drop_table_check_mv_dependency=false
enable_dynamic_prune_scan_range=true
enable_eliminate_agg=true
enable_evaluate_schema_scan_rule=true
enable_exchange_pass_through=true
enable_exchange_perf=false
enable_execution_only=false
enable_expr_prune_partition=true
enable_file_metacache=true
enable_file_pagecache=true
enable_filter_unused_columns_in_scan_stage=true
enable_fine_grained_range_predicate=false
enable_force_rule_based_mv_rewrite=true
enable_full_sort_use_german_string=true
enable_gather_fragment_locality_optimization=false
enable_gin_filter=true
enable_global_late_materialization=false
enable_global_runtime_filter=true
enable_group_by_compressed_key=true
enable_group_execution=true
enable_group_level_query_queue=false
enable_groupby_use_output_alias=false
enable_hash_join_linear_chained_opt=true
enable_hash_join_range_direct_mapping_opt=true
enable_hash_join_serialize_fixed_size_string=true
enable_hive_column_stats=true
enable_hive_metadata_cache_with_insert=false
enable_hyperscan_vec=true
enable_iceberg_column_statistics=false
enable_iceberg_identity_column_optimize=true
enable_iceberg_sink_global_shuffle=false
enable_incremental_mv=false
enable_inner_join_to_semi=true
enable_insert_partial_update=true
enable_insert_select_external_auto_refresh=true
enable_insert_strict=true
enable_ivm_refresh=false
enable_join_reorder_before_deduplicate=false
enable_join_runtime_bitset_filter=true
enable_join_runtime_filter_push_down=true
enable_labeled_column_statistic_output=false
enable_lake_tablet_internal_parallel=true
enable_lambda_pushdown=true
enable_large_in_predicate=true
enable_load_profile=false
enable_local_shuffle_agg=true
enable_materialized_view_agg_pushdown_rewrite=true
enable_materialized_view_concurrent_prepare=true
enable_materialized_view_for_insert=false
enable_materialized_view_multi_stages_rewrite=true
enable_materialized_view_plan_cache=true
enable_materialized_view_rewrite=true
enable_materialized_view_rewrite_greedy_mode=false
enable_materialized_view_rewrite_partition_compensate=true
enable_materialized_view_single_table_view_delta_rewrite=false
enable_materialized_view_text_match_rewrite=true
enable_materialized_view_timeseries_agg_pushdown_rewrite=true
enable_materialized_view_transparent_union_rewrite=true
enable_materialized_view_union_rewrite=true
enable_materialized_view_view_delta_rewrite=true
enable_metadata_profile=false
enable_min_max_optimization=true
enable_multi_cast_limit_push_down=true
enable_multicolumn_global_runtime_filter=true
enable_mv_planner=false
enable_nested_loop_join=true
enable_optimize_skew_join_v1=true
enable_optimize_skew_join_v2=false
enable_optimizer_rule_debug=false
enable_outer_join_reorder=true
enable_paimon_column_statistics=false
enable_parallel_merge=true
enable_parallel_prepare_metadata=false
enable_parquet_reader_bloom_filter=true
enable_parquet_reader_page_index=true
enable_partition_bucket_optimize=false
enable_partition_column_value_only_optimization=true
enable_partition_hash_join=true
enable_partition_level_cardinality_estimation=true
enable_per_bucket_optimize=true
enable_phased_scheduler=false
enable_pipeline_engine=true
enable_pipeline_event_scheduler=true
enable_pipeline_level_multi_partitioned_rf=false
enable_pipeline_level_shuffle=true
enable_plan_advisor=true
enable_plan_advisor_blacklist=true
enable_plan_analyzer=false
enable_plan_capture=false
enable_plan_serialize_concurrently=true
enable_plan_validation=true
enable_populate_datacache=true
enable_predicate_col_late_materialize=true
enable_predicate_expr_reuse=true
enable_predicate_move_around=true
enable_predicate_reorder=false
enable_prepare_stmt=true
enable_profile=false
enable_prune_column_after_index_filter=true
enable_prune_complex_types=true
enable_prune_complex_types_in_unnest=true
enable_prune_iceberg_manifest=true
enable_push_down_pre_agg_with_rank=true
enable_pushdown_or_predicate=true
enable_query_cache=false
enable_query_debug_trace=false
enable_query_dump=false
enable_query_history=false
enable_query_queue=true
enable_query_queue_load=false
enable_query_queue_select=false
enable_query_queue_statistic=false
enable_query_tablet_affinity=false
enable_query_trigger_analyze=true
enable_rbo_table_prune=false
enable_read_iceberg_equality_delete_with_partition_evolution=false
enable_read_iceberg_puffin_ndv=true
enable_recursive_cte=false
enable_result_sink_accumulate=true
enable_rewrite_bitmap_union_to_bitamp_agg=true
enable_rewrite_groupingsets_to_union_all=false
enable_rewrite_or_to_union_all_join=false
enable_rewrite_partition_column_minmax=true
enable_rewrite_simple_agg_to_hdfs_scan=true
enable_rewrite_simple_agg_to_meta_scan=true
enable_rewrite_sum_by_associative_rule=true
enable_rewrite_unnest_bitmap_to_array=true
enable_runtime_adaptive_dop=false
enable_scan_datacache=true
enable_scan_predicate_expr_reuse=true
enable_shared_scan=false
enable_short_circuit=false
enable_show_all_variables=false
enable_show_predicate_tree_in_profile=false
enable_simplify_case_when=true
enable_single_node_schedule=false
enable_sort_aggregate=false
enable_spill=false
enable_spill_buffer_read=true
enable_spill_to_remote_storage=false
enable_split_topn_agg=true
enable_split_topn_agg_limit=10000
enable_spm_rewrite=false
enable_sql_digest=false
enable_stats_to_optimize_skew_join=false
enable_strict_order_by=true
enable_strict_type=false
enable_subfield_no_copy=true
enable_sync_materialized_view_rewrite=true
enable_table_name_case_insensitive=false
enable_table_prune_on_update=false
enable_tablet_internal_parallel=true
enable_tde=false
enable_topn_runtime_filter=true
enable_ukfk_join_reorder=false
enable_ukfk_opt=false
enable_view_based_mv_rewrite=true
enable_wait_dependent_event=false
enable_write_hive_external_table=false
event_scheduler=OFF
exchange_hash_function_version=1
exec_mem_limit=2147483648
exec_mode=default
follower_query_forward_mode=
force_schedule_local=false
forward_to_leader=false
full_sort_late_materialization=true
full_sort_max_buffered_bytes=268435456
full_sort_max_buffered_rows=1073741824
global_runtime_filter_build_max_size=67108864
global_runtime_filter_build_min_size=131072
global_runtime_filter_probe_min_selectivity=0.5
global_runtime_filter_probe_min_size=102400
global_runtime_filter_rpc_http_min_size=67108864
global_runtime_filter_rpc_timeout=400
global_runtime_filter_wait_timeout=20
group_concat_max_len=1024
group_execution_group_scale=64
group_execution_max_groups=128
group_execution_min_scan_rows=5000000
hash_join_interpolate_passthrough=false
hash_join_push_down_right_table=true
hdfs_backend_selector_force_rebalance=false
hdfs_backend_selector_hash_algorithm=consistent
hdfs_backend_selector_scan_range_shuffle=false
historical_nodes_min_update_interval=600
hive_partition_stats_sample_size=3000
hive_temp_staging_dir=/tmp/starrocks
hudi_mor_force_jni_reader=false
init_connect=
innodb_read_only=true
insert_local_shuffle_for_window_pre_agg=true
insert_max_filter_ratio=0.0
insert_timeout=14400
interactive_timeout=3600
interleaving_group_size=10
interpolate_passthrough=true
io_tasks_per_scan_operator=4
jit_level=1
join_implementation_mode_v2=auto
join_late_materialization=false
join_reorder_driving_table_max_element=5
k_factor=1.0
lake_bucket_assign_mode=balance
language=/starrocks/share/english/
large_decimal_underlying_type=panic
large_in_predicate_threshold=100000
license=Apache License 2.0
like_predicate_consolidate_min=2
load_mem_limit=0
load_transmission_compression_type=NO_COMPRESSION
log_rejected_record_num=0
low_cardinality_optimize_on_lake=false
low_cardinality_optimize_v2=true
lower_case_table_names=0
lower_upper_support_utf8=false
materialized_view_join_same_table_permutation_limit=5
materialized_view_max_relation_mapping_size=10
materialized_view_rewrite_mode=DEFAULT
materialized_view_subquery_text_match_max_count=4
materialized_view_union_rewrite_mode=0
max_allowed_packet=33554432
max_buckets_per_be_to_use_balancer_assignment=6
max_or_to_union_all_join_predicates=3
max_parallel_scan_instance_num=-1
max_pipeline_dop=64
max_pushdown_conditions_per_column=-1
max_pushdown_or_predicates=32
max_scan_key_num=-1
max_spill_read_buffer_bytes_per_driver=16777216
max_ukfk_join_reorder_fk_rows=100000000
max_ukfk_join_reorder_scale_ratio=100
metadata_collect_query_timeout=60
nested_mv_rewrite_max_level=3
net_buffer_length=16384
net_read_timeout=60
net_write_timeout=60
new_planner_agg_stage=0
new_planner_optimize_timeout=3000
optimize_distinct_agg_over_framed_window=0
optimizer_materialized_view_timelimit=1000
orc_use_column_names=false
paimon_force_jni_reader=false
parallel_exchange_instance_num=-1
parallel_fragment_exec_instance_num=1
parallel_merge_late_materialization_mode=auto
parse_tokens_limit=3500000
partial_update_mode=auto
performance_schema=false
phased_scheduler_max_concurrency=2
pipeline_dop=0
pipeline_profile_level=1
pipeline_sink_dop=0
plan_capture_include_pattern=.*
plan_capture_interval_seconds=10800
plan_mode=auto
populate_datacache_mode=auto
pq_refine_factor=1.0
prefer_compute_node=false
prefer_cte_rewrite=false
profile_timeout=10
push_down_heavy_exprs=true
query_cache_agg_cardinality_limit=5000000
query_cache_entry_max_bytes=4194304
query_cache_entry_max_rows=409600
query_cache_force_populate=false
query_cache_hot_partition_num=3
query_cache_size=1048576
query_cache_type=0
query_debug_options=
query_delivery_timeout=300
query_excluding_mv_names=
query_history_keep_seconds=259200
query_history_load_interval_seconds=900
query_including_mv_names=
query_mem_limit=0
query_queue_concurrency_limit=0
query_queue_cpu_used_permille_limit=0
query_queue_driver_high_water=-1
query_queue_driver_low_water=-1
query_queue_fresh_resource_usage_interval_ms=5000
query_queue_max_queued_queries=1024
query_queue_mem_used_pct_limit=0.0
query_queue_pending_timeout_second=300
query_timeout=300
range_pruner_max_predicate=100
recursive_cte_finalize_temporal_table=true
recursive_cte_max_depth=5
recursive_cte_throw_limit_exception=true
resource_group=
resource_group_id=0
rpc_http_min_size=2147482624
runtime_adaptive_dop_max_block_rows_per_driver_seq=16384
runtime_adaptive_dop_max_output_amplification_factor=0
runtime_filter_early_return_selectivity=0.05
runtime_filter_on_exchange_node=false
runtime_filter_scan_wait_time=20
runtime_join_filter_push_down_limit=1024000
runtime_profile_report_interval=10
scan_hive_partition_num_limit=0
scan_olap_partition_num_limit=0
scan_or_to_union_limit=4
scan_or_to_union_threshold=50000000
scan_use_query_mem_ratio=0.3
select_ratio_threshold=0.15
semi_join_deduplicat_mode=0
single_node_exec_plan=false
skew_join_data_skew_threshold=0.2
skew_join_rand_range=1000
skew_join_use_mcv_count=5
skip_local_disk_cache=false
skip_page_cache=false
spill_enable_compaction=true
spill_enable_direct_io=false
spill_encode_level=7
spill_hash_join_probe_op_max_bytes=2147483648
spill_mem_limit_threshold=0.8
spill_mem_table_num=2
spill_mem_table_size=104857600
spill_mode=auto
spill_operator_max_bytes=1048576000
spill_operator_min_bytes=52428800
spill_partitionwise_agg=false
spill_partitionwise_agg_partition_num=32
spill_partitionwise_agg_skew_elimination=true
spill_rand_ratio=0.1
spill_revocable_max_bytes=0
spill_storage_volume=
spillable_operator_mask=-1
spm_rewrite_timeout_ms=1000
sql_dialect=StarRocks
sql_mode=ONLY_FULL_GROUP_BY
sql_quote_show_create=true
sql_safe_updates=0
sql_select_limit=9223372036854775807
statistic_collect_parallel=1
statistic_meta_collect_parallel=10
storage_engine=olap
streaming_preaggregation_mode=auto
system_time_zone=Etc/UTC
tablet_internal_parallel_mode=auto
thrift_plan_protocol=binary
time_zone=Etc/UTC
topn_filter_back_pressure_mode=0
topn_push_down_agg_mode=1
trace_log_level=0
trace_log_mode=command
transaction_isolation=REPEATABLE-READ
transaction_read_only=false
transmission_compression_type=AUTO
transmission_encode_level=7
tvr_target_mvid=
tx_isolation=REPEATABLE-READ
tx_visible_wait_timeout=10
use_compute_nodes=-1
use_page_cache=true
version=8.0.33
version_comment=4.1.0-rc01-7c0eb22
wait_timeout=28800
warehouse=default_warehouse
window_partition_mode=1