2.1.0-incubating Release Notes
This is the third release of the Apache Trafodion (incubating) project.
Build instructions are available in the Trafodion Contributor Guide.
New Features
| Feature | Jira ID |
|---|---|
| Hashing functions added to Trafodion | TRAFODION-2229 |
| Support for Hbase1.1 and CDH5.5-5.7 | TRAFODION-2016 |
| Better java exception handling in the java layer of Trafodion | TRAFODION-1988 |
| TopN Sort operator | TRAFODION-2259 |
| Runtime statistics enhancements | TRAFODION-2420 |
| RegExp operator support | TRAFODION-2353 |
| Support for LAG and LEAD OLAP functions | TRAFODION-2214 |
| Bulk load enhancements to log errors | TRAFODION-2351 |
| ODB tool support for Windows | TRAFODION-1931 |
| Support for GROUP BY ROLLUP feature | TRAFODION-2246 |
| Support ORDER BY clause in GROUP_CONCAT | TRAFODION-2270 |
| Support for boolean datatype | TRAFODION-2099 |
| Added encryption functions for Trafodion | TRAFODION-2228 |
| Support of SQL extension ‘EXCEPT’ | TRAFODION-2117 |
| Support for tinyint,largeint,unsinged datatype in SQL | TRAFODION-2086 |
| SQL syntax to support INTERSECT | TRAFODION-2047 |
| Enable support for various non-ansi sql syntax/functionality | TRAFODION-2180 |
| Use of CQD to set scratch directory locations | TRAFODION2146 |
Improvements
| Feature | Jira ID |
|---|---|
| Improve query compilation time | TRAFODION-2137 |
| Improve upsert performance for table with indexes | TRAFODION-1546 |
| Improve concurrency during DDL operations | TRAFODION-2037 |
Install and Configuration Changes
- Ambari Integration (TRAFODION-2291)
Integration with Ambari cluster manager ambari interface/integration. The Ambari integration provides support for Hortonworks Hadoop distributions, while the command-line Trafodion Installer supports Cloudera and Hortonworks Hadoop distributions, and for select vanilla Hadoop installations. - Python Installer (TRAFODION-1839)
Trafodion Installer Evolution. The command-line installer has been replaced for the 2.1.0 release. Written in python, it replaces the legacy bash-script installer. The bash command-line installer is deprecated as of 2.1.0, but is still provided, just in case you experience any problems with the new installer. If so, please report those problems to the project team, since the legacy installer will soon be obsolete. - Trafodion Configuration File (TRAFODION-2306)
Introducing a configuration file traf-site.xml specific to Trafodion similar to hbase configuration file hbase-site.xml. This configuration file extends the properties inherited from the standard hbase-site.xml. - The environment variable MY_SQROOT has been renamed to TRAF_HOME.
Fixes
This release contains fixes for 300+ JIRAs. Here is a list of resolved JIRAs in Release 2.1.
Documentation Updates
Several updates have been made to the SQL Reference Manual to reflect the new functions added in 2.1. Some functions have not been documented yet but have JIRAs outstanding and will be completed by the next release. Provisioning Guide has been updated to reflect instructions for using hte new Ambari Installer or the python installation script.
Supported Platforms
| Operating Systems | RedHat / CentOS 6.5 – 6.8 |
| Hadoop Distributions | Cloudera distributions CDH 5.4 – 5.6 Hortonworks distributions HDP 2.3 – 2.4 Apache Hadoop with Apache HBase 1.0 – 1.1 |
| Java Version | JDK 1.7.0_67 or newer |