admin管理员组文章数量:1596426
version 0.208
基本操作
etc/config.properties
session
show session;
set session join_distribution_type = 'AUTOMATIC';
base
https://prestodb.io/docs/current/admin/properties.html
https://teradata.github.io/presto/docs/current/admin/properties.html#tuning-pref-query
-- Default value: all-at-once
query.execution-policy=phased
-- Default value: 1000
query.max-concurrent-queries=10
-- Default value: false
experimental.spill-enabled=true
experimental.spiller-spill-path=/tmp/presto
-- Default value: false
-- NOT TESTED
query.low-memory-killer.enabled=false
-- Default value: false
-- NOT TESTED
node-scheduler.multiple-tasks-per-node-enabled=false
-- Default value: legacy
-- NOT TESTED
node-schedulerwork-topology=flat
join优化
参数变化情况
-- join_reordering_strategy
-- The join reordering strategy to use. Options are NONE,ELIMINATE_CROSS_JOINS,AUTOMATIC
-- DEFAULT: ELIMINATE_CROSS_JOINS
set session join_reordering_strategy = 'ELIMINATE_CROSS_JOINS';
optimizer.join-reordering-strategy = ELIMINATE_CROSS_JOINS
-- join_distribution_type
-- The join method to use. Options are BROADCAST,PARTITIONED,AUTOMATIC
-- DEFAULT: PARTITIONED
set session join_distribution_type = 'AUTOMATIC';
join-distribution-type = AUTOMATIC
-- max_reordered_joins
-- The maximum number of joins to reorder as one group in cost-based join reordering
-- DEFAULT: 9
set session max_reordered_joins = 9;
optimizer.max-reordered-joins = 9
本文标签: Prestoconfiguration
版权声明:本文标题:presto configuration 内容由热心网友自发贡献,该文观点仅代表作者本人, 转载请联系作者并注明出处:https://m.elefans.com/dongtai/1728256843a1151122.html, 本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容,一经查实,本站将立刻删除。
发表评论