Apache Tajo - Data Types
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. |
