Repository: trafodion-site Updated Branches: refs/heads/asf-site 9a835fafb -> 2d9ea87db
http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/2d9ea87d/docs/sql_reference/dependencies.html ---------------------------------------------------------------------- diff --git a/docs/sql_reference/dependencies.html b/docs/sql_reference/dependencies.html index 9a1fa81..00967e6 100644 --- a/docs/sql_reference/dependencies.html +++ b/docs/sql_reference/dependencies.html @@ -1,5 +1,5 @@ <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> -<!-- Generated by Apache Maven Doxia Site Renderer 1.4 at 2018-06-04 --> +<!-- Generated by Apache Maven Doxia Site Renderer 1.4 at 2018-06-07 --> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> @@ -10,7 +10,7 @@ @import url("./css/site.css"); </style> <link rel="stylesheet" href="./css/print.css" type="text/css" media="print" /> - <meta name="Date-Revision-yyyymmdd" content="20180604" /> + <meta name="Date-Revision-yyyymmdd" content="20180607" /> <meta http-equiv="Content-Language" content="en" /> </head> @@ -27,7 +27,7 @@ <div class="xleft"> - <span id="publishDate">Last Published: 2018-06-04</span> + <span id="publishDate">Last Published: 2018-06-07</span> | <span id="projectVersion">Version: 2.3.0</span> </div> <div class="xright"> <a href="./" title="Trafodion SQL Reference Manual">Trafodion SQL Reference Manual</a> http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/2d9ea87d/docs/sql_reference/index.html ---------------------------------------------------------------------- diff --git a/docs/sql_reference/index.html b/docs/sql_reference/index.html index 39fa585..1c6fff2 100644 --- a/docs/sql_reference/index.html +++ b/docs/sql_reference/index.html @@ -874,8 +874,7 @@ table.CodeRay td.code>pre{padding:0} <ul class="sectlevel3"> <li><a href="#merge_syntax">3.40.1. Syntax Description of MERGE</a></li> <li><a href="#merge_considerations">3.40.2. Considerations for MERGE</a></li> -<li><a href="#merge_upsert_using_single_row">3.40.3. Upsert Using Single Row</a></li> -<li><a href="#merge_examples">3.40.4. Examples of MERGE</a></li> +<li><a href="#merge_examples">3.40.3. Examples of MERGE</a></li> </ul> </li> <li><a href="#prepare_statement">3.41. PREPARE Statement</a> @@ -5648,18 +5647,33 @@ EXECUTE y; -- uses MYSCHEMA;</code></pre> <div class="ulist"> <ul> <li> -<p>Increase the cache refresh time for the histogram cache to two hours (7,200 minutes).</p> +<p>This example changes the maximum degree of parallelism to 2 for a query. The value must be less than the number of CPUs in the cluster.</p> <div class="listingblock"> <div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">CONTROL QUERY DEFAULT CACHE_HISTOGRAMS_REFRESH_INTERVAL '7200';</code></pre> +<pre class="CodeRay highlight"><code data-lang="text">SQL>CONTROL QUERY DEFAULT PARALLEL_NUM_ESPS '2'; + +--- SQL operation complete.</code></pre> +</div> +</div> +<div class="paragraph"> +<p>This example resets the <code>PARALLEL_NUM_ESPS</code> attribute to its system value in the current process. +In this case, the compiler calculates the number of ESPs to be used.</p> +</div> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">SQL>CONTROL QUERY DEFAULT PARALLEL_NUM_ESPS 'system'; + +--- SQL operation complete.</code></pre> </div> </div> </li> <li> -<p>Reset the CACHE_HISTOGRAMS_REFRESH_INTERVAL attribute to its initial value in the current process:</p> +<p>This example allows the optimizer to generate an execution using hash join.</p> <div class="listingblock"> <div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">CONTROL QUERY DEFAULT CACHE_HISTOGRAMS_REFRESH_INTERVAL RESET;</code></pre> +<pre class="CodeRay highlight"><code data-lang="text">SQL>CONTROL QUERY DEFAULT HASH_JOIN 'ON'; + +--- SQL operation complete.</code></pre> </div> </div> </li> @@ -5697,10 +5711,10 @@ this statement, AUTOCOMMIT must be turned ON (the default) for the session. (return-parameter-declaration[, return-parameter-declaration]...) EXTERNAL NAME 'character-string-literal' LIBRARY [[catalog-name.]schema-name.]library-name - [language c] + [LANGUAGE c] [parameter style sql] [no sql] - [not deterministic | deterministic] + [NOT DETERMINISTIC | DETERMINISTIC] [final call | no final call] [no state area | state area size] [no parallelism | allow any parallelism] @@ -5844,7 +5858,7 @@ library name, trafodion sql qualifies it according to the schema of the current </div> </li> <li> -<p><code>language c</code></p> +<p><code>LANGUAGE c</code></p> <div class="paragraph"> <p>specifies that the external function is written in the c language. this clause is optional.</p> </div> @@ -5863,7 +5877,7 @@ language. this clause is optional.</p> </div> </li> <li> -<p><code>deterministic | not deterministic</code></p> +<p><code>DETERMINISTIC | NOT DETERMINISTIC</code></p> <div class="paragraph"> <p>specifies whether the function always returns the same values for out parameters for a given set of argument values (deterministic, the default behavior) or does not return the same values (not deterministic). if the @@ -6323,6 +6337,12 @@ partitions are not audited and empty. <p>If the operation fails after basic semantic checks are performed, the index no longer exists and the entire transaction is rolled back even if it is a user-started transaction.</p> </div> +<div class="paragraph"> +<p>If you are creating an index on a large Trafodion table that is already populated, +you should use the NO POPULATE option, and then run the POPULATE INDEX utility to load the index. +Because CREATE INDEX executes in a single transaction, it could experience transactional limitations such as a transaction timeout +if a large amount of data is to be moved.</p> +</div> <div class="sect4"> <h5 id="create_index_authorization_and_availability_requirements">Authorization and Availability Requirements</h5> <div class="paragraph"> @@ -6678,13 +6698,13 @@ AUTOCOMMIT must be turned ON (the default) for the session. EXTERNAL NAME 'java-method-name [java-signature]' LIBRARY [[catalog-name.]schema-name.]library-name [external security external-security-type] - language java + LANGUAGE java parameter style java [no sql | contains sql | modifies sql data | reads sql data] [dynamic result sets integer] - [transaction required | no transaction required] - [deterministic | not deterministic] - [no isolate | isolate] + [TRANSACTION REQUIRED | NO TRANSACTION REQUIRED] + [DETERMINISTIC | NOT DETERMINISTIC] + [NO ISOLATE| ISOLATE] procedure-ref is: [[catalog-name.]schema-name.]procedure-name @@ -7015,7 +7035,7 @@ because those users will be able to execute the SPJ without requiring privileges <div class="ulist"> <ul> <li> -<p><code>language java</code></p> +<p><code>LANGUAGE java</code></p> <div class="paragraph"> <p>specifies that the external user-defined routine is written in the java language.</p> </div> @@ -7050,13 +7070,13 @@ this option, then the default value is 0 (zero), meaning that the SPJ does not r </div> </li> <li> -<p><code>transaction required | no transaction required</code></p> +<p><code>TRANSACTION REQUIRED | NO TRANSACTION REQUIRED</code></p> <div class="paragraph"> -<p>determines whether the SPJ must run in a transaction inherited from the calling application (<code>transaction required</code>, the default -option) or whether the SPJ runs without inheriting the calling applicationâs transaction (<code>no transaction required</code>). Typically, +<p>determines whether the SPJ must run in a transaction inherited from the calling application (<code>TRANSACTION REQUIRED</code>, the default +option) or whether the SPJ runs without inheriting the calling applicationâs transaction (<code>NO TRANSACTION REQUIRED</code>). Typically, you want the stored procedure to inherit the transaction from the calling application. However, if the SPJ method does not access the database or if you want the stored procedure to manage its own transactions, then you should set the stored -procedureâs transaction attribute to no transaction required. For more information, see +procedureâs transaction attribute to <code>NO TRANSACTION REQUIRED</code>. For more information, see <a href="#effects_of_the_transaction_attribute_on_spjs">effects of the transaction attribute on SPJs</a>.</p> </div> </li> @@ -7066,19 +7086,19 @@ procedureâs transaction attribute to no transaction required. For more informa <div class="ulist"> <ul> <li> -<p><code>deterministic | not deterministic</code></p> +<p><code>DETERMINISTIC | NOT DETERMINISTIC</code></p> <div class="paragraph"> <p>specifies whether the SPJ always returns the same values for out and inout parameters for a given set of argument values -(<code>deterministic</code>) or does not return the same values (<code>not deterministic</code>, the default option). If you specify <code>deterministic</code>, +(<code>DETERMINISTIC</code>) or does not return the same values (<code>NOT DETERMINISTIC</code>, the default option). If you specify <code>DETERMINISTIC</code>, Trafodion is not required to call the SPJ each time to produce results; instead, Trafodion caches the results and reuses them during subsequent calls, thus optimizing the CALL statement.</p> </div> </li> <li> -<p><code>no isolate | isolate</code></p> +<p><code>NO ISOLATE | ISOLATE</code></p> <div class="paragraph"> -<p>specifies that the SPJ executes either in the environment of the database server (<code>no isolate</code>) or in an isolated environment -(<code>isolate</code>, the default option). Trafodion allows both options but always executes the SPJ in the UDR server process (<code>isolate</code>).</p> +<p>specifies that the SPJ executes either in the environment of the database server (<code>NO ISOLATE</code>) or in an isolated environment +(<code>ISOLATE</code>, the default option). Trafodion allows both options but always executes the SPJ in the UDR server process (<code>ISOLATE</code>).</p> </div> </li> </ul> @@ -7623,7 +7643,7 @@ By default, this privilege is granted to PUBLIC, but it can be revoked by DB ROO <div class="ulist"> <ul> <li> -<p>This example creates a private schema schema named MYSCHEMA, which will be owned by the current user:</p> +<p>This example creates a private schema named MYSCHEMA, which will be owned by the current user:</p> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">CREATE SCHEMA myschema;</code></pre> @@ -13651,10 +13671,8 @@ key of the table if the MERGE has a <em>when-not-matched-clause</em>. The cluste </div> <div class="sect3"> <h4 id="merge_considerations">3.40.2. Considerations for MERGE</h4> - -</div> -<div class="sect3"> -<h4 id="merge_upsert_using_single_row">3.40.3. Upsert Using Single Row</h4> +<div class="sect4"> +<h5 id="merge_upsert_using_single_row">Upsert Using Single Row</h5> <div class="paragraph"> <p>A MERGE statement allows you to specify a set of column values that should be updated if the row is found, and another row to be inserted if the row is not found. The ON predicate must select exactly one row that is to be updated if the @@ -13710,6 +13728,7 @@ found in table t.</p> WHEN NOT MATCHED THEN INSERT VALUES (10, 30)</code></pre> </div> </div> +</div> <div class="sect4"> <h5 id="merge_conditional_upsert_using_single_row">Conditional Upsert Using Single Row</h5> <div class="paragraph"> @@ -13853,7 +13872,7 @@ is not found, the insert is done. The restrictions are the same as those for < </div> </div> <div class="sect3"> -<h4 id="merge_examples">3.40.4. Examples of MERGE</h4> +<h4 id="merge_examples">3.40.3. Examples of MERGE</h4> <div class="ulist"> <ul> <li> http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/2d9ea87d/docs/sql_reference/integration.html ---------------------------------------------------------------------- diff --git a/docs/sql_reference/integration.html b/docs/sql_reference/integration.html index 01bd52e..2f5ff24 100644 --- a/docs/sql_reference/integration.html +++ b/docs/sql_reference/integration.html @@ -1,5 +1,5 @@ <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> -<!-- Generated by Apache Maven Doxia Site Renderer 1.4 at 2018-06-04 --> +<!-- Generated by Apache Maven Doxia Site Renderer 1.4 at 2018-06-07 --> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> @@ -10,7 +10,7 @@ @import url("./css/site.css"); </style> <link rel="stylesheet" href="./css/print.css" type="text/css" media="print" /> - <meta name="Date-Revision-yyyymmdd" content="20180604" /> + <meta name="Date-Revision-yyyymmdd" content="20180607" /> <meta http-equiv="Content-Language" content="en" /> </head> @@ -27,7 +27,7 @@ <div class="xleft"> - <span id="publishDate">Last Published: 2018-06-04</span> + <span id="publishDate">Last Published: 2018-06-07</span> | <span id="projectVersion">Version: 2.3.0</span> </div> <div class="xright"> <a href="./" title="Trafodion SQL Reference Manual">Trafodion SQL Reference Manual</a> http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/2d9ea87d/docs/sql_reference/issue-tracking.html ---------------------------------------------------------------------- diff --git a/docs/sql_reference/issue-tracking.html b/docs/sql_reference/issue-tracking.html index bb22bf6..d3bdbc7 100644 --- a/docs/sql_reference/issue-tracking.html +++ b/docs/sql_reference/issue-tracking.html @@ -1,5 +1,5 @@ <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> -<!-- Generated by Apache Maven Doxia Site Renderer 1.4 at 2018-06-04 --> +<!-- Generated by Apache Maven Doxia Site Renderer 1.4 at 2018-06-07 --> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> @@ -10,7 +10,7 @@ @import url("./css/site.css"); </style> <link rel="stylesheet" href="./css/print.css" type="text/css" media="print" /> - <meta name="Date-Revision-yyyymmdd" content="20180604" /> + <meta name="Date-Revision-yyyymmdd" content="20180607" /> <meta http-equiv="Content-Language" content="en" /> </head> @@ -27,7 +27,7 @@ <div class="xleft"> - <span id="publishDate">Last Published: 2018-06-04</span> + <span id="publishDate">Last Published: 2018-06-07</span> | <span id="projectVersion">Version: 2.3.0</span> </div> <div class="xright"> <a href="./" title="Trafodion SQL Reference Manual">Trafodion SQL Reference Manual</a> http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/2d9ea87d/docs/sql_reference/license.html ---------------------------------------------------------------------- diff --git a/docs/sql_reference/license.html b/docs/sql_reference/license.html index a0601d8..046fb87 100644 --- a/docs/sql_reference/license.html +++ b/docs/sql_reference/license.html @@ -1,5 +1,5 @@ <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> -<!-- Generated by Apache Maven Doxia Site Renderer 1.4 at 2018-06-04 --> +<!-- Generated by Apache Maven Doxia Site Renderer 1.4 at 2018-06-07 --> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> @@ -10,7 +10,7 @@ @import url("./css/site.css"); </style> <link rel="stylesheet" href="./css/print.css" type="text/css" media="print" /> - <meta name="Date-Revision-yyyymmdd" content="20180604" /> + <meta name="Date-Revision-yyyymmdd" content="20180607" /> <meta http-equiv="Content-Language" content="en" /> </head> @@ -27,7 +27,7 @@ <div class="xleft"> - <span id="publishDate">Last Published: 2018-06-04</span> + <span id="publishDate">Last Published: 2018-06-07</span> | <span id="projectVersion">Version: 2.3.0</span> </div> <div class="xright"> <a href="./" title="Trafodion SQL Reference Manual">Trafodion SQL Reference Manual</a> http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/2d9ea87d/docs/sql_reference/mail-lists.html ---------------------------------------------------------------------- diff --git a/docs/sql_reference/mail-lists.html b/docs/sql_reference/mail-lists.html index 1941619..e75ccce 100644 --- a/docs/sql_reference/mail-lists.html +++ b/docs/sql_reference/mail-lists.html @@ -1,5 +1,5 @@ <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> -<!-- Generated by Apache Maven Doxia Site Renderer 1.4 at 2018-06-04 --> +<!-- Generated by Apache Maven Doxia Site Renderer 1.4 at 2018-06-07 --> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> @@ -10,7 +10,7 @@ @import url("./css/site.css"); </style> <link rel="stylesheet" href="./css/print.css" type="text/css" media="print" /> - <meta name="Date-Revision-yyyymmdd" content="20180604" /> + <meta name="Date-Revision-yyyymmdd" content="20180607" /> <meta http-equiv="Content-Language" content="en" /> </head> @@ -27,7 +27,7 @@ <div class="xleft"> - <span id="publishDate">Last Published: 2018-06-04</span> + <span id="publishDate">Last Published: 2018-06-07</span> | <span id="projectVersion">Version: 2.3.0</span> </div> <div class="xright"> <a href="./" title="Trafodion SQL Reference Manual">Trafodion SQL Reference Manual</a> http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/2d9ea87d/docs/sql_reference/project-info.html ---------------------------------------------------------------------- diff --git a/docs/sql_reference/project-info.html b/docs/sql_reference/project-info.html index 2bcfd5e..fc05d7c 100644 --- a/docs/sql_reference/project-info.html +++ b/docs/sql_reference/project-info.html @@ -1,5 +1,5 @@ <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> -<!-- Generated by Apache Maven Doxia Site Renderer 1.4 at 2018-06-04 --> +<!-- Generated by Apache Maven Doxia Site Renderer 1.4 at 2018-06-07 --> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> @@ -10,7 +10,7 @@ @import url("./css/site.css"); </style> <link rel="stylesheet" href="./css/print.css" type="text/css" media="print" /> - <meta name="Date-Revision-yyyymmdd" content="20180604" /> + <meta name="Date-Revision-yyyymmdd" content="20180607" /> <meta http-equiv="Content-Language" content="en" /> </head> @@ -27,7 +27,7 @@ <div class="xleft"> - <span id="publishDate">Last Published: 2018-06-04</span> + <span id="publishDate">Last Published: 2018-06-07</span> | <span id="projectVersion">Version: 2.3.0</span> </div> <div class="xright"> <a href="./" title="Trafodion SQL Reference Manual">Trafodion SQL Reference Manual</a> http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/2d9ea87d/docs/sql_reference/project-summary.html ---------------------------------------------------------------------- diff --git a/docs/sql_reference/project-summary.html b/docs/sql_reference/project-summary.html index 8cabbc3..3887d9a 100644 --- a/docs/sql_reference/project-summary.html +++ b/docs/sql_reference/project-summary.html @@ -1,5 +1,5 @@ <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> -<!-- Generated by Apache Maven Doxia Site Renderer 1.4 at 2018-06-04 --> +<!-- Generated by Apache Maven Doxia Site Renderer 1.4 at 2018-06-07 --> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> @@ -10,7 +10,7 @@ @import url("./css/site.css"); </style> <link rel="stylesheet" href="./css/print.css" type="text/css" media="print" /> - <meta name="Date-Revision-yyyymmdd" content="20180604" /> + <meta name="Date-Revision-yyyymmdd" content="20180607" /> <meta http-equiv="Content-Language" content="en" /> </head> @@ -27,7 +27,7 @@ <div class="xleft"> - <span id="publishDate">Last Published: 2018-06-04</span> + <span id="publishDate">Last Published: 2018-06-07</span> | <span id="projectVersion">Version: 2.3.0</span> </div> <div class="xright"> <a href="./" title="Trafodion SQL Reference Manual">Trafodion SQL Reference Manual</a> http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/2d9ea87d/docs/sql_reference/source-repository.html ---------------------------------------------------------------------- diff --git a/docs/sql_reference/source-repository.html b/docs/sql_reference/source-repository.html index dd36346..0919c48 100644 --- a/docs/sql_reference/source-repository.html +++ b/docs/sql_reference/source-repository.html @@ -1,5 +1,5 @@ <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> -<!-- Generated by Apache Maven Doxia Site Renderer 1.4 at 2018-06-04 --> +<!-- Generated by Apache Maven Doxia Site Renderer 1.4 at 2018-06-07 --> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> @@ -10,7 +10,7 @@ @import url("./css/site.css"); </style> <link rel="stylesheet" href="./css/print.css" type="text/css" media="print" /> - <meta name="Date-Revision-yyyymmdd" content="20180604" /> + <meta name="Date-Revision-yyyymmdd" content="20180607" /> <meta http-equiv="Content-Language" content="en" /> </head> @@ -27,7 +27,7 @@ <div class="xleft"> - <span id="publishDate">Last Published: 2018-06-04</span> + <span id="publishDate">Last Published: 2018-06-07</span> | <span id="projectVersion">Version: 2.3.0</span> </div> <div class="xright"> <a href="./" title="Trafodion SQL Reference Manual">Trafodion SQL Reference Manual</a> http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/2d9ea87d/docs/sql_reference/team-list.html ---------------------------------------------------------------------- diff --git a/docs/sql_reference/team-list.html b/docs/sql_reference/team-list.html index 0262c33..5ccaf8a 100644 --- a/docs/sql_reference/team-list.html +++ b/docs/sql_reference/team-list.html @@ -1,5 +1,5 @@ <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> -<!-- Generated by Apache Maven Doxia Site Renderer 1.4 at 2018-06-04 --> +<!-- Generated by Apache Maven Doxia Site Renderer 1.4 at 2018-06-07 --> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> @@ -10,7 +10,7 @@ @import url("./css/site.css"); </style> <link rel="stylesheet" href="./css/print.css" type="text/css" media="print" /> - <meta name="Date-Revision-yyyymmdd" content="20180604" /> + <meta name="Date-Revision-yyyymmdd" content="20180607" /> <meta http-equiv="Content-Language" content="en" /> </head> @@ -27,7 +27,7 @@ <div class="xleft"> - <span id="publishDate">Last Published: 2018-06-04</span> + <span id="publishDate">Last Published: 2018-06-07</span> | <span id="projectVersion">Version: 2.3.0</span> </div> <div class="xright"> <a href="./" title="Trafodion SQL Reference Manual">Trafodion SQL Reference Manual</a> http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/2d9ea87d/index.html ---------------------------------------------------------------------- diff --git a/index.html b/index.html index 640a263..14bb35e 100644 --- a/index.html +++ b/index.html @@ -1,6 +1,7 @@ + <!DOCTYPE html> <!-- - Generated by Apache Maven Doxia at 2018-05-30 + Generated by Apache Maven Doxia at 2018-05-30 Rendered using Reflow Maven Skin 1.1.1 (http://andriusvelykis.github.io/reflow-maven-skin) --> <html xml:lang="en" lang="en"> @@ -159,16 +160,16 @@ <div class="item active"> <a class="externalLink" href="http://trafodion.apache.org"><img src="images/carousel/scale.png" alt="Hadoop Scale" /></a> <div class="carousel-caption"> - <h4 id="Hadoop-Scale_with_SQL_Access"><a class="externalLink" href="http://trafodion.apache.org">Hadoop-Scale with SQL Access</a></h4> -<p>Running out of room with your current SQL solution? Starting a new operational application? Trafodion allows you to work in SQL at Hadoop-scale levels.</p> -<div class="section"> + <h4 id="Hadoop-Scale_with_SQL_Access"><a class="externalLink" href="http://trafodion.apache.org">Hadoop-Scale with SQL Access</a></h4> +<p>Running out of room with your current SQL solution? Starting a new operational application? Trafodion allows you to work in SQL at Hadoop-scale levels.</p> +<div class="section"> </div> </div> </div> <div class="item "> <a href="index.html"><img src="images/carousel/stack.png" alt="Trafodion Stack" /></a> <div class="carousel-caption"> - <h4 id="Fully_Integrated_with_HBase_and_Hive"><a href="index.html">Fully Integrated with HBase and Hive</a></h4> + <h4 id="Fully_Integrated_with_HBase_and_Hive"><a href="index.html">Fully Integrated with HBase and Hive</a></h4> <p>Trafodion provides SQL access to structured, semi-structured, and unstructured data allowing you to run operational, historical, and analytical workloads on a single platform.</p> </div> </div> @@ -179,43 +180,43 @@ <div class="row"> <div class="span12"> <div class="body-content"> - <div class="section"> - <h2 id="News">News</h2> - <table border="0" class="bodyTable table table-striped table-hover"> - <tbody> - <tr class="a"> - <td> <p> </p> - <div class="section"> - <div class="section"> - <div class="section"> - <h5 id="Apache_Trafodion_is_now_a_Top_Level_Project">Apache Trafodion is now a Top Level Project!</h5> - <p></p> - <p>Check out the <a class="externalLink" href="http://globenewswire.com/news-release/2018/01/10/1286517/0/en/The-Apache-Software-Foundation-Announces-Apache-Trafodion-as-a-Top-Level-Project.html">NewsWire</a> article for the official announcement.</p> - <p>See also this nice <a class="externalLink" href="https://thenewstack.io/sql-hadoop-database-trafodion-bridges-transactions-analysis-divide/">article</a> where Trafodion's own Suresh Subbiah spreads the word on Trafodion's features.</p> - <p></p> - </div> - <div class="section"> - <h5 id="Were_working_on_release_2.2">We're working on release 2.2!</h5> - <p></p> - <p>Check out the <a class="externalLink" href="https://cwiki.apache.org/confluence/display/TRAFODION/Roadmap">Roadmap</a> page for planned content.</p> - <p></p> - </div> - <div class="section"> - <h5 id="Apache_Trafodion_2.1.0-incubating_was_released_on_May_1_2017">Apache Trafodion 2.1.0-incubating was released on May 1, 2017</h5> - <p></p> - <p>Check it out on the <a class="externalLink" href="http://trafodion.apache.org/download.html">Download</a> page.</p> - <p></p> - </div> - <div class="section"> - <h5 id="Want_to_disucss_Trafodion_in_Chinese_Join_the_Trafodion_discussion_on_Tencent_QQ">Want to disucss Trafodion in Chinese? Join the Trafodion discussion on Tencent QQ!</h5> - <p></p> - <p><a class="externalLink" href="http://im.qq.com/">QQ</a> Group ID: 176011868.</p> - </div> - </div> - </div></td> - </tr> - </tbody> - </table> + <div class="section"> + <h2 id="News">News</h2> + <table border="0" class="bodyTable table table-striped table-hover"> + <tbody> + <tr class="a"> + <td> <p> </p> + <div class="section"> + <div class="section"> + <div class="section"> + <h5 id="Apache_Trafodion_is_now_a_Top_Level_Project">Apache Trafodion is now a Top Level Project!</h5> + <p></p> + <p>Check out the <a class="externalLink" href="http://globenewswire.com/news-release/2018/01/10/1286517/0/en/The-Apache-Software-Foundation-Announces-Apache-Trafodion-as-a-Top-Level-Project.html">NewsWire</a> article for the official announcement.</p> + <p>See also this nice <a class="externalLink" href="https://thenewstack.io/sql-hadoop-database-trafodion-bridges-transactions-analysis-divide/">article</a> where Trafodion's own Suresh Subbiah spreads the word on Trafodion's features.</p> + <p></p> + </div> + <div class="section"> + <h5 id="Were_working_on_release_2.2">We're working on release 2.2!</h5> + <p></p> + <p>Check out the <a class="externalLink" href="https://cwiki.apache.org/confluence/display/TRAFODION/Roadmap">Roadmap</a> page for planned content.</p> + <p></p> + </div> + <div class="section"> + <h5 id="Apache_Trafodion_2.1.0-incubating_was_released_on_May_1_2017">Apache Trafodion 2.1.0-incubating was released on May 1, 2017</h5> + <p></p> + <p>Check it out on the <a class="externalLink" href="http://trafodion.apache.org/download.html">Download</a> page.</p> + <p></p> + </div> + <div class="section"> + <h5 id="Want_to_disucss_Trafodion_in_Chinese_Join_the_Trafodion_discussion_on_Tencent_QQ">Want to disucss Trafodion in Chinese? Join the Trafodion discussion on Tencent QQ!</h5> + <p></p> + <p><a class="externalLink" href="http://im.qq.com/">QQ</a> Group ID: 176011868.</p> + </div> + </div> + </div></td> + </tr> + </tbody> + </table> <!-- 20160524 GTA Need more logos before using this part. Powered by Trafodion @@ -230,38 +231,38 @@ Contribution opportunites: usage, code, tests, presentations, documentations, we ![Slide 2](images/logo-carousel/slide-2.png) -Are you using Trafodion? We need permission to add your company's logo here. --> -</div> -<div class="section"> - <h2 id="About">About</h2> - <p>Apache Trafodion is a webscale SQL-on-Hadoop solution enabling transactional or operational workloads on Apache Hadoop. </p> - <p>The name "Trafodion" (the Welsh word for transactions, pronounced "Tra-vod-eee-on") was chosen specifically to emphasize the differentiation that Trafodion provides in closing a critical gap in the Hadoop ecosystem. </p> - <p>Trafodion builds on the scalability, elasticity, and flexibility of Hadoop. Trafodion extends Hadoop to provide guaranteed transactional integrity, enabling new kinds of big data applications to run on Hadoop. </p> +Are you using Trafodion? We need permission to add your company's logo here. --> +</div> +<div class="section"> + <h2 id="About">About</h2> + <p>Apache Trafodion is a webscale SQL-on-Hadoop solution enabling transactional or operational workloads on Apache Hadoop. </p> + <p>The name "Trafodion" (the Welsh word for transactions, pronounced "Tra-vod-eee-on") was chosen specifically to emphasize the differentiation that Trafodion provides in closing a critical gap in the Hadoop ecosystem. </p> + <p>Trafodion builds on the scalability, elasticity, and flexibility of Hadoop. Trafodion extends Hadoop to provide guaranteed transactional integrity, enabling new kinds of big data applications to run on Hadoop. </p> </div> </div> </div> </div> <div class="row columns columns2"> <div class="span6"> - <h2 id="Key_Features">Key Features</h2> -<ul> - <li>Full-functioned ANSI SQL language support</li> - <li>JDBC/ODBC connectivity for Linux/Windows clients</li> - <li>Distributed ACID transaction protection across multiple statements, tables and rows</li> - <li>Performance improvements for OLTP workloads with compile-time and run-time optimizations</li> - <li>Support for large data sets using a parallel-aware query optimizer</li> -</ul> -<div class="section"> + <h2 id="Key_Features">Key Features</h2> +<ul> + <li>Full-functioned ANSI SQL language support</li> + <li>JDBC/ODBC connectivity for Linux/Windows clients</li> + <li>Distributed ACID transaction protection across multiple statements, tables and rows</li> + <li>Performance improvements for OLTP workloads with compile-time and run-time optimizations</li> + <li>Support for large data sets using a parallel-aware query optimizer</li> +</ul> +<div class="section"> </div> </div> <div class="span6"> - <h2 id="Key_Benefits">Key Benefits</h2> -<ul> - <li>Reuse existing SQL skills and improve developer productivity</li> - <li>Distributed ACID transactions guarantee data consistency across multiple rows and tables</li> - <li>Interoperability with existing tools and applications</li> - <li>Hadoop and Linux distribution neutral</li> - <li>Easy to add to your existing Hadoop infrastructure</li> + <h2 id="Key_Benefits">Key Benefits</h2> +<ul> + <li>Reuse existing SQL skills and improve developer productivity</li> + <li>Distributed ACID transactions guarantee data consistency across multiple rows and tables</li> + <li>Interoperability with existing tools and applications</li> + <li>Hadoop and Linux distribution neutral</li> + <li>Easy to add to your existing Hadoop infrastructure</li> </ul> </div> </div> @@ -270,71 +271,71 @@ Are you using Trafodion? We need permission to add your company's logo here. --> <div class="row"> <div class="span12"> <div class="body-content"> - <table border="0" class="bodyTable table table-striped table-hover"> - <tbody> - <tr class="a"> - <td width="33%" valign="top"> - <center> - <div class="section"> - <h2 id="Understand">Understand</h2> - <img src="images/logos/understand.png" width="108" height="108" alt="" /> - <div class="section"> - <div class="section"> - <h4 id="What_makes_Trafodion_unique">What makes Trafodion unique</h4> - <div class="customHr"> - . - </div> - </div> - </div> - </div> - </center> - <ul> - <li><a href="architecture-overview.html">Architecture</a></li> - <li><a href="documentation.html">Documentation</a></li> - <li><a href="faq.html">FAQ</a></li> - </ul> </td> - <td width="33%" valign="top"> - <center> - <div class="section"> - <h2 id="Use">Use</h2> - <img src="images/logos/use.png" width="108" height="108" alt="" /> - <div class="section"> - <div class="section"> - <h4 id="Download_and_try_Trafodion">Download and try Trafodion</h4> - <div class="customHr"> - . - </div> - </div> - </div> - </div> - </center> - <ul> - <li><a href="download.html">Download</a></li> - <li><a href="quickstart.html">Quick Start</a></li> - <li><a href="release-notes.html">Release Notes</a></li> - </ul> </td> - <td width="33%" valign="top"> - <center> - <div class="section"> - <h2 id="Community">Community</h2> - <img src="images/logos/community.png" width="108" height="108" alt="" /> - <div class="section"> - <div class="section"> - <h4 id="Be_part_of_Trafodion">Be part of Trafodion</h4> - <div class="customHr"> - . - </div> - </div> - </div> - </div> - </center> - <ul> - <li><a href="contributing-redirect.html">Contribute</a></li> - <li><a href="mail-lists.html">Discuss</a></li> - <li><a class="externalLink" href="https://cwiki.apache.org/confluence/display/TRAFODION/Apache+Trafodion+Home">Wiki</a></li> - </ul> </td> - </tr> - </tbody> + <table border="0" class="bodyTable table table-striped table-hover"> + <tbody> + <tr class="a"> + <td width="33%" valign="top"> + <center> + <div class="section"> + <h2 id="Understand">Understand</h2> + <img src="images/logos/understand.png" width="108" height="108" alt="" /> + <div class="section"> + <div class="section"> + <h4 id="What_makes_Trafodion_unique">What makes Trafodion unique</h4> + <div class="customHr"> + . + </div> + </div> + </div> + </div> + </center> + <ul> + <li><a href="architecture-overview.html">Architecture</a></li> + <li><a href="documentation.html">Documentation</a></li> + <li><a href="faq.html">FAQ</a></li> + </ul> </td> + <td width="33%" valign="top"> + <center> + <div class="section"> + <h2 id="Use">Use</h2> + <img src="images/logos/use.png" width="108" height="108" alt="" /> + <div class="section"> + <div class="section"> + <h4 id="Download_and_try_Trafodion">Download and try Trafodion</h4> + <div class="customHr"> + . + </div> + </div> + </div> + </div> + </center> + <ul> + <li><a href="download.html">Download</a></li> + <li><a href="quickstart.html">Quick Start</a></li> + <li><a href="release-notes.html">Release Notes</a></li> + </ul> </td> + <td width="33%" valign="top"> + <center> + <div class="section"> + <h2 id="Community">Community</h2> + <img src="images/logos/community.png" width="108" height="108" alt="" /> + <div class="section"> + <div class="section"> + <h4 id="Be_part_of_Trafodion">Be part of Trafodion</h4> + <div class="customHr"> + . + </div> + </div> + </div> + </div> + </center> + <ul> + <li><a href="contributing-redirect.html">Contribute</a></li> + <li><a href="mail-lists.html">Discuss</a></li> + <li><a class="externalLink" href="https://cwiki.apache.org/confluence/display/TRAFODION/Apache+Trafodion+Home">Wiki</a></li> + </ul> </td> + </tr> + </tbody> </table> </div> </div> @@ -485,12 +486,12 @@ Are you using Trafodion? We need permission to add your company's logo here. --> </ul> </div> <div class="span4 bottom-description"> - <blockquote><a href="http://trafodion.apache.org/">Apache Trafodion</a> is a webscale SQL-on-Hadoop solution enabling transactional or operational - workloads on Hadoop. <br /><br />The name "Trafodion" (the Welsh word for transactions, pronounced - "Tra-vod-eee-on") was chosen specifically to emphasize the differentiation that - Trafodion provides in closing a critical gap in the Hadoop ecosystem.<br /><br /> - Trafodion builds on the scalability, elasticity, and flexibility of Hadoop. Trafodion extends - Hadoop to provide guaranteed transactional integrity, enabling new kinds of big data + <blockquote><a href="http://trafodion.apache.org/">Apache Trafodion</a> is a webscale SQL-on-Hadoop solution enabling transactional or operational + workloads on Hadoop. <br /><br />The name "Trafodion" (the Welsh word for transactions, pronounced + "Tra-vod-eee-on") was chosen specifically to emphasize the differentiation that + Trafodion provides in closing a critical gap in the Hadoop ecosystem.<br /><br /> + Trafodion builds on the scalability, elasticity, and flexibility of Hadoop. Trafodion extends + Hadoop to provide guaranteed transactional integrity, enabling new kinds of big data applications to run on Hadoop.</blockquote> </div> </div> http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/2d9ea87d/integration.html ---------------------------------------------------------------------- diff --git a/integration.html b/integration.html index 850f69d..480318e 100644 --- a/integration.html +++ b/integration.html @@ -1,7 +1,7 @@ <!DOCTYPE html> <!-- - Generated by Apache Maven Doxia at 2018-06-04 + Generated by Apache Maven Doxia at 2018-06-07 Rendered using Reflow Maven Skin 1.1.1 (http://andriusvelykis.github.io/reflow-maven-skin) --> <html xml:lang="en" lang="en"> http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/2d9ea87d/issue-tracking.html ---------------------------------------------------------------------- diff --git a/issue-tracking.html b/issue-tracking.html index 5aecb49..b869611 100644 --- a/issue-tracking.html +++ b/issue-tracking.html @@ -1,7 +1,7 @@ <!DOCTYPE html> <!-- - Generated by Apache Maven Doxia at 2018-06-04 + Generated by Apache Maven Doxia at 2018-06-07 Rendered using Reflow Maven Skin 1.1.1 (http://andriusvelykis.github.io/reflow-maven-skin) --> <html xml:lang="en" lang="en"> http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/2d9ea87d/license.html ---------------------------------------------------------------------- diff --git a/license.html b/license.html index 1d3295f..3ccdf38 100644 --- a/license.html +++ b/license.html @@ -1,7 +1,7 @@ <!DOCTYPE html> <!-- - Generated by Apache Maven Doxia at 2018-06-04 + Generated by Apache Maven Doxia at 2018-06-07 Rendered using Reflow Maven Skin 1.1.1 (http://andriusvelykis.github.io/reflow-maven-skin) --> <html xml:lang="en" lang="en"> http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/2d9ea87d/mail-lists.html ---------------------------------------------------------------------- diff --git a/mail-lists.html b/mail-lists.html index 0d09777..daa3377 100644 --- a/mail-lists.html +++ b/mail-lists.html @@ -1,7 +1,7 @@ <!DOCTYPE html> <!-- - Generated by Apache Maven Doxia at 2018-06-04 + Generated by Apache Maven Doxia at 2018-06-07 Rendered using Reflow Maven Skin 1.1.1 (http://andriusvelykis.github.io/reflow-maven-skin) --> <html xml:lang="en" lang="en"> http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/2d9ea87d/modules.html ---------------------------------------------------------------------- diff --git a/modules.html b/modules.html index 49dab39..581596d 100644 --- a/modules.html +++ b/modules.html @@ -1,7 +1,7 @@ <!DOCTYPE html> <!-- - Generated by Apache Maven Doxia at 2018-06-04 + Generated by Apache Maven Doxia at 2018-06-07 Rendered using Reflow Maven Skin 1.1.1 (http://andriusvelykis.github.io/reflow-maven-skin) --> <html xml:lang="en" lang="en"> http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/2d9ea87d/project-info.html ---------------------------------------------------------------------- diff --git a/project-info.html b/project-info.html index 4376d6a..d767bc5 100644 --- a/project-info.html +++ b/project-info.html @@ -1,7 +1,7 @@ <!DOCTYPE html> <!-- - Generated by Apache Maven Doxia at 2018-06-04 + Generated by Apache Maven Doxia at 2018-06-07 Rendered using Reflow Maven Skin 1.1.1 (http://andriusvelykis.github.io/reflow-maven-skin) --> <html xml:lang="en" lang="en"> http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/2d9ea87d/project-summary.html ---------------------------------------------------------------------- diff --git a/project-summary.html b/project-summary.html index 746f09b..6d6f8a0 100644 --- a/project-summary.html +++ b/project-summary.html @@ -1,7 +1,7 @@ <!DOCTYPE html> <!-- - Generated by Apache Maven Doxia at 2018-06-04 + Generated by Apache Maven Doxia at 2018-06-07 Rendered using Reflow Maven Skin 1.1.1 (http://andriusvelykis.github.io/reflow-maven-skin) --> <html xml:lang="en" lang="en"> http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/2d9ea87d/source-repository.html ---------------------------------------------------------------------- diff --git a/source-repository.html b/source-repository.html index c8c260a..6c740fe 100644 --- a/source-repository.html +++ b/source-repository.html @@ -1,7 +1,7 @@ <!DOCTYPE html> <!-- - Generated by Apache Maven Doxia at 2018-06-04 + Generated by Apache Maven Doxia at 2018-06-07 Rendered using Reflow Maven Skin 1.1.1 (http://andriusvelykis.github.io/reflow-maven-skin) --> <html xml:lang="en" lang="en"> http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/2d9ea87d/team-list.html ---------------------------------------------------------------------- diff --git a/team-list.html b/team-list.html index 2f1c5f8..55b2758 100644 --- a/team-list.html +++ b/team-list.html @@ -1,7 +1,7 @@ <!DOCTYPE html> <!-- - Generated by Apache Maven Doxia at 2018-06-04 + Generated by Apache Maven Doxia at 2018-06-07 Rendered using Reflow Maven Skin 1.1.1 (http://andriusvelykis.github.io/reflow-maven-skin) --> <html xml:lang="en" lang="en">