You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@pinot.apache.org by GitBox <gi...@apache.org> on 2022/06/29 20:05:45 UTC
[GitHub] [pinot] taohu18 opened a new issue, #8996: Bug in 0.10.0, Incorrect result when using more than two CASE WHEN statement in group by query
taohu18 opened a new issue, #8996:
URL: https://github.com/apache/pinot/issues/8996
Here is an example query
SELECT DISTINCTCOUNT(name) count, CASE WHEN age < 2 THEN '0-2' WHEN age < 4 THEN '2-4' ELSE '4+' END age_range FROM SAMPLE_TABLE WHERE age >= 0 GROUP BY age_range LIMIT 10
In the table, 3 people has age between 0 and 2, 2 people has age between 2-4, and 4 people has age above 4. But the result of the above query shows 0-2 has 0 people, 2-4 has 5 people and 4+ has 4 people. It adds up the count of first two case when and store the result in the case when before ELSE.
Above query is just a simple example, my production query has 7 CASE WHENs and the result adds up the count of all CASE WHENs and store the total in the last CASE WHEN group before ELSE
This bug only occurs in 0.10.0, in 0.9.3 it works as expected.
--
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@pinot.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org
Re: [I] Bug in 0.10.0, Incorrect result when using more than two CASE WHEN statement in group by query [pinot]
Posted by "Jackie-Jiang (via GitHub)" <gi...@apache.org>.
Jackie-Jiang closed issue #8996: Bug in 0.10.0, Incorrect result when using more than two CASE WHEN statement in group by query
URL: https://github.com/apache/pinot/issues/8996
--
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@pinot.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org
[GitHub] [pinot] richardstartin commented on issue #8996: Bug in 0.10.0, Incorrect result when using more than two CASE WHEN statement in group by query
Posted by GitBox <gi...@apache.org>.
richardstartin commented on issue #8996:
URL: https://github.com/apache/pinot/issues/8996#issuecomment-1171159276
@taohu18 Does this occur on master?
--
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@pinot.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org
[GitHub] [pinot] taohu18 commented on issue #8996: Bug in 0.10.0, Incorrect result when using more than two CASE WHEN statement in group by query
Posted by GitBox <gi...@apache.org>.
taohu18 commented on issue #8996:
URL: https://github.com/apache/pinot/issues/8996#issuecomment-1171488524
@richardstartin I downloaded pinot from the official build, not sure if it's on master or not. I will try with the most recent official build to see if it's fixed
--
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@pinot.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org
[GitHub] [pinot] mayankshriv commented on issue #8996: Bug in 0.10.0, Incorrect result when using more than two CASE WHEN statement in group by query
Posted by GitBox <gi...@apache.org>.
mayankshriv commented on issue #8996:
URL: https://github.com/apache/pinot/issues/8996#issuecomment-1170447075
Thanks for reporting, we will take a look. Is this a generic bug, or happens on a specific dataset?
--
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@pinot.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org
[GitHub] [pinot] taohu18 commented on issue #8996: Bug in 0.10.0, Incorrect result when using more than two CASE WHEN statement in group by query
Posted by GitBox <gi...@apache.org>.
taohu18 commented on issue #8996:
URL: https://github.com/apache/pinot/issues/8996#issuecomment-1170480655
>
This should be a generic bug. It occurs on all datasets
--
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@pinot.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org
[GitHub] [pinot] ankitsultana commented on issue #8996: Bug in 0.10.0, Incorrect result when using more than two CASE WHEN statement in group by query
Posted by GitBox <gi...@apache.org>.
ankitsultana commented on issue #8996:
URL: https://github.com/apache/pinot/issues/8996#issuecomment-1171496859
Cherry picking https://github.com/apache/pinot/pull/8748 on v0.10.0 fixed it for us.
--
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@pinot.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org