2.2.0-Release Notes
This is the first release of the Apache Trafodion project.
Build instructions are available in the Trafodion Contributor Guide.
New Feature
| Feature | Jira ID |
|---|---|
| Trafodion Elasticity enhancements | TRAFODION-2001 |
| LOB Support in JDBC | TRAFODION-2287 |
| Improve UPDATE STATISTICS performance for varchar columns | TRAFODION-2376 |
| RMS enhancements | TRAFODION-2420 |
| jdbcT4 profile configuration for publish to maven central | TRAFODION-2513 |
| Improve the log4j and log4cxx infrastructure in Trafodion | TRAFODION-2596 |
| Port Esgyn DTM changes to Trafodion | TRAFODION-2623 |
Improvement
| Feature | Jira ID |
|---|---|
| hdfs directories owned by trafodion id should be under /user/trafodion | TRAFODION-2098 |
| populateSortCols was flagged as major perf offender during profiling | TRAFODION-2422 |
| Enhance stringtolob builtin function to take varchar/char columns as parameter | TRAFODION-2516 |
| Allow scalar UDFs with delimited identifiers | TRAFODION-2517 |
| Improve handling of index hints | TRAFODION-2569 |
| Remove deprecated CQD HIVE_MAX_STRING_LENGTH | TRAFODION-2583 |
| Remove obsolete utility commands, turn off obsolete privileges | TRAFODION-2603 |
| set rowcount option in UPDATE STATISTICS does not suppress rowcount logic | TRAFODION-2618 |
| Simplify installation setting of HBase config parameters | TRAFODION-2663 |
| Ensure RMS can be disabled properly | TRAFODION-2698 |
Sub-task
| Feature | Jira ID |
|---|---|
| Implement relational operator for common subexpressions and transformation | TRAFODION-2317 |
| Add optimizer/opt_error.h to analyzeMessageGuide.py | TRAFODION-2474 |
| function support: Reverse() | TRAFODION-2485 |
| Update wiki for scalar UDFs to explain trusted flavor | TRAFODION-2558 |
| Support Index hints in a DML statement | TRAFODION-2573 |
| SQL engine work for Elasticity | TRAFODION-2628 |
| Add check to NATable cache for snapshot info | TRAFODION-2723 |
Bug Fixes
| Feature | Jira ID |
|---|---|
| LP Bug: 1442483 - SQL queries hang when Region Server goes down | TRAFODION-1151 |
| LP Bug: 1443482 - Accessing hive table with ucs2 encoded field returns 0 rows | TRAFODION-1165 |
| after uninstall, and reinstall again, dcscheck report dcs master not up | TRAFODION-1989 |
| Need better errors when DIVISION BY expression is incorrect | TRAFODION-2240 |
| WITH clause with CTE used in subquery gives error 3288 | TRAFODION-2248 |
| TLOG repeatedly reporting exceptions in deleteEntriesOlderThanASN | TRAFODION-2253 |
| need add privilege checking for explain statement | TRAFODION-2294 |
| Sequence operators are not parallel starting with the WITH clause support | TRAFODION-2324 |
| bash installer: always copy bashrc template file to trafodion's $HOME | TRAFODION-2428 |
| Invalid characters in UCS2 to UTF8 translation are not handled correctly | TRAFODION-2477 |
| HDFS connection issue during LOB creation | TRAFODION-2495 |
| TMUDF sometimes does not pass errors from its input table up to the caller | TRAFODION-2499 |
| Obscure cores seen in Trafodion while running jenkins tests with RH7 | TRAFODION-2514 |
| process abend when updating primary key with TRAF_RELOAD_NATABLE_CACHE ON | TRAFODION-2527 |
| Update stats on cell or row access to a Trafodion table raises error 9252 | TRAFODION-2529 |
| UPDATE STATISTICS is sensitive to tdm_arkcmp autocommit setting | TRAFODION-2530 |
| Create index succeeds but resulting index is empty, if dop greater than 32 | TRAFODION-2535 |
| Salted indexes do not result in parallel index scan plans | TRAFODION-2537 |
| Skew buster plan not chosen when join predicate involves SUBSTRs | TRAFODION-2552 |
| RIGHT function gives incorrect answer on UTF-8 varchars sometimes | TRAFODION-2559 |
| Index plan not chosen for UPDATE when WHERE clause and set clause are on the same index column | TRAFODION-2574 |
| UPDATE STATS sometimes fails on very long varchars | TRAFODION-2575 |
| Incremental UPDATE STATS fails on long varchar values | TRAFODION-2576 |
| installers should allow multiple ldap hosts and ldap UID lines | TRAFODION-2579 |
| UPSERT USING LOAD running slower than UPSERT with transactions disabled | TRAFODION-2586 |
| Give better diagnostics when HBase is not available while Trafodion starts | TRAFODION-2592 |
| Insert Select to/from Trafodion tables containing LOB columns | TRAFODION-2598 |
| sort operator merge phase memory pool improvement | TRAFODION-2604 |
| Rework fix to JIRA Trafodion 2294 | TRAFODION-2605 |
| Input parameters and current functions in input tables of TMUDFs | TRAFODION-2611 |
| Internal assert in CLEANUP command in some unusual cases | TRAFODION-2612 |
| HBaseTxClient throws TableNotFoundException for TRAFODION.DTM.TDDL | TRAFODION-2614 |
| TMUDF returns wrong results with small numeric inputs | TRAFODION-2615 |
| Nested join regression after fix for TRAFODION-2569 | TRAFODION-2616 |
| Memory leak in emitRow() in table-mapping UDFs | TRAFODION-2625 |
| Disk IO counter is not populated for hdfs/hive IOs | TRAFODION-2631 |
| FLOOR and CEIL return a float data type instead of the argument data type | TRAFODION-2634 |
| Core on select count( *) using hbase cell access on a salted Trafodion table | TRAFODION-2635 |
| Modest memory leak in metadata context and with CQS | TRAFODION-2636 |
| Library management in the absence of password-less ssh | TRAFODION-2637 |
| Ambari integration - dcs install with HA enabled | TRAFODION-2642 |
| Obsolete the bash installer | TRAFODION-2644 |
| mxosrvr connection state doesn't change to AVAILABLE after the timeout if no client connect to it | TRAFODION-2646 |
| sqgen no longer provides "overflow" directive for scratch disks | TRAFODION-2647 |
| New added persist configuration section missing program run time options | TRAFODION-2648 |
| Method used in rmscheck script for obtaining status is incompatible with elasticity | TRAFODION-2649 |
| Sort operator loops at times | TRAFODION-2653 |
| Change the location of trafodion-site.xml from $TRAF_HOME/etc to config | TRAFODION-2654 |
| MDAM plans on prefixes sometimes not chosen when they should be | TRAFODION-2655 |
| Incremental UPDATE STATS fails on very large sample tables | TRAFODION-2662 |
| privileges regression tests privs1/TEST040-44 output non-printable characters | TRAFODION-2678 |
| Repeated execution of prepared SQL select statement causes memory leak | TRAFODION-2681 |
| JVM startup options like heap are not passed correctly | TRAFODION-2682 |
| the value of Numeric Struct need not to be changed to BidEndian | TRAFODION-2687 |
| Log files are not created by monitor child processes | TRAFODION-2689 |
| Monitor fails to start when node names are not of the right form | TRAFODION-2692 |
| control query cancel qid fails with error 8031 sometimes | TRAFODION-2696 |
| [ODBC]The maxlength for LargeInt was fixed to 8 | TRAFODION-2701 |
| [ODBC] The SQL type is set to CHARACTER(n) CHARACTER set USC2, SQLGetData to read data multiple times returns the wrong length value | TRAFODION-2702 |
| Using multi-threads app with linux-odbc to connect trafodion will make dcs down | TRAFODION-2709 |
| JDBC LOB tests show symptoms of a leaked statement handle | TRAFODION-2724 |
| SQL types are real, FLOAT, and DOUBLE. Some values are inserted, a stack overflow occurs when SQLGetData is executed. | TRAFODION-2725 |
| Using function strtod is not enough to convert C_CHAR to DOUBLE | TRAFODION-2750 |
| JDBC executeQuery() throws exception on the with … select stmt | TRAFODION-2757 |
| LOAD and UNLOAD statements with LOB columns cause runtime errors | TRAFODION-2764 |
| Select count( * ) from a renamed table should return error 4082 instead of error 8448 | TRAFODION-2767 |
| When convert NULL to SQL_VARCHAR , the length was not be sent | TRAFODION-2811 |
| For Server 2008, function pow() in driver ODBC throws STATUS_ILLEGAL_INSTRUCTION | TRAFODION-2818 |
| When using failed connection handle to alloc statement handle, crash happens | TRAFODION-2890 |
| datalen is wrong while converting varchar in table to local datetime struct | TRAFODION-2902 |
| Catalog Api gives wrong values about NON_UNIQUE column | TRAFODION-2911 |
| Python installer does fails when Kerberos is enabled | TRAFODION-2935 |
| initialize trafodion failed at CentOS 6.9 | TRAFODION-2941 |
| license year should be updated | TRAFODION-2942 |
Task
| Feature | Jira ID |
|---|---|
| JDBCT4 group id needs to be changed to org.apache.trafodion in JAR | TRAFODION-2544 |
| JDBC T2 build changes needed for Trafodion release | TRAFODION-2554 |
Documentation
| Feature | Jira ID |
|---|---|
| update sql reference manual about with clause syntax | TRAFODION-2405 |
| Add SCRATCH_DISKS CQD | TRAFODION-2521 |
| Add with Clause | TRAFODION-2522 |
| Add tinyint data type for sql reference manual | TRAFODION-2548 |
| update sql reference manual about new hive data type | TRAFODION-2549 |
| update sql reference manual about metadata clean up command | TRAFODION-2550 |
| Remove Automating Update Statistics for SQL Reference Manual | TRAFODION-2657 |
| Update Character String Data Types | TRAFODION-2665 |
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 |