Tmb377 opened a new issue #8631: Null values not returned for group by JSON response URL: https://github.com/apache/incubator-druid/issues/8631 ### Affected Version 0.16.0 ### Description When querying with a group by query, if a dimension is null, it is filtered out of the JSON response. When `resultAsArray` is set to true, the null is returned, but if it is set to false, it is not included in the row. Here's an example with the same query with `resultAsArray` set to true and false: When set to true, this is the resulting row: `[ 1569801600000, null, 100 ]` But when set to false, this is the row: `{ "version": "v1", "timestamp": "2019-09-30T00:00:00.000Z", "event": { "SomeAggregate": 100 } }` In previous versions, the dimension would be included with a null value. Our current workaround is to make it a lookup dimension with a mapping for empty string, but I'm not sure if there's a better way.
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
