jadami10 commented on issue #8998: URL: https://github.com/apache/pinot/issues/8998#issuecomment-1181028154
Ohhh you're totally right and this is a result of our confusing column names. Because we pre-aggregate, we name the column 'sum_amount'. And then when we query we do 'sum(sum_amount) as amount'. So filtering by 'amount' is wrong and only looks like it should work because of the alias. In reality the column is 'sum_amount' Cc @noon-stripe -- 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]
