You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@pinot.apache.org by "ashishjayamohan (via GitHub)" <gi...@apache.org> on 2024/11/14 22:53:18 UTC

[I] NPE When Querying `MAX` On Non-Numeric Column [pinot]

ashishjayamohan opened a new issue, #14459:
URL: https://github.com/apache/pinot/issues/14459

   When querying the `MAX` of a column, we use `NonScanBasedAggregationOperator` to use the stored metadata. This produces a NPE on non-numeric columns as these columns do not have a stored max value. Ideally, this should produce a more informative error that states this aforementioned reason.
   ![Screenshot 2024-11-14 at 2 50 11 PM](https://github.com/user-attachments/assets/84f56080-b4ad-48c5-9ad7-80a176bf980b)


-- 
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] Nullity Error When Querying `MAX` On Non-Numeric Column [pinot]

Posted by "ashishjayamohan (via GitHub)" <gi...@apache.org>.
ashishjayamohan closed issue #14459: Nullity Error When Querying `MAX` On Non-Numeric Column
URL: https://github.com/apache/pinot/issues/14459


-- 
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

Re: [I] Nullity Error When Querying `MAX` On Non-Numeric Column [pinot]

Posted by "ashishjayamohan (via GitHub)" <gi...@apache.org>.
ashishjayamohan commented on issue #14459:
URL: https://github.com/apache/pinot/issues/14459#issuecomment-2477574900

   Correct, I updated to not be NPE. I think it would be better to state this error more informatively (rather than "null," state type)


-- 
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

Re: [I] Nullity Error When Querying `MAX` On Non-Numeric Column [pinot]

Posted by "Jackie-Jiang (via GitHub)" <gi...@apache.org>.
Jackie-Jiang commented on issue #14459:
URL: https://github.com/apache/pinot/issues/14459#issuecomment-2477572653

   Hmm, it is actually a `NumberFormatException` which is expected because `MAX` only works on numbers as of now


-- 
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

Re: [I] Nullity Error When Querying `MAX` On Non-Numeric Column [pinot]

Posted by "Jackie-Jiang (via GitHub)" <gi...@apache.org>.
Jackie-Jiang commented on issue #14459:
URL: https://github.com/apache/pinot/issues/14459#issuecomment-2477585296

   `"null"` is the actual string value, which cannot be parsed as number


-- 
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