presto 相关使用中的问题

1、Error injecting constructor, java.lang.IllegalArgumentException: query.max-memory-per-node set to 20GB, but only 10213706957B of useable heap available

解决方法：Presto will claim 0.40 * max heap size for the system pool, so your query.max-memory-per-node must not exceed this. You can increase the heap or decrease query.max-memory-per-node.

 

2、failed: Encountered too many errors talking to a worker node. The node may have crashed or be under too much load. failed java.util.concurrent.CancellationException: Task was cancelled

解决方法：such exceptions caused by timeout limits，延长等待时间，在work节点config配置中set exchange.http-client.request-timeout=50s

 

3、PrestoException: ROW comparison not supported for fields with null elements

解决方法：把 !=null 换成 is not null

 

4、Presto日志中出现大量的Triggering GC to avoid Code Cache eviction bugs

查看：

use jmx.current;

select * fro