You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by db...@apache.org on 2018/01/18 18:50:08 UTC
[1/3] trafodion git commit: Add Details for Load Statement 4 and
Correct Typos for *Trafodion SQL Reference Manual*
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 <yu...@esgyn.cn>
Authored: Tue Jan 16 15:53:28 2018 +0800
Committer: liu.yu <yu...@esgyn.cn>
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
[2/3] trafodion git commit: Incorporate Comment 1
Posted by db...@apache.org.
Incorporate Comment 1
Project: http://git-wip-us.apache.org/repos/asf/trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/trafodion/commit/c97e3c0e
Tree: http://git-wip-us.apache.org/repos/asf/trafodion/tree/c97e3c0e
Diff: http://git-wip-us.apache.org/repos/asf/trafodion/diff/c97e3c0e
Branch: refs/heads/master
Commit: c97e3c0ed3236f0f673dba392fb9f19132212529
Parents: 1e37079
Author: liu.yu <yu...@esgyn.cn>
Authored: Thu Jan 18 09:55:11 2018 +0800
Committer: liu.yu <yu...@esgyn.cn>
Committed: Thu Jan 18 09:55:11 2018 +0800
----------------------------------------------------------------------
docs/sql_reference/src/asciidoc/_chapters/olap_functions.adoc | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/trafodion/blob/c97e3c0e/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 08c6f70..4ec556d 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
[3/3] trafodion git commit: Merge [TRAFODION-2910] PR 1400 Add LOAD
details in SQL Reference Manual
Posted by db...@apache.org.
Merge [TRAFODION-2910] PR 1400 Add LOAD details in 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/b2ea5f2b
Tree: http://git-wip-us.apache.org/repos/asf/trafodion/tree/b2ea5f2b
Diff: http://git-wip-us.apache.org/repos/asf/trafodion/diff/b2ea5f2b
Branch: refs/heads/master
Commit: b2ea5f2b3240895147130aa80e06f543a8a52cfc
Parents: 13840ce c97e3c0
Author: Dave Birdsall <db...@apache.org>
Authored: Thu Jan 18 18:49:20 2018 +0000
Committer: Dave Birdsall <db...@apache.org>
Committed: Thu Jan 18 18:49:20 2018 +0000
----------------------------------------------------------------------
.../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/b2ea5f2b/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc
----------------------------------------------------------------------