Comments (1)
This PR adds a test: #11017
# Could push the filter (column1 = 2) down below unnest
# https://github.com/apache/datafusion/issues/11016
query TT
explain select uc2, column1 from (select unnest(column2) as uc2, column1 from v) where uc2 > 3 AND column1 = 2;
----
logical_plan
01)Projection: unnest(v.column2) AS uc2, v.column1
02)--Filter: unnest(v.column2) > Int64(3) AND v.column1 = Int64(2)
03)----Unnest: lists[unnest(v.column2)] structs[]
04)------Projection: v.column2 AS unnest(v.column2), v.column1
05)--------TableScan: v projection=[column1, column2]
The plan could look something like this
logical_plan
01)Projection: unnest(v.column2) AS uc2, v.column1
02)--Filter: unnest(v.column2) > Int64(3)
03)----Unnest: lists[unnest(v.column2)] structs[]
04)------Projection: v.column2 AS unnest(v.column2), v.column1
05)--------Filter: v.column1 = Int64(2) <-- Note this filter is pushed down
06)----------TableScan: v projection=[column1, column2]
from arrow-datafusion.
Related Issues (20)
- Update `REGEXP_LIKE` scalar function to support Utf8View HOT 1
- Update `REGEXP_MATCH` scalar function to support Utf8View HOT 1
- Update `regexp_replace` scalar function to support Utf8View HOT 1
- Update `REPLACE` scalar function to support Utf8View HOT 1
- Update `REPEAT` scalar function to support Utf8View HOT 1
- Update `REVERSE` scalar function to support Utf8View HOT 1
- Update `RTRIM` scalar function to support Utf8View HOT 2
- Update `RIGHT` scalar function to support Utf8View HOT 1
- Update `RPAD` scalar function to support Utf8View HOT 3
- Internal error `generate_series`: Internal error: could not cast value to .....arrow_array::types::Date32Type`
- Support creating arrays with non-nullable elements in `make_array` HOT 7
- Manage group values and states by blocks in aggregation HOT 7
- Support `element_at` for `Map` type HOT 1
- Change default value of `datafusion.catalog.has_header` to `true` HOT 2
- Add additional regexp functions
- Update `SPLIT_PART` scalar function to support Utf8View HOT 1
- Update `STRPOS` scalar function to support Utf8View HOT 1
- Update `SUBSTR` scalar function to support Utf8View HOT 1
- Update `TRANSLATE` scalar function to support Utf8View HOT 1
- Update `FIND_IN_SET` scalar function to support Utf8View HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from arrow-datafusion.