jugomezv opened a new issue, #11543:
URL: https://github.com/apache/pinot/issues/11543
I have a table with the following time column schema:
```
"dateTimeFieldSpecs": [
{
"dataType": "STRING",
"format": "1:DAYS:SIMPLE_DATE_FORMAT:yyyy-MM-dd-HH",
"granularity": "1:DAYS",
"name": "time_stamp"
}
],
```
When I run the following query that should yield non-null output I do get
empty response with no failure:
```
"SELECT \"time_stamp\", avg(\"fifteen_minutes_freshness\") AS
\"fifteen_minutes_freshness:avg\" FROM DailyPinotGlobalDataFreshnessTable WHERE
((\"time_stamp\" >= 2023-08-02-00 AND \"time_stamp\" <= 2023-08-31-23)) GROUP
BY \"time_stamp\" ORDER BY avg(\"fifteen_minutes_freshness\") DESC LIMIT 30"
+------------+-------------------------------+
| time_stamp | fifteen_minutes_freshness:avg |
+------------+-------------------------------+
+------------+-------------------------------+
```
Adding single quotes around the timestamp values makes the query work
properly:
```
"SELECT \"time_stamp\", avg(\"fifteen_minutes_freshness\") AS
\"fifteen_minutes_freshness:avg\" FROM DailyPinotGlobalDataFreshnessTable WHERE
((\"time_stamp\" >= '2023-08-02-00' AND \"time_stamp\" <= '2023-08-31-23'))
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 |
+---------------+-------------------------------+
```
--
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]
