Support dynamic timezone values fed from a column in DATETRUNC
Open
- 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
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