Need support for clickhouse

[AnkurAry]

Hi, in my project i am looking to support queries to be executed on clickhouse. Please help where to start considering I am just starting with logica.

[EvgSkv]

Hi Ankur,
as of today Logica doesn't run on clickhouse.
Some basic dialect-specific handling is described in https://github.com/EvgSkv/logica/blob/main/compiler/dialects.py, so that's where we'd start. But supporting an engine often requires some ah-hoc change across the codebase.

Also, I don't know how to run clickhouse querries. Is there a free quota, or a local version? In the past I couldn't find it.

I don't think I'll get to implementing support any time soon, but if you are interested into making a contribution, we can keep the thread going.

[aoa141]

Hey here is some initial work on on this
https://github.com/aoa141/tlogica

[yilinxia]

Wow, this is awesome!!!

[EvgSkv]

Hello @AnkurAry
ClickHose is now experimentally supported by Logica.

Example:
https://colab.research.google.com/drive/10mLrUb7djNkF9UwvbaFapOVw2iuOsBQ2?usp=sharing

It will take some iterations to make it stable. Let me know if you have a chance to use it and how it works for you.

Evgeny.