I have a table with nested column
我有一个包含嵌套列的表
...
a UInt64
b Nested (b1 String, b2 String)
c LowCardinality(String),
...
I want to update the table to be
我想要将表格更新为
...
a UInt64
b Nested (b1 String, b2 String, **b3 String**)
c LowCardinality(String),
...
I tried:
我试过:
ALTER TABLE table_name ADD COLUMN IF NOT EXISTS b3 String AFTER b2
ALTER TABLE TABLE_NAME如果b2后不存在b3字符串,则添加列
but I need the new column to be a part of Nested b
但是我需要新列成为嵌套的b的一部分。
更多回答
优秀答案推荐
found an answer
找到了答案
ALTER TABLE table_name ADD COLUMN IF NOT EXISTS b3 Array(LowCardinality(String)) AFTER b2
(In my case it urls.success. *urls is the nested)
(在我的例子中,它是成功的。*URL是嵌套的)
更多回答
我是一名优秀的程序员,十分优秀!