paleolimbot opened a new pull request, #935:
URL: https://github.com/apache/sedona-db/pull/935
This PR ensures all dataframes when created have a default alias that is
probably unique and mostly meaningful (e.g., the filename being read). This
ensures that joins don't require manual aliasing in most cases.
Motivating use case:
```python
import sedona.db
sd = sedona.db.connect()
pts = sd.read_parquet(
"https://github.com/geoarrow/geoarrow-data/releases/download/v0.2.0/ns-water_water-point.parquet";
)
ply = sd.read_parquet(
"https://github.com/geoarrow/geoarrow-data/releases/download/v0.2.0/ns-water_water-poly.parquet";
)
pts.join(ply, on=sd.funcs.st_intersects(pts.geometry, ply.geometry)).select(
pt_hid=pts.HID, pl_hid=ply.HID, geometry=pts.geometry
).show(5)
#
┌────────────────────────────────┬────────────────────────────────┬────────────────────────────────┐
# │ pt_hid ┆ pl_hid ┆
geometry │
# │ utf8 ┆ utf8 ┆
geometry │
#
╞════════════════════════════════╪════════════════════════════════╪════════════════════════════════╡
# │ FC9A29123BEF4A6588A2FD777B81A… ┆ 63E9CC5AE7144EEABEBEC2C95C91F… ┆ POINT
Z(258498.62729999982 48… │
#
├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
# │ 28E47E22D71549ED91472AD59A9D8… ┆ 63E9CC5AE7144EEABEBEC2C95C91F… ┆ POINT
Z(258498.32830000017 48… │
#
├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
# │ B10B26FA32FB4438925D86CD612BA… ┆ 63E9CC5AE7144EEABEBEC2C95C91F… ┆ POINT
Z(258502.0273000002 481… │
#
├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
# │ 6ACD71128B6B492C8177B11A5C2D2… ┆ 63E9CC5AE7144EEABEBEC2C95C91F… ┆ POINT
Z(258498.92729999963 48… │
#
├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
# │ 0A4BE2AB03D8459B8279FCC4BDE55… ┆ 63E9CC5AE7144EEABEBEC2C95C91F… ┆ POINT
Z(258526.62729999982 48… │
#
└────────────────────────────────┴────────────────────────────────┴────────────────────────────────┘
```
A downside here is that the explain plans get more verbose because they
always print out the qualifier.
Closes #926.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
