Apache Tajo™ 0.8.0 Release Announcement
The Apache Tajo team is pleased to announce the major release of Apache Tajo™ 0.8.0, an open source big data warehouse system on Hadoop. Apache Tajo™ provides low-latency and scalable batch SQL queries on large-data sets stored on HDFS and other data sources.
The source and binary release tarballs are available for free download:
This is the first top-level release. In this release, Apache Tajo team closes 363 issues, including 25 new features, 81 improvement, and 164 bug fixes.
Some of the highlights:
SQL support
- Database support (TAJO-353)
- Full/Left/Outer join (TAJO-34, TAJO-312)
- Complex joins including derived subqueries and unions.
- Datetime types and operator support
- Date type support (TAJO-60, TAJO-438)
- Time type support (TAJO-61, TAJO-439)
- Timestamp type support (TAJO-62, TAJO-437)
- Add datetime operation and functions
- extract(), to_timestamp(), utc_usec_to()
- SQL standard and PostgreSQL-compatible string function support
- ascii(), length(), chr(), bit_length(string), hex(), octet_length(), reverse(), right(), left(), md5, repeat, substr(), strpos, locate(), initcap(), lpad(), rpad(), concat(), concat_ws(), ltrim(), rtrim(), btrim(), trim(), and so on.
- SQL standard math function support
- mod(), div(), degrees(), radians(), cbrt(), abs(), exp(), sqrt(), sin(), sign(), pow(), ceiling(), round(), floor(), ceil(), and so on.
- Other functions
- sha1(), digest(), find_in_set(), to_bin(), and so on.
- CREATE TABLE AS (CTAS) on partition table (TAJO-460)
- ALTER TABLE RENAME (TAJO-615)
- ALTER TABLE ADD/RENAME COLUMN (TAJO-696, TAJO-697)
- Quoted identifier support (TAJO-644)
- Complex expression support in group-by, order-by, and having clauses
- Distinct aggregation support (TAJO-601)
- Explain statement support (TAJO-122)
Performance and Scalability
- More I/O efficient M-way unbalanced external sort executor (TAJO-36, TAJO-584)
- Reduced intermediate data volume (TAJO-435)
- Star-schema broadcast support (TAJO-725)
- Duplicated expression removal and more efficient projection push down (TAJO-501)
- Reduced memory consumption in expression evaluation (TAJO-539)
- Reduced GC overhead and memory usage (TAJO-522, TAJO-537, TAJO-544, TAJO-548)
- I/O efficient sort-based dynamic partition store method (TAJO-574)
Storage support
- Configurable serializer/deserializer of Text file (TAJO-424)
- Parquet file support (TAJO-30, TAJO-714)
- Avro storage support (TAJO-711)
- Amazon S3 support (TAJO-577)