http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/e64b94eb/docs/2.3.0/sql_reference/dependencies.html ---------------------------------------------------------------------- diff --git a/docs/2.3.0/sql_reference/dependencies.html b/docs/2.3.0/sql_reference/dependencies.html index 2f6ccb5..5f2f010 100644 --- a/docs/2.3.0/sql_reference/dependencies.html +++ b/docs/2.3.0/sql_reference/dependencies.html @@ -1,5 +1,5 @@ - + @@ -10,7 +10,7 @@ @import url("./css/site.css"); - + @@ -27,7 +27,7 @@
- Last Published: 2017-12-12 + Last Published: 2017-12-18  | Version: 2.3.0
Trafodion SQL Reference Manual http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/e64b94eb/docs/2.3.0/sql_reference/index.html ---------------------------------------------------------------------- diff --git a/docs/2.3.0/sql_reference/index.html b/docs/2.3.0/sql_reference/index.html index ed55fca..2fb2c9f 100644 --- a/docs/2.3.0/sql_reference/index.html +++ b/docs/2.3.0/sql_reference/index.html @@ -7673,7 +7673,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.

  • @@ -17977,13 +17977,14 @@ called an HFile.

    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
    + | INDEX TABLE ONLY
  • @@ -18019,30 +18020,68 @@ specify one or more of these options:

    +
  • +

    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 POPULATE INDEXES

    specifies that the Bulk Loader not handle index maintenance or populate @@ -18066,8 +18105,7 @@ data and generates an error when it detects duplicates.

    the LOAD statement prints status messages listing the steps that the Bulk Loader is executing.

    -
    -
      +
    • INDEX TABLE ONLY

      @@ -18075,13 +18113,6 @@ Bulk Loader is executing.

      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.

      -
      -
  • @@ -44981,7 +45012,7 @@ or 256 bytes of UTF8 text, whichever is less.