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: commits-unsubscr...@pinot.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org For additional commands, e-mail: commits-h...@pinot.apache.org
