datafusion
datafusion copied to clipboard
Apache DataFusion SQL Query Engine
Draft while we fix the other examples ## Which issue does this PR close? Part of https://github.com/apache/datafusion/issues/10855 ## Rationale for this change `rewrite_expr.rs` has three distinct examples within it it....
### Describe the bug In various engines, the order in which intervals are added to dates can affect the final value. This is especially noticeable with leap years. Datafusion appears...
### Describe the bug DF returns NaN in modulo query below and is not compliant with major engines: ``` > select 1 % -0.0; +------------------------+ | Int64(1) % Float64(-0) |...
### Is your feature request related to a problem or challenge? Retrieve the value of the given union variant, or `NULL` if it's not currently selected ### Describe the solution...
### Is your feature request related to a problem or challenge? Retrieve the name of the currently selected field on a union ### Describe the solution you'd like Return a...
### Is your feature request related to a problem or challenge? Description | Returns the first non-null value in the list. -- | -- Example | list_any_value([NULL, -3]) Result |...
## Which issue does this PR close? Part of #8708 Closes #10999. ## Rationale for this change ## What changes are included in this PR? ## Are these changes tested?...
## Which issue does this PR close? If successful, Closes #10967 ## Rationale for this change Currently the PropagateEmptyRelation relation doesn't optimize all join types This draft proposes to resolve...
### Is your feature request related to a problem or challenge? These sql are not supported ``` ##recursive unnest(list->list) query ? select * from unnest(unnest( [[1,2,3],[4,5,6]] )); ---- 1 2...