blob: f04b4085dbb757ff49b0c397008f49cb12783b98 [file] [log] [blame]
<!DOCTYPE html>
<!--
Generated by Apache Maven Doxia at 2020-05-02
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 2.2.0-Release Notes</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-release-notes-2-2-0 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">
<a href="#" class="dropdown-toggle" data-toggle="dropdown">Project <b class="caret"></b></a>
<ul class="dropdown-menu">
<li ><a href="index.html" 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: 233105278)" class="externalLink">QQ (Group ID: 233105278)</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="mailto:security@trafodion.apache.org" title="Report Security Issue" class="externalLink">Report Security Issue</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="index.html" 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">
<a href="https://www.apache.org/events/current-event.html" id="bannerRight"><h1><img src="https://www.apache.org/events/current-event-125x125.png" alt="Apache Events" width="125"></h1></a>
</div>
</div>
</div>
</div>
<hr class="toc-separator" />
<div id="toc-bar" class="navbar" data-spy="affix" data-offset-top="250">
<div class="navbar-inner">
<div id="toc-scroll-target" class="container">
<a class="btn btn-navbar" data-toggle="collapse" data-target="#toc-nav-collapse">
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</a>
<div class="nav-collapse collapse" id="toc-nav-collapse">
<ul id="toc" class="nav">
<li class="toplevel"><a href="#220-release_notes" title="2.2.0-Release Notes">2.2.0-Release Notes</a></li>
<li class="toplevel"><a href="#New_Feature" title="New Feature">New Feature</a></li>
<li class="toplevel"><a href="#Improvement" title="Improvement">Improvement</a></li>
<li class="toplevel"><a href="#Sub-task" title="Sub-task">Sub-task</a></li>
<li class="toplevel"><a href="#Bug_Fixes" title="Bug Fixes">Bug Fixes</a></li>
<li class="toplevel"><a href="#Task" title="Task">Task</a></li>
<li class="toplevel"><a href="#Documentation" title="Documentation">Documentation</a></li>
<li class="toplevel"><a href="#Supported_Platforms" title="Supported Platforms">Supported Platforms</a></li>
</ul>
</div>
</div>
</div>
</div>
</header>
<div class="main-body">
<div class="row">
<div class="span12">
<div class="body-content">
<!-- Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License. -->
<h1 id="220-release_notes">2.2.0-Release Notes</h1>
<p>This is the first release of the Apache Trafodion project.</p>
<p>Build instructions are available in the <a class="externalLink" href="https://cwiki.apache.org/confluence/display/TRAFODION/Create+Build+Environment">Trafodion Contributor Guide</a>.</p>
<div class="section">
<h2 id="New_Feature">New Feature</h2>
<p><span> </span></p>
<table border="0" class="bodyTable table table-striped table-hover">
<thead>
<tr class="a">
<th>Feature</th>
<th>Jira ID</th>
</tr>
</thead>
<tbody>
<tr class="b">
<td>Trafodion Elasticity enhancements</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2001">TRAFODION-2001</a></td>
</tr>
<tr class="a">
<td>LOB Support in JDBC</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2287">TRAFODION-2287</a></td>
</tr>
<tr class="b">
<td>Improve UPDATE STATISTICS performance for varchar columns</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2376">TRAFODION-2376</a></td>
</tr>
<tr class="a">
<td>RMS enhancements</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2420">TRAFODION-2420</a></td>
</tr>
<tr class="b">
<td>jdbcT4 profile configuration for publish to maven central</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2513">TRAFODION-2513</a></td>
</tr>
<tr class="a">
<td>Improve the log4j and log4cxx infrastructure in Trafodion</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2596">TRAFODION-2596</a></td>
</tr>
<tr class="b">
<td>Port Esgyn DTM changes to Trafodion</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2623">TRAFODION-2623</a></td>
</tr>
</tbody>
</table>
</div>
<div class="section">
<h2 id="Improvement">Improvement</h2>
<p><span> </span></p>
<table border="0" class="bodyTable table table-striped table-hover">
<thead>
<tr class="a">
<th>Feature</th>
<th>Jira ID</th>
</tr>
</thead>
<tbody>
<tr class="b">
<td>hdfs directories owned by trafodion id should be under /user/trafodion</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2098">TRAFODION-2098</a></td>
</tr>
<tr class="a">
<td>populateSortCols was flagged as major perf offender during profiling</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2422">TRAFODION-2422</a></td>
</tr>
<tr class="b">
<td>Enhance stringtolob builtin function to take varchar/char columns as parameter</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2516">TRAFODION-2516</a></td>
</tr>
<tr class="a">
<td>Allow scalar UDFs with delimited identifiers</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2517">TRAFODION-2517</a></td>
</tr>
<tr class="b">
<td>Improve handling of index hints</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2569">TRAFODION-2569</a></td>
</tr>
<tr class="a">
<td>Remove deprecated CQD HIVE_MAX_STRING_LENGTH</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2583">TRAFODION-2583</a></td>
</tr>
<tr class="b">
<td>Remove obsolete utility commands, turn off obsolete privileges</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2603">TRAFODION-2603</a></td>
</tr>
<tr class="a">
<td>set rowcount option in UPDATE STATISTICS does not suppress rowcount logic</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2618">TRAFODION-2618</a></td>
</tr>
<tr class="b">
<td>Simplify installation setting of HBase config parameters</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2663">TRAFODION-2663</a></td>
</tr>
<tr class="a">
<td>Ensure RMS can be disabled properly</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2698">TRAFODION-2698</a></td>
</tr>
</tbody>
</table>
</div>
<div class="section">
<h2 id="Sub-task">Sub-task</h2>
<p><span> </span></p>
<table border="0" class="bodyTable table table-striped table-hover">
<thead>
<tr class="a">
<th>Feature</th>
<th>Jira ID</th>
</tr>
</thead>
<tbody>
<tr class="b">
<td>Implement relational operator for common subexpressions and transformation</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2317">TRAFODION-2317</a></td>
</tr>
<tr class="a">
<td>Add optimizer/opt_error.h to analyzeMessageGuide.py</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2474">TRAFODION-2474</a></td>
</tr>
<tr class="b">
<td>function support: Reverse()</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2485">TRAFODION-2485</a></td>
</tr>
<tr class="a">
<td>Update wiki for scalar UDFs to explain trusted flavor</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2558">TRAFODION-2558</a></td>
</tr>
<tr class="b">
<td>Support Index hints in a DML statement</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2573">TRAFODION-2573</a></td>
</tr>
<tr class="a">
<td>SQL engine work for Elasticity</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2628">TRAFODION-2628</a></td>
</tr>
<tr class="b">
<td>Add check to NATable cache for snapshot info</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2723">TRAFODION-2723</a></td>
</tr>
</tbody>
</table>
</div>
<div class="section">
<h2 id="Bug_Fixes">Bug Fixes</h2>
<p><span> </span></p>
<table border="0" class="bodyTable table table-striped table-hover">
<thead>
<tr class="a">
<th>Feature</th>
<th>Jira ID</th>
</tr>
</thead>
<tbody>
<tr class="b">
<td>LP Bug: 1442483 - SQL queries hang when Region Server goes down</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-1151">TRAFODION-1151</a></td>
</tr>
<tr class="a">
<td>LP Bug: 1443482 - Accessing hive table with ucs2 encoded field returns 0 rows</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-1165">TRAFODION-1165</a></td>
</tr>
<tr class="b">
<td>after uninstall, and reinstall again, dcscheck report dcs master not up</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-1989">TRAFODION-1989</a></td>
</tr>
<tr class="a">
<td>Need better errors when DIVISION BY expression is incorrect</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2240">TRAFODION-2240</a></td>
</tr>
<tr class="b">
<td>WITH clause with CTE used in subquery gives error 3288</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2248">TRAFODION-2248</a></td>
</tr>
<tr class="a">
<td>TLOG repeatedly reporting exceptions in deleteEntriesOlderThanASN</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2253">TRAFODION-2253</a></td>
</tr>
<tr class="b">
<td>need add privilege checking for explain statement</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2294">TRAFODION-2294</a></td>
</tr>
<tr class="a">
<td>Sequence operators are not parallel starting with the WITH clause support</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2324">TRAFODION-2324</a></td>
</tr>
<tr class="b">
<td>bash installer: always copy bashrc template file to trafodion's $HOME</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2428">TRAFODION-2428</a></td>
</tr>
<tr class="a">
<td>Invalid characters in UCS2 to UTF8 translation are not handled correctly</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2477">TRAFODION-2477</a></td>
</tr>
<tr class="b">
<td>HDFS connection issue during LOB creation</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2495">TRAFODION-2495</a></td>
</tr>
<tr class="a">
<td>TMUDF sometimes does not pass errors from its input table up to the caller</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2499">TRAFODION-2499</a></td>
</tr>
<tr class="b">
<td>Obscure cores seen in Trafodion while running jenkins tests with RH7</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2514">TRAFODION-2514</a></td>
</tr>
<tr class="a">
<td>process abend when updating primary key with TRAF_RELOAD_NATABLE_CACHE ON</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2527">TRAFODION-2527</a></td>
</tr>
<tr class="b">
<td>Update stats on cell or row access to a Trafodion table raises error 9252</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2529">TRAFODION-2529</a></td>
</tr>
<tr class="a">
<td> UPDATE STATISTICS is sensitive to tdm_arkcmp autocommit setting</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2530">TRAFODION-2530</a></td>
</tr>
<tr class="b">
<td> Create index succeeds but resulting index is empty, if dop greater than 32</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2535">TRAFODION-2535</a></td>
</tr>
<tr class="a">
<td>Salted indexes do not result in parallel index scan plans</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2537">TRAFODION-2537</a></td>
</tr>
<tr class="b">
<td>Skew buster plan not chosen when join predicate involves SUBSTRs</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2552">TRAFODION-2552</a></td>
</tr>
<tr class="a">
<td>RIGHT function gives incorrect answer on UTF-8 varchars sometimes</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2559">TRAFODION-2559</a></td>
</tr>
<tr class="b">
<td>Index plan not chosen for UPDATE when WHERE clause and set clause are on the same index column</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2574">TRAFODION-2574</a></td>
</tr>
<tr class="a">
<td>UPDATE STATS sometimes fails on very long varchars</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2575">TRAFODION-2575</a></td>
</tr>
<tr class="b">
<td>Incremental UPDATE STATS fails on long varchar values</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2576">TRAFODION-2576</a></td>
</tr>
<tr class="a">
<td>installers should allow multiple ldap hosts and ldap UID lines</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2579">TRAFODION-2579</a></td>
</tr>
<tr class="b">
<td>UPSERT USING LOAD running slower than UPSERT with transactions disabled</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2586">TRAFODION-2586</a></td>
</tr>
<tr class="a">
<td>Give better diagnostics when HBase is not available while Trafodion starts</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2592">TRAFODION-2592</a></td>
</tr>
<tr class="b">
<td>Insert Select to/from Trafodion tables containing LOB columns</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2598">TRAFODION-2598</a></td>
</tr>
<tr class="a">
<td>sort operator merge phase memory pool improvement</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2604">TRAFODION-2604</a></td>
</tr>
<tr class="b">
<td>Rework fix to JIRA Trafodion 2294</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2605">TRAFODION-2605</a></td>
</tr>
<tr class="a">
<td>Input parameters and current functions in input tables of TMUDFs</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2611">TRAFODION-2611</a></td>
</tr>
<tr class="b">
<td>Internal assert in CLEANUP command in some unusual cases</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2612">TRAFODION-2612</a></td>
</tr>
<tr class="a">
<td>HBaseTxClient throws TableNotFoundException for TRAFODION.<i>DTM</i>.TDDL</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2614">TRAFODION-2614</a></td>
</tr>
<tr class="b">
<td>TMUDF returns wrong results with small numeric inputs</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2615">TRAFODION-2615</a></td>
</tr>
<tr class="a">
<td> Nested join regression after fix for TRAFODION-2569</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2616">TRAFODION-2616</a></td>
</tr>
<tr class="b">
<td>Memory leak in emitRow() in table-mapping UDFs</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2625">TRAFODION-2625</a></td>
</tr>
<tr class="a">
<td>Disk IO counter is not populated for hdfs/hive IOs</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2631">TRAFODION-2631</a></td>
</tr>
<tr class="b">
<td>FLOOR and CEIL return a float data type instead of the argument data type</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2634">TRAFODION-2634</a></td>
</tr>
<tr class="a">
<td>Core on select count( *) using hbase cell access on a salted Trafodion table</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2635">TRAFODION-2635</a></td>
</tr>
<tr class="b">
<td>Modest memory leak in metadata context and with CQS</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2636">TRAFODION-2636</a></td>
</tr>
<tr class="a">
<td>Library management in the absence of password-less ssh</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2637">TRAFODION-2637</a></td>
</tr>
<tr class="b">
<td>Ambari integration - dcs install with HA enabled</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2642">TRAFODION-2642</a></td>
</tr>
<tr class="a">
<td>Obsolete the bash installer</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2644">TRAFODION-2644</a></td>
</tr>
<tr class="b">
<td>mxosrvr connection state doesn't change to AVAILABLE after the timeout if no client connect to it</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2646">TRAFODION-2646</a></td>
</tr>
<tr class="a">
<td>sqgen no longer provides &quot;overflow&quot; directive for scratch disks</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2647">TRAFODION-2647</a></td>
</tr>
<tr class="b">
<td>New added persist configuration section missing program run time options</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2648">TRAFODION-2648</a></td>
</tr>
<tr class="a">
<td>Method used in rmscheck script for obtaining status is incompatible with elasticity</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2649">TRAFODION-2649</a></td>
</tr>
<tr class="b">
<td>Sort operator loops at times</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2653">TRAFODION-2653</a></td>
</tr>
<tr class="a">
<td>Change the location of trafodion-site.xml from $TRAF_HOME/etc to config</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2654">TRAFODION-2654</a></td>
</tr>
<tr class="b">
<td>MDAM plans on prefixes sometimes not chosen when they should be</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2655">TRAFODION-2655</a></td>
</tr>
<tr class="a">
<td>Incremental UPDATE STATS fails on very large sample tables</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2662">TRAFODION-2662</a></td>
</tr>
<tr class="b">
<td>privileges regression tests privs1/TEST040-44 output non-printable characters</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2678">TRAFODION-2678</a></td>
</tr>
<tr class="a">
<td>Repeated execution of prepared SQL select statement causes memory leak</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2681">TRAFODION-2681</a></td>
</tr>
<tr class="b">
<td>JVM startup options like heap are not passed correctly</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2682">TRAFODION-2682</a></td>
</tr>
<tr class="a">
<td> the value of Numeric Struct need not to be changed to BidEndian</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2687">TRAFODION-2687</a></td>
</tr>
<tr class="b">
<td>Log files are not created by monitor child processes</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2689">TRAFODION-2689</a></td>
</tr>
<tr class="a">
<td>Monitor fails to start when node names are not of the right form</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2692">TRAFODION-2692</a></td>
</tr>
<tr class="b">
<td>control query cancel qid fails with error 8031 sometimes</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2696">TRAFODION-2696</a></td>
</tr>
<tr class="a">
<td>[ODBC]The maxlength for LargeInt was fixed to 8</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2701">TRAFODION-2701</a></td>
</tr>
<tr class="b">
<td>[ODBC] The SQL type is set to CHARACTER(n) CHARACTER set USC2, SQLGetData to read data multiple times returns the wrong length value</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2702">TRAFODION-2702</a></td>
</tr>
<tr class="a">
<td>Using multi-threads app with linux-odbc to connect trafodion will make dcs down</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2709">TRAFODION-2709</a></td>
</tr>
<tr class="b">
<td>JDBC LOB tests show symptoms of a leaked statement handle</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2724">TRAFODION-2724</a></td>
</tr>
<tr class="a">
<td>SQL types are real, FLOAT, and DOUBLE. Some values are inserted, a stack overflow occurs when SQLGetData is executed.</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2725">TRAFODION-2725</a></td>
</tr>
<tr class="b">
<td>Using function strtod is not enough to convert C_CHAR to DOUBLE</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2750">TRAFODION-2750</a></td>
</tr>
<tr class="a">
<td>JDBC executeQuery() throws exception on the with … select stmt</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2757">TRAFODION-2757</a></td>
</tr>
<tr class="b">
<td>LOAD and UNLOAD statements with LOB columns cause runtime errors</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2764">TRAFODION-2764</a></td>
</tr>
<tr class="a">
<td>Select count( * ) from a renamed table should return error 4082 instead of error 8448</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2767">TRAFODION-2767</a></td>
</tr>
<tr class="b">
<td> When convert NULL to SQL_VARCHAR , the length was not be sent</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2811">TRAFODION-2811</a></td>
</tr>
<tr class="a">
<td>For Server 2008, function pow() in driver ODBC throws STATUS_ILLEGAL_INSTRUCTION</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2818">TRAFODION-2818</a></td>
</tr>
<tr class="b">
<td>When using failed connection handle to alloc statement handle, crash happens</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2890">TRAFODION-2890</a></td>
</tr>
<tr class="a">
<td>datalen is wrong while converting varchar in table to local datetime struct</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2902">TRAFODION-2902</a></td>
</tr>
<tr class="b">
<td>Catalog Api gives wrong values about NON_UNIQUE column</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2911">TRAFODION-2911</a></td>
</tr>
<tr class="a">
<td>Python installer does fails when Kerberos is enabled</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2935">TRAFODION-2935</a></td>
</tr>
<tr class="b">
<td>initialize trafodion failed at CentOS 6.9</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2941">TRAFODION-2941</a></td>
</tr>
<tr class="a">
<td>license year should be updated</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2942">TRAFODION-2942</a></td>
</tr>
</tbody>
</table>
</div>
<div class="section">
<h2 id="Task">Task</h2>
<p><span> </span></p>
<table border="0" class="bodyTable table table-striped table-hover">
<thead>
<tr class="a">
<th>Feature</th>
<th>Jira ID</th>
</tr>
</thead>
<tbody>
<tr class="b">
<td> JDBCT4 group id needs to be changed to org.apache.trafodion in JAR</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2544">TRAFODION-2544</a></td>
</tr>
<tr class="a">
<td>JDBC T2 build changes needed for Trafodion release</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2554">TRAFODION-2554</a></td>
</tr>
</tbody>
</table>
</div>
<div class="section">
<h2 id="Documentation">Documentation</h2>
<p><span> </span></p>
<table border="0" class="bodyTable table table-striped table-hover">
<thead>
<tr class="a">
<th>Feature</th>
<th>Jira ID</th>
</tr>
</thead>
<tbody>
<tr class="b">
<td>update sql reference manual about with clause syntax</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2405">TRAFODION-2405</a></td>
</tr>
<tr class="a">
<td>Add SCRATCH_DISKS CQD</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2521">TRAFODION-2521</a></td>
</tr>
<tr class="b">
<td>Add with Clause</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2522">TRAFODION-2522</a></td>
</tr>
<tr class="a">
<td>Add tinyint data type for sql reference manual</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2548">TRAFODION-2548</a></td>
</tr>
<tr class="b">
<td>update sql reference manual about new hive data type</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2549">TRAFODION-2549</a></td>
</tr>
<tr class="a">
<td>update sql reference manual about metadata clean up command</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2550">TRAFODION-2550</a></td>
</tr>
<tr class="b">
<td>Remove Automating Update Statistics for SQL Reference Manual</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2657">TRAFODION-2657</a></td>
</tr>
<tr class="a">
<td>Update Character String Data Types</td>
<td><a class="externalLink" href="https://issues.apache.org/jira/browse/TRAFODION-2665">TRAFODION-2665</a></td>
</tr>
</tbody>
</table>
</div>
<div class="section">
<h2 id="Supported_Platforms">Supported Platforms</h2>
<p><span> </span></p>
<table border="0" class="bodyTable table table-striped table-hover">
<tbody>
<tr class="a">
<td><b>Operating Systems</b></td>
<td>RedHat / CentOS 6.5 – 6.8</td>
</tr>
<tr class="b">
<td><b>Hadoop Distributions</b></td>
<td>Cloudera distributions CDH 5.4 – 5.6<br /> Hortonworks distributions HDP 2.3 – 2.4<br /> Apache Hadoop with Apache HBase 1.0 – 1.1</td>
</tr>
<tr class="a">
<td><b>Java Version</b></td>
<td>JDK 1.7.0_67 or newer</td>
</tr>
</tbody>
</table>
</div>
</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 >
<a href="index.html" 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: 233105278)" class="externalLink">QQ (Group ID: 233105278)</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="mailto:security@trafodion.apache.org" title="Report Security Issue" class="externalLink">Report Security Issue</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 &quot;Trafodion&quot; (the Welsh word for transactions, pronounced
&quot;Tra-vod-eee-on&quot;) 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 &copy;2015-2020 <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>