Apache Tajo - Data Types


Advertisements


To execute a query in a Tajo shell, open your terminal and move to the Tajo installed directory and then type the following command −

$ bin/tsql 

You will now see the response as shown in the following program −

default> 

You can now execute your queries. Otherwise you can run your queries through web console application to the following URL − http://localhost:26080/

Primitive Data Types

Apache Tajo supports the following list of primitive data types −

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.



Advertisements