You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@druid.apache.org by "carltal (via GitHub)" <gi...@apache.org> on 2024/08/09 17:00:59 UTC
[I] Druid shows "1970-01-01T00:00:00.000Z" with TIME_PARSE function even though the column should be NULL (druid)
carltal opened a new issue, #16877:
URL: https://github.com/apache/druid/issues/16877
### Affected Version
The Druid version where the problem was encountered: 29.0.1
### Description
Please see the screenshots below.
When we have the TIME_PARSE function in both SELECT and WHERE clauses, the output is correct; the column shows null.
When we DO NOT have time TIME_PARSE function in both SELECT and WHERE clauses, the output is also correct; the column shows null.
However, when we have TIME_PARSE function in SELECT but not in WHERE clause, the column shows "1970-01-01T00:00:00.000Z."
The column's type is VARCHAR.
We would like to report this finding to Druid developers. Thanks.
<img width="1091" alt="query 1" src="https://github.com/user-attachments/assets/79181b69-63a5-4dca-a33a-b49411e66200">
<img width="996" alt="query 2" src="https://github.com/user-attachments/assets/826bacc7-d9f1-4699-a1ba-636545d7e88e">
<img width="174" alt="result 1" src="https://github.com/user-attachments/assets/9d0f29ce-64f2-4d81-a1e3-e613fb37dbc7">
<img width="174" alt="result 2" src="https://github.com/user-attachments/assets/ffe085e1-28cb-407b-9682-d70f7b0a4b1e">
--
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
Re: [I] Druid shows "1970-01-01T00:00:00.000Z" with TIME_PARSE function even though the column should be NULL (druid)
Posted by "carltal (via GitHub)" <gi...@apache.org>.
carltal commented on issue #16877:
URL: https://github.com/apache/druid/issues/16877#issuecomment-2310421866
@LakshSingla Thank you! Yes that looks to be the issue we are facing.
--
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
Re: [I] Druid shows "1970-01-01T00:00:00.000Z" with TIME_PARSE function even though the column should be NULL (druid)
Posted by "abhishekagarwal87 (via GitHub)" <gi...@apache.org>.
abhishekagarwal87 commented on issue #16877:
URL: https://github.com/apache/druid/issues/16877#issuecomment-2309374480
Do you have a sample data and ingestion spec that will allow us to reproduce this bug?
--
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
Re: [I] Druid shows "1970-01-01T00:00:00.000Z" with TIME_PARSE function even though the column should be NULL (druid)
Posted by "LakshSingla (via GitHub)" <gi...@apache.org>.
LakshSingla commented on issue #16877:
URL: https://github.com/apache/druid/issues/16877#issuecomment-2309379451
https://github.com/apache/druid/pull/16915 might resolve this. I can confirm it in a while.
--
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
Re: [I] Druid shows "1970-01-01T00:00:00.000Z" with TIME_PARSE function even though the column should be NULL (druid)
Posted by "carltal (via GitHub)" <gi...@apache.org>.
carltal commented on issue #16877:
URL: https://github.com/apache/druid/issues/16877#issuecomment-2937124878
@gianm looks good 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
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
Re: [I] Druid shows "1970-01-01T00:00:00.000Z" with TIME_PARSE function even though the column should be NULL (druid)
Posted by "carltal (via GitHub)" <gi...@apache.org>.
carltal commented on issue #16877:
URL: https://github.com/apache/druid/issues/16877#issuecomment-2310420959
@abhishekagarwal87 Hi, thanks for your response. Unfortunately the above screenshot is all I can provide at this time.
--
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
Re: [I] Druid shows "1970-01-01T00:00:00.000Z" with TIME_PARSE function even though the column should be NULL (druid)
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #16877:
URL: https://github.com/apache/druid/issues/16877#issuecomment-2932970983
This issue has been marked as stale due to 280 days of inactivity.
It will be closed in 4 weeks if no further activity occurs. If this issue is still
relevant, please simply write any comment. Even if closed, you can still revive the
issue at any time or discuss it on the dev@druid.apache.org list.
Thank you for your contributions.
--
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
Re: [I] Druid shows "1970-01-01T00:00:00.000Z" with TIME_PARSE function even though the column should be NULL (druid)
Posted by "gianm (via GitHub)" <gi...@apache.org>.
gianm commented on issue #16877:
URL: https://github.com/apache/druid/issues/16877#issuecomment-2936544091
From the description, I believe this was fixed by https://github.com/apache/druid/pull/16915. Please reopen if needed.
--
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
Re: [I] Druid shows "1970-01-01T00:00:00.000Z" with TIME_PARSE function even though the column should be NULL (druid)
Posted by "gianm (via GitHub)" <gi...@apache.org>.
gianm closed issue #16877: Druid shows "1970-01-01T00:00:00.000Z" with TIME_PARSE function even though the column should be NULL
URL: https://github.com/apache/druid/issues/16877
--
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