Apache Tajo

A data warehouse system is a database used for reporting and data analysis.

Apache Tajo is the implementation of this concept, but specifically tailored to work with Hadoop, a powerful NoSQL database developed by Yahoo and currently managed by the Apache Software Foundation.

This means Tajo supports Hadoop specific technologies like HDFS, MapReduce, or ETL.

What is new in this release:

• Oracle and PostgreSQL catalog store support
• Direct JSON file support
• HBase storage integration (allowing users to directly access HBase tables through Tajo)
• Improved JDBC driver for easier use of JDBC application
• Improved Amazon S3 support

What is new in version 0.10.1:

• Oracle and PostgreSQL catalog store support
• Direct JSON file support
• HBase storage integration (allowing users to directly access HBase tables through Tajo)
• Improved JDBC driver for easier use of JDBC application
• Improved Amazon S3 support

What is new in version 0.10.0:

• Oracle and PostgreSQL catalog store support
• Direct JSON file support
• HBase storage integration (allowing users to directly access HBase tables through Tajo)
• Improved JDBC driver for easier use of JDBC application
• Improved Amazon S3 support

What is new in version 0.9.0:

• More mature SQL features:
• TIMESTAMP, DATE, and TIME Refactoring
• INTERVAL type support
• WINDOW functions and OVER clause support
• ORDER BY and GROUP BY clauses allow column references as well as expressions.
• Multiple distinct aggregation
• ORDER BY NULL FIRST support
• CREATE TABLE LIKE support
• concat() and concat_ws() function support
• to_char() for date time format
• COALESCE() for BOOLEAN, DATE, TIME, and TIMESTAMP
• Performance Improvements:
• Offheap tuple block and zero-copy tuple
• Offheap sort operator for ORDER BY
• hash shuffle I/O improvement
• Better automatic parallel degree choice for operators involving hash and range shuffles
• Skewness handling for hash shuffle
• Runtime code generation for evaluating expressions
• Lots of query optimizer improvements
• Hadoop Integration:
• Hadoop 2.2.0 or higher (to 2.5.1) support
• Hive Meta Store access support for 0.13.0 and 0.13.1
• Updated Parquet to 1.5.0
• Availability, Reliability, and Stability:
• TajoMaster HA
• More stable and error-tolerant fetch