presto configuration

version 0.208

基本操作

1. etc/config.properties

2. 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-scheduler.network-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