jugomezv commented on issue #11543: URL: https://github.com/apache/pinot/issues/11543#issuecomment-1710643531
Further more using a single boundary does yield a result but not the proper one: ``` "SELECT \"time_stamp\", avg(\"fifteen_minutes_freshness\") AS \"fifteen_minutes_freshness:avg\" FROM DailyPinotGlobalDataFreshnessTable WHERE (**\"time_stamp\" >= 2023-08-29-00**) GROUP BY \"time_stamp\" ORDER BY avg(\"fifteen_minutes_freshness\") DESC LIMIT 30" +---------------+-------------------------------+ | time_stamp | fifteen_minutes_freshness:avg | +---------------+-------------------------------+ | 2023-08-29-00 | 99.28717948717949 | | 2023-08-30-00 | 98.84102564102564 | | **2023-08-25-00** | 98.5228426395939 | +---------------+-------------------------------+ ``` When you do use single quotes around the time stamp, it does yield the proper result: ``` "SELECT \"time_stamp\", avg(\"fifteen_minutes_freshness\") AS \"fifteen_minutes_freshness:avg\" FROM DailyPinotGlobalDataFreshnessTable WHERE (\"time_stamp\" >= '2023-08-29-00') GROUP BY \"time_stamp\" ORDER BY avg(\"fifteen_minutes_freshness\") DESC LIMIT 30" +---------------+-------------------------------+ | time_stamp | fifteen_minutes_freshness:avg | +---------------+-------------------------------+ | 2023-08-29-00 | 99.28717948717949 | | 2023-08-30-00 | 98.84102564102564 | +---------------+-------------------------------+ ``` -- 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]
