ibis
ibis copied to clipboard
ibis-project
the portable Python dataframe library
### What happened? The Databricks and PySpark/spark-connect backends uses a different timestamp type. The Databricks backend always returns a timezone-aware timestamp and the PySpark does not. For example, using PySpark/spark-connect...
- use `FROM_JSON` function to unwrap the json - compress the casting operation to match user's intention fixes #11036 ## Description of changes This MR enables the `pyspark` backend to...
- when you create a ibis.timestamp(), it detects the max needed resolution for that timestamp, and uses that. For example, "2025-04-17 01:02:03" before was infered as a dt.Timestamp with scale=None....
Fixes https://github.com/ibis-project/ibis/issues/11073 EDIT: This Oracle fix was merged in #11124 Also includes a fix in the Oracle dtype compiler. The new tests cover this. If we change our tests, we...
### Is your feature request related to a problem? Consider this question: "Find the penguin with the longest bill per species". The following code works with the `duckdb` and `sqlite`...
### Is your feature request related to a problem? Using the "spatial" extension work around to read excel files I was able to ```python con.read_geo("test.xlsx", table_name="newtable", layer='sheetname', open_options = ['HEADERS=AUTO','FIELD_TYPES=STRING'])...
### Is your feature request related to a problem? I have these two tables, which I want to join regardless of capitalization. I want to be able to do this:...
### Is your feature request related to a problem? I am writing my own `alter_table` function to adjust the types of a physical table. I want to be able to...
### Is your feature request related to a problem? Combining two tables with different columns is possible with a UNION BY NAME, which is available in - Duckdb: https://duckdb.org/docs/stable/sql/query_syntax/setops.html#union-all-by-name -...
