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 | integerUsed for storing integer value with 4 bytes storage. |
| 2 | tinyintTiny integer value is 1 byte |
| 3 | smallintUsed for storing small size integer 2 bytes value. |
| 4 | bigintBig range integer value has 8 bytes storage. |
| 5 | booleanReturns true/false. |
| 6 | realUsed for storing real value. Size is 4 bytes. |
| 7 | floatFloating point precision value which has 4 or 8 bytes storage space. |
| 8 | doubleDouble point precision value stored in 8 bytes. |
| 9 | char[(n)]Character value. |
| 10 | varchar[(n)]Variable-length non-Unicode data. |
| 11 | numberDecimal values. |
| 12 | binaryBinary values. |
| 13 | dateCalendar date (year, month, day).Example − DATE ‘2016-08-22’ |
| 14 | timeTime of day (hour, minute, second, millisecond) without a time zone. Values of this type are parsed and rendered in the session time zone. |
| 15 | timezoneTime 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 | timestampInstant in time that includes the date and time of day without a time zone.Example − TIMESTAMP ‘2016-08-22 03:04:05.321’ |
| 17 | textVariable-length Unicode text. |