Apache Tajo Data Types - Apache Tajo

What are the Primitive Data Types supported by Apache Tajo?

A query is executed in a Tajo shell by typing the following command in Tajo installed directory:

The response appears as:

Now the queries can be executed. The queries can also run through the web console application in the URL - http://localhost:26080/

Primitive Data Types

The primitive Data Types supported by Apache Tajo are listed below:

S.No.

Data type & Description

1

integer

Used for storing integer value with 4 bytes storage.

2

tinyint

Tiny integer value is 1 byte

3

smallint

Used for storing small size integer 2 bytes value.

4

bigint

Big range integer value has 8 bytes storage.

5

boolean

Returns true/false.

6

real

Used for storing real value. Size is 4 bytes.

7

float

Floating point precision value which has 4 or 8 bytes storage space.

8

double

Double point precision value stored in 8 bytes.

9

char[(n)]

Character value.

10

varchar[(n)]

Variable-length non-Unicode data.

11

number

Decimal values.

12

binary

Binary values.

13

date

Calendar date (year, month, day).

Example− DATE '2016-08-22'

14

time

Time of day (hour, minute, second, millisecond) without a time zone. Values of this type are parsed and rendered in the session time zone.

15

timezone

Time of day (hour, minute, second, millisecond) with a time zone. Values of this type are rendered using the time zone from the value.

Example− TIME '01:02:03.456 Asia/kolkata'

16

timestamp

Instant in time that includes the date and time of day without a time zone.

Example− TIMESTAMP '2016-08-22 03:04:05.321'

17

text

Variable-length Unicode text.

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

Apache Tajo Topics