Author: jihoonson
Date: Tue Sep 1 06:42:40 2015
New Revision: 1700399
URL: http://svn.apache.org/r1700399
Log:
update doc
Modified:
tajo/site/docs/devel/_sources/functions.txt
tajo/site/docs/devel/_sources/functions/datetime_func_and_operators.txt
tajo/site/docs/devel/_sources/functions/json_func.txt
tajo/site/docs/devel/_sources/functions/math_func_and_operators.txt
tajo/site/docs/devel/_sources/functions/network_func_and_operators.txt
tajo/site/docs/devel/_sources/functions/string_func_and_operators.txt
tajo/site/docs/devel/_sources/getting_started.txt
tajo/site/docs/devel/_sources/index/how_to_use.txt
tajo/site/docs/devel/_sources/sql_language/alter_table.txt
tajo/site/docs/devel/_sources/sql_language/joins.txt
tajo/site/docs/devel/_sources/sql_language/sql_expression.txt
tajo/site/docs/devel/_static/basic.css
tajo/site/docs/devel/_static/doctools.js
tajo/site/docs/devel/_static/down-pressed.png
tajo/site/docs/devel/_static/down.png
tajo/site/docs/devel/_static/file.png
tajo/site/docs/devel/_static/jquery.js
tajo/site/docs/devel/_static/minus.png
tajo/site/docs/devel/_static/plus.png
tajo/site/docs/devel/_static/searchtools.js
tajo/site/docs/devel/_static/up-pressed.png
tajo/site/docs/devel/_static/up.png
tajo/site/docs/devel/_static/websupport.js
tajo/site/docs/devel/backup_and_restore.html
tajo/site/docs/devel/backup_and_restore/catalog.html
tajo/site/docs/devel/configuration.html
tajo/site/docs/devel/configuration/catalog-site-xml.html
tajo/site/docs/devel/configuration/catalog_configuration.html
tajo/site/docs/devel/configuration/cluster_setup.html
tajo/site/docs/devel/configuration/ha_configuration.html
tajo/site/docs/devel/configuration/preliminary.html
tajo/site/docs/devel/configuration/service_config_defaults.html
tajo/site/docs/devel/configuration/tajo-site-xml.html
tajo/site/docs/devel/configuration/tajo_master_configuration.html
tajo/site/docs/devel/configuration/worker_configuration.html
tajo/site/docs/devel/faq.html
tajo/site/docs/devel/functions.html
tajo/site/docs/devel/functions/datetime_func_and_operators.html
tajo/site/docs/devel/functions/json_func.html
tajo/site/docs/devel/functions/math_func_and_operators.html
tajo/site/docs/devel/functions/network_func_and_operators.html
tajo/site/docs/devel/functions/python.html
tajo/site/docs/devel/functions/string_func_and_operators.html
tajo/site/docs/devel/genindex.html
tajo/site/docs/devel/getting_started.html
tajo/site/docs/devel/hbase_integration.html
tajo/site/docs/devel/hive_integration.html
tajo/site/docs/devel/index.html
tajo/site/docs/devel/index/future_work.html
tajo/site/docs/devel/index/how_to_use.html
tajo/site/docs/devel/index/types.html
tajo/site/docs/devel/index_overview.html
tajo/site/docs/devel/introduction.html
tajo/site/docs/devel/jdbc_driver.html
tajo/site/docs/devel/objects.inv
tajo/site/docs/devel/partitioning/column_partitioning.html
tajo/site/docs/devel/partitioning/hash_partitioning.html
tajo/site/docs/devel/partitioning/intro_to_partitioning.html
tajo/site/docs/devel/partitioning/range_partitioning.html
tajo/site/docs/devel/search.html
tajo/site/docs/devel/searchindex.js
tajo/site/docs/devel/sql_language.html
tajo/site/docs/devel/sql_language/alter_table.html
tajo/site/docs/devel/sql_language/data_model.html
tajo/site/docs/devel/sql_language/ddl.html
tajo/site/docs/devel/sql_language/insert.html
tajo/site/docs/devel/sql_language/joins.html
tajo/site/docs/devel/sql_language/predicates.html
tajo/site/docs/devel/sql_language/queries.html
tajo/site/docs/devel/sql_language/sql_expression.html
tajo/site/docs/devel/storage_plugin.html
tajo/site/docs/devel/swift_integration.html
tajo/site/docs/devel/table_management.html
tajo/site/docs/devel/table_management/compression.html
tajo/site/docs/devel/table_management/file_formats.html
tajo/site/docs/devel/table_management/parquet.html
tajo/site/docs/devel/table_management/rcfile.html
tajo/site/docs/devel/table_management/sequencefile.html
tajo/site/docs/devel/table_management/table_overview.html
tajo/site/docs/devel/table_management/tablespaces.html
tajo/site/docs/devel/table_management/text.html
tajo/site/docs/devel/table_partitioning.html
tajo/site/docs/devel/tajo_client_api.html
tajo/site/docs/devel/time_zone.html
tajo/site/docs/devel/tsql.html
tajo/site/docs/devel/tsql/admin_command.html
tajo/site/docs/devel/tsql/background_command.html
tajo/site/docs/devel/tsql/dfs_command.html
tajo/site/docs/devel/tsql/execute_file.html
tajo/site/docs/devel/tsql/intro.html
tajo/site/docs/devel/tsql/meta_command.html
tajo/site/docs/devel/tsql/single_command.html
tajo/site/docs/devel/tsql/variables.html
Modified: tajo/site/docs/devel/_sources/functions.txt
URL:
http://svn.apache.org/viewvc/tajo/site/docs/devel/_sources/functions.txt?rev=1700399&r1=1700398&r2=1700399&view=diff
==============================================================================
--- tajo/site/docs/devel/_sources/functions.txt (original)
+++ tajo/site/docs/devel/_sources/functions.txt Tue Sep 1 06:42:40 2015
@@ -4,19 +4,38 @@ Functions
Tajo provides extensive supports for functions. It includes a lot of built-in
functions and user-defined functions which is implemented in Python.
-===================
-Built-in Functions
-===================
+==========================
+Built-in Scalar Functions
+==========================
.. toctree::
:maxdepth: 1
+ functions/data_type_func_and_operators
functions/math_func_and_operators
functions/string_func_and_operators
functions/datetime_func_and_operators
functions/network_func_and_operators
functions/json_func
+================================
+Built-in Aggregation Functions
+================================
+
+.. toctree::
+ :maxdepth: 1
+
+ functions/agg_func
+
+================================
+Built-in Window Functions
+================================
+
+.. toctree::
+ :maxdepth: 1
+
+ functions/window_func
+
==============================
User-defined Functions
==============================
Modified:
tajo/site/docs/devel/_sources/functions/datetime_func_and_operators.txt
URL:
http://svn.apache.org/viewvc/tajo/site/docs/devel/_sources/functions/datetime_func_and_operators.txt?rev=1700399&r1=1700398&r2=1700399&view=diff
==============================================================================
--- tajo/site/docs/devel/_sources/functions/datetime_func_and_operators.txt
(original)
+++ tajo/site/docs/devel/_sources/functions/datetime_func_and_operators.txt Tue
Sep 1 06:42:40 2015
@@ -37,7 +37,7 @@ DateTime Functions and Operators
.. function:: current_date ()
- Returns current date
+ Returns current date.
:rtype: date
@@ -48,7 +48,7 @@ DateTime Functions and Operators
.. function:: current_time ()
- Returns current time
+ Returns current time.
:rtype: time
@@ -57,10 +57,14 @@ DateTime Functions and Operators
select current_time();
> 05:18:27.651999
-.. function:: extract(field FROM source)
+.. function:: extract(field FROM source date|timestamp|time)
The extract function retrieves subfields such as year or hour from date/time
values. *source* must be a value expression of type *timestamp*, or *time*.
(Expressions of type *date* are cast to *timestamp* and can therefore be used
as well.) *field* is an identifier that selects what field to extract from the
source value. The extract function returns values of type double precision. The
following are valid field names:
+ :param field: extract field
+ :param source: source value
+ :rtype: float8
+
**century**
The century
@@ -230,10 +234,14 @@ DateTime Functions and Operators
The date_part function is also supported. It is equivalent to the
SQL-standard function extract:
-.. function:: date_part('field', source)
+.. function:: date_part(field text, source date|timestamp|time)
Note that here the field parameter needs to be a string value, not a name.
The valid field names for date_part are the same as for extract.
+ :param field: extract field
+ :param source: source value
+ :rtype: float8
+
.. code-block:: sql
select date_part('day', timestamp '2001-02-16 20:38:40');
@@ -302,7 +310,7 @@ DateTime Functions and Operators
select to_timestamp('97/2/16 8:14:30', 'FMYYYY/FMMM/FMDD FMHH:FMMI:FMSS');
> 0097-02-15 23:14:30
-.. function:: utc_usec_to (string text , long timestamp , int dayOfWeek)
+.. function:: utc_usec_to (string text , timestamp long , dayOfWeek int)
* If the **first parameter** is 'day'.
Modified: tajo/site/docs/devel/_sources/functions/json_func.txt
URL:
http://svn.apache.org/viewvc/tajo/site/docs/devel/_sources/functions/json_func.txt?rev=1700399&r1=1700398&r2=1700399&view=diff
==============================================================================
--- tajo/site/docs/devel/_sources/functions/json_func.txt (original)
+++ tajo/site/docs/devel/_sources/functions/json_func.txt Tue Sep 1 06:42:40
2015
@@ -2,16 +2,61 @@
JSON Functions
*******************************
-.. function:: json_extract_path_text (string json, string xpath)
+.. function:: json_extract_path_text (json text, json_path text)
- Extracts JSON string from a JSON string based on json path specified and
returns JSON string pointed to by xPath
+ Extracts JSON string from a JSON string based on json path specified and
returns JSON string pointed to by JSONPath.
+ Returns null if either argument is null.
- :param string:
- :param string:
+ :param json: JSON string
+ :param json_path: JSONpath
:rtype: text
:example:
.. code-block:: sql
- json_extract_path_text('{"test" : {"key" : "tajo"}}','$.test.key');
+ select json_extract_path_text('{"test" : {"key" : "tajo"}}','$.test.key');
> tajo
+
+.. function:: json_array_get (json_array text, index int4)
+
+ Returns the element at the specified index into the JSON array. This
function returns an element indexed from the end of an array with a negative
index, and null if the element at the specified index doesnât exist.
+
+ :param json_array: String of a JSON array
+ :param index: index
+ :rtype: text
+ :example:
+
+ .. code-block:: sql
+
+ select json_array_get('[100, 200, 300]', 0);
+ > 100
+
+ select json_array_get('[100, 200, 300]', -2);
+ > 200
+
+.. function:: json_array_contains (json_array text, value any)
+
+ Determine if the given value exists in the JSON array.
+
+ :param json_array: String of a JSON array
+ :param value: value of any type
+ :rtype: text
+ :example:
+
+ .. code-block:: sql
+
+ select json_array_contains('[100, 200, 300]', 100);
+ > t
+
+.. function:: json_array_length(json_array text)
+
+ Returns the length of json array.
+
+ :param json_array: String of a JSON array
+ :rtype: int8
+ :example:
+
+ .. code-block:: sql
+
+ select json_array_length('[100, 200, 300]');
+ > 3
Modified: tajo/site/docs/devel/_sources/functions/math_func_and_operators.txt
URL:
http://svn.apache.org/viewvc/tajo/site/docs/devel/_sources/functions/math_func_and_operators.txt?rev=1700399&r1=1700398&r2=1700399&view=diff
==============================================================================
--- tajo/site/docs/devel/_sources/functions/math_func_and_operators.txt
(original)
+++ tajo/site/docs/devel/_sources/functions/math_func_and_operators.txt Tue Sep
1 06:42:40 2015
@@ -87,6 +87,7 @@ Math Functions and Operators
:param number: target real number
:rtype: int8
+ :alias: ceiling
:example:
.. code-block:: sql
@@ -213,6 +214,19 @@ Math Functions and Operators
select radians(45.0);
> 0.7853981633974483
+.. function:: random(number int4)
+
+ Returns a pseudorandom number.
+
+ :param number: range restriction
+ :rtype: int4
+ :example:
+
+ .. code-block:: sql
+
+ select random(10);
+ > 4
+
.. function:: round (number int|float)
Rounds to nearest integer
Modified: tajo/site/docs/devel/_sources/functions/network_func_and_operators.txt
URL:
http://svn.apache.org/viewvc/tajo/site/docs/devel/_sources/functions/network_func_and_operators.txt?rev=1700399&r1=1700398&r2=1700399&view=diff
==============================================================================
--- tajo/site/docs/devel/_sources/functions/network_func_and_operators.txt
(original)
+++ tajo/site/docs/devel/_sources/functions/network_func_and_operators.txt Tue
Sep 1 06:42:40 2015
@@ -23,7 +23,7 @@ as follows. ::
Supported Functions
===================
-.. function:: geoip_country_code (string addr)
+.. function:: geoip_country_code (addr text)
Convert an ipv4 address string to a geoip country code.
@@ -36,7 +36,7 @@ Supported Functions
select geoip_country_code('163.152.71.31')
> 'KR'
-.. function:: geoip_country_code (inet4 addr)
+.. function:: geoip_country_code (addr inet4)
Convert an ipv4 address to a geoip country code.
@@ -49,7 +49,7 @@ Supported Functions
select geoip_country_code(163.152.71.31)
> 'KR'
-.. function:: geoip_in_country (string addr, string code)
+.. function:: geoip_in_country (addr text, code text)
If the given country code is same with the country code of the given
address, it returns true. Otherwise, returns false.
@@ -63,7 +63,7 @@ Supported Functions
select geoip_in_country('163.152.71.31', 'KR')
> true
-.. function:: geoip_in_country (inet4 addr, string code)
+.. function:: geoip_in_country (addr inet4, code text)
If the given country code is same with the country code of the given
address, it returns true. Otherwise, returns false.
Modified: tajo/site/docs/devel/_sources/functions/string_func_and_operators.txt
URL:
http://svn.apache.org/viewvc/tajo/site/docs/devel/_sources/functions/string_func_and_operators.txt?rev=1700399&r1=1700398&r2=1700399&view=diff
==============================================================================
--- tajo/site/docs/devel/_sources/functions/string_func_and_operators.txt
(original)
+++ tajo/site/docs/devel/_sources/functions/string_func_and_operators.txt Tue
Sep 1 06:42:40 2015
@@ -13,77 +13,284 @@ String Functions and Operators
.. code-block:: sql
- select âTaâ || âjoâ;
+ select 'Ta' || 'jo';
> 'Tajo'
+.. function:: ascii (string text)
+
+ Returns the ASCII code of the first character of the text.
+ For UTF-8, this function returns the Unicode code point of the character.
+ For other multibyte encodings, the argument must be an ASCII character.
+
+ :param string: input string
+ :rtype: int4
+ :example:
+
+ .. code-block:: sql
+
+ select ascii('x');
+ > 120
+
+.. function:: bit_length (string text)
+
+ Returns the number of bits in string.
+
+ :param string: input string
+ :rtype: int4
+ :example:
+
+ .. code-block:: sql
+
+ select bit_length('jose');
+ > 32
.. function:: char_length (string text)
- Returns Number of characters in string
+ Returns the number of characters in string.
:param string: to be counted
:rtype: int4
- :alias: character_length
+ :alias: character_length, length
+ :example:
+
+ .. code-block:: sql
+
+ select char_length('Tajo');
+ > 4
+
+.. function:: octet_length (string text)
+
+ Returns the number of bytes in string.
+
+ :param string: input string
+ :rtype: int4
:example:
.. code-block:: sql
- select char_length(âTajoâ);
+ select octet_length('jose');
> 4
+.. function:: chr (code int4)
+
+ Returns a character with the given code.
+
+ :param code: input character code
+ :rtype: char
+ :example:
+
+ .. code-block:: sql
+
+ select chr(65);
+ > A
+
+.. function:: decode (binary text, format text)
+
+ Decode binary data from textual representation in string.
+
+ :param binary: encoded value
+ :param format: decode format. base64, hex, escape. escape converts zero
bytes and high-bit-set bytes to octal sequences (\nnn) and doubles backslashes.
+ :rtype: text
+ :example:
+
+ .. code-block:: sql
+
+ select decode('MTIzXDAwMFwwMDE=', 'base64');
+ > 123\\000\\001
+
+.. function:: digest (input text, method text)
+
+ Calculates the Digest hash of string.
+
+ :param input: input string
+ :param method: hash method
+ :rtype: text
+ :example:
+
+ .. code-block:: sql
+
+ select digest('tajo', 'sha1');
+ > 02b0e20540b89f0b735092bbac8093eb2e3804cf
+
+.. function:: encode (binary text, format text)
+
+ Encode binary data into a textual representation.
+
+ :param binary: decoded value
+ :param format: encode format. base64, hex, escape. escape converts zero
bytes and high-bit-set bytes to octal sequences (\nnn) and doubles backslashes.
+ :rtype: text
+ :example:
+
+ .. code-block:: sql
+
+ select encode('123\\000\\001', 'base64');
+ > MTIzXDAwMFwwMDE=
+
+.. function:: initcap (string text)
+
+ Convert the first letter of each word to upper case and the rest to lower
case.
+
+ :param string: input string
+ :rtype: text
+ :example:
+
+ .. code-block:: sql
+
+ select initcap('hi THOMAS');
+ > Hi Thomas
+
+.. function:: md5 (string text)
+
+ Calculates the MD5 hash of string.
+
+ :param string: input string
+ :rtype: text
+ :example:
+
+ .. code-block:: sql
+
+ select md5('abc');
+ > 900150983cd24fb0d6963f7d28e17f72
+
+.. function:: left (string text, number int4)
+
+ Returns the first n characters in the string.
+
+ :param string: input string
+ :param number: number of characters retrieved
+ :rtype: text
+ :example:
+
+ .. code-block:: sql
+
+ select left('ABC', 2);
+ > AB
+
+.. function:: right(string text, number int4)
-.. function:: trim([leading | trailing | both] [characters] from string)
+ Returns the last n characters in the string.
- Removes the characters (a space by default) from the start/end/both ends of
the string
+ :param string: input string
+ :param number: number of characters retrieved
+ :rtype: text
+ :example:
+
+ .. code-block:: sql
+
+ select right('ABC', 2);
+ > BC
+
+.. function:: locate(source text, target text, [start_index int4])
+
+ Returns the location of specified substring.
+
+ :param source: source string
+ :param target: target substring
+ :param start_index: the index where the search is started
+ :rtype: int4
+ :alias: strpos
+ :example:
+
+ .. code-block:: sql
+
+ select locate('high', 'ig', 1);
+ > 2
+
+.. function:: strposb(source text, target text)
+
+ Returns the binary location of specified substring.
+
+ :param source: source string
+ :param target: target substring
+ :rtype: int4
+ :example:
+
+ .. code-block:: sql
- :param string:
- :param characters:
+ select strpos('tajo', 'aj');
+ > 2
+
+.. function:: substr(source text, start int4, length int4)
+
+ Extract substring.
+
+ :param source: source string
+ :param start: start index
+ :param length: length of substring
+ :rtype: text
+ :example:
+
+ .. code-block:: sql
+
+ select substr('alphabet', 3, 2);
+ > ph
+
+.. function:: trim(string text, [characters text])
+
+ Removes the characters (a space by default) from the start/end/both ends of
the string.
+
+ :param string: input string
+ :param characters: characters which will be removed
+ :rtype: text
+ :example:
+
+ .. code-block:: sql
+
+ select trim('xTajoxx', 'x');
+ > Tajo
+
+.. function:: trim([leading | trailing | both] [characters text] FROM string
text)
+
+ Removes the characters (a space by default) from the start/end/both ends of
the string.
+
+ :param string: input string
+ :param characters: characters which will be removed
:rtype: text
:example:
.. code-block:: sql
- select trim(both âxâ from âxTajoxxâ);
- > Tajo
+ select trim(both 'x' from 'xTajoxx');
+ > Tajo
.. function:: btrim(string text, [characters text])
- Removes the characters (a space by default) from the both ends of the string
+ Removes the characters (a space by default) from the both ends of the string.
- :param string:
- :param characters:
+ :param string: input string
+ :param characters: characters which will be removed
:rtype: text
:alias: trim
:example:
.. code-block:: sql
- select btrim(âxTajoxxâ, âxâ);
+ select btrim('xTajoxx', 'x');
> Tajo
.. function:: ltrim(string text, [characters text])
- Removes the characters (a space by default) from the start ends of the string
+ Removes the characters (a space by default) from the start ends of the
string.
- :param string:
- :param characters:
+ :param string: input string
+ :param characters: characters which will be removed
:rtype: text
:example:
.. code-block:: sql
- select ltrim(âxxTajoâ, âxâ);
+ select ltrim('xxTajo', 'x');
> Tajo
.. function:: rtrim(string text, [characters text])
- Removes the characters (a space by default) from the end ends of the string
+ Removes the characters (a space by default) from the end ends of the string.
- :param string:
- :param characters:
+ :param string: input string
+ :param characters: characters which will be removed
:rtype: text
:example:
@@ -95,42 +302,42 @@ String Functions and Operators
.. function:: split_part(string text, delimiter text, field int)
- Splits a string on delimiter and return the given field (counting from one)
+ Splits a string on delimiter and return the given field (counting from one).
- :param string:
- :param delimiter:
- :param field:
+ :param string: input string
+ :param delimiter: delimiter
+ :param field: index to field
:rtype: text
:example:
.. code-block:: sql
- select split_part(âab_bc_cdâ,â_â,2);
+ select split_part('ab_bc_cd','_',2);
> bc
.. function:: regexp_replace(string text, pattern text, replacement text)
- Replaces substrings matched to a given regular expression pattern
+ Replaces substrings matched to a given regular expression pattern.
- :param string:
- :param pattern:
- :param replacement:
+ :param string: input string
+ :param pattern: pattern
+ :param replacement: string substituted for the matching substring
:rtype: text
:example:
.. code-block:: sql
- select regexp_replace(âabcdefâ, â(Ëab|ef$)â, âââ);
+ select regexp_replace('abcdef', '(Ëab|ef$)', 'â');
> âcdâ
.. function:: upper(string text)
- makes an input text to be upper case
+ Makes an input text to be upper case.
- :param string:
+ :param string: input string
:rtype: text
:example:
@@ -142,9 +349,9 @@ String Functions and Operators
.. function:: lower(string text)
- makes an input text to be lower case
+ Makes an input text to be lower case.
- :param string:
+ :param string: input string
:rtype: text
:example:
@@ -152,3 +359,73 @@ String Functions and Operators
select lower('TAJO');
> tajo
+
+.. function:: lpad(source text, number int4, pad text)
+
+ Fill up the string to length by prepending the characters fill (a space by
default). If the string is already longer than length then it is truncated (on
the right).
+
+ :param source: source string
+ :param number: padding length
+ :param pad: padding string
+ :rtype: text
+ :example:
+
+ .. code-block:: sql
+
+ select lpad('hi', 5, 'xy');
+ > xyxhi
+
+.. function:: rpad(source text, number int4, pad text)
+
+ Fill up the string to length length by appending the characters fill (a
space by default). If the string is already longer than length then it is
truncated.
+
+ :param source: source string
+ :param number: padding length
+ :param pad: padding string
+ :rtype: text
+ :example:
+
+ .. code-block:: sql
+
+ select rpad('hi', 5, 'xy');
+ > hixyx
+
+.. function:: quote_ident(string text)
+
+ Return the given string suitably quoted to be used as an identifier in an
SQL statement string. Quotes are added only if necessary (i.e., if the string
contains non-identifier characters or would be case-folded). Embedded quotes
are properly doubled.
+
+ :param string: input string
+ :rtype: text
+ :example:
+
+ .. code-block:: sql
+
+ select quote_ident('Foo bar');
+ > "Foo bar"
+
+.. function:: repeat(string text, number int4)
+
+ Repeat string the specified number of times.
+
+ :param string: input string
+ :param number: repetition number
+ :rtype: text
+ :example:
+
+ .. code-block:: sql
+
+ select repeat('Pg', 4);
+ > PgPgPgPg
+
+.. function:: reverse(string text)
+
+ Reverse string.
+
+ :param string: input string
+ :rtype: text
+ :example:
+
+ .. code-block:: sql
+
+ select reverse('TAJO');
+ > OJAT
\ No newline at end of file
Modified: tajo/site/docs/devel/_sources/getting_started.txt
URL:
http://svn.apache.org/viewvc/tajo/site/docs/devel/_sources/getting_started.txt?rev=1700399&r1=1700398&r2=1700399&view=diff
==============================================================================
--- tajo/site/docs/devel/_sources/getting_started.txt (original)
+++ tajo/site/docs/devel/_sources/getting_started.txt Tue Sep 1 06:42:40 2015
@@ -9,7 +9,7 @@ Prerequisites
======================
* Hadoop 2.3.0 or higher (up to 2.6.0)
- * Java 1.6 or 1.7
+ * Java 1.7 or higher
* Protocol buffer 2.5.0
===================================
Modified: tajo/site/docs/devel/_sources/index/how_to_use.txt
URL:
http://svn.apache.org/viewvc/tajo/site/docs/devel/_sources/index/how_to_use.txt?rev=1700399&r1=1700398&r2=1700399&view=diff
==============================================================================
--- tajo/site/docs/devel/_sources/index/how_to_use.txt (original)
+++ tajo/site/docs/devel/_sources/index/how_to_use.txt Tue Sep 1 06:42:40 2015
@@ -66,4 +66,4 @@ If you don't want to use the index scan
.. note::
- Once the index scan feature is enabled, Tajo currently always performs
the index scan regardless of its efficiency. You should set this option when
the expected number of retrieved tuples is sufficiently small.
\ No newline at end of file
+ Once the index scan feature is enabled, Tajo currently always performs
the index scan regardless of its efficiency. You should set this option when
the expected number of retrieved tuples is sufficiently small.
Modified: tajo/site/docs/devel/_sources/sql_language/alter_table.txt
URL:
http://svn.apache.org/viewvc/tajo/site/docs/devel/_sources/sql_language/alter_table.txt?rev=1700399&r1=1700398&r2=1700399&view=diff
==============================================================================
--- tajo/site/docs/devel/_sources/sql_language/alter_table.txt (original)
+++ tajo/site/docs/devel/_sources/sql_language/alter_table.txt Tue Sep 1
06:42:40 2015
@@ -79,7 +79,7 @@ ADD PARTITION
ALTER TABLE table1 ADD PARTITION (col1 = 1 , col2 = 2)
ALTER TABLE table1 ADD PARTITION (col1 = 1 , col2 = 2) LOCATION
'hdfs://xxx.com/warehouse/table1/col1=1/col2=2'
-You can use ``ALTER TABLE ADD PARTITION`` to add partitions to a table. The
location must be a directory inside of which data files reside. If the location
doesn't exist on the file system, Tajo will make the location by force. ``ADD
PARTITION`` changes the table metadata, but does not load data. If the data
does not exist in the partition's location, queries will not return any results.
+You can use ``ALTER TABLE ADD PARTITION`` to add partitions to a table. The
location must be a directory inside of which data files reside. If the location
doesn't exist on the file system, Tajo will make the location by force. ``ADD
PARTITION`` changes the table metadata, but does not load data. If the data
does not exist in the partition's location, queries will not return any
results. An error is thrown if the partition for the table already exists. You
can use ``IF NOT EXISTS`` to skip the error.
========================
DROP PARTITION
@@ -89,12 +89,11 @@ You can use ``ALTER TABLE ADD PARTITION`
.. code-block:: sql
- ALTER TABLE <table_name> [IF NOT EXISTS] DROP PARTITION (<partition column>
= <partition value>, ...) [PURGE]
+ ALTER TABLE <table_name> [IF EXISTS] DROP PARTITION (<partition column> =
<partition value>, ...) [PURGE]
For example:
ALTER TABLE table1 DROP PARTITION (col1 = 1 , col2 = 2)
ALTER TABLE table1 DROP PARTITION (col1 = '2015' , col2 = '01', col3 = '11' )
ALTER TABLE table1 DROP PARTITION (col1 = 'TAJO' ) PURGE
-You can use ``ALTER TABLE DROP PARTITION`` to drop a partition for a table.
This removes the data for a managed table
- and this doesn't remove the data for an external table. But if ``PURGE`` is
specified for an external table, the partition data will be removed. The
metadata is completely lost in all cases.
\ No newline at end of file
+You can use ``ALTER TABLE DROP PARTITION`` to drop a partition for a table.
This removes the data for a managed table and this doesn't remove the data for
an external table. But if ``PURGE`` is specified for an external table, the
partition data will be removed. The metadata is completely lost in all cases.
An error is thrown if the partition for the table doesn't exists. You can use
``IF EXISTS`` to skip the error.
Modified: tajo/site/docs/devel/_sources/sql_language/joins.txt
URL:
http://svn.apache.org/viewvc/tajo/site/docs/devel/_sources/sql_language/joins.txt?rev=1700399&r1=1700398&r2=1700399&view=diff
==============================================================================
--- tajo/site/docs/devel/_sources/sql_language/joins.txt (original)
+++ tajo/site/docs/devel/_sources/sql_language/joins.txt Tue Sep 1 06:42:40
2015
@@ -114,7 +114,7 @@ Basically, joining multiple relations is
To find the best join order, Tajo's cost-based optimizer considers join
conditions, join types, and the size of input relations.
In addition, it considers the computation cost of consecutive joins so that
the shape of query plan forms a bushy tree.
-For example, suppose that there are 4 relations ``a`` (10), ``b`` (20), ``c``
(30), and ``d``(40) where the numbers within brackets represent the relation
size.
+For example, suppose that there are 4 relations ``a`` (10), ``b`` (20), ``c``
(30), and ``d`` (40) where the numbers within brackets represent the relation
size.
The following query
.. code-block:: sql
Modified: tajo/site/docs/devel/_sources/sql_language/sql_expression.txt
URL:
http://svn.apache.org/viewvc/tajo/site/docs/devel/_sources/sql_language/sql_expression.txt?rev=1700399&r1=1700398&r2=1700399&view=diff
==============================================================================
--- tajo/site/docs/devel/_sources/sql_language/sql_expression.txt (original)
+++ tajo/site/docs/devel/_sources/sql_language/sql_expression.txt Tue Sep 1
06:42:40 2015
@@ -16,16 +16,26 @@ A type cast converts a specified-typed d
CAST ( expression AS type )
expression::type
+In addition, several functions are provided for type conversion. Please refer
to `:doc:data_type_func_and_operators` and `:doc:datetime_func_and_operators`.
-------------------------
-String Expressions
+String Constants
-------------------------
+A string constant is an arbitrary sequence of characters bounded by single
quotes (``'``):
+
+.. code-block:: sql
+
+ 'tajo'
-------------------------
Function Call
-------------------------
+The syntax for a function call consists of the name of a function and its
argument list enclosed in parentheses:
+
.. code-block:: sql
- function_name ([expression [, expression ... ]] )
\ No newline at end of file
+ function_name ([expression [, expression ... ]] )
+
+For more information about functions, please refer to `:doc:functions`.
\ No newline at end of file
Modified: tajo/site/docs/devel/_static/basic.css
URL:
http://svn.apache.org/viewvc/tajo/site/docs/devel/_static/basic.css?rev=1700399&r1=1700398&r2=1700399&view=diff
==============================================================================
--- tajo/site/docs/devel/_static/basic.css (original)
+++ tajo/site/docs/devel/_static/basic.css Tue Sep 1 06:42:40 2015
@@ -4,7 +4,7 @@
*
* Sphinx stylesheet -- basic theme.
*
- * :copyright: Copyright 2007-2015 by the Sphinx team, see AUTHORS.
+ * :copyright: Copyright 2007-2014 by the Sphinx team, see AUTHORS.
* :license: BSD, see LICENSE for details.
*
*/
@@ -197,10 +197,7 @@ h3:hover > a.headerlink,
h4:hover > a.headerlink,
h5:hover > a.headerlink,
h6:hover > a.headerlink,
-dt:hover > a.headerlink,
-caption:hover > a.headerlink,
-p.caption:hover > a.headerlink,
-div.code-block-caption:hover > a.headerlink {
+dt:hover > a.headerlink {
visibility: visible;
}
@@ -317,13 +314,6 @@ table.docutils {
border-collapse: collapse;
}
-table caption span.caption-number {
- font-style: italic;
-}
-
-table caption span.caption-text {
-}
-
table.docutils td, table.docutils th {
padding: 1px 8px 1px 5px;
border-top: 0;
@@ -354,25 +344,6 @@ table.citation td {
border-bottom: none;
}
-/* -- figures ---------------------------------------------------------------
*/
-
-div.figure {
- margin: 0.5em;
- padding: 0.5em;
-}
-
-div.figure p.caption {
- padding: 0.3em;
-}
-
-div.figure p.caption span.caption-number {
- font-style: italic;
-}
-
-div.figure p.caption span.caption-text {
-}
-
-
/* -- other body styles -----------------------------------------------------
*/
ol.arabic {
@@ -435,10 +406,6 @@ dl.glossary dt {
font-size: 1.3em;
}
-.sig-paren {
- font-size: larger;
-}
-
.versionmodified {
font-style: italic;
}
@@ -504,51 +471,22 @@ table.highlighttable td {
padding: 0 0.5em 0 0.5em;
}
-div.code-block-caption {
- padding: 2px 5px;
- font-size: small;
-}
-
-div.code-block-caption code {
- background-color: transparent;
-}
-
-div.code-block-caption + div > div.highlight > pre {
- margin-top: 0;
-}
-
-div.code-block-caption span.caption-number {
- padding: 0.1em 0.3em;
- font-style: italic;
-}
-
-div.code-block-caption span.caption-text {
-}
-
-div.literal-block-wrapper {
- padding: 1em 1em 0;
-}
-
-div.literal-block-wrapper div.highlight {
- margin: 0;
-}
-
-code.descname {
+tt.descname {
background-color: transparent;
font-weight: bold;
font-size: 1.2em;
}
-code.descclassname {
+tt.descclassname {
background-color: transparent;
}
-code.xref, a code {
+tt.xref, a tt {
background-color: transparent;
font-weight: bold;
}
-h1 code, h2 code, h3 code, h4 code, h5 code, h6 code {
+h1 tt, h2 tt, h3 tt, h4 tt, h5 tt, h6 tt {
background-color: transparent;
}
Modified: tajo/site/docs/devel/_static/doctools.js
URL:
http://svn.apache.org/viewvc/tajo/site/docs/devel/_static/doctools.js?rev=1700399&r1=1700398&r2=1700399&view=diff
==============================================================================
--- tajo/site/docs/devel/_static/doctools.js (original)
+++ tajo/site/docs/devel/_static/doctools.js Tue Sep 1 06:42:40 2015
@@ -4,7 +4,7 @@
*
* Sphinx JavaScript utilities for all documentation.
*
- * :copyright: Copyright 2007-2015 by the Sphinx team, see AUTHORS.
+ * :copyright: Copyright 2007-2014 by the Sphinx team, see AUTHORS.
* :license: BSD, see LICENSE for details.
*
*/
@@ -91,30 +91,6 @@ jQuery.fn.highlightText = function(text,
});
};
-/*
- * backward compatibility for jQuery.browser
- * This will be supported until firefox bug is fixed.
- */
-if (!jQuery.browser) {
- jQuery.uaMatch = function(ua) {
- ua = ua.toLowerCase();
-
- var match = /(chrome)[ \/]([\w.]+)/.exec(ua) ||
- /(webkit)[ \/]([\w.]+)/.exec(ua) ||
- /(opera)(?:.*version|)[ \/]([\w.]+)/.exec(ua) ||
- /(msie) ([\w.]+)/.exec(ua) ||
- ua.indexOf("compatible") < 0 && /(mozilla)(?:.*? rv:([\w.]+)|)/.exec(ua)
||
- [];
-
- return {
- browser: match[ 1 ] || "",
- version: match[ 2 ] || "0"
- };
- };
- jQuery.browser = {};
- jQuery.browser[jQuery.uaMatch(navigator.userAgent).browser] = true;
-}
-
/**
* Small JavaScript module for the documentation.
*/
@@ -176,10 +152,9 @@ var Documentation = {
/**
* workaround a firefox stupidity
- * see: https://bugzilla.mozilla.org/show_bug.cgi?id=645075
*/
fixFirefoxAnchorBug : function() {
- if (document.location.hash)
+ if (document.location.hash && $.browser.mozilla)
window.setTimeout(function() {
document.location.href += '';
}, 10);
Modified: tajo/site/docs/devel/_static/down-pressed.png
URL:
http://svn.apache.org/viewvc/tajo/site/docs/devel/_static/down-pressed.png?rev=1700399&r1=1700398&r2=1700399&view=diff
==============================================================================
Binary files - no diff available.
Modified: tajo/site/docs/devel/_static/down.png
URL:
http://svn.apache.org/viewvc/tajo/site/docs/devel/_static/down.png?rev=1700399&r1=1700398&r2=1700399&view=diff
==============================================================================
Binary files - no diff available.
Modified: tajo/site/docs/devel/_static/file.png
URL:
http://svn.apache.org/viewvc/tajo/site/docs/devel/_static/file.png?rev=1700399&r1=1700398&r2=1700399&view=diff
==============================================================================
Binary files - no diff available.
