ericxiao251 commented on issue #10644: URL: https://github.com/apache/druid/issues/10644#issuecomment-840038909
@benkrug I don't have much context as to why the results are what they are but I think that is the intentions of the runtime parameter `druid.generic.useDefaultValueForNull`; return a non-null value (when set to True) or `NULL` (when set to False). Whether the non-null value should be 0 or `Long.MIN_VALUE` is what I am trying to figure out. In Presto SQL... this is what I get: <img width="324" alt="Screen Shot 2021-05-12 at 3 23 20 PM" src="https://user-images.githubusercontent.com/9758510/118032727-fd586780-b335-11eb-9940-bf2aeec73d16.png";> --- This is from the [documentation](https://druid.apache.org/docs/latest/configuration/index.html#sql-compatible-null-handling): ``` When set to true, null values will be stored as '' for string columns and 0 for numeric columns. Set to false to store and query data in SQL compatible mode. ``` It worries that the default value gives the non SQL expected value (Null). -- 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
![https://user-images.githubusercontent.com/9758510/118032727-fd586780-b335-11eb-9940-bf2aeec73d16.png"](https://user-images.githubusercontent.com/9758510/118032727-fd586780-b335-11eb-9940-bf2aeec73d16.png"){kind=link}