You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@druid.apache.org by "rahulkg31 (via GitHub)" <gi...@apache.org> on 2023/03/22 12:42:41 UTC
[GitHub] [druid] rahulkg31 opened a new issue, #13963: Ingest null value for INT and LONG type column in Druid
rahulkg31 opened a new issue, #13963:
URL: https://github.com/apache/druid/issues/13963
I am ingesting some data from JSON to Druid. The input data has null value for some of the INT and LONG fields. I want to store them as null, instead of storing them as 0. I am not able to figure out how to do that. Can anyone guide me through?
There is a similar question on stackoverflow - [Apache Druid can store null value for number](https://stackoverflow.com/questions/71480544/apache-druid-can-store-null-value-for-number). The answers say it can be done, but it's not clear how it can be done.
Thanks,
--
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.
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org
[GitHub] [druid] rahulkg31 closed issue #13963: Ingest null value for INT and LONG type column in Druid
Posted by "rahulkg31 (via GitHub)" <gi...@apache.org>.
rahulkg31 closed issue #13963: Ingest null value for INT and LONG type column in Druid
URL: https://github.com/apache/druid/issues/13963
--
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.
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org
[GitHub] [druid] rahulkg31 commented on issue #13963: Ingest null value for INT and LONG type column in Druid
Posted by "rahulkg31 (via GitHub)" <gi...@apache.org>.
rahulkg31 commented on issue #13963:
URL: https://github.com/apache/druid/issues/13963#issuecomment-1482333846
Solution -
`druid.generic.useDefaultValueForNull=false` is actually a system property and has to be added in following config file that will not convert `null` to 0. By default `druid.generic.useDefaultValueForNull=true`, and that is why the issue.
druid/conf/druid/cluster/_common/common.runtime.properties
I must say, documentation is little bit vague though.
--
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.
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org