apache / apache/pinot

LOOKUP not supported in v2 engine

Open
#11,651 13 comments 0 reactions 1 assignee Claimed by @walterddr View on GitHub
multi-stage
Dominant language
Java
Stars
6.1k
Forks
1.5k
Avg merge
2d 55m
Merged PRs (30d)
182

Description

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(, , , )
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(, , , )
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))
```

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.