[Trino] Split long-format results into one series per label
Maintainers usually reply within 1 day
Assessment
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Newbie friendliness
- 35/100
- Issue type
- Feature
- Clarity
- Mostly clear
- Activity status
- Stale
- Tech stack
- typescript
- Domain
- data-visualization
Research direction
Read the Trino time-series query handling changed in the review of #931 and follow-up pull request #941. Check how it currently converts numeric columns into series, then determine how label values should group rows and appear as series names and labels. Done when each distinct label combination produces its own series and results without label columns retain current behavior.
Written by the indexing model from the issue text.
Description
Follow-up from the review of #931.
The Trino time-series query turns each numeric column into one series ("wide" format). A result in "long" format, with one row per timestamp and label value, for example:
SELECT date_trunc('minute', ts) AS time, host, avg(cpu) AS value
FROM metrics GROUP BY 1, 2
becomes a single value series mixing every host, instead of one series per host.
Proposal: treat non-time, non-numeric columns as labels, and group rows by their label values into separate series, each named from its labels and carrying them as series labels. Results with no label columns keep today's behaviour.
- Dominant language
- TypeScript
- Stars
- 33
- Forks
- 95
- Avg merge
- 2d 12h
- Merged PRs (30d)
- 40
Getting set up
- No Dockerfile or Docker Compose file
- Has a pull request template
- No contributing guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from perses/plugins
-
enhancement
Difficulty 2/5 1-3 hours Newbie friendliness 75/100
Maintainers usually reply within 1 day
-
enhancement
Difficulty 4/5 3-5 days Newbie friendliness 48/100
Maintainers usually reply within 1 day
-
[BUG] splunk: export parsing, job polling and missing values are not handled robustlyPossibly taken @AnKiT-GaRG2 claimed this 22 days ago. Open
Difficulty 3/5 1-2 days Newbie friendliness 35/100
Maintainers usually reply within 1 day
-
[BUG] clickhouse: getTimeSeriesData drops dimension columns, collapsing long-format results into one seriesPossibly taken @aminadojava claimed this 50 days ago. Open
Difficulty 4/5 3-5 days Newbie friendliness 58/100
perses/plugins#843 · 1 reaction ·
Maintainers usually reply within 1 day
-
[BUG] clickhouse: FORMAT substring check, envelope fallback and swallowed errorsPossibly taken @Yash121l claimed this 38 days ago. Open
Difficulty 4/5 3-5 days Newbie friendliness 55/100
perses/plugins#842 · 1 comment ·
Maintainers usually reply within 1 day
Similar issues
-
db-d1-sqlite: upsert is aliased to updateOne, so payload.kv.set never inserts new keysPossibly taken @pcbeingused333 claimed this today. OpenBug db: d1-sqlite Payload OSS
Difficulty 2/5 1-3 hours Newbie friendliness 76/100
payloadcms/payload#19766 ·
Maintainers usually reply within 1 day
-
Difficulty 2/5 1-3 hours Newbie friendliness 68/100
device-management-toolkit/sample-web-ui#3711 ·
Maintainers usually reply within 1 day
-
bug impact:low Team: SecuritySolution Team:Defend Workflows v9.6.0
Difficulty 2/5 1-3 hours Newbie friendliness 72/100
elastic/kibana#306401 · 3 comments ·
Maintainers usually reply within 1 day
-
Difficulty 2/5 1-3 hours Newbie friendliness 68/100
agentes-chat/agentes-chat#927 ·
Maintainers usually reply within 1 day
-
Closing a pinned tab jumps to the Tabs section instead of the next open pinned tabPossibly taken @seenimohamed claimed this today. Openbug
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
ardia-browser/ardia#2769 ·
Maintainers usually reply within 1 day