unknown exception on skipEmptyBuckets

Hi,

we are using rest apis to query druid. and we are trying to set context.skipEmptyBuckets on timeseries query to true but always encounter “unknown exception” and there is no other informative error message that we could understand what the problem was.

could be that we are merging segments?

we are using druid 0.9.0

regards

Roy

Hey Roy,

Do you see any exceptions in the logs of your broker or historical nodes?

Hi

here are the logs

broker log

2016-05-27T03:56:19,256 INFO [qtp1179244298-47] io.druid.server.QueryResource - Unknown exception [a367e409-d3c6-408e-b6ce-b604df1daeea]

``

historical log

2016-05-27T03:59:36,843 ERROR [processing-1] io.druid.query.ChainedExecutionQueryRunner - Exception with one of the sequences!

java.lang.ClassCastException

2016-05-27T03:59:36,844 WARN [qtp688581408-54] io.druid.server.QueryResource - Exception occurred on request [TimeseriesQuery{dataSource=‘binnedSessions’, querySegmentSpec=MultipleSpecificSegmentSpec{descriptors=[SegmentDescriptor{interval=2011-04-01T00:00:00.000Z/2011-04-02T00:00:00.000Z, version=‘2016-04-27T13:50:39.361Z’, partitionNumber=0}]}, descending=false, dimFilter=null, granularity=‘DurationGranularity{length=3600000, origin=0}’, aggregatorSpecs=[CardinalityAggregatorFactory{name=‘clientCount’, fieldNames=’[clientMac]’}], postAggregatorSpecs=, context={finalize=false, queryId=dc2e5c2d-7207-42e0-bf14-1358ff5c47b4, skipEmptyBuckets=true, timeout=300000}}]

java.lang.ClassCastException

2016-05-27T03:59:36,844 ERROR [qtp688581408-54] io.druid.server.QueryResource - Exception handling request: {class=io.druid.server.QueryResource, exceptionType=class java.lang.ClassCastException, exceptionMessage=null, exception=java.lang.ClassCastException, query=TimeseriesQuery{dataSource=‘binnedSessions’, querySegmentSpec=MultipleSpecificSegmentSpec{descriptors=[SegmentDescriptor{interval=2011-04-01T00:00:00.000Z/2011-04-02T00:00:00.000Z, version=‘2016-04-27T13:50:39.361Z’, partitionNumber=0}]}, descending=false, dimFilter=null, granularity=‘DurationGranularity{length=3600000, origin=0}’, aggregatorSpecs=[CardinalityAggregatorFactory{name=‘clientCount’, fieldNames=’[clientMac]’}], postAggregatorSpecs=, context={finalize=false, queryId=dc2e5c2d-7207-42e0-bf14-1358ff5c47b4, skipEmptyBuckets=true, timeout=300000}}, peer=10.0.1.30}

java.lang.ClassCastException

``

Hey Roy,

Try passing “true” (the string) rather than true (a boolean).

This will be less finicky in 0.9.1 due to https://github.com/druid-io/druid/pull/2616.

Thank you, it works :slight_smile: