apache / apache/pinot

Multiple aggregate columns not showing on Pinot Data Explorer.

Open
#4,542 2 comments 0 reactions 0 assignees View on GitHub
Dominant language
Java
Stars
6.1k
Forks
1.5k
Avg merge
1d 21h
Merged PRs (30d)
189

Description

I just built quickstart from latest commit from origin/HEAD: 83cc88d76298edafbd0ca72a7d2fbde8e13dabf0

Do some queries on baseballStats table:
```
select teamID, COUNT(*), MAX(numberOfGames) from baseballStats group by teamID
```

But the table view doesn't show the max number of games column (image 1). But, the JSON view returns (image 2).

Images are attached:
**Image 1:**
![Screenshot from 2019-08-20 21-13-56](https://user-images.githubusercontent.com/49970715/63355215-ff270e00-c38f-11e9-8f8b-e22fe6677223.png)

**Image 2:**
![Screenshot from 2019-08-20 21-14-05](https://user-images.githubusercontent.com/49970715/63355162-e7e82080-c38f-11e9-83b8-7a33b2168089.png)

Contributor guide

Open the contributing guide

Research direction

Reproduce the baseballStats query in Pinot Data Explorer and compare the table view with the JSON view. Trace how aggregate columns are rendered in the table, then verify that the MAX(numberOfGames) result appears alongside COUNT(*) while grouped results remain correct.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, sql
Domain
frontend
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.