shaobo-stripe opened a new issue, #12106:
URL: https://github.com/apache/pinot/issues/12106
Hi, we are trying out v2 query engine. This simplified query works well in
v1 (without `set useMultistageEngine=true;`):
```
set useMultistageEngine=true;
select
*
from
<table>
where
created_ms >= FromDateTime('2023-09-22 11:30:00', 'yyyy-MM-dd HH:mm:ss')
and created_ms < FromDateTime('2023-09-22 12:00:00', 'yyyy-MM-dd HH:mm:ss')
limit 1
```
but we see this error with v2 turned on
```
Caused by: org.apache.calcite.runtime.CalciteContextException: From line 8,
column 3 to line 8, column 81: Cannot apply '>=' to arguments of type '<BIGINT>
>= <TIMESTAMP(0)>'. Supported form(s): '<COMPARABLE_TYPE> >= <COMPARABLE_TYPE>'
at
java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
at
java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at
java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at
java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
...
Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Cannot
apply '>=' to arguments of type '<BIGINT> >= <TIMESTAMP(0)>'. Supported
form(s): '<COMPARABLE_TYPE> >= <COMPARABLE_TYPE>'
at
java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
at
java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at
java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at
java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490))
```
Could use help figuring out how to craft the time comparison logic in v2
engine
--
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]
