Tajo - A Big Data Warehouse System on Hadoop

Primitive types

byte - 1 byte value
bool - boolean value (1 byte)
short - 2 byte integer
int - 4 byte integer
long - 8 byte integer
float - single precision (4 byte)
double - double precision (8 byte)
bytes
string - sequence of characters in UTF-8

DDL

CREATE TABLE

Synopsis

CREATE TABLE <table_name> [(<column_name> <data_type>, ... )]
  [using <storage_type> [with (<key> = <value>, ...)]] [AS <select_statement>]

CREATE EXTERNAL TABLE

CREATE EXTERNAL TABLE <table_name> (<column_name> <data_type>, ... )
  using <storage_type> [with (<key> = <value>, ...)] LOCATION '<path>'

DML

SELECT

SELECT [distinct [all]] * | <expression> [[AS] <alias>] [, ...]
  [FROM <table name> [[AS] <table alias name>] [, ...]]
  [WHERE <condition>]
  [GROUP BY <expression> [, ...]]
  [HAVING <condition>]
  [ORDER BY <expression> [ASC|DESC] [NULL FIRST|NULL LAST] [, ...]]

Primitive types

DDL

CREATE TABLE

CREATE EXTERNAL TABLE

DML

SELECT

WHERE

GROUP BY and HAVING

ORDER BY

JOIN