Replies: 1 comment
-
|
Created #650 |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
Suggestion: implement support of ALIAS columns in Clickhouse
Background: There are ALIAS columns that could be created in Clickhouse tables, those columns are calculated columns (values) that are not stored physically, but calculated on the fly. Those columns could not be used in INSERT SQL statements
ref: https://clickhouse.com/docs/sql-reference/statements/create/table#alias
Problem: Currently in case sling replication config contains
table_dlldefinition intarget_options:with such DDL sling starts replication process, but on the final step (moving _tmp table into real one) it fails.
It fails because sling parse table_ddl and think that e.g.
is_deletedcolumn (in example above) is a real column, and it tries to insert data into it:Suggestion: enable sling to detect ALIAS columns and skip/remove them from INSERT statements
Beta Was this translation helpful? Give feedback.
All reactions