PartiQL 2019 Specification does not define a first-class map type.
Why not using struct (or tuple) Type?
It is a fair question and we need to examine it through the work required for this issue. Having said that, PartiQL struct can be used in a way as map or multimap with the limitation of their key to be string. Is that sufficient for a map type in PartiQL? considering the prior art in industry—e.g., Apache Iceberg or Hive DDL—perhaps not.
DoD
We have a clear understanding of why we cannot use struct (or tuple type) and need a first class type for map.
If we actually require map type:
We have an experimental implementation of map type.
We have an RFC that describes the syntax and semantics of map type.
PartiQL 2019 Specification does not define a first-class
maptype.Why not using
struct(ortuple) Type?It is a fair question and we need to examine it through the work required for this issue. Having said that, PartiQL
structcan be used in a way asmapormultimapwith the limitation of their key to bestring. Is that sufficient for amaptype in PartiQL? considering the prior art in industry—e.g., Apache Iceberg or Hive DDL—perhaps not.DoD
struct(ortupletype) and need a first class type formap.maptype:maptype.maptype.