io.druid.query.QueryInterruptedException: Not enough disk space to execute this query

Hi

Still last week big queries for one month and all working. From this week query for 1 month data is not working and throwing below error:

Caused by: io.druid.query.QueryInterruptedException: Not enough disk space to execute this query. Try raising druid.query.groupBy.maxOnDiskStorage.

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_112]

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[?:1.8.0_112]

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.8.0_112]

at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[?:1.8.0_112]

In Broker Druide version is 0.12.0.

Any help. Very urgent.

Thanks

Prabakaran Krishnan

Hi,

There was a similar issue discussed in - https://groups.google.com/forum/#!topic/druid-user/WvKmDQ32ElQ

might be of your help.

  • Arun

Please try increasing below param in Brokers/Historicals run time properties :

druid.query.groupBy.maxMergingDictionarySize

If it still fails with the value you set , increase it further (1Gb/2Gb) to the extent possible in the node if this still fails you can think of druid.query.groupBy.maxOnDiskStorage as setting this value would spill the data back to disk and hence it would impact the query performance.

You can search for both the properties in druid configuration doc.

Thanks and Regards,

VaibhaV