Array(t)

    You can use a function to create an array:

    1. []

    Example of creating an array:

      1. ┌─x─────┬─toTypeName([1, 2])─┐
      2. │ [1,2] │ Array(UInt8)       │

      Working with Data Types

      If ClickHouse couldn’t determine the data type, it generates an exception. For instance, this happens when trying to create an array with strings and numbers simultaneously ().

      1. ┌─x──────────┬─toTypeName(array(1, 2, NULL))─┐
      2. │ [1,2,NULL] │ Array(Nullable(UInt8))        │
      3. └────────────┴───────────────────────────────┘

      If you try to create an array of incompatible data types, ClickHouse throws an exception: