flyway icon indicating copy to clipboard operation
flyway copied to clipboard

Clickhouse support

Open f1yegor opened this issue 2 years ago • 7 comments

ClickHouse support for flyway. Updated #3134 from master.

f1yegor avatar Nov 24 '21 13:11 f1yegor

CLA assistant check
All committers have signed the CLA.

CLAassistant avatar Nov 24 '21 13:11 CLAassistant

Can it be merged? ClickHouse is on the hype, and everybody needs Flyway.

den-crane avatar Nov 24 '21 13:11 den-crane

Flyway will loose many production clickhouse's users because this MR is not merged. That's a pity. I like Flyway, but must move on to the tools which are more flexible. Is there any chase it might be merged soon?

ipolishchuk avatar Dec 14 '21 00:12 ipolishchuk

Golang-migrate https://github.com/golang-migrate/migrate supports clickhouse and offers much of the simplicity of flyway

waifairer avatar Apr 18 '22 20:04 waifairer

Are there any plans for merge it?

TheHett avatar Sep 07 '22 06:09 TheHett

It's works, but schema detection isn't working.

Clickhouse JDBC diver say about it

ClickHouse does not support catalog, please use setSchema instead

Need to replace calls of getCatalog/setCatalog by getSchema/setSchema I tested, after replacing works fine.

TheHett avatar Sep 08 '22 17:09 TheHett

Second: need to replace old driver

                <groupId>ru.yandex.clickhouse</groupId>
                <artifactId>clickhouse-jdbc</artifactId>
                <version>${version.clickhouse-jdbc}</version>
                <optional>true</optional>

by new

                <groupId>com.clickhouse</groupId>
                <artifactId>clickhouse-jdbc</artifactId>
                <version>${version.clickhouse-jdbc}</version>
                <optional>true</optional>

And change to actual version 0.3.2-patch11

TheHett avatar Sep 08 '22 17:09 TheHett

@TheHett I fixed that in new PR. It also meets current contribution rules. https://github.com/flyway/flyway/pull/3611

sazonov avatar Feb 03 '23 10:02 sazonov

Clickhouse has been added via subsequent PRs

Barry-RG avatar Jan 31 '24 10:01 Barry-RG