search

Segfault-Inc / Multicorn

Data Access Library
https://multicorn.org/
PostgreSQL License
699 stars 145 forks source link

Multicorn ClickHouse Issue #193

Open levin-kelevra opened 6 years ago

levin-kelevra commented 6 years ago

Multicorn: commit 213ddb178 SqlAlchemy: 1.1.14 python: 2.7

CREATE SERVER alchemy_srv FOREIGN DATA WRAPPER multicorn options (
    wrapper 'multicorn.sqlalchemyfdw.SqlAlchemyFdw'
);
CREATE FOREIGN TABLE ch_allevents (
    VEHICLE_ID  Int8,
    DRIVER_CODE Int8,
    DRIVER_CODE_PRESENT Int,
    ADDRESS varchar  DEFAULT '',
    ADDRESS_PRESENT Int
) SERVER alchemy_srv OPTIONS (
    tablename 'allevents',
    db_url 'clickhouse://cluser:clpass@10.0.95.202/default'
);
postgres=# SELECT vehicle_id FROM ch_allevents;
ERROR:  Error in python: Exception
DETAILS:  Code: 47, e.displayText() = DB::Exception: Unknown identifier: vehicle_id, e.what() = DB::Exception