[Backport 2.19-dev] Support casting date literal to timestamp (#3831)#3939
Merged
qianheng-aws merged 1 commit intoopensearch-project:2.19-devfrom Jul 31, 2025
Conversation
3f23ef3 to
f76a964
Compare
* Support following datetime casts in v2: date str -> timestamp timestamp str -> date timestamp str -> time Signed-off-by: Yuanchun Shen <yuanchu@amazon.com> * Invoke datetime UDF to cast date/time/timestamp with Calcite Signed-off-by: Yuanchun Shen <yuanchu@amazon.com> * Test cast to date/time/timestamp Signed-off-by: Yuanchun Shen <yuanchu@amazon.com> * Use stricter date and time formatters Signed-off-by: Yuanchun Shen <yuanchu@amazon.com> * Add a timestamp formatter for instantiating ExprTimestampValue Signed-off-by: Yuanchun Shen <yuanchu@amazon.com> * Simplify date/time expr constructors & parsers Signed-off-by: Yuanchun Shen <yuanchu@amazon.com> * Change to ExpressionEvaluationException when fail parsing malformat date/time strings Signed-off-by: Yuanchun Shen <yuanchu@amazon.com> --------- Signed-off-by: Yuanchun Shen <yuanchu@amazon.com> (cherry picked from commit 30aba65)
f76a964 to
1fbff4f
Compare
LantaoJin
approved these changes
Jul 30, 2025
qianheng-aws
approved these changes
Jul 31, 2025
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
3 participants
Add this suggestion to a batch that can be applied as a single commit.This suggestion is invalid because no changes were made to the code.Suggestions cannot be applied while the pull request is closed.Suggestions cannot be applied while viewing a subset of changes.Only one suggestion per line can be applied in a batch.Add this suggestion to a batch that can be applied as a single commit.Applying suggestions on deleted lines is not supported.You must change the existing code in this line in order to create a valid suggestion.Outdated suggestions cannot be applied.This suggestion has been applied or marked resolved.Suggestions cannot be applied from pending reviews.Suggestions cannot be applied on multi-line comments.Suggestions cannot be applied while the pull request is queued to merge.Suggestion cannot be applied right now. Please check back later.
Description
Backport #3831 to 2.19-dev
Commit message
Support following datetime casts in v2: date str -> timestamp
timestamp str -> date
timestamp str -> time
Invoke datetime UDF to cast date/time/timestamp with Calcite
Test cast to date/time/timestamp
Use stricter date and time formatters
Add a timestamp formatter for instantiating ExprTimestampValue
Simplify date/time expr constructors & parsers
Change to ExpressionEvaluationException when fail parsing malformat date/time strings
(cherry picked from commit 30aba65)
Related Issues
#3728
Check List
--signoff.By submitting this pull request, I confirm that my contribution is made under the terms of the Apache 2.0 license.
For more information on following Developer Certificate of Origin and signing off your commits, please check here.