Data Types

Currently, HetuEngine supports the following data types when creating tables: TINYINT, SMALLINT, BIGINT, INT, BOOLEAN, REAL, DECIMAL, DOUBLE, VARCHAR, STRING, BINARY, VARBINARY, TIMESTAMP, DATE, CHAR, ARRAY, ROW, MAP, and STRUCT. Other types are supported during data query and calculation.

Generally, most non-composite data types can be entered by literals and character strings. In the example, a string in the JSON format is added.

select json '{"name": "aa", "sex": "man"}';
              _col0              
---------------------------------
 {"name":"aa","sex":"man"} 
(1 row)