apache / apache/pinot

LOOKUP (dimension table) does not work with GROUP BY

Open
#11,018 2 comments 0 reactions 0 assignees View on GitHub
Dominant language
Java
Stars
6.1k
Forks
1.5k
Avg merge
2d 3h
Merged PRs (30d)
195

Description

From the broker logs:

```log
2023/06/30 21:28:35.954 ERROR [PinotClientRequest] [jersey-server-managed-async-executor-1] Caught exception while processing POST request
java.lang.IllegalArgumentException: Unsupported function: lookup not found
at org.apache.pinot.core.query.postaggregation.PostAggregationFunction.(PostAggregationFunction.java:47)
```

It's called out in the docs that `LOOKUP` is not supported for multi-value fields. But is it intentionally not supported for post-aggregation decoration? Or is this just an omission?

Contributor guide

Open the contributing guide

Research direction

Start with org.apache.pinot.core.query.postaggregation.PostAggregationFunction.java, named in the broker stack trace, and trace how LOOKUP is resolved for post-aggregation expressions in GROUP BY queries. Compare that path with the documented multi-value limitation and determine whether the expected result is support or an explicit restriction; done means the behavior is defined and verified without the current unsupported-function error.

Written by the indexing model from the issue text.

Assessment

Tech stack
java
Domain
database
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
30/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.