Merge [TRAFODION-2910] PR 1400 Add LOAD details in SQL Reference Manual
diff --git a/docs/sql_reference/src/asciidoc/_chapters/olap_functions.adoc b/docs/sql_reference/src/asciidoc/_chapters/olap_functions.adoc
index 91ff943..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 @@
* `_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 @@
[[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)`
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 0d8dd6c..0d5c3c7 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 @@
<<<
[[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 @@
=== Considerations for CONCAT
[[operands]]
-=== Operands
+==== Operands
A string value can be specified by any character value expression, such
@@ -1547,7 +1547,7 @@
[[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
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 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 @@
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 @@
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 @@
_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>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 @@
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 @@
** 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> 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