You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@tajo.apache.org by Apache Wiki <wi...@apache.org> on 2013/04/05 04:57:48 UTC

[Tajo Wiki] Update of "QueryLanguage" by HyunsikChoi

Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Tajo Wiki" for change notification.

The "QueryLanguage" page has been changed by HyunsikChoi:
http://wiki.apache.org/tajo/QueryLanguage

Comment:
Moved from the site

New page:
== 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] [, ...]]
}}}

(still working)