ibis
ibis copied to clipboard
ibis-project
the portable Python dataframe library
### Problem Description When using a fixed integer seed with RAND() on the Impala backend, the results are not reproducible when the RAND(seed) call is used within the ORDER BY...
### Is your feature request related to a problem? _No response_ ### What is the motivation behind your request? I have a task that involves converting data from a client's...
### Problem I need deterministic random sampling within partitions using a seed value. I want to generate SQL like ORDER BY RAND(42) but cannot find a way to pass a...
### What happened? In ibis/expr/types/temporal.py, IntervalValue.as_unit() is annotated to return IntervalValue, yet every “unit” convenience property (years, quarters, months, weeks, days, hours, ...) is annotated to return ir.IntegerValue. each property...
Closes #11137. Closes #11062.
### Is your feature request related to a problem? The existing support for "temp" tables with the Big Query backend is to upload session scoped tables from in-memory tables to...
### What happened? ```python In [1]: import polars as pl In [2]: import ibis In [3]: ibis.set_backend('polars') In [4]: df = pl.DataFrame({'a': [1,1,2], 'b': ['red', 'red', 'green']}, schema_overrides={'b': pl.Enum(['red', 'green',...
Sometimes, I just need to load some temp data into a backend, but I don't care what the table name is. now `conn.create_table(obj=data, temp=True)` is a nice short way to...
### Is your feature request related to a problem? In SQL, you can create aggregates over scalars. However, in ibis, the ir.Scalar Values don't have any of the aggregation functions:...
### What happened? After upgrading existing Ibis code that uses `Table.union` to 10.4.0, I started receiving error messages about string lengths not matching, e.g.: ``` Traceback (most recent call last):...
