Tajo is an SQL-on-Hadoop platform thats designed to help organizations extract more intelligence from their Hadoop deployments, and its first official release comes with updates that provide more connectivity to third-party databases like Oracle and PostGreSQL, plus Java programs
The software helps analyze data stored on the Hadoop Distributed File System (HDFS), as well as other data sources like Amazon S3, Openstack Swift and local file systems
Although less well-known, its somewhat similar to solutions like Apache Hive and Clouderas Impala, providing an extract, transform and load (ETL) feature set and an extensible query re-write system that lets users and external programs query data through SQL
The software could be a good fit for organizations that have outgrown their commercial data warehouses, writes Joab Jackson in Computerworld
On top of that, it could also be a useful solution for companies looking to analyze Hadoop data using more familiar commercial businesses intelligence tools, rather than the MapReduce framework.