Clickhouse: question about nested structure in mergeTree engine

Created on 11 Apr 2019  Β·  1Comment  Β·  Source: ClickHouse/ClickHouse

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

question

Most helpful comment

This is about

       n1 Nested(
             n2 Nested ( x Int64 )
       )

not about multidimensional arrays

>All comments

This is about

       n1 Nested(
             n2 Nested ( x Int64 )
       )

not about multidimensional arrays

Was this page helpful?
0 / 5 - 0 ratings