Incorporate Comments 1
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/fd561079 Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/fd561079 Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/fd561079 Branch: refs/heads/master Commit: fd561079b2d3077c144873ddd06671504362b6fe Parents: 87a9937 Author: liu.yu <[email protected]> Authored: Wed Nov 15 16:40:47 2017 +0800 Committer: liu.yu <[email protected]> Committed: Wed Nov 15 16:40:47 2017 +0800 ---------------------------------------------------------------------- .../asciidoc/_chapters/sql_functions_and_expressions.adoc | 2 +- .../sql_reference/src/asciidoc/_chapters/sql_statements.adoc | 8 ++++---- 2 files changed, 5 insertions(+), 5 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/fd561079/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc ---------------------------------------------------------------------- diff --git a/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc b/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc index 7861cc3..6c2c530 100644 --- a/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc +++ b/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc @@ -2573,7 +2573,7 @@ DATE_PART('year', date'12/05/2006') DATE_PART('day', TIMESTAMP '2006-12-31 11:59:59.999999') ``` -* This function returns the value 2011 07. +* This function returns the value 201107. + ``` DATE_PART('YEARMONTH', date '2011-07-25') http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/fd561079/docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc ---------------------------------------------------------------------- diff --git a/docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc b/docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc index cce664d..a81499c 100644 --- a/docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc +++ b/docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc @@ -2822,7 +2822,7 @@ specifies a select query which is used to populate the created table. A select q is a list of expressions that can only refer to primary key or STORE BY columns. + -The followings are allowed expressions in the DIVISON BY clause, they are monotonically increasing expressions: +The following are allowed expressions in the DIVISON BY clause, they are monotonically increasing expressions: + ** cast((exact_numeric_column[ + const1 ]) / const2 as numeric_data_type) @@ -3343,7 +3343,7 @@ SELECT * FROM T WHERE b = 'A'; SELECT * FROM T WHERE b = 'A' (not casespecific); ``` -* This is the 1^st^ example of DIVISION BY usage. +* This is the first example of DIVISION BY usage. + ``` CREATE TABLE call_home_data @@ -3355,7 +3355,7 @@ SALT USING 16 PARTITIONS ON (id) DIVISION BY (date_trunc('day', ts)); ``` -* This is the 2^nd^ example of DIVISION BY usage. +* This is the second example of DIVISION BY usage. + ``` CREATE TABLE sales1 @@ -3367,7 +3367,7 @@ PRIMARY KEY (store_id, item_id, sale_date)) DIVISION BY (DATEDIFF(YEAR, '2017-11-02', sale_date)); ``` -* This is the 3^rd^ example of DIVISION BY usage. +* This is the third example of DIVISION BY usage. + ``` CREATE TABLE sales2
