You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@druid.apache.org by GitBox <gi...@apache.org> on 2021/04/21 23:04:04 UTC
[GitHub] [druid] benkrug opened a new issue #11145: sql count(*) returns no results instead of 0 when no rows meet filter
benkrug opened a new issue #11145:
URL: https://github.com/apache/druid/issues/11145
A select count(*) will return nothing rather than 0, if no rows pass the WHERE conditions.
Eg, load wikipedia.
`select count(*) from wikipedia` - returns 24433 (for me, in my load)
`select count(*) from wikipedia where channel = 'abc'` - returns nothing, not 0.
This is true running in the console, or using the API. There I get `[{"EXPR$0":24433}]` for the first query, and `[]` for the second.
--
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:
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] clintropolis commented on issue #11145: sql count(*) returns no results instead of 0 when no rows meet filter
Posted by GitBox <gi...@apache.org>.
clintropolis commented on issue #11145:
URL: https://github.com/apache/druid/issues/11145#issuecomment-830978612
>Hey, can I take this up if it isn't a problem?
Oops, I think I have solved this with #11188, which I just did as an offshoot of #11157 before I noticed this ticket. I hope you didn't get too far into working on this, my apologies for not searching open issues before hacking on stuff.
--
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:
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] karthikbhat13 commented on issue #11145: sql count(*) returns no results instead of 0 when no rows meet filter
Posted by GitBox <gi...@apache.org>.
karthikbhat13 commented on issue #11145:
URL: https://github.com/apache/druid/issues/11145#issuecomment-830651484
Hey, can I take this up if it isn't a problem?
--
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:
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] clintropolis closed issue #11145: sql count(*) returns no results instead of 0 when no rows meet filter
Posted by GitBox <gi...@apache.org>.
clintropolis closed issue #11145:
URL: https://github.com/apache/druid/issues/11145
--
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:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org