PG to Clickhouse: map date to date32

PeerDB-io / peerdb

Fast, Simple and a cost effective tool to replicate data from Postgres to Data Warehouses, Queues and Storage

https://peerdb.io

Other

2.17k stars 88 forks source link

PG to Clickhouse: map date to date32 #2108

Closed Amogh-Bharadwaj closed 4 days ago

Amogh-Bharadwaj commented 5 days ago

Date in Clickhouse has a limited range of [1970-01-01, 2149-06-06]. Whereas Date32 has the same range of DateTime64(6), allowing dates < 1970 to be synced This PR now maps dates in postgres to date32 instead of date on CH