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] [, ...]]

WHERE

GROUP BY and HAVING

ORDER BY

JOIN

(still working)