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)