Apache Releases Trafodion
Written by Kay Ewbank   
Thursday, 29 March 2018

Apache Trafodion has been moved from incubator status to become a high level project. Trafodion is a webscale SQL-on-Hadoop solution enabling transactional or operational workloads on Apache Hadoop. 

Trafodion was incubated at HP Labs to develop an enterprise-class SQL-on-HBase solution targeting big data transactional workloads. Its name is Welsh for Transactions, in case you were wondering, and was chosen to emphasize the differentiation that Trafodion provides in closing a critical gap in the Hadoop ecosystem. The gap is in transactional integrity. Trafodion guarantees transactional integrity and operational workloads so extending the types of big data applications that run on Hadoop.

Because Trafodion works with HBase, it can be integrated with Hadoop and HDFS, and it  can also run on Hive, Hadoop’s main data warehouse software.



Trafodion has fully functional support for ANSI SQL, so making it possible to use existing knowledge of SQL when creating transactions rather than having to use MapReduce, which is a scarcer skill. It also has distributed ACID data protection across multiple statements, tables and rows.

Running on top of HBase using the HBase APIs to perform the typical SQL functions of insert, update, delete, and query data with transactional protection, Trafodion delivers a full-featured and optimized transactional SQL-on-HBase DBMS solution with full transactional data protection. These capabilities help overcome basic Hadoop limitations in supporting transactional workloads. There are also plans to include database capabilities using the coprocessor mechanism provided by HBase.

Trafodion comes with a parallel-aware query optimizer that supports large data sets, so ensuring queries run in the most efficient manner. It also has compile-time and run-time optimizers to provide performance improvements for OLTP workloads.

Trafodion can be used with existing Apache Hadoop tools and solutions, such as Hive, Ambari, Flume, Kafka, and Oozie. It comes with JDBC/ODBC support for Linux and Windows clients. 


More Information

Trafodion Website



Related Articles

Hadoop 3 Adds HDFS Erasure Coding

HBase 1.4 With New Shaded Client 

Hadoop 2.9 Adds Resource Estimator

Hadoop Adds In-Memory Caching

Hadoop SQL Query Engine Launched

Hadoop 2 Introduces YARN

To be informed about new articles on I Programmer, sign up for our weekly newsletter, subscribe to the RSS feed and follow us on, Twitter, Facebook or Linkedin.


Record Setting Drone Animation

China already holds the record for having the largest number of unmanned aerial vehicles (UAVs), or drones as we prefer to call them, airborne simultaneously. Now it has added longest duration of dron [ ... ]

Apache Kafka 2.7 Updates Broker

Apache Kafka, the big data and datastreams platform, has been updated in a new version that the developers say moves closer to replacing ZooKeeper in Kafka with a self-managed metadata quorum.

More News





or email your comment to: comments@i-programmer.info

Last Updated ( Thursday, 29 March 2018 )