rohityadav1993 opened a new issue, #14629: URL: https://github.com/apache/pinot/issues/14629
when doing a `select count(*) from table_name` query on a table with no segments, the response is empty instead of 0. This is a correct behavour for non aggregation queries but for general aggregation queries where datatype is known a default value like 0 can be returned, e.g. sum(), count(), etc when there are no segments otherwise the caller needs to handle the empty rows scenario as well to prevent result parsing failures. I'll be happy to contribute if we can get a confirmation if this is an intended behavior or can be improved. <img width="945" alt="Screenshot 2024-12-10 at 6 27 45 PM" src="https://github.com/user-attachments/assets/bf3abdab-a13c-45c6-b8a3-4dc461aa66f2";> -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
