egalpin opened a new issue, #11651:
URL: https://github.com/apache/pinot/issues/11651
This may be an intentional choice but LOOKUP (dimension table use) does not
appear to work in v2 engine. Repro steps are:
- write any query using LOOKUP in v1 engine, validate that it works
- issue the same query to the v2 engine
- note that it fails with a message like:
```
Caused by: org.apache.calcite.runtime.CalciteContextException: From line 2,
column 63 to line 2, column 126: No match found for function signature
LOOKUP(<CHARACTER>, <CHARACTER>, <CHARACTER>, <NUMERIC>)
at
jdk.internal.reflect.GeneratedConstructorAccessor219.newInstance(Unknown Source)
at
java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at
java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
at
org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:505)
...
Caused by: org.apache.calcite.sql.validate.SqlValidatorException: No match
found for function signature LOOKUP(<CHARACTER>, <CHARACTER>, <CHARACTER>,
<NUMERIC>)
at
jdk.internal.reflect.GeneratedConstructorAccessor218.newInstance(Unknown Source)
at
java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at
java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
at
org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:505))
```
--
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.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
