Repository: trafodion-site Updated Branches: refs/heads/asf-site 5cb946c95 -> d0b28d5a5
http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/d0b28d5a/docs/sql_reference/dependencies.html ---------------------------------------------------------------------- diff --git a/docs/sql_reference/dependencies.html b/docs/sql_reference/dependencies.html index ec92234..8007025 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 at Jan 26, 2018 --> +<!-- Generated by Apache Maven Doxia at Jan 30, 2018 --> <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="20180126" /> + <meta name="Date-Revision-yyyymmdd" content="20180130" /> <meta http-equiv="Content-Language" content="en" /> </head> @@ -27,7 +27,7 @@ <div class="xleft"> - <span id="publishDate">Last Published: 2018-01-26</span> + <span id="publishDate">Last Published: 2018-01-30</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/d0b28d5a/docs/sql_reference/index.html ---------------------------------------------------------------------- diff --git a/docs/sql_reference/index.html b/docs/sql_reference/index.html index 7f8aa77..857be4d 100644 --- a/docs/sql_reference/index.html +++ b/docs/sql_reference/index.html @@ -18149,7 +18149,8 @@ option is: | NO POPULATE INDEXES | NO DUPLICATE CHECK | NO OUTPUT - | INDEX TABLE ONLY</code></pre> + | INDEX TABLE ONLY + | REBUILD INDEXES</code></pre> </div> </div> <div class="sect3"> @@ -18306,6 +18307,21 @@ Bulk Loader is executing.</p> data from the parent table.</p> </div> </li> +<li> +<p><code>REBUILD INDEXES</code></p> +<div class="paragraph"> +<p>specifies that indexes of the target table will be updated automatically when the source table +is updated.</p> +</div> +<div class="paragraph"> +<p>This is the default behavior of the LOAD Statement, that is, even if this option is not +specified, the LOAD Statement will rebuild indexes unless the +CQD <code>TRAF_LOAD_ALLOW_RISKY_INDEX_MAINTENANCE</code> is turned <strong>ON</strong>. This CQD is turned <strong>OFF</strong> by default. +In this case, the elapsed time of using LOAD Statement without options is nearly equal to +using LOAD WITH REBUILD INDEXES, and the elapsed time of the former is less than the latter +if this CQD is turned ON.</p> +</div> +</li> </ul> </div> </li> @@ -19134,6 +19150,372 @@ SQL> DROP INDEX index_target_table4; </div> </div> <div class="sect4"> +<h5 id="rebuild_indexes_examples">Examples of <code>REBUILD INDEXES</code></h5> +<div class="paragraph"> +<p>Suppose that we have following tables:</p> +</div> +<div class="paragraph"> +<p><em>source_table</em>:</p> +</div> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">SQL>select count(*) from source_table; +(EXPR) +-------------------- +Â Â Â Â Â Â Â Â Â Â Â Â 1000000 + +--- 1 row(s) selected.</code></pre> +</div> +</div> +<div class="paragraph"> +<p><em>target_table1</em> and <em>target_table2</em> both have the following structure:</p> +</div> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">SQL>CREATE TABLE target_table1 +Â ( +Â Â Â Â IDÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â INT NO DEFAULT NOT NULL NOT DROPPABLE NOT +Â Â Â Â Â SERIALIZED +Â , NUMÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â INT DEFAULT NULL NOT SERIALIZED +Â , CARD_IDÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â LARGEINT DEFAULT NULL NOT SERIALIZED +Â , PRICEÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â DECIMAL(11, 3) DEFAULT NULL NOT SERIALIZED +Â , START_DATEÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â DATE DEFAULT NULL NOT SERIALIZED +Â , START_TIMEÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â TIME(0) DEFAULT NULL NOT SERIALIZED +Â , END_TIMEÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â TIMESTAMP(6) DEFAULT NULL NOT SERIALIZED +Â , B_YEARÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â INTERVAL YEAR(10) DEFAULT NULL NOT +Â Â Â Â Â SERIALIZED +Â , B_YMÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â INTERVAL YEAR(5) TO MONTH DEFAULT NULL NOT +Â Â Â Â Â SERIALIZED +Â , B_DSÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â INTERVAL DAY(10) TO SECOND(3) DEFAULT NULL +Â Â Â Â Â NOT SERIALIZED +Â , PRIMARY KEY (ID ASC) +Â ) +Â SALT USING 9 PARTITIONS + ATTRIBUTES ALIGNED FORMAT NAMESPACE 'TRAF_1500000' +Â Â HBASE_OPTIONS +Â Â ( +Â Â Â Â MEMSTORE_FLUSH_SIZE = '1073741824' +Â Â ) +;</code></pre> +</div> +</div> +<div class="ulist"> +<ul> +<li> +<p>This example compares the execution time of using LOAD Statement without options and +using <code>LOAD WITH REBUILD INDEXES</code> when the CQD <code>TRAF_LOAD_ALLOW_RISKY_INDEX_MAINTENANCE</code> +is turned <strong>OFF</strong> by default. These two statements take almost the same time.</p> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">SQL>CREATE INDEX index_target_table1 ON target_table1(id); +--- SQL operation complete. + +SQL>SET STATISTICS ON; + +SQL>LOAD INTO target_table1 SELECT * FROM source_table WHERE id < 301; + +UTIL_OUTPUT +--------------------------------------------------------------------------------- +Task: LOAD Status: Started Object: TRAFODION.SEABASE.TARGET_TABLE1 +Task: CLEANUP Status: Started Time: 2018-01-18 13:33:52.310 +Task: CLEANUP Status: Ended Time: 2018-01-18 13:33:52.328 +Task: CLEANUP Status: Ended Elapsed Time: 00:00:00.019 +Task: DISABLE INDEXE Status: Started Time: 2018-01-18 13:33:52.328 +Task: DISABLE INDEXE Status: Ended Time: 2018-01-18 13:34:04.709 +Task: DISABLE INDEXE Status: Ended Elapsed Time: 00:00:12.381 +Task: LOADING DATA Status: Started Time: 2018-01-18 13:34:04.709 + Rows Processed: 300 + Error Rows: 0 +Task: LOADING DATA Status: Ended Time: 2018-01-18 13:34:21.629 +Task: LOADING DATA Status: Ended Elapsed Time: 00:00:16.919 +Task: COMPLETION Status: Started Time: 2018-01-18 13:34:21.629 + Rows Loaded: 300 +Task: COMPLETION Status: Ended Time: 2018-01-18 13:34:22.436 +Task: COMPLETION Status: Ended Elapsed Time: 00:00:00.808 +Task: POPULATE INDEX Status: Started Time: 2018-01-18 13:34:22.436 +Task: POPULATE INDEX Status: Ended Time: 2018-01-18 13:34:31.116 +Task: POPULATE INDEX Status: Ended Elapsed Time: 00:00:08.680 +--- SQL operation complete. + +Start Time 2018/01/18 13:33:51.478782 +End Time 2018/01/18 13:34:31.549491 +Elapsed Time 00:00:40.070709 +Compile Time 00:00:00.510024 +Execution Time 00:00:39.559433 + +SQL>LOAD INTO target_table1 SELECT * FROM source_table WHERE id > 300; +UTIL_OUTPUT +--------------------------------------------------------------------------------- +Task: LOAD Status: Started Object: TRAFODION.SEABASE.TARGET_TABLE1 +Task: CLEANUP Status: Started Time: 2018-01-18 13:35:01.804 +Task: CLEANUP Status: Ended Time: 2018-01-18 13:35:01.823 +Task: CLEANUP Status: Ended Elapsed Time: 00:00:00.018 +Task: DISABLE INDEXE Status: Started Time: 2018-01-18 13:35:01.823 +Task: DISABLE INDEXE Status: Ended Time: 2018-01-18 13:35:13.840 +Task: DISABLE INDEXE Status: Ended Elapsed Time: 00:00:12.017 +Task: LOADING DATA Status: Started Time: 2018-01-18 13:35:13.840 + Rows Processed: 999700 + Error Rows: 0 +Task: LOADING DATA Status: Ended Time: 2018-01-18 13:35:19.720 +Task: LOADING DATA Status: Ended Elapsed Time: 00:00:05.879 +Task: COMPLETION Status: Started Time: 2018-01-18 13:35:19.720 + Rows Loaded: 999700 +Task: COMPLETION Status: Ended Time: 2018-01-18 13:35:22.436 +Task: COMPLETION Status: Ended Elapsed Time: 00:00:02.717 +Task: POPULATE INDEX Status: Started Time: 2018-01-18 13:35:22.436 +Task: POPULATE INDEX Status: Ended Time: 2018-01-18 13:35:33.346 +Task: POPULATE INDEX Status: Ended Elapsed Time: 00:00:10.910 +--- SQL operation complete. + +Start Time 2018/01/18 13:35:00.624490 +End Time 2018/01/18 13:35:33.779394 +Elapsed Time 00:00:33.154904 +Compile Time 00:00:00.825703 +Execution Time 00:00:32.321890 + +SQL>SET PARSERFLAGS 1; +--- SQL operation complete. + +SQL>SELECT COUNT(*) FROM TABLE(INDEX_TABLE index_target_table1); +(EXPR) +-------------------- + 1000000 +--- 1 row(s) selected.</code></pre> +</div> +</div> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">SQL>CREATE INDEX index_target_table2 ON target_table2(id); +--- SQL operation complete. + +SQL>SET STATISTICS ON; + +SQL>LOAD WITH REBUILD INDEXES INTO target_table2 SELECT * FROM source_table WHERE id < 301; +UTIL_OUTPUT +--------------------------------------------------------------------------------- +Task: LOAD Status: Started Object: TRAFODION.SEABASE.TARGET_TABLE2 +Task: CLEANUP Status: Started Time: 2018-01-18 13:34:37.836 +Task: CLEANUP Status: Ended Time: 2018-01-18 13:34:37.847 +Task: CLEANUP Status: Ended Elapsed Time: 00:00:00.011 +Task: DISABLE INDEXE Status: Started Time: 2018-01-18 13:34:37.847 +Task: DISABLE INDEXE Status: Ended Time: 2018-01-18 13:34:45.445 +Task: DISABLE INDEXE Status: Ended Elapsed Time: 00:00:07.598 +Task: LOADING DATA Status: Started Time: 2018-01-18 13:34:45.445 + Rows Processed: 300 + Error Rows: 0 +Task: LOADING DATA Status: Ended Time: 2018-01-18 13:35:03.576 +Task: LOADING DATA Status: Ended Elapsed Time: 00:00:18.131 +Task: COMPLETION Status: Started Time: 2018-01-18 13:35:03.577 + Rows Loaded: 300 +Task: COMPLETION Status: Ended Time: 2018-01-18 13:35:04.873 +Task: COMPLETION Status: Ended Elapsed Time: 00:00:01.296 +Task: POPULATE INDEX Status: Started Time: 2018-01-18 13:35:04.873 +Task: POPULATE INDEX Status: Ended Time: 2018-01-18 13:35:12.461 +Task: POPULATE INDEX Status: Ended Elapsed Time: 00:00:07.589 +--- SQL operation complete. + +Start Time 2018/01/18 13:34:37.053647 +End Time 2018/01/18 13:35:12.893891 +Elapsed Time 00:00:35.840244 +Compile Time 00:00:00.435855 +Execution Time 00:00:35.402620 + +SQL>LOAD WITH REBUILD INDEXES INTO target_table2 SELECT * FROM source_table WHERE id > 300; +UTIL_OUTPUT +--------------------------------------------------------------------------------- +Task: LOAD Status: Started Object: TRAFODION.SEABASE.TARGET_TABLE2 +Task: CLEANUP Status: Started Time: 2018-01-18 13:35:25.480 +Task: CLEANUP Status: Ended Time: 2018-01-18 13:35:25.493 +Task: CLEANUP Status: Ended Elapsed Time: 00:00:00.013 +Task: DISABLE INDEXE Status: Started Time: 2018-01-18 13:35:25.493 +Task: DISABLE INDEXE Status: Ended Time: 2018-01-18 13:35:38.844 +Task: DISABLE INDEXE Status: Ended Elapsed Time: 00:00:12.591 +Task: LOADING DATA Status: Started Time: 2018-01-18 13:35:38.845 + Rows Processed: 999700 + Error Rows: 0 +Task: LOADING DATA Status: Ended Time: 2018-01-18 13:35:43.491 +Task: LOADING DATA Status: Ended Elapsed Time: 00:00:05.407 +Task: COMPLETION Status: Started Time: 2018-01-18 13:35:43.491 + Rows Loaded: 999700 +Task: COMPLETION Status: Ended Time: 2018-01-18 13:35:45.920 +Task: COMPLETION Status: Ended Elapsed Time: 00:00:01.601 +Task: POPULATE INDEX Status: Started Time: 2018-01-18 13:35:45.920 +Task: POPULATE INDEX Status: Ended Time: 2018-01-18 13:35:56.322 +Task: POPULATE INDEX Status: Ended Elapsed Time: 00:00:11.230 +--- SQL operation complete. + +Start Time 2018/01/18 13:35:24.693410 +End Time 2018/01/18 13:35:56.754441 +Elapsed Time 00:00:32.061031 +Compile Time 00:00:00.449236 +Execution Time 00:00:31.611112 + +SQL>SET PARSERFLAGS 1; +--- SQL operation complete. + +SQL>SELECT COUNT(*) FROM TABLE(INDEX_TABLE index_target_table2); +(EXPR) +-------------------- + 1000000 + +--- 1 row(s) selected.</code></pre> +</div> +</div> +</li> +<li> +<p>This example compares the execution time of using LOAD Statement without options and +using <code>LOAD WITH REBUILD INDEXES</code> when the CQD <code>TRAF_LOAD_ALLOW_RISKY_INDEX_MAINTENANCE</code> +is turned <strong>ON</strong>. The former takes less time than the latter.</p> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">SQL>CQD TRAF_LOAD_ALLOW_RISKY_INDEX_MAINTENANCE 'ON'; +--- SQL operation complete. + +SQL>CREATE INDEX index_target_table1 ON target_table1(id); +--- SQL operation complete. + +SQL>SET STATISTICS ON; + +SQL>LOAD INTO target_table1 SELECT * FROM source_table WHERE id < 301; +UTIL_OUTPUT +--------------------------------------------------------------------------------- +Task: LOAD Status: Started Object: TRAFODION.SEABASE.TARGET_TABLE1 +Task: CLEANUP Status: Started Time: 2018-01-18 13:46:01.730 +Task: CLEANUP Status: Ended Time: 2018-01-18 13:46:01.756 +Task: CLEANUP Status: Ended Elapsed Time: 00:00:00.027 +Task: LOADING DATA Status: Started Time: 2018-01-18 13:46:01.756 + Rows Processed: 300 + Error Rows: 0 +Task: LOADING DATA Status: Ended Time: 2018-01-18 13:46:22.415 +Task: LOADING DATA Status: Ended Elapsed Time: 00:00:20.659 +Task: COMPLETION Status: Started Time: 2018-01-18 13:46:22.415 + Rows Loaded: 300 +Task: COMPLETION Status: Ended Time: 2018-01-18 13:46:26.353 +Task: COMPLETION Status: Ended Elapsed Time: 00:00:03.938 +--- SQL operation complete. + +Start Time 2018/01/18 13:46:00.954518 +End Time 2018/01/18 13:46:26.795757 +Elapsed Time 00:00:25.841239 +Compile Time 00:00:00.455681 +Execution Time 00:00:25.384158 + +SQL>LOAD INTO target_table1 SELECT * FROM source_table WHERE id > 300; +UTIL_OUTPUT +--------------------------------------------------------------------------------- +Task: LOAD Status: Started Object: TRAFODION.SEABASE.TARGET_TABLE1 +Task: CLEANUP Status: Started Time: 2018-01-18 13:46:57.811 +Task: CLEANUP Status: Ended Time: 2018-01-18 13:46:57.870 +Task: CLEANUP Status: Ended Elapsed Time: 00:00:00.058 +Task: LOADING DATA Status: Started Time: 2018-01-18 13:46:57.870 + Rows Processed: 999700 + Error Rows: 0 +Task: LOADING DATA Status: Ended Time: 2018-01-18 13:47:12.411 +Task: LOADING DATA Status: Ended Elapsed Time: 00:00:14.541 +Task: COMPLETION Status: Started Time: 2018-01-18 13:47:12.411 + Rows Loaded: 999700 +Task: COMPLETION Status: Ended Time: 2018-01-18 13:47:16.292 +Task: COMPLETION Status: Ended Elapsed Time: 00:00:03.881 +--- SQL operation complete. + +Start Time 2018/01/18 13:46:57.400422 +End Time 2018/01/18 13:47:16.738970 +Elapsed Time 00:00:19.338548 +Compile Time 00:00:00.010545 +Execution Time 00:00:19.321781 + +SQL>SET PARSERFLAGS 1; +--- SQL operation complete. + +SQL>SELECT COUNT(*) FROM TABLE(INDEX_TABLE index_target_table1); +(EXPR) +-------------------- + 1000000 +--- 1 row(s) selected.</code></pre> +</div> +</div> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">SQL>CREATE INDEX index_target_table2 ON target_table2(id); +--- SQL operation complete. + +SQL>SET STATISTICS ON; + +SQL>LOAD WITH REBUILD INDEXES INTO target_table2 SELECT * FROM source_table WHERE id < 301; +UTIL_OUTPUT +--------------------------------------------------------------------------------- +Task: LOAD Status: Started Object: TRAFODION.SEABASE.TARGET_TABLE2 +Task: CLEANUP Status: Started Time: 2018-01-18 13:46:28.303 +Task: CLEANUP Status: Ended Time: 2018-01-18 13:46:28.796 +Task: CLEANUP Status: Ended Elapsed Time: 00:00:00.049 +Task: DISABLE INDEXE Status: Started Time: 2018-01-18 13:46:28.796 +Task: DISABLE INDEXE Status: Ended Time: 2018-01-18 13:46:38.479 +Task: DISABLE INDEXE Status: Ended Elapsed Time: 00:00:10.400 +Task: LOADING DATA Status: Started Time: 2018-01-18 13:46:38.479 + Rows Processed: 300 + Error Rows: 0 +Task: LOADING DATA Status: Ended Time: 2018-01-18 13:46:58.143 +Task: LOADING DATA Status: Ended Elapsed Time: 00:00:19.665 +Task: COMPLETION Status: Started Time: 2018-01-18 13:46:58.144 + Rows Loaded: 300 +Task: COMPLETION Status: Ended Time: 2018-01-18 13:47:00.186 +Task: COMPLETION Status: Ended Elapsed Time: 00:00:02.043 +Task: POPULATE INDEX Status: Started Time: 2018-01-18 13:47:00.187 +Task: POPULATE INDEX Status: Ended Time: 2018-01-18 13:47:09.966 +Task: POPULATE INDEX Status: Ended Elapsed Time: 00:00:08.910 +--- SQL operation complete. + +Start Time 2018/01/18 13:46:27.063642 +End Time 2018/01/18 13:47:09.529257 +Elapsed Time 00:00:42.465615 +Compile Time 00:00:00.532541 +Execution Time 00:00:41.928812 + +SQL>LOAD WITH REBUILD INDEXES INTO target_table2 SELECT * FROM source_table WHERE id > 300; +UTIL_OUTPUT +--------------------------------------------------------------------------------- +Task: LOAD Status: Started Object: TRAFODION.SEABASE.TARGET_TABLE2 +Task: CLEANUP Status: Started Time: 2018-01-18 13:47:18.187 +Task: CLEANUP Status: Ended Time: 2018-01-18 13:47:18.198 +Task: CLEANUP Status: Ended Elapsed Time: 00:00:00.011 +Task: DISABLE INDEXE Status: Started Time: 2018-01-18 13:47:18.198 +Task: DISABLE INDEXE Status: Ended Time: 2018-01-18 13:47:30.670 +Task: DISABLE INDEXE Status: Ended Elapsed Time: 00:00:12.472 +Task: LOADING DATA Status: Started Time: 2018-01-18 13:47:30.670 + Rows Processed: 999700 + Error Rows: 0 +Task: LOADING DATA Status: Ended Time: 2018-01-18 13:47:39.311 +Task: LOADING DATA Status: Ended Elapsed Time: 00:00:08.641 +Task: COMPLETION Status: Started Time: 2018-01-18 13:47:39.311 + Rows Loaded: 999700 +Task: COMPLETION Status: Ended Time: 2018-01-18 13:47:40.497 +Task: COMPLETION Status: Ended Elapsed Time: 00:00:01.186 +Task: POPULATE INDEX Status: Started Time: 2018-01-18 13:47:40.497 +Task: POPULATE INDEX Status: Ended Time: 2018-01-18 13:47:52.367 +Task: POPULATE INDEX Status: Ended Elapsed Time: 00:00:11.539 +--- SQL operation complete. + +Start Time 2018/01/18 13:47:17.447093 +End Time 2018/01/18 13:47:52.469190 +Elapsed Time 00:00:35.022097 +Compile Time 00:00:00.412718 +Execution Time 00:00:34.608571 + +SQL>SET PARSERFLAGES 1; +--- SQL operation complete. + +SQL>SELECT COUNT(*) FROM TABLE(INDEX_TABLE index_target_table2); +(EXPR) +-------------------- + 1000000 +--- 1 row(s) selected.</code></pre> +</div> +</div> +</li> +</ul> +</div> +</div> +<div class="sect4"> <h5 id="loading_data_from_hive_table_examples">Examples of Loading data from Hive Table</h5> <div class="ulist"> <ul> http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/d0b28d5a/docs/sql_reference/integration.html ---------------------------------------------------------------------- diff --git a/docs/sql_reference/integration.html b/docs/sql_reference/integration.html index 6a7ecd9..c6f6f66 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 at Jan 26, 2018 --> +<!-- Generated by Apache Maven Doxia at Jan 30, 2018 --> <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="20180126" /> + <meta name="Date-Revision-yyyymmdd" content="20180130" /> <meta http-equiv="Content-Language" content="en" /> </head> @@ -27,7 +27,7 @@ <div class="xleft"> - <span id="publishDate">Last Published: 2018-01-26</span> + <span id="publishDate">Last Published: 2018-01-30</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/d0b28d5a/docs/sql_reference/issue-tracking.html ---------------------------------------------------------------------- diff --git a/docs/sql_reference/issue-tracking.html b/docs/sql_reference/issue-tracking.html index d5c6a0d..29ef2a6 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 at Jan 26, 2018 --> +<!-- Generated by Apache Maven Doxia at Jan 30, 2018 --> <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="20180126" /> + <meta name="Date-Revision-yyyymmdd" content="20180130" /> <meta http-equiv="Content-Language" content="en" /> </head> @@ -27,7 +27,7 @@ <div class="xleft"> - <span id="publishDate">Last Published: 2018-01-26</span> + <span id="publishDate">Last Published: 2018-01-30</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/d0b28d5a/docs/sql_reference/license.html ---------------------------------------------------------------------- diff --git a/docs/sql_reference/license.html b/docs/sql_reference/license.html index 3f35fcc..95e6c00 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 at Jan 26, 2018 --> +<!-- Generated by Apache Maven Doxia at Jan 30, 2018 --> <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="20180126" /> + <meta name="Date-Revision-yyyymmdd" content="20180130" /> <meta http-equiv="Content-Language" content="en" /> </head> @@ -27,7 +27,7 @@ <div class="xleft"> - <span id="publishDate">Last Published: 2018-01-26</span> + <span id="publishDate">Last Published: 2018-01-30</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/d0b28d5a/docs/sql_reference/mail-lists.html ---------------------------------------------------------------------- diff --git a/docs/sql_reference/mail-lists.html b/docs/sql_reference/mail-lists.html index 7355611..86bee3e 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 at Jan 26, 2018 --> +<!-- Generated by Apache Maven Doxia at Jan 30, 2018 --> <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="20180126" /> + <meta name="Date-Revision-yyyymmdd" content="20180130" /> <meta http-equiv="Content-Language" content="en" /> </head> @@ -27,7 +27,7 @@ <div class="xleft"> - <span id="publishDate">Last Published: 2018-01-26</span> + <span id="publishDate">Last Published: 2018-01-30</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/d0b28d5a/docs/sql_reference/project-info.html ---------------------------------------------------------------------- diff --git a/docs/sql_reference/project-info.html b/docs/sql_reference/project-info.html index 608438f..f68fa4f 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 at Jan 26, 2018 --> +<!-- Generated by Apache Maven Doxia at Jan 30, 2018 --> <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="20180126" /> + <meta name="Date-Revision-yyyymmdd" content="20180130" /> <meta http-equiv="Content-Language" content="en" /> </head> @@ -27,7 +27,7 @@ <div class="xleft"> - <span id="publishDate">Last Published: 2018-01-26</span> + <span id="publishDate">Last Published: 2018-01-30</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/d0b28d5a/docs/sql_reference/project-summary.html ---------------------------------------------------------------------- diff --git a/docs/sql_reference/project-summary.html b/docs/sql_reference/project-summary.html index 21328a6..0309d74 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 at Jan 26, 2018 --> +<!-- Generated by Apache Maven Doxia at Jan 30, 2018 --> <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="20180126" /> + <meta name="Date-Revision-yyyymmdd" content="20180130" /> <meta http-equiv="Content-Language" content="en" /> </head> @@ -27,7 +27,7 @@ <div class="xleft"> - <span id="publishDate">Last Published: 2018-01-26</span> + <span id="publishDate">Last Published: 2018-01-30</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/d0b28d5a/docs/sql_reference/source-repository.html ---------------------------------------------------------------------- diff --git a/docs/sql_reference/source-repository.html b/docs/sql_reference/source-repository.html index 21c9047..af76724 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 at Jan 26, 2018 --> +<!-- Generated by Apache Maven Doxia at Jan 30, 2018 --> <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="20180126" /> + <meta name="Date-Revision-yyyymmdd" content="20180130" /> <meta http-equiv="Content-Language" content="en" /> </head> @@ -27,7 +27,7 @@ <div class="xleft"> - <span id="publishDate">Last Published: 2018-01-26</span> + <span id="publishDate">Last Published: 2018-01-30</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/d0b28d5a/docs/sql_reference/team-list.html ---------------------------------------------------------------------- diff --git a/docs/sql_reference/team-list.html b/docs/sql_reference/team-list.html index acf84de..145d3fe 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 at Jan 26, 2018 --> +<!-- Generated by Apache Maven Doxia at Jan 30, 2018 --> <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="20180126" /> + <meta name="Date-Revision-yyyymmdd" content="20180130" /> <meta http-equiv="Content-Language" content="en" /> </head> @@ -27,7 +27,7 @@ <div class="xleft"> - <span id="publishDate">Last Published: 2018-01-26</span> + <span id="publishDate">Last Published: 2018-01-30</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/d0b28d5a/index.html ---------------------------------------------------------------------- diff --git a/index.html b/index.html index 1179287..644b06c 100644 --- a/index.html +++ b/index.html @@ -1,7 +1,7 @@ <!DOCTYPE html> <!-- - Generated by Apache Maven Doxia at 2018-01-26 + Generated by Apache Maven Doxia at 2018-01-26 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/d0b28d5a/integration.html ---------------------------------------------------------------------- diff --git a/integration.html b/integration.html index f9651e3..a80c57f 100644 --- a/integration.html +++ b/integration.html @@ -1,7 +1,7 @@ <!DOCTYPE html> <!-- - Generated by Apache Maven Doxia at 2018-01-26 + Generated by Apache Maven Doxia at 2018-01-30 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/d0b28d5a/issue-tracking.html ---------------------------------------------------------------------- diff --git a/issue-tracking.html b/issue-tracking.html index f2635f1..06048c3 100644 --- a/issue-tracking.html +++ b/issue-tracking.html @@ -1,7 +1,7 @@ <!DOCTYPE html> <!-- - Generated by Apache Maven Doxia at 2018-01-26 + Generated by Apache Maven Doxia at 2018-01-30 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/d0b28d5a/license.html ---------------------------------------------------------------------- diff --git a/license.html b/license.html index e037fd2..3398875 100644 --- a/license.html +++ b/license.html @@ -1,7 +1,7 @@ <!DOCTYPE html> <!-- - Generated by Apache Maven Doxia at 2018-01-26 + Generated by Apache Maven Doxia at 2018-01-30 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/d0b28d5a/mail-lists.html ---------------------------------------------------------------------- diff --git a/mail-lists.html b/mail-lists.html index 173e458..8b5f085 100644 --- a/mail-lists.html +++ b/mail-lists.html @@ -1,7 +1,7 @@ <!DOCTYPE html> <!-- - Generated by Apache Maven Doxia at 2018-01-26 + Generated by Apache Maven Doxia at 2018-01-30 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/d0b28d5a/modules.html ---------------------------------------------------------------------- diff --git a/modules.html b/modules.html index 424cb14..c386e4d 100644 --- a/modules.html +++ b/modules.html @@ -1,7 +1,7 @@ <!DOCTYPE html> <!-- - Generated by Apache Maven Doxia at 2018-01-26 + Generated by Apache Maven Doxia at 2018-01-30 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/d0b28d5a/project-info.html ---------------------------------------------------------------------- diff --git a/project-info.html b/project-info.html index 15aff7b..0d295cc 100644 --- a/project-info.html +++ b/project-info.html @@ -1,7 +1,7 @@ <!DOCTYPE html> <!-- - Generated by Apache Maven Doxia at 2018-01-26 + Generated by Apache Maven Doxia at 2018-01-30 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/d0b28d5a/project-summary.html ---------------------------------------------------------------------- diff --git a/project-summary.html b/project-summary.html index 3f458fd..fb272aa 100644 --- a/project-summary.html +++ b/project-summary.html @@ -1,7 +1,7 @@ <!DOCTYPE html> <!-- - Generated by Apache Maven Doxia at 2018-01-26 + Generated by Apache Maven Doxia at 2018-01-30 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/d0b28d5a/source-repository.html ---------------------------------------------------------------------- diff --git a/source-repository.html b/source-repository.html index 61200d2..491327c 100644 --- a/source-repository.html +++ b/source-repository.html @@ -1,7 +1,7 @@ <!DOCTYPE html> <!-- - Generated by Apache Maven Doxia at 2018-01-26 + Generated by Apache Maven Doxia at 2018-01-30 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/d0b28d5a/team-list.html ---------------------------------------------------------------------- diff --git a/team-list.html b/team-list.html index e641a87..ced057a 100644 --- a/team-list.html +++ b/team-list.html @@ -1,7 +1,7 @@ <!DOCTYPE html> <!-- - Generated by Apache Maven Doxia at 2018-01-26 + Generated by Apache Maven Doxia at 2018-01-30 Rendered using Reflow Maven Skin 1.1.1 (http://andriusvelykis.github.io/reflow-maven-skin) --> <html xml:lang="en" lang="en">
