apache / apache/pinot

Support dynamic timezone values fed from a column in DATETRUNC

Open
#8,299 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

In the current implementation DATETRUNC()'s optional timezone param is a hard coded string. We can pass only one value to it. In some use cases, each record in the table need to be supplied with its own timezone, coming from a different column (part of the fact table itself or coming from a dim table via lookup join).

It would be great if we can support this.

Contributor guide

Open the contributing guide

Research direction

No files, tests, or entry points are named. Start by locating the DATETRUNC implementation and tracing how its optional timezone parameter is handled. Done means the timezone can be supplied per record from a fact-table or joined dimension column rather than only as a hard-coded string.

Written by the indexing model from the issue text.

Assessment

Tech stack
java
Domain
databases
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.