Nothing¶
This data type isn't supported at ingest. It is only supported at query time and to create Copy Data Sources or Materialized View Data Sources.
The only purpose of this data type is to represent cases where a value isn't expected. So you can’t create a Nothing type value.
For example, literal NULL has type of Nullable(Nothing).
You can also use the Nothing type to denote empty arrays:
SELECT toTypeName(array())
┌─toTypeName(array())─┐
│ Array(Nothing) │
└─────────────────────┘