clickhouse-sqlalchemy
clickhouse-sqlalchemy copied to clipboard
xzkostyan
ClickHouse dialect for SQLAlchemy
I have a sql query: `SELECT * FROM TABLE1` The table is stored in a Clickhouse database. I am running the following code: ``` from sqlalchemy import text from sqlalchemy.ext.asyncio...
Hello ! I would like to propose some change to the github actions to use the `services` capabilities to start the clickhouse server instead of hacking the setup.cfg and the...
**To Reproduce** In database: ``` CREATE TABLE test_01 ( `first_col` String) ENGINE = Log; CREATE TABLE test_02 ( `first_col` String) ENGINE = Log; ``` Code: ``` from clickhouse_sqlalchemy import Table...
**Describe the bug** Versions of alembic lower than 1.11.0 will fail with syntax error when trying to produce a migration script.  ``` migration = produce_migrations(mig_ctx, metadata)...
Hello, The code seems to use python 2 conventions. I propose that we update these syntaxes to the new one introduced with python 3.7, as it is currently the minimal...
```sql CREATE MATERIALIZED VIEW db1.mv_with_target_table TO db1.mv_target_table ( `col_DateTime` DateTime, `col_Int64` Int64, `col_Float64` Float64, `col_Decimal64` Decimal(18, 5), `col_String` String ) AS SELECT col_DateTime, col_Int64, col_Float64, col_Decimal64, col_String FROM db1.test_data_types; ```...
**Describe the bug** ```python from sqlalchemy import Column, create_engine from clickhouse_sqlalchemy import engines, types from clickhouse_sqlalchemy.ext.declarative import declarative_base from sqlalchemy.orm import sessionmaker from sqlalchemy import insert as sainsert ChBase =...
**Describe the bug** For a table DDL like this: ``` CREATE TABLE IF NOT EXISTS bugtable on cluster 'local' ( id Int, metadata Map(String, Map(String, Nullable(String))) ) ENGINE = MergeTree()...
**Describe the bug** So, I have created a model for my table in Clickhouse: ```python from __future__ import annotations from sqlalchemy.schema import Column from clickhouse_sqlalchemy import types, engines from collector.common.database.models...
First of all, thanks for all the work done here! To the point, currently there's no way to deal w/ AggregateFunction types, so we need a way to issue, say,...
