Schema sampling fails due to sort memory limit exceeded, how to add allowDiskUse:true

[michael_hoeller (Michael Höller)]

Hello @Stennie_X

@Stennie_X

I recall you using dedicated clusters, but would note that shared clusters (M0, M2, M5) do not support the allowDiskUse option.

Thanks for the note, now it comes clear. I moved a staging cluster to M2, I was aware that there are restrictions on M0 and forgot to check for M2, your link is actually on my link list. My fault. I double checked with an M50 Cluster, there I don’t get the message. It fails also on the M50 cluster but with a timeout which is an other issue mentioned in Chart get’s a timeout - how to debug?. The workaround in that post is to use a view, which generally works but is sub optimal for a schema analysis.

Thanks a lot Stennie!
Michael