After modifying a column in clikchouse, does the connector need to be restarted? #475
Unanswered
zTranquilizer
asked this question in
Q&A
Replies: 1 comment 1 reply
-
In general, it's safer to stop the connector -> alter the table -> start the connector. tableRefreshInterval sets the time for refreshing the table mapping, but there is usually a gap between updates. For DateTime, what is your data format? |
Beta Was this translation helpful? Give feedback.
1 reply
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Hi all, noticed this peculiarity and can't figure out if it's something I have that's not working right or if it's the connector that's working that way.
If I have modified the column data type
do I also need to restart the connector/task ?
When I restart - everything starts working fine. But before the restart the connector doesn't realize that the data schema has changed, although I can see the log: “Update table mapping” or something like that.
Also in the connector there is a setting
tableRefreshInterval
, I thought it is responsible for pulling up the new schema in real time, and does not require restarting the connector, but maybe I'm wrong.Also another point, almost unrelated to the question. I saw that the
DateTime
data type is supported by the connector, but when I add a small change, something likeDateTime('UTC')
and it stops working. I take itDateTime('UTC')
is not supported by the connector yet?Beta Was this translation helpful? Give feedback.
All reactions