It was wrong to create the ClickHouse engine about clickhouse-sqlalchemy

[danielgafni]

Seems like this is still a problem. A default table engine is still not specified.

[antonio-antuan]

I think it is not right because ENGINE clause is mandatory for CREATE TABLE statement in ClickHouse.
Your request is the same as if you request the same feature for ClickHouse DBMS.

[xzkostyan]

Hi.

This error means that engine for table creation is missed somewhere in pandas dataframe internals.

There is an example of table creation in readme: https://github.com/xzkostyan/clickhouse-sqlalchemy#basic-ddl-support. You should define table at first and afterwards create it.

In your case engine detection can be missed during table reflection from database. Can you test it in pure clickhouse-sqlalchemy?

[wuhuanyan]

HI.
Can you set default engine in "clickhouse_sqlalchemy\drivers\base.py in post_create_table(self, table)"?

[wuhuanyan]

For example：

if not engine:
    # raise exc.CompileError("No engine for table '%s'" % table.name)
    return ' ENGINE = Log '  # + self.process(engine)
return ' ENGINE = ' + self.process(engine)

I'm a novice to Python，I don't know what self.process (engine) has done.
But after that, it looks as if it can run normally.