dsabonis opened a new issue #6412:
URL: https://github.com/apache/incubator-pinot/issues/6412
Noticed that date transformation/formatting fails in `WHERE` clause though
it works fine when used in `SELECT`.
My dataset timestamp is of the following format: `2020-10-01T14:00:00.000Z`.
The following works:
```
SELECT
dateTimeConvert("timestamp",
'1:HOURS:SIMPLE_DATE_FORMAT:yyyy-MM-dd''T''HH:mm:ss.SSS''Z''',
'1:HOURS:SIMPLE_DATE_FORMAT:yyyy-MM-dd', '1:HOURS')
FROM myTable
```
But same expression fails if moved to `WHERE`:
```
SELECT
*
FROM myTable
WHERE
dateTimeConvert("timestamp",
'1:HOURS:SIMPLE_DATE_FORMAT:yyyy-MM-dd''T''HH:mm:ss.SSS''Z''',
'1:HOURS:SIMPLE_DATE_FORMAT:yyyy-MM-dd', '1:HOURS') = '2020-10-01'
```
This is likely related with handling single quotes in
`SIMPLE_DATE_FORMAT:yyyy-MM-dd''T''HH:mm:ss.SSS''Z''`
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
