Comments (3)
That actually sounds like a good driver for feature prioritisation on the SQL interface (which is by no means complete yet - lots done, lots to do ;) 👌
Also, can I check which version of Polars you tested on? The latest (0.20.31) has quite a number of updates that may help.
Looks like adding support for implicit JOIN syntax would also immediately raise the number of supported queries; I'll investigate.
from polars.
actually you are right, I changed the syntax to use joins and now we have 8 working from 22
https://colab.research.google.com/drive/10GUzHfrOSu1GHXoY7stQ22_xITNkmnVs#scrollTo=LjOA0sqjFYRc
from polars.
I am not too worry about the sql syntax, I am sure it will be added eventually, what will really nice is to have support for ctx.sql("select 42").show() so i don't have to create a separate function just for polars
from polars.
Related Issues (20)
- Add `polars.Expr.list.drop_nans()` HOT 2
- `read_parquet` don't recognize OSS url scheme
- Not clear if Parquet statistics are used when filter applied
- `bottom_k` should not include nulls if the column contains at least `k` valid elements
- Construct CsvReader from bytestream using CsvReadOptions
- segfault when reading msql using arrow-odbc HOT 1
- `implode` results in extra level of nesting when run within a `group_by(...).agg` HOT 2
- Support reading directly from zipfile.Path objects.
- Read_json panics when infer_schema_length = 0
- `explain(streaming=True)` isn't showing correct plan
- Data in csv files with less columns than schema shifts data. HOT 4
- Add the argument `ignore_nulls` in `.arr.all()`, `.arr.any()`, `.list.all()` and `.list.any()`
- read_database_uri panics for dates beyond 2262.04.11 HOT 2
- Move streaming engine original plan to separate field on the `IRPlan`
- Write upgrade guide for 1.0.0
- Polars is unable to parse dates beyond 2262.04.11 HOT 1
- Make a ParquetWriter context handler and/or more control over row group creation
- Casting to float32, int32, int16 and int8 in polars is slower than pandas in larger dfs HOT 4
- Interpolate based on other Float64 column HOT 3
- Comparing 0 with UInt64 values larger than Int64::MAX incorrectly return NULL
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 polars.