Presto介绍及常用查询优化方法总结

[GOOD]: SELECT GROUP BY uid, gender [BAD]:  SELECT GROUP BY gender, uid

[GOOD] SELECT ... FROM access WHERE regexp_like(method, 'GET|POST|PUT|DELETE') 
[BAD] SELECT ... FROM access WHERE method LIKE '%GET%' OR  method LIKE '%POST%' OR  method LIKE '%PUT%' OR  method LIKE '%DELETE%'

set session distributed_join = 'true' 
SELECT ... FROM large_table1 join large_table2 on large_table1.id = large_table2.id

SELECT ... FROM t1 JOIN t2 ON t1.a1 = t2.a1 ORt1.a2 = t2.a2 
改为
SELECT ... FROM t1 JOIN t2 ON t1.a1 = t2.a1 union SELECT ... FROM t1 JOIN t2 ON t1.a2 = t2.a2

WITH tmp AS (   SELECT DISTINCT a1, a2   FROM t2) SELECT ... FROM t1 JOIN tmp ON t1.a1 = tmp.a1 union SELECT ... FROM t1 JOIN tmp ON t1.a2 = tmp.a2;