hi
I get this
Only a single nesting level is supported.
Columns of nested structures containing arrays are equivalent to multidimensional arrays,
so they have limited support (there is no support for storing these columns in tables with the MergeTree engine).
in the clickhouse document
It means that I can't use multidimensional arrays in mergeTree engine?
But I have create table succeed with multidimensional arrays
describe array1
DESCRIBE TABLE array1
ββnameββ¬βtypeββββββββββββββββββ¬βdefault_typeββ¬βdefault_expressionββ¬βcommentββ¬βcodec_expressionββ
β a β String β β β β β
β b β Date β β β β β
β c β Array(Array(String)) β β β β β
ββββββββ΄βββββββββββββββββββββββ΄βββββββββββββββ΄βββββββββββββββββββββ΄ββββββββββ΄βββββββββββββββββββ
or
describe nested1
DESCRIBE TABLE nested1
ββnameββ¬βtypeββββββββββββββββββ¬βdefault_typeββ¬βdefault_expressionββ¬βcommentββ¬βcodec_expressionββ
β a β String β β β β β
β b β Date β β β β β
β c.d β Array(Array(String)) β β β β β
ββββββββ΄βββββββββββββββββββββββ΄βββββββββββββββ΄βββββββββββββββββββββ΄ββββββββββ΄βββββββββββββββββββ
Is there something wrong?
thanks
This is about
n1 Nested(
n2 Nested ( x Int64 )
)
not about multidimensional arrays
Most helpful comment
This is about
not about multidimensional arrays