http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/87aa78a9/docs/rest_reference/apidocs/org/trafodion/rest/version/util/package-use.html ---------------------------------------------------------------------- diff --git a/docs/rest_reference/apidocs/org/trafodion/rest/version/util/package-use.html b/docs/rest_reference/apidocs/org/trafodion/rest/version/util/package-use.html index ef8b1ef..06c5547 100644 --- a/docs/rest_reference/apidocs/org/trafodion/rest/version/util/package-use.html +++ b/docs/rest_reference/apidocs/org/trafodion/rest/version/util/package-use.html @@ -2,10 +2,10 @@ - + Uses of Package org.trafodion.rest.version.util (Trafodion REST 2.0.0 API) - + http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/87aa78a9/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/ZKConfig.html ---------------------------------------------------------------------- diff --git a/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/ZKConfig.html b/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/ZKConfig.html index 33b221f..0966901 100644 --- a/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/ZKConfig.html +++ b/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/ZKConfig.html @@ -2,10 +2,10 @@ - + ZKConfig (Trafodion REST 2.0.0 API) - + http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/87aa78a9/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/ZKServerTool.html ---------------------------------------------------------------------- diff --git a/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/ZKServerTool.html b/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/ZKServerTool.html index 28c3a9d..9489345 100644 --- a/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/ZKServerTool.html +++ b/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/ZKServerTool.html @@ -2,10 +2,10 @@ - + ZKServerTool (Trafodion REST 2.0.0 API) - + http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/87aa78a9/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/ZkClient.html ---------------------------------------------------------------------- diff --git a/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/ZkClient.html b/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/ZkClient.html index 565221c..a03b56a 100644 --- a/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/ZkClient.html +++ b/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/ZkClient.html @@ -2,10 +2,10 @@ - + ZkClient (Trafodion REST 2.0.0 API) - + http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/87aa78a9/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/ZkQuorumPeer.html ---------------------------------------------------------------------- diff --git a/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/ZkQuorumPeer.html b/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/ZkQuorumPeer.html index 8f19999..838c650 100644 --- a/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/ZkQuorumPeer.html +++ b/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/ZkQuorumPeer.html @@ -2,10 +2,10 @@ - + ZkQuorumPeer (Trafodion REST 2.0.0 API) - + http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/87aa78a9/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/ZkUtil.html ---------------------------------------------------------------------- diff --git a/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/ZkUtil.html b/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/ZkUtil.html index 1a498e3..bf08a62 100644 --- a/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/ZkUtil.html +++ b/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/ZkUtil.html @@ -2,10 +2,10 @@ - + ZkUtil (Trafodion REST 2.0.0 API) - + http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/87aa78a9/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/ZooKeeperMainServerArg.html ---------------------------------------------------------------------- diff --git a/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/ZooKeeperMainServerArg.html b/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/ZooKeeperMainServerArg.html index 2537574..bf64bbd 100644 --- a/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/ZooKeeperMainServerArg.html +++ b/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/ZooKeeperMainServerArg.html @@ -2,10 +2,10 @@ - + ZooKeeperMainServerArg (Trafodion REST 2.0.0 API) - + http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/87aa78a9/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/class-use/ZKConfig.html ---------------------------------------------------------------------- diff --git a/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/class-use/ZKConfig.html b/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/class-use/ZKConfig.html index af7e336..cab7b32 100644 --- a/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/class-use/ZKConfig.html +++ b/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/class-use/ZKConfig.html @@ -2,10 +2,10 @@ - + Uses of Class org.trafodion.rest.zookeeper.ZKConfig (Trafodion REST 2.0.0 API) - + http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/87aa78a9/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/class-use/ZKServerTool.html ---------------------------------------------------------------------- diff --git a/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/class-use/ZKServerTool.html b/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/class-use/ZKServerTool.html index cf8e509..254d347 100644 --- a/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/class-use/ZKServerTool.html +++ b/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/class-use/ZKServerTool.html @@ -2,10 +2,10 @@ - + Uses of Class org.trafodion.rest.zookeeper.ZKServerTool (Trafodion REST 2.0.0 API) - + http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/87aa78a9/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/class-use/ZkClient.html ---------------------------------------------------------------------- diff --git a/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/class-use/ZkClient.html b/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/class-use/ZkClient.html index f5cf99c..a199130 100644 --- a/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/class-use/ZkClient.html +++ b/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/class-use/ZkClient.html @@ -2,10 +2,10 @@ - + Uses of Class org.trafodion.rest.zookeeper.ZkClient (Trafodion REST 2.0.0 API) - + http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/87aa78a9/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/class-use/ZkQuorumPeer.html ---------------------------------------------------------------------- diff --git a/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/class-use/ZkQuorumPeer.html b/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/class-use/ZkQuorumPeer.html index 922d586..f53160a 100644 --- a/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/class-use/ZkQuorumPeer.html +++ b/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/class-use/ZkQuorumPeer.html @@ -2,10 +2,10 @@ - + Uses of Class org.trafodion.rest.zookeeper.ZkQuorumPeer (Trafodion REST 2.0.0 API) - + http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/87aa78a9/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/class-use/ZkUtil.html ---------------------------------------------------------------------- diff --git a/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/class-use/ZkUtil.html b/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/class-use/ZkUtil.html index 615d643..6c0d37e 100644 --- a/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/class-use/ZkUtil.html +++ b/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/class-use/ZkUtil.html @@ -2,10 +2,10 @@ - + Uses of Class org.trafodion.rest.zookeeper.ZkUtil (Trafodion REST 2.0.0 API) - + http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/87aa78a9/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/class-use/ZooKeeperMainServerArg.html ---------------------------------------------------------------------- diff --git a/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/class-use/ZooKeeperMainServerArg.html b/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/class-use/ZooKeeperMainServerArg.html index 91a0932..2607619 100644 --- a/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/class-use/ZooKeeperMainServerArg.html +++ b/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/class-use/ZooKeeperMainServerArg.html @@ -2,10 +2,10 @@ - + Uses of Class org.trafodion.rest.zookeeper.ZooKeeperMainServerArg (Trafodion REST 2.0.0 API) - + http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/87aa78a9/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/package-frame.html ---------------------------------------------------------------------- diff --git a/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/package-frame.html b/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/package-frame.html index 00523ac..b9d7d7e 100644 --- a/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/package-frame.html +++ b/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/package-frame.html @@ -2,10 +2,10 @@ - + org.trafodion.rest.zookeeper (Trafodion REST 2.0.0 API) - + http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/87aa78a9/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/package-summary.html ---------------------------------------------------------------------- diff --git a/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/package-summary.html b/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/package-summary.html index b6f3546..2c855fa 100644 --- a/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/package-summary.html +++ b/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/package-summary.html @@ -2,10 +2,10 @@ - + org.trafodion.rest.zookeeper (Trafodion REST 2.0.0 API) - + http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/87aa78a9/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/package-tree.html ---------------------------------------------------------------------- diff --git a/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/package-tree.html b/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/package-tree.html index ebe0216..cf22b89 100644 --- a/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/package-tree.html +++ b/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/package-tree.html @@ -2,10 +2,10 @@ - + org.trafodion.rest.zookeeper Class Hierarchy (Trafodion REST 2.0.0 API) - + http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/87aa78a9/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/package-use.html ---------------------------------------------------------------------- diff --git a/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/package-use.html b/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/package-use.html index acd57df..26fdf2f 100644 --- a/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/package-use.html +++ b/docs/rest_reference/apidocs/org/trafodion/rest/zookeeper/package-use.html @@ -2,10 +2,10 @@ - + Uses of Package org.trafodion.rest.zookeeper (Trafodion REST 2.0.0 API) - + http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/87aa78a9/docs/rest_reference/apidocs/overview-frame.html ---------------------------------------------------------------------- diff --git a/docs/rest_reference/apidocs/overview-frame.html b/docs/rest_reference/apidocs/overview-frame.html index 62dd054..8d3c9e2 100644 --- a/docs/rest_reference/apidocs/overview-frame.html +++ b/docs/rest_reference/apidocs/overview-frame.html @@ -2,10 +2,10 @@ - + Overview List (Trafodion REST 2.0.0 API) - + http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/87aa78a9/docs/rest_reference/apidocs/overview-summary.html ---------------------------------------------------------------------- diff --git a/docs/rest_reference/apidocs/overview-summary.html b/docs/rest_reference/apidocs/overview-summary.html index 238d50c..d2fad89 100644 --- a/docs/rest_reference/apidocs/overview-summary.html +++ b/docs/rest_reference/apidocs/overview-summary.html @@ -2,10 +2,10 @@ - + Overview (Trafodion REST 2.0.0 API) - + http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/87aa78a9/docs/rest_reference/apidocs/overview-tree.html ---------------------------------------------------------------------- diff --git a/docs/rest_reference/apidocs/overview-tree.html b/docs/rest_reference/apidocs/overview-tree.html index 0be53f5..1f163e7 100644 --- a/docs/rest_reference/apidocs/overview-tree.html +++ b/docs/rest_reference/apidocs/overview-tree.html @@ -2,10 +2,10 @@ - + Class Hierarchy (Trafodion REST 2.0.0 API) - + http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/87aa78a9/docs/rest_reference/apidocs/serialized-form.html ---------------------------------------------------------------------- diff --git a/docs/rest_reference/apidocs/serialized-form.html b/docs/rest_reference/apidocs/serialized-form.html index 49f30e9..534679e 100644 --- a/docs/rest_reference/apidocs/serialized-form.html +++ b/docs/rest_reference/apidocs/serialized-form.html @@ -2,10 +2,10 @@ - + Serialized Form (Trafodion REST 2.0.0 API) - + http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/87aa78a9/docs/rest_reference/failsafe-report.html ---------------------------------------------------------------------- diff --git a/docs/rest_reference/failsafe-report.html b/docs/rest_reference/failsafe-report.html index 0cd789a..c4eebf2 100644 --- a/docs/rest_reference/failsafe-report.html +++ b/docs/rest_reference/failsafe-report.html @@ -1,5 +1,5 @@ - + @@ -10,7 +10,7 @@ @import url("./css/site.css"); - + @@ -27,7 +27,7 @@
- Last Published: 2016-02-24 + Last Published: 2016-03-03  | Version: 2.0.0
Trafodion REST http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/87aa78a9/docs/rest_reference/index.html ---------------------------------------------------------------------- diff --git a/docs/rest_reference/index.html b/docs/rest_reference/index.html index 1c14455..2e74b2c 100644 --- a/docs/rest_reference/index.html +++ b/docs/rest_reference/index.html @@ -95,7 +95,7 @@ under the License.

2.0.0

-

2016-02-24T18:48

+

2016-03-03T20:14

http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/87aa78a9/docs/rest_reference/mail-lists.html ---------------------------------------------------------------------- diff --git a/docs/rest_reference/mail-lists.html b/docs/rest_reference/mail-lists.html index f7180f7..89f73a0 100644 --- a/docs/rest_reference/mail-lists.html +++ b/docs/rest_reference/mail-lists.html @@ -1,5 +1,5 @@ - + @@ -10,7 +10,7 @@ @import url("./css/site.css"); - + @@ -27,7 +27,7 @@
- Last Published: 2016-02-24 + Last Published: 2016-03-03  | Version: 2.0.0
Trafodion REST http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/87aa78a9/docs/rest_reference/project-info.html ---------------------------------------------------------------------- diff --git a/docs/rest_reference/project-info.html b/docs/rest_reference/project-info.html index ba0a782..c5ffa7f 100644 --- a/docs/rest_reference/project-info.html +++ b/docs/rest_reference/project-info.html @@ -1,5 +1,5 @@ - + @@ -10,7 +10,7 @@ @import url("./css/site.css"); - + @@ -27,7 +27,7 @@
- Last Published: 2016-02-24 + Last Published: 2016-03-03  | Version: 2.0.0
Trafodion REST http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/87aa78a9/docs/rest_reference/project-reports.html ---------------------------------------------------------------------- diff --git a/docs/rest_reference/project-reports.html b/docs/rest_reference/project-reports.html index f4deb4f..be20889 100644 --- a/docs/rest_reference/project-reports.html +++ b/docs/rest_reference/project-reports.html @@ -1,5 +1,5 @@ - + @@ -10,7 +10,7 @@ @import url("./css/site.css"); - + @@ -27,7 +27,7 @@
- Last Published: 2016-02-24 + Last Published: 2016-03-03  | Version: 2.0.0
Trafodion REST http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/87aa78a9/docs/rest_reference/team-list.html ---------------------------------------------------------------------- diff --git a/docs/rest_reference/team-list.html b/docs/rest_reference/team-list.html index 7de700a..109c982 100644 --- a/docs/rest_reference/team-list.html +++ b/docs/rest_reference/team-list.html @@ -1,5 +1,5 @@ - + @@ -10,7 +10,7 @@ @import url("./css/site.css"); - + @@ -27,7 +27,7 @@
- Last Published: 2016-02-24 + Last Published: 2016-03-03  | Version: 2.0.0
Trafodion REST http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/87aa78a9/docs/sql_reference/Trafodion_SQL_Reference_Manual.pdf ---------------------------------------------------------------------- diff --git a/docs/sql_reference/Trafodion_SQL_Reference_Manual.pdf b/docs/sql_reference/Trafodion_SQL_Reference_Manual.pdf index 29c38e7..94e2783 100644 Binary files a/docs/sql_reference/Trafodion_SQL_Reference_Manual.pdf and b/docs/sql_reference/Trafodion_SQL_Reference_Manual.pdf differ http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/87aa78a9/docs/sql_reference/dependencies.html ---------------------------------------------------------------------- diff --git a/docs/sql_reference/dependencies.html b/docs/sql_reference/dependencies.html index 712d257..310aaee 100644 --- a/docs/sql_reference/dependencies.html +++ b/docs/sql_reference/dependencies.html @@ -1,5 +1,5 @@ - + @@ -10,7 +10,7 @@ @import url("./css/site.css"); - + @@ -27,7 +27,7 @@
- Last Published: 2016-02-24 + Last Published: 2016-03-03  | Version: 2.0.0
Trafodion SQL Reference Manual http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/87aa78a9/docs/sql_reference/index.html ---------------------------------------------------------------------- diff --git a/docs/sql_reference/index.html b/docs/sql_reference/index.html index cbb946f..7504cfc 100644 --- a/docs/sql_reference/index.html +++ b/docs/sql_reference/index.html @@ -1943,40 +1943,35 @@ table.CodeRay td.code>pre{padding:0}
  • 10. Control Query Default (CQD) Attributes @@ -2279,16 +2274,12 @@ INTERVAL { start-field TO end-field | single-field }

    A vertical line separates alternatives in a horizontal list that is enclosed in brackets or braces.

    -
  • - -
    {expression | NULL}
    -
    -
      +
    • … Ellipsis

      @@ -2306,14 +2297,14 @@ INTERVAL { start-field TO end-field | single-field }

      For example:

      -
    • -
    -
    expression-n ...
    + + +
      @@ -5174,18 +5165,18 @@ EXECUTE y; -- uses MYSCHEMA;
      • -

        Change the maximum supported length of the column names to 200 for the current process:

        +

        Increase the cache refresh time for the histogram cache to two hours (7,200 minutes).

        -
        CONTROL QUERY DEFAULT HBASE_MAX_COLUMN_NAME_LENGTH '200';
        +
        CONTROL QUERY DEFAULT CACHE_HISTOGRAMS_REFRESH_INTERVAL '7200';
      • -

        Reset the HBASE_MAX_COLUMN_NAME_LENGTH attribute to its initial value in the current process:

        +

        Reset the CACHE_HISTOGRAMS_REFRESH_INTERVAL attribute to its initial value in the current process:

        -
        CONTROL QUERY DEFAULT HBASE_MAX_COLUMN_NAME_LENGTH RESET;
        +
        CONTROL QUERY DEFAULT CACHE_HISTOGRAMS_REFRESH_INTERVAL RESET;
      • @@ -16431,21 +16422,63 @@ server, and ends when data eventually is written to an HBase data file called an HFile.

      -

      The Trafodion bulk load process takes place in two phases:

      +

      The Trafodion bulk load process takes place in the following phases:

      +
      +
      +
        +
      • +

        Disable Indexes (if incremental index build not used)

        +
      • +
      • +

        Prepare (takes most time, heart of the bulk load operation)

        +
        +
          +
        • +

          Read source files (Trafodion Table, Hive table, or Hive external table)

          +
        • +
        • +

          Data encoded in Trafodion encoding

          +
        • +
        • +

          Data repartitioned and sorted to match regions of target table

          +
        • +
        • +

          Data written to HFiles

          +
        • +
        • +

          Data repartitioned and written to index HFiles (if incremental index build IS used)

          +
        • +
        +
      • +
      • +

        Complete (with or without Snapshot recovery)

        • -

          Preparation phase: In this phase, Trafodion reads the data from -the source files in Hive or HDFS, partitions the data based on the -target table’s partitioning scheme, sorts the data, and then generates -key-value pairs that will populate the HFiles. Trafodion also encodes the -data for faster storage and retrieval.

          +

          Take a snapshot of the table

          +
        • +
        • +

          Merge HFiles into HBase table (very fast – move, not a copy)

          +
        • +
        • +

          Delete snapshot or restore from snapshot if merge fails

          +
        • +
        +
        +
      • +
      • +

        Populate Indexes (if incremental index build is NOT used)

      • -

        Loading-the-files-into-HBase phase: This phase uses the -LoadIncrementalHFiles (also known as the computebulkload tool) and load -the generated HFiles into the region servers.

        +

        Cleanup

        +
        +
          +
        • +

          HFiles temporary space cleanup

          +
        • +
        +
      @@ -16514,6 +16547,14 @@ default, the Bulk Loader handles recovery using the HBase snapshots mechanism.

    + +
    + + +
    +
    +
    +
    • NO POPULATE INDEXES

      @@ -16538,10 +16579,8 @@ 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

      @@ -16558,6 +16597,9 @@ inserts without a transaction.

    + + +
    @@ -16606,10 +16648,11 @@ guidelines.

    Staging Folder for HFiles

    The Bulk Loader uses an HDFS folder as a staging area for the HFiles -before calling HBase APIs to merge them into the Trafodion table. By -default, Trafodion uses /bulkload/ as the staging -folder. This folder must be owned by the same user as the one under -which Trafodion runs. Trafodion +before calling HBase APIs to merge them into the Trafodion table.

    +
    +
    +

    By default, Trafodion uses /bulkload as the staging folder. This folder +must be owned by the same user as the one under which Trafodion runs. Trafodion also must have full permissions on this folder. The HBase user (that is, the user under which HBase runs) must have read/write access to this folder.

    @@ -16622,15 +16665,50 @@ folder.

    drwxr-xr-x - trafodion trafodion 0 2014-07-07 09:49 /bulkload.
    +
    + +
    +
    Improving Throughput
    +
    +

    The following CQD (Control Query Default) settings help improve the Bulk Loader +throughput:

    +
    +
    + +
    +
    +

    Also, consider using NO DUPLICATE CHECK to improve througput if your +source data is clean.

    +
    Hive Source Table
    -

    To load data stored in HDFS, you will need to create a Hive table with +

    To load data stored in HDFS, you need to create a Hive table with the right fields and types pointing to the HDFS folder containing the data before you start the load.

    -
    HBase Snapshots
    @@ -16638,13 +16716,100 @@ data before you start the load.

    If you do not specify the NO RECOVERY OPTION in the LOAD statement, the Bulk Loader uses HBase snapshots as a mechanism for recovery. Snapshots are a lightweight operation where some metadata is copied. (Data is not -copied.) A snapshot is taken before the load starts and is removed after +copied.)

    +
    +
    +

    A snapshot is taken before the load starts and is removed after the load completes successfully. If something goes wrong and it is possible to recover, the snapshot is used to restore the table to its initial state before the load started. To use this recovery mechanism, HBase needs to be configured to allow snapshots.

    +
    +
    Incremental Loads
    +
    +

    The Bulk Loader allows for incremental loads by default. Snapshots are +taken before second phase starts and deleted once the bulk load completes.

    +
    +
    +

    If something goes wrong with the load, then the snapshot is restored to +go to the previous state.

    +
    +
    +
    +
    +
    Non-Incremental Loads
    +
    +

    These following bulk load options can be used to do non-incremental load:

    +
    +
    + +
    +
    +
    +
    Space Usage
    +
    +

    The target table values for SYSKEY, SALT, identity, divisioning columns +are created automatically the during transformation step. The size of the +HBase files is determined based on encoding, compression, HDFS replication +factor, and row format. Target table can be pre-split into regions using +salting, a Java Program, by seeding the table with data.

    +
    +
    +
    +
    Performance
    +
    +

    The overall throughput is influenced by row format, row length, number of +columns, skew in data, etc. LOAD sas upsert semantics (duplicate constraint +not checked with existing data). LOAD has lower CPU abd disk activity than +similar trickle load (INSERT, UPSERT, or UPSERT USING LOAD), Also, LOAD has +lower compaction activity after completion than Trickle Load.

    +
    +
    +
    +
    Hive Scans
    +
    +

    Direct access for Hive table data supports:

    +
    +
    + +
    +
    +

    Tables must be created/dropped/altered through Hive itself.

    +
    +
    +

    Trafodion:

    +
    +
    + +
    +
    +

    4.1.3. Examples of LOAD

    @@ -41786,43 +41951,9 @@ enclose them in double quotes.

    default settings.

    -

    10.1. HBase Environment CQDs

    -
    -

    Defines the HBase interface.

    -
    -
    -

    10.1.1. HBASE_INTERFACE

    - ---- - - - - - - - - - - - - - - -

    Category

    HBase

    Description

    Interface to use to access HBase.

    Values

    Specify one of these values:
    -
    -- JNI to use a JNI interface
    -- JNI_TRX to use a transactional interface with HBase-trx via JNI.
    -
    - The default value is JNI_TRX.

    -
    -
    -
    -

    10.2. Hive Environment CQDs

    +

    10.1. Hive Environment CQDs

    -

    10.2.1. HIVE_MAX_STRING_LENGTH

    +

    10.1.1. HIVE_MAX_STRING_LENGTH

    @@ -41849,9 +41980,9 @@ CHARACTER SET UTF8, with n being the value of this CQD.

    -

    10.3. Managing Histograms

    +

    10.2. Managing Histograms

    -

    10.3.1. CACHE_HISTOGRAMS_REFRESH_INTERVAL

    +

    10.2.1. CACHE_HISTOGRAMS_REFRESH_INTERVAL

    @@ -41922,7 +42053,7 @@ recently updated statistics.

    -

    10.3.2. HIST_NO_STATS_REFRESH_INTERVAL

    +

    10.2.2. HIST_NO_STATS_REFRESH_INTERVAL

    @@ -41984,7 +42115,7 @@ histogram statistics, potentially resulting in poorer plans.

    -

    10.3.3. HIST_PREFETCH

    +

    10.2.3. HIST_PREFETCH

    @@ -42034,7 +42165,7 @@ histogram statistics, potentially resulting in poorer plans.

    -

    10.3.4. HIST_ROWCOUNT_REQUIRING_STATS

    +

    10.2.4. HIST_ROWCOUNT_REQUIRING_STATS

    @@ -42088,9 +42219,9 @@ having fewer rows than set in this CQD, no warnings are displayed irrespective o
    -

    10.4. Optimizer

    +

    10.3. Optimizer

    -

    10.4.1. JOIN_ORDER_BY_USER

    +

    10.3.1. JOIN_ORDER_BY_USER

    @@ -42143,7 +42274,7 @@ the plan generated may not be the optimal one.

    -

    10.4.2. MDAM_SCAN_METHOD

    +

    10.3.2. MDAM_SCAN_METHOD

    @@ -42197,7 +42328,7 @@ In those cases you may want to set it at the service or system level.

    -

    10.4.3. SUBQUERY_UNNESTING

    +

    10.3.3. SUBQUERY_UNNESTING

    @@ -42250,9 +42381,9 @@ Use only as a workaround for observed problems due to un-nesting.

    -

    10.5. Managing Schemas

    +

    10.4. Managing Schemas

    -

    10.5.1. SCHEMA

    +

    10.4.1. SCHEMA

    @@ -42303,9 +42434,9 @@ The default is SEABASE.

    -

    10.6. Transaction Control and Locking

    +

    10.5. Transaction Control and Locking

    -

    10.6.1. BLOCK_TO_PREVENT_HALLOWEEN

    +

    10.5.1. BLOCK_TO_PREVENT_HALLOWEEN

    @@ -42381,7 +42512,7 @@ then this default should be set to 'ON' only for that service level. Otherwise t
    -

    10.6.2. UPD_ORDERED

    +

    10.5.2. UPD_ORDERED

    http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/87aa78a9/docs/sql_reference/integration.html ---------------------------------------------------------------------- diff --git a/docs/sql_reference/integration.html b/docs/sql_reference/integration.html index fb1bb13..63e7060 100644 --- a/docs/sql_reference/integration.html +++ b/docs/sql_reference/integration.html @@ -1,5 +1,5 @@ - + @@ -10,7 +10,7 @@ @import url("./css/site.css"); - + @@ -27,7 +27,7 @@
    - Last Published: 2016-02-24 + Last Published: 2016-03-03  | Version: 2.0.0
    Trafodion SQL Reference Manual http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/87aa78a9/docs/sql_reference/issue-tracking.html ---------------------------------------------------------------------- diff --git a/docs/sql_reference/issue-tracking.html b/docs/sql_reference/issue-tracking.html index 2da1744..5bc0f03 100644 --- a/docs/sql_reference/issue-tracking.html +++ b/docs/sql_reference/issue-tracking.html @@ -1,5 +1,5 @@ - + @@ -10,7 +10,7 @@ @import url("./css/site.css"); - + @@ -27,7 +27,7 @@
    - Last Published: 2016-02-24 + Last Published: 2016-03-03  | Version: 2.0.0
    Trafodion SQL Reference Manual http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/87aa78a9/docs/sql_reference/license.html ---------------------------------------------------------------------- diff --git a/docs/sql_reference/license.html b/docs/sql_reference/license.html index 2254bd4..0201df7 100644 --- a/docs/sql_reference/license.html +++ b/docs/sql_reference/license.html @@ -1,5 +1,5 @@ - + @@ -10,7 +10,7 @@ @import url("./css/site.css"); - + @@ -27,7 +27,7 @@
    - Last Published: 2016-02-24 + Last Published: 2016-03-03  | Version: 2.0.0
    Trafodion SQL Reference Manual http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/87aa78a9/docs/sql_reference/mail-lists.html ---------------------------------------------------------------------- diff --git a/docs/sql_reference/mail-lists.html b/docs/sql_reference/mail-lists.html index 1843d5d..d4b55db 100644 --- a/docs/sql_reference/mail-lists.html +++ b/docs/sql_reference/mail-lists.html @@ -1,5 +1,5 @@ - + @@ -10,7 +10,7 @@ @import url("./css/site.css"); - + @@ -27,7 +27,7 @@
    - Last Published: 2016-02-24 + Last Published: 2016-03-03  | Version: 2.0.0
    Trafodion SQL Reference Manual http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/87aa78a9/docs/sql_reference/project-info.html ---------------------------------------------------------------------- diff --git a/docs/sql_reference/project-info.html b/docs/sql_reference/project-info.html index ef64955..4ede807 100644 --- a/docs/sql_reference/project-info.html +++ b/docs/sql_reference/project-info.html @@ -1,5 +1,5 @@ - + @@ -10,7 +10,7 @@ @import url("./css/site.css"); - + @@ -27,7 +27,7 @@
    - Last Published: 2016-02-24 + Last Published: 2016-03-03  | Version: 2.0.0
    Trafodion SQL Reference Manual http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/87aa78a9/docs/sql_reference/project-summary.html ---------------------------------------------------------------------- diff --git a/docs/sql_reference/project-summary.html b/docs/sql_reference/project-summary.html index b9e41ac..703141b 100644 --- a/docs/sql_reference/project-summary.html +++ b/docs/sql_reference/project-summary.html @@ -1,5 +1,5 @@ - + @@ -10,7 +10,7 @@ @import url("./css/site.css"); - + @@ -27,7 +27,7 @@
    - Last Published: 2016-02-24 + Last Published: 2016-03-03  | Version: 2.0.0
    Trafodion SQL Reference Manual http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/87aa78a9/docs/sql_reference/source-repository.html ---------------------------------------------------------------------- diff --git a/docs/sql_reference/source-repository.html b/docs/sql_reference/source-repository.html index 0ac58b3..8b6ea88 100644 --- a/docs/sql_reference/source-repository.html +++ b/docs/sql_reference/source-repository.html @@ -1,5 +1,5 @@ - + @@ -10,7 +10,7 @@ @import url("./css/site.css"); - + @@ -27,7 +27,7 @@
    - Last Published: 2016-02-24 + Last Published: 2016-03-03  | Version: 2.0.0
    Trafodion SQL Reference Manual http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/87aa78a9/docs/sql_reference/team-list.html ---------------------------------------------------------------------- diff --git a/docs/sql_reference/team-list.html b/docs/sql_reference/team-list.html index 89a9795..154ddee 100644 --- a/docs/sql_reference/team-list.html +++ b/docs/sql_reference/team-list.html @@ -1,5 +1,5 @@ - + @@ -10,7 +10,7 @@ @import url("./css/site.css"); - + @@ -27,7 +27,7 @@
    - Last Published: 2016-02-24 + Last Published: 2016-03-03  | Version: 2.0.0
    Trafodion SQL Reference Manual http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/87aa78a9/documentation.html ---------------------------------------------------------------------- diff --git a/documentation.html b/documentation.html index 49f9b52..031792e 100644 --- a/documentation.html +++ b/documentation.html @@ -1,7 +1,7 @@ @@ -20,7 +20,6 @@ - @@ -58,12 +57,12 @@ - Apache Trafodion + Apache Trafodion
    @@ -351,6 +343,9 @@ Release Notes
  • + Wiki +
  • +
  • Managing Trafodion
  • @@ -363,6 +358,9 @@ Presentations
  • + Logo +
  • +
  • Mailing List
  • @@ -505,7 +503,6 @@ - http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/87aa78a9/download.html ---------------------------------------------------------------------- diff --git a/download.html b/download.html index c7aa4e1..a23851a 100644 --- a/download.html +++ b/download.html @@ -1,7 +1,7 @@ @@ -20,7 +20,6 @@ - @@ -58,12 +57,12 @@ - Apache Trafodion + Apache Trafodion -

    The Trafodion Installer performs all the operations required to install and start Trafodion. Type initialize trafodion; when the trafci prompt (>>) appears.

    -

    Example

    -
    -
    -
    Apache Trafodion Conversational Interface 1.3.0
    -Copyright (c) 2015 Apache Software Foundation
    ->> initialize trafodion;
    ---- SQL operation complete.
    ->>
    -
    -End of MXCI Session
    -
    -***INFO: Installation completed successfully.
    -
    -
    -
    +

    The Trafodion Installer performs all the operations required to install and start Trafodion. Wait for it to complete before continuing to the next step.

    Verify Installation

    @@ -416,6 +393,9 @@ swstatus Release Notes
  • + Wiki +
  • +
  • Managing Trafodion
  • @@ -428,6 +408,9 @@ swstatus Presentations
  • + Logo +
  • +
  • Mailing List
  • @@ -570,7 +553,6 @@ swstatus - http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/87aa78a9/enable-secure-trafodion.html ---------------------------------------------------------------------- diff --git a/enable-secure-trafodion.html b/enable-secure-trafodion.html index 56f911a..414d88b 100644 --- a/enable-secure-trafodion.html +++ b/enable-secure-trafodion.html @@ -1,7 +1,7 @@ @@ -20,7 +20,6 @@ - @@ -58,12 +57,12 @@ - Apache Trafodion + Apache Trafodion