Repository: trafodion-site Updated Branches: refs/heads/asf-site e967487a8 -> 758b046ee
http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/758b046e/docs/sql_reference/dependencies.html ---------------------------------------------------------------------- diff --git a/docs/sql_reference/dependencies.html b/docs/sql_reference/dependencies.html index f3d010a..05d2261 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 Mar 18, 2018 --> +<!-- Generated by Apache Maven Doxia at Mar 20, 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="20180318" /> + <meta name="Date-Revision-yyyymmdd" content="20180320" /> <meta http-equiv="Content-Language" content="en" /> </head> @@ -27,7 +27,7 @@ <div class="xleft"> - <span id="publishDate">Last Published: 2018-03-18</span> + <span id="publishDate">Last Published: 2018-03-20</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/758b046e/docs/sql_reference/index.html ---------------------------------------------------------------------- diff --git a/docs/sql_reference/index.html b/docs/sql_reference/index.html index 4e28037..a31a1bf 100644 --- a/docs/sql_reference/index.html +++ b/docs/sql_reference/index.html @@ -9040,6 +9040,346 @@ CREATE TABLE t2 (c1 int, c2 char (50) UPSHIFT NOT NULL) AS SELECT * FROM t1;</co </div> <div style="page-break-after: always;"></div> </div> +<div class="sect4"> +<h5 id="create_table_examples_create_external_table">Examples of CREATE EXTERNAL TABLE</h5> +<div class="paragraph"> +<p>This example compares the execution time of using external table and not using external table when reading hive tables.</p> +</div> +<div class="paragraph"> +<p>The former takes less time than the latter, since the trafodion external table supplies upper bounds for varchar lengths, which may lead to better plans and/or run-time behavior.</p> +</div> +<div class="admonitionblock tip"> +<table> +<tr> +<td class="icon"> +<i class="fa icon-tip" title="Tip"></i> +</td> +<td class="content"> +Either running UPDATE STATISTICS or using a trafodion external table may improve performance. To get full performance benefit, you must run UPDATE STATISTICS and use the trafodion external table. +</td> +</tr> +</table> +</div> +<div class="paragraph"> +<p>This is the definition of the <strong>hive table</strong> <em>test_mix</em> which has a trafodion external table, the size is 137.6G.</p> +</div> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">SQL>SHOWDDL test_mix; + +CREATE EXTERNAL TABLE test_mix( + mix_id int not null not droppable primary key, + mix_age int, + mix_name string, + mix_timestamp01 string, + mix_timestamp02 string, + mix_other01 string, + mix_other02 string, + mix_other03 string, + mix_other04 string, + mix_other05 string, + mix_other06 string, + mix_other07 string, + mix_other08 string, + mix_other09 string, + mix_other10 string, + mix_other11 string, + mix_other12 string, + mix_other13 string, + mix_other14 string, + mix_other15 string + ) +row format delimited fields terminated by '|' + location '/user/trafodion/data/ExternalTable_data'; +-- 01-06 short 06-11medium 12-15 long</code></pre> +</div> +</div> +<div class="paragraph"> +<p>This is the definition of the <strong>trafodion external table</strong> <em>test_mix</em>, it has the same structure and size as the hive table <em>test_mix</em>.</p> +</div> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">SQL>SHOWDDL text_mix; + +CREATE EXTERNAL TABLE test_mix( + mix_id int, + mix_age int, + mix_name varchar(20), + mix_timestamp01 timestamp, + mix_timestamp02 varchar(20), + mix_other01 varchar(12), + mix_other02 varchar(12), + mix_other03 varchar(12), + mix_other04 varchar(12), + mix_other05 varchar(12), + mix_other06 varchar(12), + mix_other07 varchar(64), + mix_other08 varchar(64), + mix_other09 varchar(64), + mix_other10 varchar(64), + mix_other11 varchar(128), + mix_other12 varchar(128), + mix_other13 varchar(128), + mix_other14 varchar(1024), + mix_other15 varchar(1024) + )for hive.hive.test_mix; +-- 01-06 short 07-11medium 12-15 long</code></pre> +</div> +</div> +<div class="ulist"> +<ul> +<li> +<p>When executing the following query:</p> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">SELECT [LAST 1] * FROM hive.hive.test_mix WHERE mix_other02 = 'Ot';</code></pre> +</div> +</div> +<div class="paragraph"> +<p>it takes approximately <strong>6 minutes</strong> (average value) to get the result using the trafodion external table.</p> +</div> +<table class="tableblock frame-all grid-all spread"> +<colgroup> +<col style="width: 20%;"> +<col style="width: 20%;"> +<col style="width: 20%;"> +<col style="width: 20%;"> +<col style="width: 20%;"> +</colgroup> +<thead> +<tr> +<th class="tableblock halign-left valign-top"></th> +<th class="tableblock halign-left valign-top">First Result</th> +<th class="tableblock halign-left valign-top">Second Result</th> +<th class="tableblock halign-left valign-top">Third Result</th> +<th class="tableblock halign-left valign-top">Average Value</th> +</tr> +</thead> +<tbody> +<tr> +<td class="tableblock halign-left valign-top"><p class="tableblock">Start Time</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/07 18:40:31.655159</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/07 09:37:50.801345</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/07 09:45:05.921706</p></td> +<td class="tableblock halign-left valign-top"></td> +</tr> +<tr> +<td class="tableblock halign-left valign-top"><p class="tableblock">End Time</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/07 18:49:08.879780</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/07 09:43:16.695492</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/07 09:48:58.251764</p></td> +<td class="tableblock halign-left valign-top"></td> +</tr> +<tr> +<td class="tableblock halign-left valign-top"><p class="tableblock">Elapsed Time</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/07 00:08:37.224621</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/07 00:05:25.894147</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/07 00:03:52.330058</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">00:06:12.23</p></td> +</tr> +<tr> +<td class="tableblock halign-left valign-top"><p class="tableblock">Compile Time</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/07 00:00:03.497624</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/07 00:00:11.595054</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/07 00:00:00.551781</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">00:00:04.8</p></td> +</tr> +<tr> +<td class="tableblock halign-left valign-top"><p class="tableblock">Execution Time</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/07 00:08:33.715742</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/07 00:05:14.295840</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/07 00:03:51.708673</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock"><strong>00:06:12</strong></p></td> +</tr> +</tbody> +</table> +<div class="paragraph"> +<p>while it takes approximately <strong>14 minutes</strong> (average value) to get the result without using the trafodion external table.</p> +</div> +<table class="tableblock frame-all grid-all spread"> +<colgroup> +<col style="width: 20%;"> +<col style="width: 20%;"> +<col style="width: 20%;"> +<col style="width: 20%;"> +<col style="width: 20%;"> +</colgroup> +<thead> +<tr> +<th class="tableblock halign-left valign-top"></th> +<th class="tableblock halign-left valign-top">First Result</th> +<th class="tableblock halign-left valign-top">Second Result</th> +<th class="tableblock halign-left valign-top">Third Result</th> +<th class="tableblock halign-left valign-top">Average Value</th> +</tr> +</thead> +<tbody> +<tr> +<td class="tableblock halign-left valign-top"><p class="tableblock">Start Time</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/07 13:33:46.722646</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/07 14:39:30.323730</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/07 14:54:58.177258</p></td> +<td class="tableblock halign-left valign-top"></td> +</tr> +<tr> +<td class="tableblock halign-left valign-top"><p class="tableblock">End Time</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/07 13:48:35.028916</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/07 14:53:53.887911</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/07 15:09:11.517646</p></td> +<td class="tableblock halign-left valign-top"></td> +</tr> +<tr> +<td class="tableblock halign-left valign-top"><p class="tableblock">Elapsed Time</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/07 00:14:48.306270</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/07 00:14:23.564181</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/07 00:14:13.340388</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">00:14:28.40</p></td> +</tr> +<tr> +<td class="tableblock halign-left valign-top"><p class="tableblock">Compile Time</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/07 00:00:00.773770</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/07 00:00:00.388777</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/07 00:00:14.856643</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">00:00:04</p></td> +</tr> +<tr> +<td class="tableblock halign-left valign-top"><p class="tableblock">Execution Time</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/07 00:14:47.530017</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/07 00:14:23.146420</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/07 00:13:58.463850</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock"><strong>00:13:58</strong></p></td> +</tr> +</tbody> +</table> +</li> +<li> +<p>When executing the following query:</p> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">SELECT [LAST 1] mix_other02, substring(mix_other12 from 1 for 10) FROM hive.hive.test_mix WHERE substring(mix_other02 from 1 for 1) = 'O';</code></pre> +</div> +</div> +<div class="paragraph"> +<p>it takes approximately <strong>6 minutes</strong> (average value) to get the result using the trafodion external table.</p> +</div> +<table class="tableblock frame-all grid-all spread"> +<colgroup> +<col style="width: 20%;"> +<col style="width: 20%;"> +<col style="width: 20%;"> +<col style="width: 20%;"> +<col style="width: 20%;"> +</colgroup> +<thead> +<tr> +<th class="tableblock halign-left valign-top"></th> +<th class="tableblock halign-left valign-top">First Result</th> +<th class="tableblock halign-left valign-top">Second Result</th> +<th class="tableblock halign-left valign-top">Third Result</th> +<th class="tableblock halign-left valign-top">Average Value</th> +</tr> +</thead> +<tbody> +<tr> +<td class="tableblock halign-left valign-top"><p class="tableblock">Start Time</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/09 14:07:59.353015</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/09 14:16:27.725035</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/09 14:41:01.454408</p></td> +<td class="tableblock halign-left valign-top"></td> +</tr> +<tr> +<td class="tableblock halign-left valign-top"><p class="tableblock">End Time</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/09 14:15:05.979546</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/09 14:20:44.939776</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/09 14:46:58.238246</p></td> +<td class="tableblock halign-left valign-top"></td> +</tr> +<tr> +<td class="tableblock halign-left valign-top"><p class="tableblock">Elapsed Time</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/09 00:07:06.626531</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/09 00:04:17.214741</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/09 00:05:56.783838</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">00:05:59</p></td> +</tr> +<tr> +<td class="tableblock halign-left valign-top"><p class="tableblock">Compile Time</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/09 00:00:00.197789</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/09 00:00:00.296705</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/09 00:00:00.227511</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">00:00:00.23</p></td> +</tr> +<tr> +<td class="tableblock halign-left valign-top"><p class="tableblock">Execution Time</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/09 00:07:06.411065</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/09 00:04:16.873090</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/09 00:05:56.554411</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock"><strong>00:05:59</strong></p></td> +</tr> +</tbody> +</table> +<div class="paragraph"> +<p>while it takes approximately 35 minutes (average value) to get the result without using the trafodion external table.</p> +</div> +<table class="tableblock frame-all grid-all spread"> +<colgroup> +<col style="width: 20%;"> +<col style="width: 20%;"> +<col style="width: 20%;"> +<col style="width: 20%;"> +<col style="width: 20%;"> +</colgroup> +<thead> +<tr> +<th class="tableblock halign-left valign-top"></th> +<th class="tableblock halign-left valign-top">First Result</th> +<th class="tableblock halign-left valign-top">Second Result</th> +<th class="tableblock halign-left valign-top">Third Result</th> +<th class="tableblock halign-left valign-top">Average Value</th> +</tr> +</thead> +<tbody> +<tr> +<td class="tableblock halign-left valign-top"><p class="tableblock">Start Time</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/09 11:01:12.676307</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/09 11:35:54.514479</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/09 13:15:07.006658</p></td> +<td class="tableblock halign-left valign-top"></td> +</tr> +<tr> +<td class="tableblock halign-left valign-top"><p class="tableblock">End Time</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/09 11:35:16.264756</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/09 12:11:09.587147</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/09 13:49:23.740406</p></td> +<td class="tableblock halign-left valign-top"></td> +</tr> +<tr> +<td class="tableblock halign-left valign-top"><p class="tableblock">Elapsed Time</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/09 00:34:03.588449</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/09 00:35:15.072668</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/09 00:34:16.733748</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">34:44:00</p></td> +</tr> +<tr> +<td class="tableblock halign-left valign-top"><p class="tableblock">Compile Time</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/09 00:00:00.703053</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/09 00:00:00.280146</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/09 00:00:00.536929</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">00:00:00.5</p></td> +</tr> +<tr> +<td class="tableblock halign-left valign-top"><p class="tableblock">Execution Time</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/09 00:34:02.828529</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/09 00:35:14.743914</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">2018/03/09 00:34:16.155336</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock"><strong>34:44:00</strong></p></td> +</tr> +</tbody> +</table> +</li> +</ul> +</div> +<div style="page-break-after: always;"></div> +</div> </div> </div> <div class="sect2"> @@ -14055,7 +14395,7 @@ evaluation of query expressions, or joined tables.</p> query-specification is: [with-clause] -SELECT [ "[" ANY N "]" | "[" FIRST N "]" ] [ALL | DISTINCT] select-list +SELECT [ "[" ANY N "]" | "[" FIRST N "]" | "[" LAST N "]" ] [ALL | DISTINCT] select-list FROM table-ref [,table-ref]... [WHERE search-condition] [SAMPLE sampling-method] @@ -14219,14 +14559,14 @@ transpose-item-list is: </div> </li> <li> -<p><code>"[" ANY <em>N</em> "]" | "[" FIRST <em>N</em> "]"</code></p> +<p>`"[" ANY <em>N</em> "]" | "[" FIRST <em>N</em> "]" | "[" LAST <em>N</em> "]" `</p> <div class="paragraph"> <p>specifies that <em>N</em> rows are to be returned (assuming the table has at least <em>N</em> rows and that the qualification criteria specified in the WHERE clause, if any, would select at least <em>N</em> rows) and you do not care which <em>N</em> rows are chosen (out of the qualified rows) to actually be returned.</p> </div> <div class="paragraph"> -<p><em>You must enclose ANY N or FIRST N in square brackets ([]).</em> The quotation marks ("") around each square bracket in +<p>You must enclose <code>ANY <em>N</em></code>, <code>FIRST <em>N</em></code> or <code>LAST <em>N</em></code> in square brackets ([]). The quotation marks ("") around each square bracket in the syntax diagram indicate that the bracket is a required character that you must type as shown (for example, [ANY 10] or [FIRST 5]). Do not include quotation marks in ANY or FIRST clauses.</p> </div> @@ -14236,6 +14576,9 @@ result table of the SELECT statement. <em>N</em> is an unsigned numeric literal of rows in the table, all rows are returned. [ANY <em>N</em>] and [FIRST <em>N</em>] are disallowed in nested SELECT statements and on either side of a UNION operation.</p> </div> +<div class="paragraph"> +<p><code>[LAST <em>N</em>]</code> performs the entire query and calculates elapsed time. The <em>N</em> must be 0 or 1. <code>[LAST <em>0</em>]</code> does not return any rows. <code>[LAST <em>1</em>]</code> returns only the last qualified row.</p> +</div> </li> <li> <p><code>ALL | DISTINCT</code></p> @@ -15989,6 +16332,35 @@ SELECT a+1 FROM t GROUP BY 1+a;</code></pre> </div> </div> </li> +<li> +<p>Examples of using <code>[LAST <em>N</em>]</code> option:</p> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">SQL>SELECT [LAST 0] * FROM employee; + +--- 0 row(s) selected.</code></pre> +</div> +</div> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">SQL>SELECT [LAST 1] * FROM employee WHERE jobcode <> 100 AND salary = 30000; + +EMPNUM FIRST_NAME LAST_NAME DEPTNUM JOBCODE SALARY +------ --------------- -------------------- ------- ------- ---------- + 227 XAVIER SEDLEMEYER 3300 300 30000.00 + +--- 1 row(s) selected.</code></pre> +</div> +</div> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">SQL>SELECT [LAST 2] * FROM employee; + +*** ERROR[15002] Internal parser error: Number of rows must be 0 or 1 with LAST option. +. [2018-02-28 18:05:12]</code></pre> +</div> +</div> +</li> </ul> </div> <div style="page-break-after: always;"></div> http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/758b046e/docs/sql_reference/integration.html ---------------------------------------------------------------------- diff --git a/docs/sql_reference/integration.html b/docs/sql_reference/integration.html index 1512b44..f5c28da 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 Mar 18, 2018 --> +<!-- Generated by Apache Maven Doxia at Mar 20, 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="20180318" /> + <meta name="Date-Revision-yyyymmdd" content="20180320" /> <meta http-equiv="Content-Language" content="en" /> </head> @@ -27,7 +27,7 @@ <div class="xleft"> - <span id="publishDate">Last Published: 2018-03-18</span> + <span id="publishDate">Last Published: 2018-03-20</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/758b046e/docs/sql_reference/issue-tracking.html ---------------------------------------------------------------------- diff --git a/docs/sql_reference/issue-tracking.html b/docs/sql_reference/issue-tracking.html index 4063299..4f3a706 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 Mar 18, 2018 --> +<!-- Generated by Apache Maven Doxia at Mar 20, 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="20180318" /> + <meta name="Date-Revision-yyyymmdd" content="20180320" /> <meta http-equiv="Content-Language" content="en" /> </head> @@ -27,7 +27,7 @@ <div class="xleft"> - <span id="publishDate">Last Published: 2018-03-18</span> + <span id="publishDate">Last Published: 2018-03-20</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/758b046e/docs/sql_reference/license.html ---------------------------------------------------------------------- diff --git a/docs/sql_reference/license.html b/docs/sql_reference/license.html index b7e8c20..ccce9a4 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 Mar 18, 2018 --> +<!-- Generated by Apache Maven Doxia at Mar 20, 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="20180318" /> + <meta name="Date-Revision-yyyymmdd" content="20180320" /> <meta http-equiv="Content-Language" content="en" /> </head> @@ -27,7 +27,7 @@ <div class="xleft"> - <span id="publishDate">Last Published: 2018-03-18</span> + <span id="publishDate">Last Published: 2018-03-20</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/758b046e/docs/sql_reference/mail-lists.html ---------------------------------------------------------------------- diff --git a/docs/sql_reference/mail-lists.html b/docs/sql_reference/mail-lists.html index c2c5cda..eafdeaf 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 Mar 18, 2018 --> +<!-- Generated by Apache Maven Doxia at Mar 20, 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="20180318" /> + <meta name="Date-Revision-yyyymmdd" content="20180320" /> <meta http-equiv="Content-Language" content="en" /> </head> @@ -27,7 +27,7 @@ <div class="xleft"> - <span id="publishDate">Last Published: 2018-03-18</span> + <span id="publishDate">Last Published: 2018-03-20</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/758b046e/docs/sql_reference/project-info.html ---------------------------------------------------------------------- diff --git a/docs/sql_reference/project-info.html b/docs/sql_reference/project-info.html index 810d6b9..03e7ca7 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 Mar 18, 2018 --> +<!-- Generated by Apache Maven Doxia at Mar 20, 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="20180318" /> + <meta name="Date-Revision-yyyymmdd" content="20180320" /> <meta http-equiv="Content-Language" content="en" /> </head> @@ -27,7 +27,7 @@ <div class="xleft"> - <span id="publishDate">Last Published: 2018-03-18</span> + <span id="publishDate">Last Published: 2018-03-20</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/758b046e/docs/sql_reference/project-summary.html ---------------------------------------------------------------------- diff --git a/docs/sql_reference/project-summary.html b/docs/sql_reference/project-summary.html index 5ea17cf..86d005b 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 Mar 18, 2018 --> +<!-- Generated by Apache Maven Doxia at Mar 20, 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="20180318" /> + <meta name="Date-Revision-yyyymmdd" content="20180320" /> <meta http-equiv="Content-Language" content="en" /> </head> @@ -27,7 +27,7 @@ <div class="xleft"> - <span id="publishDate">Last Published: 2018-03-18</span> + <span id="publishDate">Last Published: 2018-03-20</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/758b046e/docs/sql_reference/source-repository.html ---------------------------------------------------------------------- diff --git a/docs/sql_reference/source-repository.html b/docs/sql_reference/source-repository.html index 767d5b7..4633693 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 Mar 18, 2018 --> +<!-- Generated by Apache Maven Doxia at Mar 20, 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="20180318" /> + <meta name="Date-Revision-yyyymmdd" content="20180320" /> <meta http-equiv="Content-Language" content="en" /> </head> @@ -27,7 +27,7 @@ <div class="xleft"> - <span id="publishDate">Last Published: 2018-03-18</span> + <span id="publishDate">Last Published: 2018-03-20</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/758b046e/docs/sql_reference/team-list.html ---------------------------------------------------------------------- diff --git a/docs/sql_reference/team-list.html b/docs/sql_reference/team-list.html index f2987ff..30ed386 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 Mar 18, 2018 --> +<!-- Generated by Apache Maven Doxia at Mar 20, 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="20180318" /> + <meta name="Date-Revision-yyyymmdd" content="20180320" /> <meta http-equiv="Content-Language" content="en" /> </head> @@ -27,7 +27,7 @@ <div class="xleft"> - <span id="publishDate">Last Published: 2018-03-18</span> + <span id="publishDate">Last Published: 2018-03-20</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/758b046e/index.html ---------------------------------------------------------------------- diff --git a/index.html b/index.html index bbd57dd..b0fee69 100644 --- a/index.html +++ b/index.html @@ -1,7 +1,7 @@ <!DOCTYPE html> <!-- - Generated by Apache Maven Doxia at 2018-02-20 + Generated by Apache Maven Doxia at 2018-02-20 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/758b046e/index.html~ ---------------------------------------------------------------------- diff --git a/index.html~ b/index.html~ deleted file mode 100644 index 644b06c..0000000 --- a/index.html~ +++ /dev/null @@ -1,524 +0,0 @@ - -<!DOCTYPE html> -<!-- - 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"> - - <head> - <meta charset="UTF-8" /> - <title>Apache Trafodion</title> - <meta name="viewport" content="width=device-width, initial-scale=1.0" /> - <meta name="description" content="" /> - <meta http-equiv="content-language" content="en" /> - - <link href="//netdna.bootstrapcdn.com/bootswatch/2.3.2/cerulean/bootstrap.min.css" rel="stylesheet" /> - <link href="//netdna.bootstrapcdn.com/twitter-bootstrap/2.3.1/css/bootstrap-responsive.min.css" rel="stylesheet" /> - <link href="./css/bootswatch.css" rel="stylesheet" /> - <link href="./css/reflow-skin.css" rel="stylesheet" /> - - <link href="//yandex.st/highlightjs/7.5/styles/default.min.css" rel="stylesheet" /> - - - <link href="./css/site.css" rel="stylesheet" /> - <link href="./css/print.css" rel="stylesheet" media="print" /> - - <!-- Le HTML5 shim, for IE6-8 support of HTML5 elements --> - <!--[if lt IE 9]> - <script src="http://html5shim.googlecode.com/svn/trunk/html5.js";></script> - <![endif]--> - - - - <!-- Google Analytics --> - <script type="text/javascript"> - - var _gaq = _gaq || []; - _gaq.push(['_setAccount', 'UA-72491210-1']); - _gaq.push(['_trackPageview']); - - (function() { - var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true; - ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js'; - var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s); - })(); - - </script> - </head> - - <body class="page-index project-trafodion" data-spy="scroll" data-offset="60" data-target="#toc-scroll-target"> - - <div class="navbar navbar-fixed-top"> - <div class="navbar-inner"> - <div class="container"> - <a class="btn btn-navbar" data-toggle="collapse" data-target="#top-nav-collapse"> - <span class="icon-bar"></span> - <span class="icon-bar"></span> - <span class="icon-bar"></span> - </a> - <a class="brand" href="index.html"><span class="brand-apache">Apache </span><span class="brand-trafodion">Trafodion</span> <span class="brand-apache"></span></a> - <div class="nav-collapse collapse" id="top-nav-collapse"> - <ul class="nav pull-right"> - <li ><a href="download.html" title="Download">Download</a></li> - <li ><a href="quickstart.html" title="Quick Start">Quick Start</a></li> - <li ><a href="documentation.html" title="Documentation">Documentation</a></li> - <li ><a href="contributing-redirect.html" title="Contribute">Contribute</a></li> - <li class="dropdown active"> - <a href="#" class="dropdown-toggle" data-toggle="dropdown">Project <b class="caret"></b></a> - <ul class="dropdown-menu"> - <li class="active"><a href="" title="Overview">Overview</a></li> - <li ><a href="faq.html" title="FAQ">FAQ</a></li> - <li ><a href="release-notes.html" title="Release Notes">Release Notes</a></li> - <li ><a href="https://cwiki.apache.org/confluence/display/TRAFODION/Apache+Trafodion+Home"; title="Wiki" class="externalLink">Wiki</a></li> - <li ><a href="https://www.youtube.com/playlist?list=PLyyCp3HBB8Tv9696OnG0_mmgF5tfHeyOi"; title="Videos" class="externalLink">Videos</a></li> - <li ><a href="management.html" title="Managing Trafodion">Managing Trafodion</a></li> - <li ><a href="https://cwiki.apache.org/confluence/display/TRAFODION/Roadmap"; title="Roadmap" class="externalLink">Roadmap</a></li> - <li ><a href="http:divider" title=""></a></li> - <li ><a href="team-redirect.html" title="Team">Team</a></li> - <li ><a href="presentations.html" title="Presentations">Presentations</a></li> - <li ><a href="http://www.apache.org/events/current-event.html"; title="Events" class="externalLink">Events</a></li> - <li ><a href="logo.html" title="Logo">Logo</a></li> - <li ><a href="mail-lists.html" title="Mailing Lists">Mailing Lists</a></li> - <li ><a href="http://im.qq.com"; title="QQ (Group ID:176011868)" class="externalLink">QQ (Group ID:176011868)</a></li> - <li ><a href="http:divider" title=""></a></li> - <li ><a href="source-repository.html" title="Source Repository">Source Repository</a></li> - <li ><a href="issue-tracking.html" title="Issue Tracking">Issue Tracking</a></li> - <li ><a href="http://www.apache.org/security/"; title="Security" class="externalLink">Security</a></li> - <li ><a href="license.html" title="License">License</a></li> - </ul> - </li> - <li class="dropdown"> - <a href="#" class="dropdown-toggle" data-toggle="dropdown">Features <b class="caret"></b></a> - <ul class="dropdown-menu"> - <li ><a href="architecture-overview.html" title="Architecture Overview">Architecture Overview</a></li> - <li ><a href="http:divider" title=""></a></li> - <li ><a href="https://blueprints.launchpad.net/trafodion/+spec/security-ansi-schemas"; title="ANSI Schema Support" class="externalLink">ANSI Schema Support</a></li> - <li ><a href="https://blueprints.launchpad.net/trafodion/+spec/ustat-automation"; title="Automated Update Statistics" class="externalLink">Automated Update Statistics</a></li> - <li ><a href="https://blueprints.launchpad.net/trafodion/+spec/bulkunload"; title="Bulk Unload" class="externalLink">Bulk Unload</a></li> - <li ><a href="https://cwiki.apache.org/confluence/display/TRAFODION/Trafodion+Manageability#TrafodionManageability-LoggingEvents"; title="Event Handling" class="externalLink">Event Handling</a></li> - <li ><a href="https://blueprints.launchpad.net/trafodion/+spec/hybrid-query-cache"; title="Hybrid Query Cache" class="externalLink">Hybrid Query Cache</a></li> - <li ><a href="https://blueprints.launchpad.net/trafodion/+spec/identity-column"; title="Identity Column" class="externalLink">Identity Column</a></li> - <li ><a href="https://blueprints.launchpad.net/trafodion/+spec/lob-support"; title="Large Object (LOB)" class="externalLink">Large Object (LOB)</a></li> - <li ><a href="https://blueprints.launchpad.net/trafodion/+spec/ddl-query-invalidation"; title="Metadata Query Invalidation" class="externalLink">Metadata Query Invalidation</a></li> - <li ><a href="https://cwiki.apache.org/confluence/display/TRAFODION/Cmp-divisioning"; title="Multi-Temperature Data" class="externalLink">Multi-Temperature Data</a></li> - <li ><a href="https://blueprints.launchpad.net/trafodion/+spec/access-external-hbase-tables"; title="Native HBase Tables" class="externalLink">Native HBase Tables</a></li> - <li ><a href="https://cwiki.apache.org/confluence/display/TRAFODION/Tutorial:+The+object-oriented+UDF+interface"; title="Object-Oriented UDF Tutorial" class="externalLink">Object-Oriented UDF Tutorial</a></li> - <li ><a href="https://blueprints.launchpad.net/trafodion/+spec/sql-query-cancel"; title="Query Cancel" class="externalLink">Query Cancel</a></li> - <li ><a href="https://blueprints.launchpad.net/trafodion/+spec/security-privilege-updates"; title="Privilege Checking" class="externalLink">Privilege Checking</a></li> - <li ><a href="https://cwiki.apache.org/confluence/display/TRAFODION/Trafodion+Manageability"; title="Repository" class="externalLink">Repository</a></li> - <li ><a href="https://blueprints.launchpad.net/trafodion/+spec/enable-get-statistics-thru-rms"; title="Runtime Management System" class="externalLink">Runtime Management System</a></li> - <li ><a href="https://blueprints.launchpad.net/trafodion/+spec/sequence-numbers"; title="Sequence Numbers" class="externalLink">Sequence Numbers</a></li> - <li ><a href="https://blueprints.launchpad.net/trafodion/+spec/skew-buster"; title="Skew Buster" class="externalLink">Skew Buster</a></li> - <li ><a href="http:divider" title=""></a></li> - <li ><a href="https://cwiki.apache.org/confluence/display/TRAFODION/Backup+and+Restore"; title="Backup/Restore Utility" class="externalLink">Backup/Restore Utility</a></li> - <li ><a href="https://cwiki.apache.org/confluence/display/TRAFODION/Metadata+Cleanup"; title="Metadata Cleanup Utility" class="externalLink">Metadata Cleanup Utility</a></li> - </ul> - </li> - <li class="dropdown"> - <a href="#" class="dropdown-toggle" data-toggle="dropdown">Apache <b class="caret"></b></a> - <ul class="dropdown-menu"> - <li ><a href="http://www.apache.org/foundation/how-it-works.html"; title="Apache Foundation" target="_blank" class="externalLink">Apache Foundation</a></li> - <li ><a href="http://www.apache.org/licenses/"; title="Apache License" target="_blank" class="externalLink">Apache License</a></li> - <li ><a href="http://www.apache.org/security/"; title="Apache Security" target="_blank" class="externalLink">Apache Security</a></li> - <li ><a href="http:divider" title=""></a></li> - <li ><a href="http://www.apache.org/foundation/sponsorship.html"; title="Sponsorship" target="_blank" class="externalLink">Sponsorship</a></li> - <li ><a href="http://www.apache.org/foundation/thanks.html"; title="Thanks" target="_blank" class="externalLink">Thanks</a></li> - </ul> - </li> - </ul> - </div><!--/.nav-collapse --> - </div> - </div> - </div> - - <div class="container"> - - <!-- Masthead - ================================================== --> - - <header> - <div class="jumbotron subhead"> - <div class="row" id="banner"> - <div class="span12"> - <div class="pull-left"> - <a href="" id="bannerLeft"><h1><img src="images/logos/trafodion-logo.jpg" alt="Trafodion Logo" width="383"></h1></a> - <p class="lead">Transactional SQL-on-Hadoop Database</p> - </div> - <div class="pull-right"> - </div> - </div> - </div> - </div> - </header> - - <div class="main-body"> - <div id="carousel0" class="carousel slide"> - <div class="carousel-inner"> - <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"> -</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> -<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> - </div> - <a class="left carousel-control" href="#carousel0" data-slide="prev">‹</a> - <a class="right carousel-control" href="#carousel0" data-slide="next">›</a> - </div> - <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> - <!-- 20160524 GTA Need more logos before using this part. - -Powered by Trafodion - -#### Join the Trafodion Movement - - - -Contribution opportunites: usage, code, tests, presentations, documentations, web sites, and things we didn't think of yet. - -#### Powered By Trafodion - - - -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"> -</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> -</ul> - </div> - </div> - <div class="row"> - </div> - <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> - </div> - </div> - </div> - </div> - - </div><!-- /container --> - - <!-- Footer - ================================================== --> - <footer class="well"> - <div class="container"> - <div class="row"> - <div class="span4 bottom-nav"> - <ul class="nav nav-list"> - <li class="nav-header">Project</li> - <li class="active"> - <a href="#" title="Overview">Overview</a> - </li> - <li > - <a href="faq.html" title="FAQ">FAQ</a> - </li> - <li > - <a href="release-notes.html" title="Release Notes">Release Notes</a> - </li> - <li > - <a href="https://cwiki.apache.org/confluence/display/TRAFODION/Apache+Trafodion+Home"; title="Wiki" class="externalLink">Wiki</a> - </li> - <li > - <a href="https://www.youtube.com/playlist?list=PLyyCp3HBB8Tv9696OnG0_mmgF5tfHeyOi"; title="Videos" class="externalLink">Videos</a> - </li> - <li > - <a href="management.html" title="Managing Trafodion">Managing Trafodion</a> - </li> - <li > - <a href="https://cwiki.apache.org/confluence/display/TRAFODION/Roadmap"; title="Roadmap" class="externalLink">Roadmap</a> - </li> - <li > - <a href="http:divider" title=""></a> - </li> - <li > - <a href="team-redirect.html" title="Team">Team</a> - </li> - <li > - <a href="presentations.html" title="Presentations">Presentations</a> - </li> - <li > - <a href="http://www.apache.org/events/current-event.html"; title="Events" class="externalLink">Events</a> - </li> - <li > - <a href="logo.html" title="Logo">Logo</a> - </li> - <li > - <a href="mail-lists.html" title="Mailing Lists">Mailing Lists</a> - </li> - <li > - <a href="http://im.qq.com"; title="QQ (Group ID:176011868)" class="externalLink">QQ (Group ID:176011868)</a> - </li> - <li > - <a href="http:divider" title=""></a> - </li> - <li > - <a href="source-repository.html" title="Source Repository">Source Repository</a> - </li> - <li > - <a href="issue-tracking.html" title="Issue Tracking">Issue Tracking</a> - </li> - <li > - <a href="http://www.apache.org/security/"; title="Security" class="externalLink">Security</a> - </li> - <li > - <a href="license.html" title="License">License</a> - </li> - </ul> - </div> - <div class="span4 bottom-nav"> - <ul class="nav nav-list"> - <li class="nav-header">Features</li> - <li > - <a href="architecture-overview.html" title="Architecture Overview">Architecture Overview</a> - </li> - <li > - <a href="http:divider" title=""></a> - </li> - <li > - <a href="https://blueprints.launchpad.net/trafodion/+spec/security-ansi-schemas"; title="ANSI Schema Support" class="externalLink">ANSI Schema Support</a> - </li> - <li > - <a href="https://blueprints.launchpad.net/trafodion/+spec/ustat-automation"; title="Automated Update Statistics" class="externalLink">Automated Update Statistics</a> - </li> - <li > - <a href="https://blueprints.launchpad.net/trafodion/+spec/bulkunload"; title="Bulk Unload" class="externalLink">Bulk Unload</a> - </li> - <li > - <a href="https://cwiki.apache.org/confluence/display/TRAFODION/Trafodion+Manageability#TrafodionManageability-LoggingEvents"; title="Event Handling" class="externalLink">Event Handling</a> - </li> - <li > - <a href="https://blueprints.launchpad.net/trafodion/+spec/hybrid-query-cache"; title="Hybrid Query Cache" class="externalLink">Hybrid Query Cache</a> - </li> - <li > - <a href="https://blueprints.launchpad.net/trafodion/+spec/identity-column"; title="Identity Column" class="externalLink">Identity Column</a> - </li> - <li > - <a href="https://blueprints.launchpad.net/trafodion/+spec/lob-support"; title="Large Object (LOB)" class="externalLink">Large Object (LOB)</a> - </li> - <li > - <a href="https://blueprints.launchpad.net/trafodion/+spec/ddl-query-invalidation"; title="Metadata Query Invalidation" class="externalLink">Metadata Query Invalidation</a> - </li> - <li > - <a href="https://cwiki.apache.org/confluence/display/TRAFODION/Cmp-divisioning"; title="Multi-Temperature Data" class="externalLink">Multi-Temperature Data</a> - </li> - <li > - <a href="https://blueprints.launchpad.net/trafodion/+spec/access-external-hbase-tables"; title="Native HBase Tables" class="externalLink">Native HBase Tables</a> - </li> - <li > - <a href="https://cwiki.apache.org/confluence/display/TRAFODION/Tutorial:+The+object-oriented+UDF+interface"; title="Object-Oriented UDF Tutorial" class="externalLink">Object-Oriented UDF Tutorial</a> - </li> - <li > - <a href="https://blueprints.launchpad.net/trafodion/+spec/sql-query-cancel"; title="Query Cancel" class="externalLink">Query Cancel</a> - </li> - <li > - <a href="https://blueprints.launchpad.net/trafodion/+spec/security-privilege-updates"; title="Privilege Checking" class="externalLink">Privilege Checking</a> - </li> - <li > - <a href="https://cwiki.apache.org/confluence/display/TRAFODION/Trafodion+Manageability"; title="Repository" class="externalLink">Repository</a> - </li> - <li > - <a href="https://blueprints.launchpad.net/trafodion/+spec/enable-get-statistics-thru-rms"; title="Runtime Management System" class="externalLink">Runtime Management System</a> - </li> - <li > - <a href="https://blueprints.launchpad.net/trafodion/+spec/sequence-numbers"; title="Sequence Numbers" class="externalLink">Sequence Numbers</a> - </li> - <li > - <a href="https://blueprints.launchpad.net/trafodion/+spec/skew-buster"; title="Skew Buster" class="externalLink">Skew Buster</a> - </li> - <li > - <a href="http:divider" title=""></a> - </li> - <li > - <a href="https://cwiki.apache.org/confluence/display/TRAFODION/Backup+and+Restore"; title="Backup/Restore Utility" class="externalLink">Backup/Restore Utility</a> - </li> - <li > - <a href="https://cwiki.apache.org/confluence/display/TRAFODION/Metadata+Cleanup"; title="Metadata Cleanup Utility" class="externalLink">Metadata Cleanup Utility</a> - </li> - </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 - applications to run on Hadoop.</blockquote> - </div> - </div> - </div> - </footer> - - <div class="container subfooter"> - <div class="row"> - <div class="span12"> - <p class="pull-right"><a href="#">Back to top</a></p> - <p class="copyright">Copyright ©2015-2018 <a href="http://www.apache.org";>Apache Software Foundation</a>. All Rights Reserved.</p> - -<hr/> -<div class="row span16"> - <span>Apache, Apache Maven, Apache Maven Fluido Skin, the Apache feather logo, and the Apache Maven project logo - are trademarks of the Apache Software Foundation.</span> - <br/> - <br/> -</div> </div> - </div> - </div> - - <!-- Le javascript - ================================================== --> - <!-- Placed at the end of the document so the pages load faster --> - <script src="//ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script> - - <script src="//netdna.bootstrapcdn.com/twitter-bootstrap/2.3.2/js/bootstrap.min.js"></script> - <script src="./js/reflow-scroll.js"></script> - <script src="//yandex.st/highlightjs/7.5/highlight.min.js"></script> - - <script src="./js/reflow-skin.js"></script> - - </body> -</html> http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/758b046e/integration.html ---------------------------------------------------------------------- diff --git a/integration.html b/integration.html index 64f815c..635460b 100644 --- a/integration.html +++ b/integration.html @@ -1,7 +1,7 @@ <!DOCTYPE html> <!-- - Generated by Apache Maven Doxia at 2018-03-18 + Generated by Apache Maven Doxia at 2018-03-20 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/758b046e/issue-tracking.html ---------------------------------------------------------------------- diff --git a/issue-tracking.html b/issue-tracking.html index 72b5a91..a5a0ec4 100644 --- a/issue-tracking.html +++ b/issue-tracking.html @@ -1,7 +1,7 @@ <!DOCTYPE html> <!-- - Generated by Apache Maven Doxia at 2018-03-18 + Generated by Apache Maven Doxia at 2018-03-20 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/758b046e/license.html ---------------------------------------------------------------------- diff --git a/license.html b/license.html index 3096748..aee0683 100644 --- a/license.html +++ b/license.html @@ -1,7 +1,7 @@ <!DOCTYPE html> <!-- - Generated by Apache Maven Doxia at 2018-03-18 + Generated by Apache Maven Doxia at 2018-03-20 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/758b046e/mail-lists.html ---------------------------------------------------------------------- diff --git a/mail-lists.html b/mail-lists.html index 6945a6f..90fbb96 100644 --- a/mail-lists.html +++ b/mail-lists.html @@ -1,7 +1,7 @@ <!DOCTYPE html> <!-- - Generated by Apache Maven Doxia at 2018-03-18 + Generated by Apache Maven Doxia at 2018-03-20 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/758b046e/modules.html ---------------------------------------------------------------------- diff --git a/modules.html b/modules.html index a4e163c..a6c52cb 100644 --- a/modules.html +++ b/modules.html @@ -1,7 +1,7 @@ <!DOCTYPE html> <!-- - Generated by Apache Maven Doxia at 2018-03-18 + Generated by Apache Maven Doxia at 2018-03-20 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/758b046e/project-info.html ---------------------------------------------------------------------- diff --git a/project-info.html b/project-info.html index 8516ff9..2fc79a3 100644 --- a/project-info.html +++ b/project-info.html @@ -1,7 +1,7 @@ <!DOCTYPE html> <!-- - Generated by Apache Maven Doxia at 2018-03-18 + Generated by Apache Maven Doxia at 2018-03-20 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/758b046e/project-summary.html ---------------------------------------------------------------------- diff --git a/project-summary.html b/project-summary.html index 99e5f03..a734a37 100644 --- a/project-summary.html +++ b/project-summary.html @@ -1,7 +1,7 @@ <!DOCTYPE html> <!-- - Generated by Apache Maven Doxia at 2018-03-18 + Generated by Apache Maven Doxia at 2018-03-20 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/758b046e/source-repository.html ---------------------------------------------------------------------- diff --git a/source-repository.html b/source-repository.html index 48275eb..cc837ce 100644 --- a/source-repository.html +++ b/source-repository.html @@ -1,7 +1,7 @@ <!DOCTYPE html> <!-- - Generated by Apache Maven Doxia at 2018-03-18 + Generated by Apache Maven Doxia at 2018-03-20 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/758b046e/team-list.html ---------------------------------------------------------------------- diff --git a/team-list.html b/team-list.html index 2675de8..d4ed472 100644 --- a/team-list.html +++ b/team-list.html @@ -1,7 +1,7 @@ <!DOCTYPE html> <!-- - Generated by Apache Maven Doxia at 2018-03-18 + Generated by Apache Maven Doxia at 2018-03-20 Rendered using Reflow Maven Skin 1.1.1 (http://andriusvelykis.github.io/reflow-maven-skin) --> <html xml:lang="en" lang="en">
