clickhouse-sqlalchemy

clickhouse-sqlalchemy copied to clipboard

Can't Create a clickhouse udf function By using execute method

2

**Describe the bug** I want create a udf function like below: ``` CREATE FUNCTION linear_equation AS (x, k, b) -> k*x + b; ``` But it failed; Exception came from...

superjcd

select() clause with join creates a cross join

6

**Describe the bug** Hi, I'm in the process of upgrading our codebase to use SqlAlchemy 1.4. I have a problem with select clause(that SqlAlchemy would like us to move to...

AviSarmani

How to create AggregatingMergeTree table by materialized view from other tables?

1

Now I want to create some AggregatingMergeTree tables but it is not mentioned on the documentation and I did not find any example about it. Here is clickhouse queries about...

hoangnguyennhu

"Nullable" type not working with undefined values.

4

**Describe the bug** When having a Nullable column and not setting the related property in an entity instance, trying to add the object to the session and then committing raises...

diogobaeder

Nullable columns don't seem to work

2

**Describe the bug** Nullable columns don't work with: - String - Integer - Enum Passing `None` with any of these types (I didn't check the others) and doing `session.add(); session.commit()`...

danielgafni

Nullable DateTime64(x) support

1

**Describe the bug** ClickHouseDialect._get_column_type does not support Nullable(DateTime64(x)) **Expected behavior** Nullable nested_type should be DateTime64

Trokul

```python from clickhouse_sqlalchemy import make_session from sqlalchemy import create_engine from sqlalchemy.pool import NullPool engine = create_engine(uri, echo=False, poolclass=NullPool) session = make_session(engine) ``` i want to know, whether clickhouse-sqlalchemy package supports...

flyly0755

session hangout without any error output

1

**Describe the bug** https://github.com/xzkostyan/clickhouse-sqlalchemy/blob/master/clickhouse_sqlalchemy/drivers/http/transport.py#L102 ```python self.timeout = float(timeout) if timeout is not None else None ``` with this line code, is there any issue here when timeout is None, then...

flyly0755

**Describe the bug** A properly-encoded password containing `#` fails at client creation. SQLAlchemy decodes the password and returns the url to `clickhouse-sqlalchemy`, which in turn uses the `from_url` method of...

betelguez

Implement Int128, UInt128, Int256 and UInt256 types

1

Added support for `Int128`, `UInt128` and `Int256`, `UInt256` types. - fixes #176

akolov