Comments (2)
Oh there's no other parameters involved in case that wasn't clear. Only submitting the query and connection to the read_database
method
from polars.
Could you provide some additional information?
Specifically, the following might be helpful:
- What exactly is the connection - Denodo's own driver, or something else?
- What is the schema of the table you're querying?
- Which column does the failing value "Valutakurs: 11,4760" come from?
- Have you tried providing an ODBC connection string instead?
This would then use the fast "arrow-odbc" engine (which you can pip install).# connecting to an ODBC source (using arrow-odbc) df = pl.read_database( query = "SELECT * FROM tbl", connection = "Driver={PostgreSQL};Server=localhost;Port=5432;Database=test;Uid=usr;Pwd=", )
- Note that you can likely provide a
schema_overrides={"column": dtype}
entry for the problematic column.
I'll expose the parameter referenced in the error shortly, but ideally you should be able to avoid it 🤔
from polars.
Related Issues (20)
- Ensure column names are unique for horizontal concat in the IR
- Expression input not working correctly for either argument of `Expr.str.replace_many` HOT 10
- PanicException on reading Parquet file from S3 HOT 4
- add an `ignore_nulls` option to `json_encode` for the `pl.Struct` column
- Change all columns one time HOT 5
- map_elements replaces all array elements with nulls HOT 2
- Let arr.reshape use Expr as inputs instead of just python tuple
- Import and Export Schema Objects to JSON
- error[E0599]: no variant or associated item named `Struct` found for enum `polars_core::datatypes::DataType` in the current scope HOT 2
- `with_columns(dict)` fail silently if key exists as column HOT 5
- Polars write database - Rest API call failing with AWS Lambda trigger HOT 1
- Change `read_csv` and `read_ipc` to use object store instead of fsspec
- `.over()` fails with `.top_k_by` HOT 3
- `join_nulls` in "asof" join HOT 3
- exception on numpy slicing literal column with object column
- Scanning cloud paths with percentages '%' fails
- Make pl.Enum(...) return type rather than instance HOT 2
- Elementwise check on `join` expressions is too restrictive HOT 3
- Built-in datasets and a function to load them HOT 1
- Python test workflows may fail due to failure to download `torch` dependency 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 polars.