We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Is your feature request related to a problem or challenge? Please describe what you are trying to do.
WindowFrameBound enum takes Option<u64> for Preceding and Following fields. When we run the below query in datafusion (valid in POSTGRESQL).
WindowFrameBound
Option<u64>
Preceding
Following
SELECT COUNT(*) OVER(ORDER BY ts RANGE BETWEEN '1 DAY' PRECEDING AND '1 DAY' FOLLOWING) as cnt FROM t
it produces error below.
Error: SQL(ParserError("Expected literal int, found: '1 DAY'"))
Describe the solution you'd like
Instead of Option<u64>, we can use Option<ScalarValue> to support different types such as timestamps.
Option<ScalarValue>
Describe alternatives you've considered
N.A
Additional context
The relevant code section can be found at the following link.
arrow-datafusion/window_frame.rs at c3bf84e334d6a12c89bacec38e2baa02ca2417ac · apache/arrow-datafusion
The text was updated successfully, but these errors were encountered:
Successfully merging a pull request may close this issue.
Hardcoded u64 for WindowFrameBound fields
Is your feature request related to a problem or challenge? Please describe what you are trying to do.
WindowFrameBound
enum takesOption<u64>
forPreceding
andFollowing
fields. When we run the below query in datafusion (valid in POSTGRESQL).it produces error below.
Describe the solution you'd like
Instead of
Option<u64>
, we can useOption<ScalarValue>
to support different types such as timestamps.Describe alternatives you've considered
N.A
Additional context
The relevant code section can be found at the following link.
arrow-datafusion/window_frame.rs at c3bf84e334d6a12c89bacec38e2baa02ca2417ac · apache/arrow-datafusion
The text was updated successfully, but these errors were encountered: