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 2017/12/18 16:52:18 UTC
[1/2] incubator-trafodion git commit: Correct the syntax descriptions
of LOAD Statement for *Trafodion SQL Reference Manual*
Repository: incubator-trafodion
Updated Branches:
refs/heads/master aa40e9667 -> d344fad28
Correct the syntax descriptions of LOAD Statement for *Trafodion SQL Reference Manual*
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/1006ee72
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/1006ee72
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/1006ee72
Branch: refs/heads/master
Commit: 1006ee725a5f06f327ac650861377a915392da56
Parents: 4639458
Author: liu.yu <yu...@esgyn.cn>
Authored: Fri Dec 15 11:49:10 2017 +0800
Committer: liu.yu <yu...@esgyn.cn>
Committed: Fri Dec 15 11:49:10 2017 +0800
----------------------------------------------------------------------
.../src/asciidoc/_chapters/sql_statements.adoc | 2 +-
.../src/asciidoc/_chapters/sql_utilities.adoc | 52 ++++++++++++++------
2 files changed, 37 insertions(+), 17 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/1006ee72/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 7ffd7b9..824dc59 100644
--- a/docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc
+++ b/docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc
@@ -2724,7 +2724,7 @@ hbase-options-list is:
* `VOLATILE`
+
-specifies a volatile table, which is a table limited to the session that creates the table. After the session ends, the
+specifies a volatile table, which is a table limited to the session that creates the table. After the session ends, the volatile table will be automatically dropped.
* `IF NOT EXISTS`
+
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/1006ee72/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 3b42d81..50b080d 100644
--- a/docs/sql_reference/src/asciidoc/_chapters/sql_utilities.adoc
+++ b/docs/sql_reference/src/asciidoc/_chapters/sql_utilities.adoc
@@ -407,13 +407,14 @@ LOAD is a {project-name} SQL extension.
LOAD [WITH option[[,] option]...] INTO target-table SELECT ... FROM source-table
option is:
- TRUNCATE TABLE
- | NO RECOVERY
+ CONTINUE ON ERROR
+ | LOG ERROR ROWS [TO error-location-name]
+ | STOP AFTER num ERROR ROWS
+ | TRUNCATE TABLE
| NO POPULATE INDEXES
| NO DUPLICATE CHECK
| NO OUTPUT
| INDEX TABLE ONLY
- | UPSERT USING LOAD
```
[[load_syntax]]
@@ -440,19 +441,43 @@ source data as a filter.
is a set of options that you can specify for the load operation. You can
specify one or more of these options:
+** `CONTINUE ON ERROR`
++
+LOAD statement will continue after errors encountered while scanning rows from source table.
++
+Errors during the load or sort phase will cause the LOAD statement to abort.
++
+Error rows will be logged by default in HDFS files in the directory `/user/trafodion/bulkload/logs`. The default name of the error files will be of the form `ERR_<three-part-target-table-name>_<date>_<id>`, where `<id>` is a numeric identifier unique to the process where the error was seen.
++
+This option is implied if `LOG ERROR ROWS [TO _error-location-name_]` or `STOP AFTER _num_ ERROR ROWS` is specified and it is not enabled by default.
+
+** `LOG ERROR ROWS [TO _error-location-name_]`
++
+If error rows must be written to a specified location, then specify TO _error-location-name_, otherwise they will be written to the default location.
++
+Error logs are written in separate files by the processes involved in the load command under sub-directory representing the load command in the given location.
+The actual log file location is displayed in the load command output.
+
+*** `_error-location-name_`
++
+must be a HDFS directory name to which trafodion has write access.
+
+** `STOP AFTER _num_ ERROR ROWS`
++
+Use this option to stop the LOAD statement from progressing after num errors have been encountered during this statement.
++
+Duplicate check errors and errors which we have continued from using previous options are included in the count.
+
+*** _num_
++
+specifies the number of error rows.
+
** `TRUNCATE TABLE`
+
causes the Bulk Loader to truncate the target table before starting the
load operation. By default, the Bulk Loader does not truncate the target
table before loading data.
-** `NO RECOVERY`
-+
-specifies that the Bulk Loader not use HBase snapshots for recovery. By
-default, the Bulk Loader handles recovery using the HBase snapshots
-mechanism.
-
-<<<
** `NO POPULATE INDEXES`
+
specifies that the Bulk Loader not handle index maintenance or populate
@@ -472,16 +497,11 @@ prevents the LOAD statement from displaying status messages. By default,
the LOAD statement prints status messages listing the steps that the
Bulk Loader is executing.
-* `INDEX TABLE ONLY`
+** `INDEX TABLE ONLY`
+
specifies that the target table, which is an index, be populated with
data from the parent table.
-* `UPSERT USING LOAD`
-+
-specifies that the data be inserted into the target table using row set
-inserts without a transaction.
-
<<<
[[load_considerations]]
=== Considerations for LOAD
[2/2] incubator-trafodion git commit: Merge [TRAFODION-2845] PR 1346
Correct LOAD desc in SQL Ref Manual
Posted by db...@apache.org.
Merge [TRAFODION-2845] PR 1346 Correct LOAD desc in SQL Ref Manual
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/d344fad2
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/d344fad2
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/d344fad2
Branch: refs/heads/master
Commit: d344fad28a72015b231a539b7742e6dd8124b9cc
Parents: aa40e96 1006ee7
Author: Dave Birdsall <db...@apache.org>
Authored: Mon Dec 18 16:51:31 2017 +0000
Committer: Dave Birdsall <db...@apache.org>
Committed: Mon Dec 18 16:51:31 2017 +0000
----------------------------------------------------------------------
.../src/asciidoc/_chapters/sql_statements.adoc | 2 +-
.../src/asciidoc/_chapters/sql_utilities.adoc | 52 ++++++++++++++------
2 files changed, 37 insertions(+), 17 deletions(-)
----------------------------------------------------------------------