Repository: trafodion Updated Branches: refs/heads/master 13840cee2 -> b2ea5f2b3
Add Details for Load Statement 4 and Correct Typos for *Trafodion SQL Reference Manual* Project: http://git-wip-us.apache.org/repos/asf/trafodion/repo Commit: http://git-wip-us.apache.org/repos/asf/trafodion/commit/1e370798 Tree: http://git-wip-us.apache.org/repos/asf/trafodion/tree/1e370798 Diff: http://git-wip-us.apache.org/repos/asf/trafodion/diff/1e370798 Branch: refs/heads/master Commit: 1e3707985078d1f5d338bfa69d9c4600c85085b7 Parents: 27897ca Author: liu.yu <[email protected]> Authored: Tue Jan 16 15:53:28 2018 +0800 Committer: liu.yu <[email protected]> Committed: Tue Jan 16 15:53:28 2018 +0800 ---------------------------------------------------------------------- .../src/asciidoc/_chapters/olap_functions.adoc | 4 ++-- .../sql_functions_and_expressions.adoc | 6 +++--- .../src/asciidoc/_chapters/sql_utilities.adoc | 22 +++++++++++--------- 3 files changed, 17 insertions(+), 15 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/trafodion/blob/1e370798/docs/sql_reference/src/asciidoc/_chapters/olap_functions.adoc ---------------------------------------------------------------------- diff --git a/docs/sql_reference/src/asciidoc/_chapters/olap_functions.adoc b/docs/sql_reference/src/asciidoc/_chapters/olap_functions.adoc index 91ff943..08c6f70 100644 --- a/docs/sql_reference/src/asciidoc/_chapters/olap_functions.adoc +++ b/docs/sql_reference/src/asciidoc/_chapters/olap_functions.adoc @@ -260,7 +260,7 @@ and <<interval_value_expressions,Interval Value Expressions>>. * `_inline-window-specification_` + -specifies_the_window_over_which_the_avg_is_computed. The +specifies the window over which the avg is computed. The _inline-window-specification_ can contain an optional partition by clause, an optional ORDER BY clause and an optional window frame clause. The PARTITION BY clause specifies how the intermediate result is @@ -483,7 +483,7 @@ FROM persnl.employee; [[first_value_window_function]] == FIRST_VALUE Window Function -The FIRST_VALUE window function returns the first value from a sorted partition. +The FIRST_VALUE window function returns the first value from a sorted partition. `FIRST_VALUE (expression)` http://git-wip-us.apache.org/repos/asf/trafodion/blob/1e370798/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 364211a..d6d2e70 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 @@ -1492,7 +1492,7 @@ is a character string. <<< [[concat_function]] -=== CONCAT Function +== CONCAT Function The CONCAT function returns the concatenation of two character value expressions as a character string value. You can also use the @@ -1534,7 +1534,7 @@ An operand can be any SQL value expression of data type CHAR or VARCHAR. === Considerations for CONCAT [[operands]] -=== Operands +==== Operands A string value can be specified by any character value expression, such @@ -1547,7 +1547,7 @@ VARCHAR. [[sql-parameters]] -=== SQL Parameters +==== SQL Parameters You can concatenate an SQL parameter and a character value expression. The concatenated parameter takes on the data type attributes of the http://git-wip-us.apache.org/repos/asf/trafodion/blob/1e370798/docs/sql_reference/src/asciidoc/_chapters/sql_utilities.adoc ---------------------------------------------------------------------- diff --git a/docs/sql_reference/src/asciidoc/_chapters/sql_utilities.adoc b/docs/sql_reference/src/asciidoc/_chapters/sql_utilities.adoc index d7f1266..8f3408e 100644 --- a/docs/sql_reference/src/asciidoc/_chapters/sql_utilities.adoc +++ b/docs/sql_reference/src/asciidoc/_chapters/sql_utilities.adoc @@ -784,7 +784,7 @@ Task: COMPLETION Status: Ended Time: 2018-01-03 16:23:04.301579 Task: COMPLETION Status: Ended Elapsed Time: 00:00:00.381 --- SQL operation complete. -SQL>select * from target_table1; +SQL>SELECT * FROM target_table1; A B ----------- ---- 4 dd @@ -832,8 +832,8 @@ drwxr-xr-x - trafodion trafodion 0 2018-01-03 17:19 Suppose that we have two same tables (_source_table_ and _target_table1_) as shown in the <<continue_on_error_examples,Examples of `CONTINUE ON ERROR`>>. -* The examples below illustrate how the LOAD Statement behaves depending on the different `num`. -+ +The examples below illustrate how the LOAD Statement behaves depending on the different `num`. + ``` SQL>LOAD WITH STOP AFTER 2 ERROR ROWS INTO target_table1 SELECT * FROM source_table; @@ -851,7 +851,7 @@ Task: LOADING DATA Status: Started Time: 2018-01-05 10:53:52.45757 SQL>SELECT * FROM target_table1; --- 0 row(s) selected. ``` -+ + ``` SQL>LOAD WITH STOP AFTER 3 ERROR ROWS INTO target_table1 SELECT * FROM source_table; @@ -930,10 +930,10 @@ CREATE TABLE TRAFODION.SEABASE.TARGET_TABLE1 _target_table2_: ``` -SQL>select * from target_table2; +SQL>SELECT * FROM target_table2; --- 0 row(s) selected. -SQL>showddl target_table2; +SQL>SHOWDDL target_table2; CREATE TABLE TRAFODION.SEABASE.TARGET_TABLE2 ( A INT NO DEFAULT NOT NULL NOT DROPPABLE NOT @@ -995,10 +995,10 @@ SQL>SET PARSERFLAGS 1; SQL>LOAD WITH INDEX TABLE ONLY INTO TABLE(INDEX_TABLE index_target_table1) SELECT b,a FROM source_table; --- SQL operation complete. -SQL>select * from target_table1; +SQL>SELECT * FROM target_table1; --- 0 row(s) selected. -select * from table(index_table index_target_table1); +SELECT * FROM table(index_table index_target_table1); B@ A ---- -------------------- aaaa 1 @@ -1033,7 +1033,7 @@ A B 6 fff --- 6 row(s) selected. -SQL>select * from table(index_table index_target_table1); +SQL>SELECT * FROM table(index_table index_target_table1); B@ A ---- -------------------- aaaa 1 @@ -1125,7 +1125,7 @@ A@ ** The _target_table4_ has columns A (index column) and B defined, in this case, populate the index table with column A and syskey from the _source_table_. + ``` -SQL> create index index_target_table4 on target_table4(a) no populate; +SQL> CREATE INDEX index_target_table4 ON target_table4(a) NO POPULATE; --- SQL operation complete. SQL>SET PARSERFLAGS 1; @@ -1173,6 +1173,8 @@ SQL> POPULATE INDEX index_target_table4 ON target_table4; SQL> DROP INDEX index_target_table4; --- SQL operation complete. ``` +[[loading_data_from_hive_table_examples]] +==== Examples of Loading data from Hive Table * For customer demographics data residing in `/hive/tpcds/customer_demographics`, create an external Hive table using
