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 2016/05/05 23:39:47 UTC
[16/22] incubator-trafodion git commit: Prepared documents for TLP
and centralized shared information.
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/21d6d8d3/docs/cqd_reference/src/asciidoc/_chapters/about.adoc
----------------------------------------------------------------------
diff --git a/docs/cqd_reference/src/asciidoc/_chapters/about.adoc b/docs/cqd_reference/src/asciidoc/_chapters/about.adoc
index 732a6ce..51dac34 100644
--- a/docs/cqd_reference/src/asciidoc/_chapters/about.adoc
+++ b/docs/cqd_reference/src/asciidoc/_chapters/about.adoc
@@ -20,18 +20,18 @@
* under the License.
*
* @@@ END COPYRIGHT @@@
- */
+*/
////
= About This Document
-This guide describes Trafodion Control Query Defaults (CQDs) that are used to override
+This guide describes {project-name} Control Query Defaults (CQDs) that are used to override
system-level default settings.
== Intended Audience
This guide is intended for database administrators and application programmers who want to
-use CQDs to override system-default settings when querying a Trafodion database.
+use CQDs to override system-default settings when querying a {project-name} database.
== New and Changed Information
@@ -161,19 +161,8 @@ match-value [NOT] LIKE _pattern
[ESCAPE esc-char-expression]
```
-== Publishing History
-[cols="2*",options="header"]
-|===
-| Product Version | Publication Date
-| Trafodion Release 1.3.0 | January 2016.
-|===
-
== Comments Encouraged
-The Trafodion community encourages your comments concerning this document. We are committed to providing documentation that meets your
-needs. Send any errors found, suggestions for improvement, or compliments to:
-
-issues@trafodion.incubator.apache.org
+We encourage your comments concerning this document. We are committed to providing documentation that meets your
+needs. Send any errors found, suggestions for improvement, or compliments to {project-support}.
-Include the document title and any comment, error found, or suggestion for improvement you have concerning this document. Or, even
-better, join our community and help us improve our documentation. Please refer to
-http://trafodion.incubator.apache.org/contributing_redirect.html[Trafodion Contributor Guide] for details.
+Include the document title and any comment, error found, or suggestion for improvement you have concerning this document.
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/21d6d8d3/docs/cqd_reference/src/asciidoc/_chapters/debugging.adoc
----------------------------------------------------------------------
diff --git a/docs/cqd_reference/src/asciidoc/_chapters/debugging.adoc b/docs/cqd_reference/src/asciidoc/_chapters/debugging.adoc
index 3d50322..76bf6e9 100644
--- a/docs/cqd_reference/src/asciidoc/_chapters/debugging.adoc
+++ b/docs/cqd_reference/src/asciidoc/_chapters/debugging.adoc
@@ -20,7 +20,7 @@
* under the License.
*
* @@@ END COPYRIGHT @@@
- */
+*/
////
[[debugging]]
@@ -40,12 +40,12 @@ This section describes CQDs that are used for debugging controls.
Default: *'0'*.
| *Usage* |
See See https://cwiki.apache.org/confluence/display/TRAFODION/Tutorial%3A+The+object-oriented+UDF+interface#Tutorial:Theobject-orientedUDFinterface-DebuggingUDFcode[UDF Tutorial].
-| *Production Usage* | Consult the Trafodion community.
+| *Production Usage* | Please contact {project-support}.
| *Impact* | Not applicable.
| *Level* | Session.
| *Conflicts/Synergies* | Not applicable.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
@@ -62,12 +62,12 @@ See See https://cwiki.apache.org/confluence/display/TRAFODION/Tutorial%3A+The+ob
Default: *'0'*.
| *Usage* |
See See https://cwiki.apache.org/confluence/display/TRAFODION/Tutorial%3A+The+object-oriented+UDF+interface#Tutorial:Theobject-orientedUDFinterface-DebuggingUDFcode[UDF Tutorial].
-| *Production Usage* | Consult the Trafodion community.
+| *Production Usage* | Please contact {project-support}.
| *Impact* | Not applicable.
| *Level* | Session.
| *Conflicts/Synergies* | Not applicable.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
@@ -84,12 +84,12 @@ See See https://cwiki.apache.org/confluence/display/TRAFODION/Tutorial%3A+The+ob
Default: *'0'*.
| *Usage* |
See See https://cwiki.apache.org/confluence/display/TRAFODION/Tutorial%3A+The+object-oriented+UDF+interface#Tutorial:Theobject-orientedUDFinterface-DebuggingUDFcode[UDF Tutorial].
-| *Production Usage* | Consult the Trafodion community.
+| *Production Usage* | Please contact {project-support}.
| *Impact* | Not applicable.
| *Level* | Session.
| *Conflicts/Synergies* | Not applicable.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/21d6d8d3/docs/cqd_reference/src/asciidoc/_chapters/histograms.adoc
----------------------------------------------------------------------
diff --git a/docs/cqd_reference/src/asciidoc/_chapters/histograms.adoc b/docs/cqd_reference/src/asciidoc/_chapters/histograms.adoc
index 7086d90..4e1535b 100644
--- a/docs/cqd_reference/src/asciidoc/_chapters/histograms.adoc
+++ b/docs/cqd_reference/src/asciidoc/_chapters/histograms.adoc
@@ -20,7 +20,7 @@
* under the License.
*
* @@@ END COPYRIGHT @@@
- */
+*/
////
[[manage-histograms]]
@@ -55,7 +55,7 @@ the histograms. More obsolete histograms may result in poor performance for quer
| *Level* | System or Service.
| *Conflicts/Synergies* | Frequency of update statistics run using MAINTAIN.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
@@ -100,7 +100,7 @@ may not bring commensurate benefit to a large number of queries.
| *Level* | System.
| *Conflicts/Synergies* | Not applicable.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
@@ -128,7 +128,7 @@ then the compiler may be working with obsolete histogram statistics, potentially
| *Level* | Service.
| *Conflicts/Synergies* | Not applicable.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
@@ -150,7 +150,7 @@ The default value is *'ON'*.
| *Level* | System or Service.
| *Conflicts/Synergies* | Use this CQD with <<cache-histograms,CACHE_HISTOGRAMS>>. If CACHE_HISTOGRAMS is OFF, then this CQD has no effect.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
@@ -160,7 +160,7 @@ The default value is *'ON'*.
[cols="25%h,75%"]
|===
-| *Description* | Specifies the minimum row count for which the Trafodion Optimizer needs histograms, in order to compute better cardinality estimates.
+| *Description* | Specifies the minimum row count for which the {project-name} Optimizer needs histograms, in order to compute better cardinality estimates.
The Optimizer does not issue any missing statistics warnings for tables whose size is smaller than the value of this CQD.
| *Values* | Integer. +
+
@@ -173,7 +173,7 @@ However, there may be some exceptions where missing statistics on small tables c
| *Conflicts/Synergies* | Use this CQD with <<hist-missing-stats-warning-level,HIST_MISSING_STATS_WARNING_LEVEL>>. If the warning level CQD is 0,
then this CQD does not have any effect. Also, for tables having fewer rows than set in this CQD, no warnings are displayed irrespective of the warning level.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
@@ -202,6 +202,6 @@ However, it can also increase the compile time.
| *Level* | Any.
| *Conflicts/Synergies* | In order to use the feature in its default form, sample tables should exist in `public_access_schema`.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/21d6d8d3/docs/cqd_reference/src/asciidoc/_chapters/introduction.adoc
----------------------------------------------------------------------
diff --git a/docs/cqd_reference/src/asciidoc/_chapters/introduction.adoc b/docs/cqd_reference/src/asciidoc/_chapters/introduction.adoc
index fe3be20..96c5917 100644
--- a/docs/cqd_reference/src/asciidoc/_chapters/introduction.adoc
+++ b/docs/cqd_reference/src/asciidoc/_chapters/introduction.adoc
@@ -20,14 +20,14 @@
* under the License.
*
* @@@ END COPYRIGHT @@@
- */
+*/
////
[[introduction]]
= Introduction
Refer to the
-http://trafodion.apache.org/docs/sql_reference/index.html#control_query_cancel_statement[Trafodion SQL Reference Manual]
+http://trafodion.apache.org/docs/sql_reference/index.html#control_query_cancel_statement[{project-name} SQL Reference Manual]
full documentation of the CQD (CONTROL QUERY DEFAULT) statement.
The CONTROL QUERY DEFAULT statement changes the default settings for the current process. You can execute
@@ -83,7 +83,7 @@ The following information is provided for each CQD:
+
• Values, in the form of a character string, that specify the applicable attribute values for the CQD. +
• The default attribute value. +
-• If applicable, the Trafodion release in which the attribute values or default changed.
+• If applicable, the {project-name} release in which the attribute values or default changed.
| *Usage* | Describes the conditions when the CQD is helpful, and how to detect the conditions.
| *Production Usage* | Identifies when the CQD is not safe to be used as a permanent setting in production.
| *Impact* | Describes any positive and negative implications of using the CQD.
@@ -97,6 +97,6 @@ The following information is provided for each CQD:
NOTE: This level indicates that the CQD can be used at the Query, Session or Service level as long as you fully understands the scope of the impact of the CQD.
| *Conflicts/Synergies* | Describes CQDs that are in conflict with or can be used in conjunction with the CQD.
| *Real Problem Addressed* | Describes any design or solution that the CQD may be a workaround for and how you can directly address the real problem.
-| *Introduced In Release* | Indicates the Trafodion release when the CQD was introduced.
+| *Introduced In Release* | Indicates the {project-name} release when the CQD was introduced.
| *Deprecated In Release* | Indicates in what release the CQD was deprecated.
|===
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/21d6d8d3/docs/cqd_reference/src/asciidoc/_chapters/operational_controls.adoc
----------------------------------------------------------------------
diff --git a/docs/cqd_reference/src/asciidoc/_chapters/operational_controls.adoc b/docs/cqd_reference/src/asciidoc/_chapters/operational_controls.adoc
index 8d077cf..dd4ff8b 100644
--- a/docs/cqd_reference/src/asciidoc/_chapters/operational_controls.adoc
+++ b/docs/cqd_reference/src/asciidoc/_chapters/operational_controls.adoc
@@ -20,7 +20,7 @@
* under the License.
*
* @@@ END COPYRIGHT @@@
- */
+*/
////
[[operational-controls]]
@@ -48,7 +48,7 @@ then a large number of queries may be impacted. Therefore, you need to assess if
| *Level* | System.
| *Conflicts/Synergies* | Not applicable.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
@@ -73,7 +73,7 @@ Change this setting if you see explain plan being undesirably truncated only.
| *Level* | System.
| *Conflicts/Synergies* | Not applicable.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
@@ -83,21 +83,21 @@ Change this setting if you see explain plan being undesirably truncated only.
[cols="25%h,75%"]
|===
-| *Description* | Enables Trafodion to use HBase block cache in an optimal manner. Defines the maximum Java
+| *Description* | Enables {project-name} to use HBase block cache in an optimal manner. Defines the maximum Java
heap size (-Xmx option) the HBase Region Server are assigned, in MB units.
| *Values* |
Positive integer. +
+
Default: *'1024'*.
| *Usage* | If the HBase Region servers are configured with a maximum Java heap size different than 1 GB, then
-set this attribute so that Trafodion is aware of the actual maximum heap size of the Region Servers.
+set this attribute so that {project-name} is aware of the actual maximum heap size of the Region Servers.
| *Production Usage* | Yes.
| *Impact* | When set correctly, this CQD ensures that HBase block cache are be used optimally. Small scans
are cached and larger scans are not cached to avoid cache trashing.
| *Level* | System.
| *Conflicts/Synergies* | Not applicable.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
@@ -114,19 +114,19 @@ are cached and larger scans are not cached to avoid cache trashing.
*> 0*: The cached Hive meta-data is valid only for <value> seconds. +
+
Default: *'0'*.
-| *Usage* | Use a value of -1 when the Hive tables are read-only. This allows Trafodion to avoid repeatedly reading the
+| *Usage* | Use a value of -1 when the Hive tables are read-only. This allows {project-name} to avoid repeatedly reading the
metadata when the table is referenced in multiple queries. +
+
Use a value of 0 when updates to the Hive tables are likely to be frequent. +
+
-Use a positive value _n_ to cause Trafodion to re-read metadata after n seconds has elapsed.
+Use a positive value _n_ to cause {project-name} to re-read metadata after n seconds has elapsed.
Use this option when updates to the Hive table happen at least _n_ seconds apart.
-| *Production Usage* | Consult with the Trafodion community.
+| *Production Usage* | Please contact {project-support}.
| *Impact* | Compilation time.
| *Level* | Session.
| *Conflicts/Synergies* | Not applicable.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
@@ -182,7 +182,7 @@ including case and white space. By caching text-based queries, the compiler avoi
queries and improves performance by reducing compile times and increasing compiler throughput. The text cache is always searched first for a query.
If the plan object is not produced due to a text cache miss, then the plan is stored in the template cache if it meets the criteria for template caching.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
@@ -207,7 +207,7 @@ Change the default to ON only when certain that new rows do not have a conflict
| *Level* | System.
| *Conflicts/Synergies* | Not applicable.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
@@ -230,7 +230,7 @@ Consider using lower values if the table has several indexes and is memory const
| *Level* | System.
| *Conflicts/Synergies* | Not applicable.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/21d6d8d3/docs/cqd_reference/src/asciidoc/_chapters/query_execution.adoc
----------------------------------------------------------------------
diff --git a/docs/cqd_reference/src/asciidoc/_chapters/query_execution.adoc b/docs/cqd_reference/src/asciidoc/_chapters/query_execution.adoc
index eae1ff3..91d390a 100644
--- a/docs/cqd_reference/src/asciidoc/_chapters/query_execution.adoc
+++ b/docs/cqd_reference/src/asciidoc/_chapters/query_execution.adoc
@@ -20,7 +20,7 @@
* under the License.
*
* @@@ END COPYRIGHT @@@
- */
+*/
////
[[query-execution]]
@@ -47,7 +47,7 @@ in different threads.
| *Level* | Query.
| *Conflicts/Synergies* | Not applicable.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
@@ -66,12 +66,12 @@ The default value is *'SYSTEM'*.
In LRU block cache configuration, the amount of block cache retained in memory is proportional to the amount of reserved maximum
Java heap size of the region server. LRU Block Cache is the default in HBase. +
+
-The Trafodion Optimizer determines whether a sequential scan of the HBase table in a query would cause the full eviction of the
+The {project-name} Optimizer determines whether a sequential scan of the HBase table in a query would cause the full eviction of the
data blocks cached earlier thereby impacting the performance of the random reads. The cache blocks option is turned off for the table
in such a case. +
+
Set the CQD <<hbase-region-server-max-heap-size,HBASE_REGION_SERVER_MAX_HEAP_SIZE>> value to reflect the amount of java heap size reserved for the region servers.
-This CQD is used by the Trafodion Optimizer to evaluate if the block cache should be turned off.
+This CQD is used by the {project-name} Optimizer to evaluate if the block cache should be turned off.
| *Production Usage* | Leave the setting to be 'SYSTEM' when HBase is configured to use LRU block cache. If needed,
you can override this settings with 'ON' or 'OFF'. +
+
@@ -80,7 +80,7 @@ With other HBase configurations, you need to set HBASE_CACHE_BLOCKS to 'ON' or '
| *Level* | Query.
| *Conflicts/Synergies* | Not applicable.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
@@ -104,12 +104,12 @@ An explain plan can show whether predicates are successfully pushed down to the
The default value is *'OFF'*.
| *Usage* | Used to improve performance by reducing the number of columns retrieved to a strict minimum
and filter out rows as early as possible.
-| *Production Usage* | Please consult the Trafodion community.
+| *Production Usage* | Please contact {project-support}.
| *Impact* | Using this CQD increases the amount of work done in the HBase Region Servers.
| *Level* | System or Session.
| *Conflicts/Synergies* | Not applicable.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 2.0.0.
+| *Introduced In Release* | {project-name} 2.0.0.
| *Deprecated In Release* | Not applicable.
|===
@@ -119,10 +119,10 @@ and filter out rows as early as possible.
[cols="25%h,75%"]
|===
-| *Description* | Treat salted Trafodion tables as hash-partitioned on the salt columns.
+| *Description* | Treat salted {project-name} tables as hash-partitioned on the salt columns.
| *Values* |
-*'OFF'*: Salted Trafodion tables are not hash-partitioned on the salt columns. +
-*'ON'*: Salted Trafodion tables are hash-partitioned on the salt columns. +
+*'OFF'*: Salted {project-name} tables are not hash-partitioned on the salt columns. +
+*'ON'*: Salted {project-name} tables are hash-partitioned on the salt columns. +
+
The default value is *'ON'*.
| *Usage* | If, for any reason, there are issues with parallel plans on salted tables (especially with data skew) then try setting this CQD to OFF.
@@ -131,7 +131,7 @@ The default value is *'ON'*.
| *Level* | System or Session.
| *Conflicts/Synergies* | Not applicable.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 2.0.0.
+| *Introduced In Release* | {project-name} 2.0.0.
| *Deprecated In Release* | Not applicable.
|===
@@ -151,13 +151,13 @@ a sequential scan of a table. +
+
You need to consider how soon the maximum number of rows are materialized on the Region Servers. When filtering is pushed down to Region Servers,
then it can take a longer time depending upon the query and the predicates involved. This can result in HBase scanner timeouts.
-| *Production Usage* | Use the default setting and reduce the value to avoid HBase scanner timeouts. Consult with the Trafodion community
+| *Production Usage* | Use the default setting and reduce the value to avoid HBase scanner timeouts. Please contact {project-support}.
if you think that you need to use this CQD.
| *Impact* | Not applicable.
| *Level* | Query.
| *Conflicts/Synergies* | Not applicable.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
@@ -173,16 +173,16 @@ if you think that you need to use this CQD.
*'OFF'*: Do not perform IUD operations as an HBase batch `put` operation. +
+
The default value is *'ON'*.
-| *Usage* | When IUD operation involves multiple tuples, then the Trafodion Optimizer evaluates whether these operations
+| *Usage* | When IUD operation involves multiple tuples, then the {project-name} Optimizer evaluates whether these operations
can be done in a batch manner at the HBase level thereby reducing the network interactions between the client applications and the HBase Region Servers. +
+
-If possible, then the query plan involves VSBB operators. The Virtual Sequential Block Buffer(VSBB) name is retained in Trafodion though it is unrelated to HBase.
+If possible, then the query plan involves VSBB operators. The Virtual Sequential Block Buffer(VSBB) name is retained in {project-name} though it is unrelated to HBase.
| *Production Usage* | Yes.
| *Impact* | IUD operations can become slower if this CQD is set to 'OFF'.
| *Level* | Query.
| *Conflicts/Synergies* | Not applicable.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
@@ -197,8 +197,8 @@ If possible, then the query plan involves VSBB operators. The Virtual Sequential
Numeric value.
+
The default value is *'1024'*.
-| *Usage* | The Trafodion execution engine already adjusts the number of rows in a batch depending upon how fast
-the queue to IUD (INSERT,UPDATE,DELETE) operator is filled up in the data flow architecture of Trafodion. +
+| *Usage* | The {project-name} execution engine already adjusts the number of rows in a batch depending upon how fast
+the queue to IUD (INSERT,UPDATE,DELETE) operator is filled up in the data flow architecture of {project-name}. +
+
You can adjust the maximum size to suit your application needs and thus tune it to perform optimally.
| *Production Usage* | Yes. You can disable this feature by setting the HBASE_ROWSET_VSBB_OPT CQD to 'OFF'.
@@ -206,7 +206,7 @@ You can adjust the maximum size to suit your application needs and thus tune it
| *Level* | Query.
| *Conflicts/Synergies* | Not applicable.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
@@ -216,24 +216,24 @@ You can adjust the maximum size to suit your application needs and thus tune it
[cols="25%h,75%"]
|===
-| *Description* | Enables Trafodion to leverage the HBase small scanner optimization. This optimization reduces I/O usage up to 66%
+| *Description* | Enables {project-name} to leverage the HBase small scanner optimization. This optimization reduces I/O usage up to 66%
and enables non-blocking reads for higher concurrency support. When a scan is known to require less than a HBASE BLOCK SIZE (default is 64K),
then enabling the HBase small scanner optimization increases performance.
| *Values* |
*'OFF'*: Never use the HBase small scanner optimization. +
-*'SYSTEM'*: Only enable the HBase small scanner optimization when the Trafodion Compiler determines that the scan size will fit in the table's HBASE BLOCK SIZE +
+*'SYSTEM'*: Only enable the HBase small scanner optimization when the {project-name} Compiler determines that the scan size will fit in the table's HBASE BLOCK SIZE +
*'ON'*: Enable the HBase small scanner optimization regardless of the size of scan. +
+
The default value is *'OFF'*.
| *Usage* | Consider using this CQD to improve the performance of your queries.
-| *Production Usage* | Consult with the Trafodion community.
+| *Production Usage* | Please contact {project-support}.
| *Impact* | The performance of small scan may increase by 1.4x. This CQD can be very useful for MDAM scans.
| *Level* | System or Session.
| *Conflicts/Synergies* | MDAM performance may be improved by 1.4x when correctly picking HBase block size so that each MDAM scan operation fit within a HBASE BLOCK SIZE boundary. +
+
If you enable small scanner on large size scan incorrectly, then you are likely to see a 6% performance decrease. The returned results will still be correct.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 2.0.0.
+| *Introduced In Release* | {project-name} 2.0.0.
| *Deprecated In Release* | Not applicable.
|===
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/21d6d8d3/docs/cqd_reference/src/asciidoc/_chapters/query_plans.adoc
----------------------------------------------------------------------
diff --git a/docs/cqd_reference/src/asciidoc/_chapters/query_plans.adoc b/docs/cqd_reference/src/asciidoc/_chapters/query_plans.adoc
index c72aa46..2791e96 100644
--- a/docs/cqd_reference/src/asciidoc/_chapters/query_plans.adoc
+++ b/docs/cqd_reference/src/asciidoc/_chapters/query_plans.adoc
@@ -20,7 +20,7 @@
* under the License.
*
* @@@ END COPYRIGHT @@@
- */
+*/
////
[[query-plans]]
@@ -56,7 +56,7 @@ elapsed time for some of the longer running queries that leverage adaptive segme
parallelism only for a certain set of queries and use it at the service level.
| *Conflicts/Synergies* | Not applicable.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
@@ -66,7 +66,7 @@ parallelism only for a certain set of queries and use it at the service level.
[cols="25%h,75%"]
|===
-| *Description* | Determines whether the Trafodion Optimizer considers Hash Join when generating an execution plan.
+| *Description* | Determines whether the {project-name} Optimizer considers Hash Join when generating an execution plan.
| *Values* |
*'ON'* Hash Join is considered. +
*'OFF'* Hash Join is not considered. +
@@ -79,7 +79,7 @@ It is highly recommended that you do not turn HASH_JOINS OFF; that is, this CQD
| *Level* | Query.
| *Conflicts/Synergies* | If you turn all three join implementations OFF (Hash Joins, Nested Joins, and Merge Joins), then the compiler may fail to generate query plans.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
@@ -95,17 +95,17 @@ It is highly recommended that you do not turn HASH_JOINS OFF; that is, this CQD
*'OFF'*: Do not use HBase coprocessors. +
+
The default value is *'ON'*.
-| *Usage* | Enables Trafodion to use HBase coprocessors to do early aggregation and filtering
-at the HBase Region Server level. This CQD does not affect Transaction coprocessors used by Trafodion. +
+| *Usage* | Enables {project-name} to use HBase coprocessors to do early aggregation and filtering
+at the HBase Region Server level. This CQD does not affect Transaction coprocessors used by {project-name}. +
+
As of Release 2.0 only COUNT(*) queries will be affected by this attribute.
| *Production Usage* | Yes.
-| *Impact* | Network traffic between Region Server and Trafodion processes is reduced but
+| *Impact* | Network traffic between Region Server and {project-name} processes is reduced but
the Region Server can become very busy when aggregating over large tables.
| *Level* | Query.
| *Conflicts/Synergies* | Not applicable.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
@@ -129,7 +129,7 @@ On the other hand decreasing the attribute to 1 could help with concurrency.
| *Conflicts/Synergies* | The CQD <<hive-min-bytes-per-esp-partition,HIVE_MIN_BYTES_PER_ESP_PARTITION>> (default = 67108864) may need to be adjusted downward
when this attribute is used to increase the parallelism of scanning smaller Hive tables.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
@@ -155,7 +155,7 @@ specified in the FROM clause, the plan generated may not be the optimal one.
| *Level* | Query.
| *Conflicts/Synergies* | Not applicable.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
@@ -183,12 +183,12 @@ A value of *0* treats every multi-column value as skew values. This may increase
side child of the hash join to all join processes. +
+
A value *greater than 0* selects those multi-column values as skewed values if their occurrence frequencies are high enough.
-| *Production Usage* | Consult the Trafodion community.
+| *Production Usage* | Please contact {project-support}.
| *Impact* | This CQD impacts runtime performance.
| *Level* | Session.
| *Conflicts/Synergies* | Not applicable.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
@@ -199,7 +199,7 @@ A value *greater than 0* selects those multi-column values as skewed values if t
[cols="25%h,75%"]
|===
| *Description* | This CQD effects the behavior of the query optimizer when there are no statistics available for a query
-having range predicates on key columns. The Trafodion Optimizer calculates the worst case number of seeks that the MDAM access method
+having range predicates on key columns. The {project-name} Optimizer calculates the worst case number of seeks that the MDAM access method
would do if chosen for the query. +
+
If this number is greater than the value of MDAM_NO_STATS_POSITIONS_THRESHOLD, then MDAM is not considered for the query execution plan.
@@ -210,13 +210,13 @@ Default value: *10*.
| *Usage* | In certain situations, queries on tables lacking statistics may not be optimal because MDAM was not chosen.
Increasing the value for this CQD allows MDAM to be chosen in more cases. On the other hand, if the value is made too high and the worst case
scenario actually occurs, an MDAM plan may perform poorly.
-| *Production Usage* | Consult the Trafodion community.
+| *Production Usage* | Please contact {project-support}.
| *Impact* | Table scans on tables lacking statistics may improve by varying the value of this CQD.
Results vary depending on the actual data in the table and the semantics of the query.
| *Level* | Query.
| *Conflicts/Synergies* | If <<mdam-scan-method,MDAM_SCAN_METHOD>> is set to *'OFF'*, then this CQD has no effect.
| *Real Problem Addressed* | Perform UPDATE STATISTICS on the table (at the very least on key columns) to obtain statistics.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
@@ -233,7 +233,7 @@ Results vary depending on the actual data in the table and the semantics of the
*'OFF'* MDAM is disabled. +
+
The default value is *'ON'*.
-| *Usage* | In certain situations, the Trafodion Optimizer might choose MDAM inappropriately, causing poor performance.
+| *Usage* | In certain situations, the {project-name} Optimizer might choose MDAM inappropriately, causing poor performance.
In such situations you may want to turn MDAM OFF for the query it is effecting.
| *Production Usage* | Yes.
| *Impact* | Table scans with predicates on non-leading clustering key column(s) could benefit from MDAM access
@@ -243,7 +243,7 @@ there may be cases (usually a defect) where a larger set of queries is being neg
to set it at the service or system level.
| *Conflicts/Synergies* | Not applicable.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
@@ -272,9 +272,9 @@ time because the optimizer now has to consider many more join options.
there may be cases (usually a defect) where a larger set of queries is being negatively impacted by Merge Joins. In those cases you may want to
set it at the service or system level.
| *Conflicts/Synergies* | Avoid turning all the three join implementations OFF (Hash Joins, Nested Joins, and Merge Joins).
-This may result in the Trafodion Compiler failing to generate query plans.
+This may result in the {project-name} Compiler failing to generate query plans.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
@@ -302,7 +302,7 @@ such as light workloads and star join queries.
This may result in the compiler failing to generate query plans.
| *Real Problem Addressed* | The problem of inefficient Nested Joins can be better handled using a higher degree of query plan
robustness as set by the <<robust-query-optimization,ROBUST_QUERY_OPTIMIZATION>> CQD.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
@@ -327,7 +327,7 @@ Increasing the optimization level over the system default may result in very hig
| *Level* | Query.
| *Conflicts/Synergies* | Not applicable.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
@@ -352,7 +352,7 @@ query workloads, but has the potential disadvantage of increasing the elapsed ti
| *Level* | Service.
| *Conflicts/Synergies* | Not applicable.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
@@ -378,7 +378,7 @@ may be used to influence the optimizer to consider another join instead, such as
+
NESTED_JOINS OFF could turn nested joins off completely. However, there are many cases where nested joins do provide better performance than hash
joins, and turning them off completely may negatively impact the performance of queries that can do a lot better with nested joins.
-| *Production Usage* | Consult with the Trafodion community.
+| *Production Usage* | Please contact {project-support}.
| *Impact* | Specifying a risk premium insures against nested joins being chosen when they should not have been. However,
this can also result in nested joins not being chosen where the cardinality estimation was in fact accurate and a nested join could have
performed better. Therefore, this setting should be used with care in order to get robustness with a net gain in performance.
@@ -388,7 +388,7 @@ than other workloads. In such cases this could be used at the Service level.
influencing the nested join risk premium as well. It is advisable that you use that setting instead to influence plans, unless they are specifically
addressing nested join issues and need to use this setting independent of that CQD.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
@@ -411,7 +411,7 @@ allowed to win over competing parallel plans. +
+
If it is determined that the optimizer is using serial plans often enough where these plans are resulting in poor performance, then this CQD
may be used to influence the optimizer to consider parallel plans instead in some of those cases. +
-| *Production Usage* | Consult with the Trafodion community.
+| *Production Usage* | Please contact {project-support}.
| *Impact* | Specifying a risk premium insures against serial plans being chosen when they should not have been.
However, this can also result in serial plans not being chosen where the cardinality estimation was in fact accurate and a serial plan
could have performed better. Therefore, this setting should be used with care in order to get robustness with a net gain in performance.
@@ -421,7 +421,7 @@ CQD more than other workloads. In such cases this could be used at the Service l
influencing the serial plan risk premium as well. It is advised that you use that setting instead to influence plans, unless they are specifically
addressing serial plan issues and need to use this setting independent of that CQD.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
@@ -434,7 +434,7 @@ addressing serial plan issues and need to use this setting independent of that C
| *Description* | Defines the minimal estimated max cardinality or row count of any relational operators in a query above
which the risk premium for serial plan is applied. +
+
-A serial query plan is favored by the Trafodion Compiler when it estimates the query reads and processes small amount of data.
+A serial query plan is favored by the {project-name} Compiler when it estimates the query reads and processes small amount of data.
The estimation error could become large when some operator is calculated to produce many rows yielding a non-optimal serial plan.
This CQD helps prevent utilizing serial plan in such cases.
| *Values* | An unsigned integer value.
@@ -442,12 +442,12 @@ This CQD helps prevent utilizing serial plan in such cases.
+
Use of a value smaller than the default (10,000) to penalize more serial plans or favor more parallel plans for operators produce less number of rows.
Otherwise, use of a larger value.
-| *Production Usage* | Consult with the Trafodion community.
+| *Production Usage* | Please contact {project-support}.
| *Impact* | This CQD impacts plan quality.
| *Level* | Session.
| *Conflicts/Synergies* | Not applicable.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
@@ -529,7 +529,7 @@ use the individual CQDs at a finer granularity, such as at a query level, to get
or serial plan being chosen when it shouldn't have been, may be due to not enough, or inaccurate, histogram statistics information available
to the optimizer. So, first and foremost, histogram statistics should be kept up to date along with the multi-column statistics that the
optimizer may warn about. However, cardinality underestimations may still happen at higher levels of an execution plan.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
@@ -551,7 +551,7 @@ The default value is *'OFF'*.
| *Level* | Any.
| *Conflicts/Synergies* | Allows additional information to be displayed in explain plans. It has no impact on query plans.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
@@ -590,7 +590,7 @@ information about the table skew, the query, and the value that worked. Filing a
| *Conflicts/Synergies* | SKEW_EXPLAIN can be used as described in above. Also, <<skew-sensitivity-threshold,SKEW_SENSITIVITY_THRESHOLD>>
is relevant if this threshold allows a skew to be detected only.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
@@ -623,7 +623,7 @@ as it effectively turns off skew buster.
The <<skew-rowcount-threshold,SKEW_ROWCOUNT_THRESHOLD CQD>> controls the row count of the table at which the optimizer looks for a skew.
| *Real Problem Addressed* | Skew is quite common in a real big-data application, and is effectively addressed by skew buster.
However, there may be design opportunities that could help address the problem as well.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
@@ -640,13 +640,13 @@ However, there may be design opportunities that could help address the problem a
+
The default value is *'ON'*.
| *Usage* | Turn this CQD OFF when (in rare cases) unnesting a correlated subquery causes performance to degrade.
-If this attribute has to be turned OFF, then that could indicate a bug in the Trafodion Optimizer. Consult with the Trafodion community.
+If this attribute has to be turned OFF, then that could indicate a bug in the {project-name} Optimizer. Please contact {project-support}.
| *Production Usage* | Yes.
| *Impact* | Turn OFF with caution at a system level, as other queries which rely on un-nesting could be adversely impacted.
| *Level* | Query.
| *Conflicts/Synergies* | Not applicable.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
@@ -664,12 +664,12 @@ network traffic between the ESP processes and the HBase Region Servers.
+
The default value is *'OFF'*.
| *Usage* | Enable the feature when each region server serves approximately equal amount of data, and/or reducing network traffic is important.
-| *Production Usage* | Consult with the Trafodion community.
+| *Production Usage* | Please contact {project-support}.
| *Impact* | Plan quality.
| *Level* | Session.
| *Conflicts/Synergies* | Not applicable.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
@@ -697,7 +697,7 @@ which improves the performance of the UPSERT statements with omitted default val
| *Level* | Query.
| *Conflicts/Synergies* | Not applicable.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
@@ -722,6 +722,6 @@ you could set this CQD to OFF.
| *Level* | Query.
| *Conflicts/Synergies* | Not applicable.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/21d6d8d3/docs/cqd_reference/src/asciidoc/_chapters/runtime_controls.adoc
----------------------------------------------------------------------
diff --git a/docs/cqd_reference/src/asciidoc/_chapters/runtime_controls.adoc b/docs/cqd_reference/src/asciidoc/_chapters/runtime_controls.adoc
index 4196115..2b727a6 100644
--- a/docs/cqd_reference/src/asciidoc/_chapters/runtime_controls.adoc
+++ b/docs/cqd_reference/src/asciidoc/_chapters/runtime_controls.adoc
@@ -20,7 +20,7 @@
* under the License.
*
* @@@ END COPYRIGHT @@@
- */
+*/
////
[[runtime-controls]]
@@ -45,7 +45,7 @@ returning the rows to the client. It is especially useful for testing the plans
| *Conflicts/Synergies* | Not to be confused with SELECT [LAST 0] which behaves the same way but does not guarantee that the plan
is the same as when you do not use the [LAST 0] clause in the query.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
@@ -76,6 +76,6 @@ However, if the default is set too low, then even well behaved, useful queries f
| *Level* | Service.
| *Conflicts/Synergies* | Not applicable.
| *Real Problem Addressed* | Use standard processed for creating high-quality queries, and procedures that ensure that table histograms are always current.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/21d6d8d3/docs/cqd_reference/src/asciidoc/_chapters/schema_controls.adoc
----------------------------------------------------------------------
diff --git a/docs/cqd_reference/src/asciidoc/_chapters/schema_controls.adoc b/docs/cqd_reference/src/asciidoc/_chapters/schema_controls.adoc
index 0f84bb0..9a64c0b 100644
--- a/docs/cqd_reference/src/asciidoc/_chapters/schema_controls.adoc
+++ b/docs/cqd_reference/src/asciidoc/_chapters/schema_controls.adoc
@@ -20,7 +20,7 @@
* under the License.
*
* @@@ END COPYRIGHT @@@
- */
+*/
////
[[schema-controls]]
@@ -37,7 +37,7 @@ This section describes CQDs that are used for schema controls.
| *Values* | Any valid ANSI name, including delimited names. +
+
The default is *'TRAFODION'*.
-| *Usage* | Trafodion tables must be in a catalog called TRAFODION. If you mostly access Hive or native HBase tables,
+| *Usage* | {project-name} tables must be in a catalog called TRAFODION. If you mostly access Hive or native HBase tables,
then the catalog could be changed to HIVE or HBASE respectively. +
+
The default setting is overridden by any catalog name specified in a SQL statement.
@@ -46,7 +46,7 @@ The default setting is overridden by any catalog name specified in a SQL stateme
| *Level* | Any.
| *Conflicts/Synergies* | Alternately you can use the SET CATALOG statement.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
@@ -66,6 +66,6 @@ The default is *'TRAFODION'*.
| *Level* | Any.
| *Conflicts/Synergies* | Alternately you can use the SET SCHEMA statement.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/21d6d8d3/docs/cqd_reference/src/asciidoc/_chapters/table_definition.adoc
----------------------------------------------------------------------
diff --git a/docs/cqd_reference/src/asciidoc/_chapters/table_definition.adoc b/docs/cqd_reference/src/asciidoc/_chapters/table_definition.adoc
index 0a93dce..169638c 100644
--- a/docs/cqd_reference/src/asciidoc/_chapters/table_definition.adoc
+++ b/docs/cqd_reference/src/asciidoc/_chapters/table_definition.adoc
@@ -20,7 +20,7 @@
* under the License.
*
* @@@ END COPYRIGHT @@@
- */
+*/
////
[[table_definition]]
@@ -33,20 +33,20 @@ This section describes CQDs that are used for table definition
[cols="25%h,75%"]
|===
-| *Description* | Allow Trafodion tables to be created with NULLABLE columns in the PRIMARY or STORE BY key.
+| *Description* | Allow {project-name} tables to be created with NULLABLE columns in the PRIMARY or STORE BY key.
| *Values* | *'ON'* or *'OFF'* +
+
The default value is *'OFF'*.
-| *Usage* | Allows NULLABLE columns to be included in the PRIMARY or STORE BY key for Trafodion tables.
+| *Usage* | Allows NULLABLE columns to be included in the PRIMARY or STORE BY key for {project-name} tables.
This CQD must be set prior to creating the table. It is not necessary to specify this CQD during DML operations on the table. +
+
When performing UPDATE STATISTICS with SAMPLE option on such tables, this CQD must be set so that an appropriate sample table can be created.
-| *Production Usage* | Please consult with the Trafodion community.
+| *Production Usage* | Please contact {project-support}.
| *Impact* | Two bytes are added to the key for each nullable column.
| *Level* | Session.
| *Conflicts/Synergies* | Not applicable.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
@@ -56,11 +56,11 @@ When performing UPDATE STATISTICS with SAMPLE option on such tables, this CQD mu
[cols="25%h,75%"]
|===
-| *Description* | Allow Trafodion tables to be created with specified HBase block size.
+| *Description* | Allow {project-name} tables to be created with specified HBase block size.
| *Values* | Positive integer. +
+
The default value is *'65536'*.
-| *Usage* | The value of this attribute is passed on to HBase when a Trafodion table is created in HBase.
+| *Usage* | The value of this attribute is passed on to HBase when a {project-name} table is created in HBase.
See the https://hbase.apache.org/book.html[Apache HBase(TM) Reference Guide] for usage information .
| *Production Usage* | Yes.
| *Impact* | The impact depends on the type of table access. Choose a block size that is appropriate
@@ -68,7 +68,7 @@ for how the table is primarily accessed.
| *Level* | System.
| *Conflicts/Synergies* | Not applicable.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
@@ -89,7 +89,7 @@ Default: *'UTF8'*
| *Level* | System.
| *Conflicts/Synergies* | Not applicable.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
@@ -99,8 +99,8 @@ Default: *'UTF8'*
[cols="25%h,75%"]
|===
-| *Description* | For certain character sets that are not supported in Trafodion, you can specify the character set here
-causing Trafodion to automatically convert the data to the character set specified in the HIVE_DEFAULT_CHARSET CQD. +
+| *Description* | For certain character sets that are not supported in {project-name}, you can specify the character set here
+causing {project-name} to automatically convert the data to the character set specified in the HIVE_DEFAULT_CHARSET CQD. +
+
This feature is currently supported only for *'GBK'*, and only if HIVE_DEFAULT_CHARSET is set to *'UTF8'*.
| *Values* |
@@ -113,7 +113,7 @@ Default: empty
| *Level* | System.
| *Conflicts/Synergies* | Only applicable if HIVE_DEFAULT_CHARSET is set to *'UTF8'*.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
@@ -123,7 +123,7 @@ Default: empty
[cols="25%h,75%"]
|===
-| *Description* | Hive columns of type STRING have a maximum length in Trafodion, which you can specify with this CQD. +
+| *Description* | Hive columns of type STRING have a maximum length in {project-name}, which you can specify with this CQD. +
+
*NOTE* For UTF-8 data, this length is specified in bytes, not UTF-8 characters.
| *Values* |
@@ -136,7 +136,7 @@ Default: 32000.
| *Level* | System.
| *Conflicts/Synergies* | Not applicable.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/21d6d8d3/docs/cqd_reference/src/asciidoc/_chapters/transactions.adoc
----------------------------------------------------------------------
diff --git a/docs/cqd_reference/src/asciidoc/_chapters/transactions.adoc b/docs/cqd_reference/src/asciidoc/_chapters/transactions.adoc
index 6a18aab..e0046b9 100644
--- a/docs/cqd_reference/src/asciidoc/_chapters/transactions.adoc
+++ b/docs/cqd_reference/src/asciidoc/_chapters/transactions.adoc
@@ -20,7 +20,7 @@
* under the License.
*
* @@@ END COPYRIGHT @@@
- */
+*/
////
[[transaction-control-and-locking]]
@@ -65,7 +65,7 @@ is provided. This default attribute specifies the isolation level for update and
SYSTEM_DEFAULTS table, the default value is the same as the ISOLATION_LEVEL default attribute. However, if specified or present in the SYSTEM_DEFAULTS table,
then its value is used as the isolation level for updates and DDL statements. UPDATE in ISOLATION_LEVEL_FOR_UPDATES refers to INSERT, UPDATE, and DELETE statements.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
@@ -87,6 +87,6 @@ The default value is *'READ COMMITTED'* (ANSI).
ISOLATION_LEVEL can be set to READ UNCOMMITTED. This CQD still remains READ COMMITTED. You can change it to READ UNCOMMITTED to prevent queries
running at the service level to not perform any updates.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/21d6d8d3/docs/cqd_reference/src/asciidoc/_chapters/update_stats.adoc
----------------------------------------------------------------------
diff --git a/docs/cqd_reference/src/asciidoc/_chapters/update_stats.adoc b/docs/cqd_reference/src/asciidoc/_chapters/update_stats.adoc
index 9695e3f..b683897 100644
--- a/docs/cqd_reference/src/asciidoc/_chapters/update_stats.adoc
+++ b/docs/cqd_reference/src/asciidoc/_chapters/update_stats.adoc
@@ -20,7 +20,7 @@
* under the License.
*
* @@@ END COPYRIGHT @@@
- */
+*/
////
[[update-statistics-and-reorg]]
@@ -47,7 +47,7 @@ However, if a table is not used frequently, then this CQD influences how frequen
+
A smaller setting reduces the number of histograms being updated if there are many tables that have not been used within that interval.
A larger setting updates histogram for many more tables that are not being accessed that often.
-| *Production Usage* | Consult the Trafodion community.
+| *Production Usage* | Please contact {project-support}.
| *Impact* | Influences the number of histograms that need to be regenerated and therefore the time it takes for
update statistics automation to regenerate histograms for all the tables that so qualify.
| *Level* | System.
@@ -56,7 +56,7 @@ update statistics automation to regenerate histograms for all the tables that so
It is influenced by USTAT_AUTO_READTIME_UPDATE_INTERVAL, which influences how often READ_TIME is updated for the histogram.
This CQD qualifies the histogram to be regenerated; it is the maximum time since READ_TIME was updated. $$$
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
@@ -74,7 +74,7 @@ The default value is 10000.
| *Usage* | Influences for what tables sampling is used for histogram statistics generation. If the setting is smaller,
then more tables qualify for sampling. If the setting is larger, then fewer tables qualify for sampling. Sampling can result in faster update
statistics run times. But for smaller tables, it can also result in poor histogram accuracy which could result in poor query plans.
-| *Production Usage* | Consult the Trafodion community.
+| *Production Usage* | Please contact {project-support}.
| *Impact* | Setting this CQD to a smaller value means that sampling is used for tables with fewer rows, when the SAMPLE option is
specified as part of update statistics. This can result in less accurate histograms and poor query plans, because the sample size may be too small to
generate good estimates for histograms. +
@@ -84,7 +84,7 @@ However, these tables may also have more accurate histograms.
| *Level* | System.
| *Conflicts/Synergies* | Not applicable.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
@@ -103,13 +103,13 @@ the <<hist-default-sample-min,HIST_DEFAULT_SAMPLE_MIN>> CQD. (which defaults to
The default for this CQD is *1,000,000*.
| *Usage* | Prevents accidental use of too-small samples when generating statistics on tables. If sample sizes are too small,
then histogram statistics will be less accurate, leading to potentially less efficient query plans.
-| *Production Usage* | Consult the Trafodion community.
+| *Production Usage* | Please contact {project-support}.
| *Impact* | Setting this CQD to lower values may result in smaller sample sizes for small tables.
This may slightly improve UPDATE STATISTICS run time, but at the cost of potentially less efficient queries.
| *Level* | System.
| *Conflicts/Synergies* | <<hist-default-sample-min,HIST_DEFAULT_SAMPLE_MIN>> effects the behavior of this CQD.
| *Real Problem Addressed* | Not applicable.
-| *Introduced In Release* | Trafodion 1.3.0.
+| *Introduced In Release* | {project-name} 1.3.0.
| *Deprecated In Release* | Not applicable.
|===
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/21d6d8d3/docs/cqd_reference/src/asciidoc/index.adoc
----------------------------------------------------------------------
diff --git a/docs/cqd_reference/src/asciidoc/index.adoc b/docs/cqd_reference/src/asciidoc/index.adoc
index 9de403c..690a991 100644
--- a/docs/cqd_reference/src/asciidoc/index.adoc
+++ b/docs/cqd_reference/src/asciidoc/index.adoc
@@ -32,7 +32,8 @@
:experimental:
:source-language: text
:revnumber: {project-version}
-:title-logo-image: ../../../shared/trafodion-logo.jpg
+:title-logo-image: {project-logo}
+:project-name: {project-name}
:images: ../images
:leveloffset: 1
@@ -41,22 +42,10 @@
// processing of files found in directories starting with an _. This
// prevents each chapter being built as its own book.
-**License Statement**
+include::../../shared/license.txt[]
-Licensed to the Apache Software Foundation (ASF) under one or more contributor license agreements. See the NOTICE file
-distributed with this work for additional information regarding copyright ownership. The ASF licenses this file
-to you under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with
-the License. You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0
-
-Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the
-specific language governing permissions and limitations under the License.
-
-[cols="2",options="header"]
-|===
-| Version | Date
-| 1.3.0 | January, 2016
-|===
+<<<
+include::../../shared/revisions.txt[]
include::asciidoc/_chapters/about.adoc[]
include::asciidoc/_chapters/introduction.adoc[]
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/21d6d8d3/docs/jdbct4ref_guide/src/asciidoc/index.adoc
----------------------------------------------------------------------
diff --git a/docs/jdbct4ref_guide/src/asciidoc/index.adoc b/docs/jdbct4ref_guide/src/asciidoc/index.adoc
index 38e2f3e..6e83647 100644
--- a/docs/jdbct4ref_guide/src/asciidoc/index.adoc
+++ b/docs/jdbct4ref_guide/src/asciidoc/index.adoc
@@ -46,17 +46,10 @@
include::../../shared/license.txt[]
<<<
-include::resources/acknowledgements.txt[]
+include::../../shared/acknowledgements.txt[]
<<<
-*Revision History*
-
-[cols="2",options="header"]
-|===
-| Version | Date
-| 2.0.0 | To be announced.
-| 1.3.0 | January, 2016
-|===
+include::../../shared/revisions.txt[]
include::asciidoc/_chapters/about.adoc[]
include::asciidoc/_chapters/introduction.adoc[]
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/21d6d8d3/docs/jdbct4ref_guide/src/resources/acknowledgements.txt
----------------------------------------------------------------------
diff --git a/docs/jdbct4ref_guide/src/resources/acknowledgements.txt b/docs/jdbct4ref_guide/src/resources/acknowledgements.txt
deleted file mode 100644
index c395596..0000000
--- a/docs/jdbct4ref_guide/src/resources/acknowledgements.txt
+++ /dev/null
@@ -1,38 +0,0 @@
-*Acknowledgements*
-
-Microsoft�, Windows�, Windows NT�, Windows� XP, and Windows Vista� are
-U.S. registered trademarks of Microsoft Corporation. Intel� and Intel�
-Itanium� are trademarks of Intel Corporation in the U.S. and other
-countries. Java� is a registered trademark of Oracle and/or its
-affiliates. Motif, OSF/1, UNIX�, X/Open�, and the X device is a
-trademark of X/Open Company Ltd. in the UK and other countries.
-
-OSF, OSF/1, OSF/Motif, Motif, and Open Software Foundation are trademarks of
-the Open Software Foundation in the U.S. and other countries.
-� 1990, 1991, 1992, 1993 Open Software Foundation, Inc.
-
-The OSF documentation and the OSF software to which it relates are derived in
-part from materials supplied by the following: � 1987, 1988, 1989
-Carnegie-Mellon University. � 1989, 1990, 1991 Digital Equipment
-Corporation. � 1985, 1988, 1989, 1990 Encore Computer Corporation. � 1988 Free
-Software Foundation, Inc. � 1987, 1988, 1989, 1990, 1991 Hewlett-Packard
-Company. � 1985, 1987, 1988, 1989, 1990, 1991, 1992 International
-Business Machines Corporation. � 1988, 1989 Massachusetts Institute of
-Technology. � 1988, 1989, 1990 Mentat Inc. � 1988 Microsoft Corporation.
-� 1987, 1988, 1989, 1990, 1991,
-1992 SecureWare, Inc. � 1990, 1991 Siemens Nixdorf Informations systeme
-AG. � 1986, 1989, 1996, 1997 Sun Microsystems, Inc. � 1989, 1990, 1991
-Transarc Corporation.
-
-OSF software and documentation are based in part
-on the Fourth Berkeley Software Distribution under license from The
-Regents of the University of California. OSF acknowledges the following
-individuals and institutions for their role in its development: Kenneth
-C.R.C. Arnold, Gregory S. Couch, Conrad C. Huang, Ed James, Symmetric
-Computer Systems, Robert Elz. � 1980, 1981, 1982, 1983, 1985, 1986,
-1987, 1988, 1989 Regents of the University of California. OSF MAKES NO
-WARRANTY OF ANY KIND WITH REGARD TO THE OSF MATERIAL PROVIDED HEREIN,
-INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY
-AND FITNESS FOR A PARTICULAR PURPOSE. OSF shall not be liable for errors
-contained herein or for incidental consequential damages in connection
-with the furnishing, performance, or use of this material.
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/21d6d8d3/docs/load_transform/pom.xml
----------------------------------------------------------------------
diff --git a/docs/load_transform/pom.xml b/docs/load_transform/pom.xml
index d54b0e8..f811dde 100644
--- a/docs/load_transform/pom.xml
+++ b/docs/load_transform/pom.xml
@@ -184,6 +184,10 @@
<!-- Location of centralized stylesheet -->
<stylesheet>${basedir}/../shared/trafodion-manuals.css</stylesheet>
<project-version>${env.TRAFODION_VER}</project-version>
+ <project-name>Trafodion</project-name>
+ <project-logo>${basedir}/../shared/trafodion-logo.jpg</project-logo>
+ <project-support>user@trafodion.incubator.apache.org</project-support>
+ <docs-url>http://trafodion.incubator.apache.org/docs</docs-url>
<build-date>${maven.build.timestamp}</build-date>
<google-analytics-account>UA-72491210-1</google-analytics-account>
</attributes>
@@ -202,6 +206,10 @@
<outputDirectory>${basedir}/target</outputDirectory>
<attributes>
<project-version>${env.TRAFODION_VER}</project-version>
+ <project-name>Trafodion</project-name>
+ <project-logo>${basedir}/../shared/trafodion-logo.jpg</project-logo>
+ <project-support>user@trafodion.incubator.apache.org</project-support>
+ <docs-url>http://trafodion.incubator.apache.org/docs</docs-url>
<build-date>${maven.build.timestamp}</build-date>
<pdf-stylesdir>${basedir}/../shared</pdf-stylesdir>
<pdf-style>trafodion</pdf-style>
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/21d6d8d3/docs/load_transform/src/asciidoc/_chapters/about.adoc
----------------------------------------------------------------------
diff --git a/docs/load_transform/src/asciidoc/_chapters/about.adoc b/docs/load_transform/src/asciidoc/_chapters/about.adoc
index f15fd04..48e2281 100644
--- a/docs/load_transform/src/asciidoc/_chapters/about.adoc
+++ b/docs/load_transform/src/asciidoc/_chapters/about.adoc
@@ -20,25 +20,25 @@
* under the License.
*
* @@@ END COPYRIGHT @@@
- */
+*/
////
= About This Document
-This guide describes how to load and transform data into a Trafodion database.
+This guide describes how to load and transform data into a {project-name} database.
-The information herein is complementary to the following Trafodion documentation:
+The information herein is complementary to the following {project-name} documentation:
-* http://trafodion.apache.org/docs/sql_reference/index.html[Trafodion SQL Reference Manual]
-* http://trafodion.apache.org/docs/odb/index.html[Trafodion odb User Guide]
+* {docs-url}/sql_reference/index.html[{project-name} SQL Reference Manual]
+* {docs-url}/odb/index.html[{project-name} odb User Guide]
== Intended Audience
-This guide targets anyone wanting to load data into a Trafodion database.
+This guide targets anyone wanting to load data into a {project-name} database.
You need to have skills in the following areas to make full use of the information in this guide:
* SQL DDL and DML.
* Installation and configuration of Linux software.
-* Trafodion administration.
+* {project-name} administration.
* Depending on your data source, Java and/or Hadoop ecosystem usage.
== New and Changed Information
@@ -170,19 +170,8 @@ match-value [NOT] LIKE _pattern
[ESCAPE esc-char-expression]
```
-== Publishing History
-[cols="2*",options="header"]
-|===
-| Product Version | Publication Date
-| Trafodion Release 1.3.0 | January 2016.
-|===
-
== Comments Encouraged
-The Trafodion community encourages your comments concerning this document. We are committed to providing documentation that meets your
-needs. Send any errors found, suggestions for improvement, or compliments to:
-
-issues@trafodion.incubator.apache.org
+We encourage your comments concerning this document. We are committed to providing documentation that meets your
+needs. Send any errors found, suggestions for improvement, or compliments to {project-support}.
-Include the document title and any comment, error found, or suggestion for improvement you have concerning this document. Or, even
-better, join our community and help us improve our documentation. Please refer to
-http://trafodion.incubator.apache.org/contributing_redirect.html[Trafodion Contributor Guide] for details.
+Include the document title and any comment, error found, or suggestion for improvement you have concerning this document.
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/21d6d8d3/docs/load_transform/src/asciidoc/_chapters/bulk_load.adoc
----------------------------------------------------------------------
diff --git a/docs/load_transform/src/asciidoc/_chapters/bulk_load.adoc b/docs/load_transform/src/asciidoc/_chapters/bulk_load.adoc
index 46593b5..2866b23 100644
--- a/docs/load_transform/src/asciidoc/_chapters/bulk_load.adoc
+++ b/docs/load_transform/src/asciidoc/_chapters/bulk_load.adoc
@@ -20,7 +20,7 @@
* under the License.
*
* @@@ END COPYRIGHT @@@
- */
+*/
////
[[bulk-load]]
@@ -28,20 +28,20 @@
The LOAD statement enables batch loading large volumes of data efficiently in a scalable manner.
-See the http://trafodion.apache.org/docs/sql_reference/index.html#load_statement[Trafodion SQL Reference Manual]
+See the {docs-url}/sql_reference/index.html#load_statement[{project-name} SQL Reference Manual]
for a full description of this SQL statement.
You can bulk-load data using one of the following methods:
-* <<bulk-load-data-from-trafodion-tables,Load Data From Trafodion Tables>>
+* <<bulk-load-data-from-trafodion-tables,Load Data From {project-name} Tables>>
* <<bulk-load-data-from-hdfs-files, Load Data From HDFS Files>>
* <<bulk-load-data-from-hive-tables,Load Data From Hive Tables>>
-* <<bulk-load-data-from-external-databases,Load Data From External Databases>>
+* <<bulk-load-data-from-external-databases, Load Data From External Databases>>
[[bulk-load-from-trafodion-tables]]
-== Load Data From Trafodion Tables
+== Load Data From {project-name} Tables
-You copy data between two Trafodion tables by using the appropriate SELECT statement in the LOAD command.
+You copy data between two {project-name} tables by using the appropriate SELECT statement in the LOAD command.
=== Example
@@ -57,24 +57,24 @@ to the HDFS folder containing the data. You may also specify a WHERE clause on t
See the https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-ExternalTables[External Tables]
page on the https://cwiki.apache.org/confluence/display/Hive[Hive Wiki] for more information.
-Trafodion can access columns in Hive tables having integer, string and char types.
+{project-name} can access columns in Hive tables having integer, string and char types.
See the https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Types[LanguageManual Types]
page on the https://cwiki.apache.org/confluence/display/Hive[Hive Wiki] for the data types available in Hive.
Overall, you do the following:
1. Export the data on the local or remote cluster.
-2. If applicable, transport files to Trafodion cluster via FTP, scp, or some other method.
+2. If applicable, transport files to {project-name} cluster via FTP, scp, or some other method.
3. Use LOAD referencing HIVE external tables.
=== Example
-You have a customer-demographics in a text file, which you need to load into Trafodion.
+You have a customer-demographics in a text file, which you need to load into {project-name}.
The columns are separated by `|`.
Do the following:
-1. Using trafci, define the Trafodion table where you want to load the data.
+1. Using trafci, define the {project-name} table where you want to load the data.
+
```
CREATE TABLE customer_demographics_salt
@@ -121,7 +121,7 @@ LOCATION '/hive/tpcds/customer_demographics'
;
```
-4. Using trafci, load the Trafodion `customer_demographics_salt` table from the Hive table named
+4. Using trafci, load the {project-name} `customer_demographics_salt` table from the Hive table named
`hive.hive.customer_demographics`:
+
```
@@ -150,19 +150,19 @@ You can import data from Hive using the trafci or sqlci command interface. Do th
CQD HIVE_MAX_STRING_LENGTH '1000'; -- if the widest column is 1KB
```
+
-This setting is required if there are time-related column types in the target Trafodion table.
+This setting is required if there are time-related column types in the target {project-name} table.
+
```
CQD ALLOW_INCOMPATIBLE_ASSIGNMENT 'on';
```
-2. Issue the LOAD statement to load data into Trafodion tables from Hive. For example:
+2. Issue the LOAD statement to load data into {project-name} tables from Hive. For example:
+
```
LOAD WITH NO POPULATE INDEXES INTO trafodion.sch.demo SELECT * FROM hive.hive.demo;
```
-See the http://trafodion.incubator.apache.org/docs/sql_reference/index.html#load_statement[Trafodion SQL Reference Manual].
+See the {docs-url}/sql_reference/index.html#load_statement[{project-name} SQL Reference Manual].
for the complete syntax of the LOAD statement.
If you use multiple LOAD statements to incrementally load sets of data into a single target table, then several HFiles are created
@@ -192,7 +192,7 @@ NOTE: The `major_compact` command returns immediately since it's not waited. Typ
You need to import data into Hive when loading data from external databases.
Use http://sqoop.apache.org/[Apache Sqoop], an open-source tools to move the data from the external database
-into Hive tables on the Trafodion cluster.
+into Hive tables on the {project-name} cluster.
Source data can be in the following formats:
@@ -221,9 +221,9 @@ introduction to Sqoop.
=== Install Required Software
-By default, Sqoop is not installed on Trafodion clusters. Do the following:
+By default, Sqoop is not installed on {project-name} clusters. Do the following:
-* Install and start Sqoop on the Trafodion cluster using either the Ambari or Cloudera Manager GUI.
+* Install and start Sqoop on the {project-name} cluster using either the Ambari or Cloudera Manager GUI.
See the http://sqoop.apache.org/docs/1.99.3/Installation.html[Sqoop installation instructions].
* Install http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html[JDK 1.8]
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/21d6d8d3/docs/load_transform/src/asciidoc/_chapters/bulk_unload.adoc
----------------------------------------------------------------------
diff --git a/docs/load_transform/src/asciidoc/_chapters/bulk_unload.adoc b/docs/load_transform/src/asciidoc/_chapters/bulk_unload.adoc
index 5ba2349..d9a1fac 100644
--- a/docs/load_transform/src/asciidoc/_chapters/bulk_unload.adoc
+++ b/docs/load_transform/src/asciidoc/_chapters/bulk_unload.adoc
@@ -20,22 +20,22 @@
* under the License.
*
* @@@ END COPYRIGHT @@@
- */
+*/
////
[[bulk-unload]]
= Bulk Unload
-The http://trafodion.apache.org/docs/sql_reference/index.html#unload_statement[UNLOAD] statement is a
-Trafodion extension that exports data from Trafodion tables into an HDFS location that you specify.
-Refer to the http://trafodion.apache.org/docs/sql_reference/index.html#unload_statement[Trafodion SQL Reference Manual]
+The {docs-url}/sql_reference/index.html#unload_statement[UNLOAD] statement is a
+{project-name} extension that exports data from {project-name} tables into an HDFS location that you specify.
+Refer to the {docs-url}/sql_reference/index.html#unload_statement[{project-name} SQL Reference Manual]
for complete documentation.
The extracted data can be either compressed or uncompressed based on what you choose.
UNLOAD performs multiple steps based on the options you give; for example:
* If using snapshot scan:
-** Get list of Trafodion tables from the query plan.
+** Get list of {project-name} tables from the query plan.
** Create/verify snapshots.
* Purge target location, if specified
@@ -50,7 +50,7 @@ UNLOAD performs multiple steps based on the options you give; for example:
*Example*
This example shows how the UNLOAD statement extracts data from a
-Trafodion table, `TRAFODION.HBASE.CUSTOMER_DEMOGRAPHICS`, into an HDFS
+{project-name} table, `TRAFODION.HBASE.CUSTOMER_DEMOGRAPHICS`, into an HDFS
folder, `/bulkload/customer_demographics`:
```
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/21d6d8d3/docs/load_transform/src/asciidoc/_chapters/introduction.adoc
----------------------------------------------------------------------
diff --git a/docs/load_transform/src/asciidoc/_chapters/introduction.adoc b/docs/load_transform/src/asciidoc/_chapters/introduction.adoc
index 05e0cd5..aad3a56 100644
--- a/docs/load_transform/src/asciidoc/_chapters/introduction.adoc
+++ b/docs/load_transform/src/asciidoc/_chapters/introduction.adoc
@@ -20,7 +20,7 @@
* under the License.
*
* @@@ END COPYRIGHT @@@
- */
+*/
////
[[introduction]]
@@ -28,13 +28,13 @@
[[introduction-load-methods]]
== Load Methods
-There are two methods used to load data into a Trafodion table. Both methods can run while the database is concurrently queried:
+There are two methods used to load data into a {project-name} table. Both methods can run while the database is concurrently queried:
[cols="20%,40%,40%",options="header"]
|===
| Type | Description | Methods/Tools
| *Bulk Load* | Large data volumes +
-Stage data and load in the batches | Trafodion Bulk Loader
+Stage data and load in the batches | {project-name} Bulk Loader
| *Trickle Load* | Small data volumes +
Insert data as it arrives | ETL tool +
Custom ODBC/JDBC application +
@@ -45,21 +45,21 @@ odb Tool
These two methods use four types of SQL insert statements
* *Bulk Load*
-** http://trafodion.incubator.apache.org/docs/sql_reference/index.html#load_statement[LOAD]
+** {docs-url}/sql_reference/index.html#load_statement[LOAD]
* *Trickle Load*
-** http://trafodion.incubator.apache.org/docs/sql_reference/index.html#insert_statement[INSERT]
-** http://trafodion.incubator.apache.org/docs/sql_reference/index.html#upsert_statement[UPSERT]
-** http://trafodion.incubator.apache.org/docs/sql_reference/index.html#upsert_statement[UPSERT USING LOAD]
+** {docs-url}/sql_reference/index.html#insert_statement[INSERT]
+** {docs-url}/sql_reference/index.html#upsert_statement[UPSERT]
+** {docs-url}/sql_reference/index.html#upsert_statement[UPSERT USING LOAD]
-The http://trafodion.incubator.apache.org/docs/sql_reference/index.html[Trafodion SQL Reference Manual]
+The {docs-url}/sql_reference/index.html[{project-name} SQL Reference Manual]
provides syntax descriptions for these statements.
The data source defines what type of load approach and method you use:
* *Bulk Load* (LOAD statement)
** _Text Files_: Map an external Hive table.
-** _JDBC-Compliant Database_: Load into Hive on the Trafodion cluster using `sqoop`.
+** _JDBC-Compliant Database_: Load into Hive on the {project-name} cluster using `sqoop`.
** _Hive Tables_: Direct load.
** _Native HBase Tables_: Direct load.
** _Disparate Data Source_: Write Java/C++ UDF to read data from source and pass rows to LOAD.
@@ -79,7 +79,7 @@ For more information, refer to:
[[introduction-insert-types]]
=== Insert Types
-The following insert types are supported in Trafodion:
+The following insert types are supported in {project-name}:
* `INSERT INTO T …`
* `UPSERT INTO T …`
@@ -104,7 +104,7 @@ The following table compares the different insert types:
Throughput, max/min sizes depends on multiple factors:
-* Format of rows in Trafodion table (aligned format or not).
+* Format of rows in {project-name} table (aligned format or not).
* Length of row.
* Number of columns in row.
* Data type of columns.
@@ -115,7 +115,7 @@ Throughput, max/min sizes depends on multiple factors:
== Unload
-The Trafodion UNLOAD statement exports data from Trafodion tables into an HDFS directory. Refer to <<bulk-unload,Bulk Unload>> for more information.
+The {project-name} UNLOAD statement exports data from {project-name} tables into an HDFS directory. Refer to <<bulk-unload,Bulk Unload>> for more information.
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/21d6d8d3/docs/load_transform/src/asciidoc/_chapters/monitor.adoc
----------------------------------------------------------------------
diff --git a/docs/load_transform/src/asciidoc/_chapters/monitor.adoc b/docs/load_transform/src/asciidoc/_chapters/monitor.adoc
index ab66bf8..cfe1492 100644
--- a/docs/load_transform/src/asciidoc/_chapters/monitor.adoc
+++ b/docs/load_transform/src/asciidoc/_chapters/monitor.adoc
@@ -20,7 +20,7 @@
* under the License.
*
* @@@ END COPYRIGHT @@@
- */
+*/
////
[[monitor-progress]]
@@ -28,12 +28,12 @@
== INSERT and UPSERT
-For an INSERT statement, rows are written to the HBase table that represents the Trafodion table when the transaction commits.
+For an INSERT statement, rows are written to the HBase table that represents the {project-name} table when the transaction commits.
It is more difficult to see query progress here.
== UPSERT USING LOAD
-For an UPSERT USING LOAD statement, rows added are visible in the Trafodion table after each `ListOfPut` call succeeds.
+For an UPSERT USING LOAD statement, rows added are visible in the {project-name} table after each `ListOfPut` call succeeds.
You can use a `SELECT COUNT(*)` statement to monitor progress. That way, you know how many rows are already in the table when the
statement starts executing.
@@ -58,7 +58,7 @@ lsof +L1 | grep SCR | wc -l
This command returns a count of the number of overflow files for sort. Each file is 2GB in size.
You need to have an approximate idea of the volume of data being loaded to know how much more
data needs to be sorted. On a cluster, sort is done on all nodes with a pdsh-like utility.
-Trafodion data volume can also be larger than Hive data volume by a factor of 2 or 3.
+{project-name} data volume can also be larger than Hive data volume by a factor of 2 or 3.
In step 3, create prep HFiles, use the following command to monitor the volume of data written
out to the staging directory: