Data types

GlareDB uses many DataFusion components under the hood, including much of its type system. Internally, all values are represented using Arrow. This section provides a mapping between SQL types and Arrow types.

The arrow_typeof function can be used to determine the arrow type used for a given SQL expression.

glaredb=> select arrow_typeof(1);
 arrowtypeof(Int64(1))
-----------------------
 Int64
(1 row)

glaredb=> select arrow_typeof('11-12-23'::date);
 arrowtypeof(Utf8("11-12-23"))
-------------------------------
 Date32
(1 row)