Query exceeded max memory size when like operate

[zhaiyuyong]

select * from a.table_1 where pt='2018-10-09' and id like '%123456' limit 10;

Query 20181010_060653_03859_wve7n failed: Query exceeded max memory size of 500GB

[findepi]

Have a look at query JSON in the Web UI. It will show you where all the memory allocations were accounted.

[zhaiyuyong]

[findepi]

@zhaiyuyong i see you found the json (https://user-images.githubusercontent.com/4199724/46720753-fc558a00-cca3-11e8-9630-5ed64c8f1b84.png).
now you need to find the operator that has mem allocations.

[zhaiyuyong]

@findepi

[findepi]

This might be incorrect accounting of the memory. What is Presto version? What is the file format?

[zhaiyuyong]

file format:ORC
presto version:0.203

[nezihyigitbasi]

I recommend you to try the latest version as there have been memory tracking-related fixes since 0.203.

[zhaiyuyong]

@nezihyigitbasi could you provide an id of the issue？

[tsuxia]

Was wondering if this issue should be closed or not?

[stale]

This issue has been automatically marked as stale because it has not had any activity in the last 2 years. If you feel that this issue is important, just comment and the stale tag will be removed; otherwise it will be closed in 7 days. This is an attempt to ensure that our open issues remain valuable and relevant so that we can keep track of what needs to be done and prioritize the right things.