Data type examples

true

false

TINYINT '123'

SMALLINT '123'

123456790

BIGINT '1234567890'

2147483648

'123456.78'

1.234

DECIMAL '123.456'

CHAR 'hello world', CHAR 'hello ''world''!'

VARCHAR 'hello world', VARCHAR 'hello ''world''!'

X'00 01 02'

TIME '10:11:12', TIME '10:11:12.345'

TIME '10:11:12.345 -06:00'

DATE '2024-03-25'

TIMESTAMP, TIMESTAMP WITHOUT TIME ZONE, TIMESTAMP(precision), TIMESTAMP(precision) WITHOUT TIME ZONE

TIMESTAMP '2024-03-25 11:12:13', TIMESTAMP '2024-03-25 11:12:13.456'

TIMESTAMP '2024-03-25 11:12:13.456 Europe/Berlin'

INTERVAL '3' MONTH

INTERVAL '2' DAY

ARRAY['one', 'two', 'three']

MAP(ARRAY['one', 'two', 'three'], ARRAY[1, 2, 3])

Note that maps are created from an array of keys and an array of values. The following example creates a table that maps strings to integers.

CREATE TABLE map_table(col1 map<string, integer>) LOCATION '...';
INSERT INTO map_table values(MAP(ARRAY['foo', 'bar'], ARRAY[1, 2]));

ROW('one', 'two', 'three')

Note that rows created this way have no column names. To add column names, you can use CAST, as in the following example:

CAST(ROW(1, 2, 3) AS ROW(one INT, two INT, three INT))

JSON '{"one":1, "two": 2, "three": 3}'

UUID '12345678-90ab-cdef-1234-567890abcdef'

IPADDRESS '10.0.0.1'

IPADDRESS '2001:db8::1'