[YDB DWH] add alter and upsert templates for column tables

artemmufazalov commented 5 months ago

Currently for column tables we have template similar to row tables, although they don't fit:

Alter template ends up with error: update parse error: Type 'Bool' specified for column 'is_deleted' is not supported. in alter constructor STANDALONE_UPDATE:

ALTER TABLE `/dev02/home/va-kuznecov/db1/column_table`
    ADD COLUMN is_deleted Bool;

Upset template ends up with error: Write mode 'upsert' is not supported for olap tables.:

UPSERT INTO `/dev02/home/va-kuznecov/db1/column_table`
    ( `id`, `name` )
VALUES (1, 'Ivan' );

artemmufazalov commented 2 months ago

UPSERT template works in versions from this commit: https://github.com/ydb-platform/ydb/commit/805fb4bf998390fe496ba6979d885d16d24bec83, so we can leave current template

In ALTER template Bool should be replaced with Int32. UPSERT template could be further improved with real columns names: https://github.com/ydb-platform/ydb-embedded-ui/issues/1274

artemmufazalov commented 2 months ago

ydb-platform / ydb-embedded-ui