clintropolis commented on a change in pull request #8894: document SQL compatible null handling mode URL: https://github.com/apache/incubator-druid/pull/8894#discussion_r348299536
########## File path: docs/configuration/index.md ########## @@ -627,6 +627,15 @@ Support for 64-bit floating point columns was released in Druid 0.11.0, so if yo |--------|-----------|-------| |`druid.indexing.doubleStorage`|Set to "float" to use 32-bit double representation for double columns.|double| +### SQL compatible null handling +Also prior to version 0.13.0, Druid string columns treated `''` and `null` values as interchangeable, and numeric columns were unable to represent `null` values, coercing `null` to `0`. Druid 0.13.0 introduced an at the time undocumented mode which enabled SQL compatible null handling, allowing string columns to distinguish empty strings from nulls, and numeric columns to contain null rows. + +|Property|Description|Default| +|---|---|---| +|`druid.generic.useDefaultValueForNull`|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 segments in SQL compatible mode.|`true`| Review comment: changed ---------------------------------------------------------------- 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]
