# Apache Tajo Reviews **Vendor:** The Apache Software Foundation **Category:** [Data Warehouse Solutions](https://www.g2.com/categories/data-warehouse) **Average Rating:** 4.3/5.0 **Total Reviews:** 6 ## About Apache Tajo Apache Tajo is a robust big data relational and distributed data warehouse system for Apache Hadoop. ## Apache Tajo Pros & Cons **What users like:** - Users find Apache Tajo **easy to use** , especially for handling large data volumes with SQL-like queries. (1 reviews) - Users find Apache Tajo beneficial for handling **large datasets** , leveraging its SQL capabilities for efficient data management. (1 reviews) - Users find Apache Tajo's **SQL support** invaluable for easily processing large datasets on Hadoop. (1 reviews) **What users dislike:** - Users note that Tajo's **inefficiency in real-time analytics** results from its batch processing architecture, causing significant latencies. (1 reviews) - Users find that Tajo has **performance issues** with real-time analytics due to its batch processing architecture, causing latency. (1 reviews) ## Apache Tajo Reviews ### 1. Draw information from large data sets **Rating:** 4.5/5.0 stars **Reviewed by:** Seyha H. | Project Scheduler, Retail, Small-Business (50 or fewer emp.) **Reviewed Date:** October 08, 2024 **What do you like best about Apache Tajo?** As data analyst processing big data on Hadoop, Apache Tajo becomes useful due to its capabilities. It is easy to use and works with SQL like queries, and I can manipulate large volumes of data that are stored in HDFS. **What do you dislike about Apache Tajo?** In cases where I want to examine data as it is flowing steadily or where real-time analytics are necessary, Tajo is not the best fit. Due to the batch processing architecture of Tajo, data needs to be pre-loaded which causes latencies for the real time applications. **What problems is Apache Tajo solving and how is that benefiting you?** Tajo enables me to carry out query operations over huge Hadoop data, and express these operations using conventional SQL. This does away with the need to master several MapReduce programming languages and makes analysis of data much easier. ### 2. Fast and reliable data insights, **Rating:** 4.5/5.0 stars **Reviewed by:** Ashraf S. | HR Manager, Furniture, Mid-Market (51-1000 emp.) **Reviewed Date:** June 03, 2024 **What do you like best about Apache Tajo?** There is no doubt that the ease of using SQL to query huge data sets was attractive. This could be compared with relief as opposed to having to memorize an entire new language for big data analysis. It also has the benefits of being open-source, which meant that I could easily find a plethora of support from developers online. **What do you dislike about Apache Tajo?** It was slow during most of the experiments and particularly for complex queries on large datasets. The jobs used to run for hours on end and therefore, it became very difficult to make quick conclusions from the results that I got. This slowly proved disadvantageous to my unit and turned into a bottlenecks. **What problems is Apache Tajo solving and how is that benefiting you?** Apache Tajo provided an ability to analyze large data at a lower cost and, what is more, use standard SQL for that. This could have been a very useful tool for many data exploration requirements we may come across later in other projects. ### 3. Simplifying Query and Analysis for Better Warehousing and Better decision making using Apache Tajo **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Consulting | Enterprise (> 1000 emp.) **Reviewed Date:** April 05, 2024 **What do you like best about Apache Tajo?** One of the best feature of Apache Tajo is it provides use for multiple data formats including those of standard and it can be processed with very minimal modifications. It has user defined function, which is intuitive to user and makes sure to understand users input well and with ease.It requires less maintenance and it is as simple as it gets. I have been using it for several for my Big data processing purposes including: Warehousing and Analysis of data, Data storage and Data formatting, Log and Data analysis of Large set of Ecom data. **What do you dislike about Apache Tajo?** Given reliability on the SQL set of coding, it requires one to be thorough on SQL before using it so it has a dependency on SQL. **What problems is Apache Tajo solving and how is that benefiting you?** It allow me to have a straightaway direct saying over the flow of data and distributed execution for the various strategy in query evaluation and at the same time provides optimization opportunities.Given it is intuitive and ease of its use with the simple design architecture, tolenance in faults and vectorized query for exe plan along to fatser delivery it helps me have better control over data and it's warehousing of the large set of big data. ### 4. Good for Quering Datawarehouses **Rating:** 5.0/5.0 stars **Reviewed by:** Kapil G. | Business Technology Solutions Associate , Small-Business (50 or fewer emp.) **Reviewed Date:** June 06, 2024 **What do you like best about Apache Tajo?** Recommended Solution for an oragnization or individuals who used SQL in day to day activities. It give faster result compare to hive QL. **What do you dislike about Apache Tajo?** Nothing dislikes as such, good to professional, beginers might take time to learn its env and installation process is bit lengthy. **What problems is Apache Tajo solving and how is that benefiting you?** We did some POC to create some metrics of a patients in Tajo. Later, we switched to bigquery. ### 5. Solid HQL software **Rating:** 3.0/5.0 stars **Reviewed by:** Verified User in Marketing and Advertising | Mid-Market (51-1000 emp.) **Reviewed Date:** June 13, 2018 **What do you like best about Apache Tajo?** I find Apache Tajo is a bit easier to navigate than Apache Hive. I also noticed that the results I received from queries were coming in much faster than our previous software. **What do you dislike about Apache Tajo?** The software is a bit complicated and has a tough learning curve for users who aren't previously familiar with SQL coding. We had to really onboard our team in order to effectively utilize the system. **What problems is Apache Tajo solving and how is that benefiting you?** Apache Tajo makes it much easier to organize large sets of data. The software is fast and doesn't frequently crash which is a problem we had experienced in the past. I think one of the biggest benefits was the full SQL support: As long as people who are using Tajo are already comfortable with HQL, there's no pressing need for SQL. Although you can easily understand why it's a benefit to have full-sql support. ### 6. Perfect foundation warehouse solution for our company **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Warehousing | Mid-Market (51-1000 emp.) **Reviewed Date:** June 13, 2018 **What do you like best about Apache Tajo?** Our company needed a solid warehouse solution that could bring us up to speed and provide future enhancements. Apache Tajo nailed it! **What do you dislike about Apache Tajo?** The procedures to setup and configure took some learning from our IT team. Education is key! **Recommendations to others considering Apache Tajo:** More training videos please! **What problems is Apache Tajo solving and how is that benefiting you?** warehouse management, inventory control, automation of shipping/deliveries ## Apache Tajo Discussions - [What is Apache Tajo used for?](https://www.g2.com/discussions/what-is-apache-tajo-used-for) - 1 comment, 1 upvote - [View Apache Tajo pricing details and edition comparison](https://www.g2.com/products/apache-tajo/reviews?section=pricing&secure%5Bexpires_at%5D=2026-05-31+14%3A31%3A50+-0500&secure%5Bsession_id%5D=2db9b421-cdc8-4fd1-a0bd-bf0ce11df305&secure%5Btoken%5D=a0770a20c4b9869a6af30af99eb40ef3702ce4a0389ced75a43798975e254cd8&format=llm_user) ## Apache Tajo Features **Data Management** - Data Integration - Data Compression - Data Quality - Built-In Data Analytics - In-Database Machine Learning - Data Lake Analytics **Integration** - AI/ ML Integration - BI Tool Integration - Data lake Integration **Deployment** - On-Premise - Cloud **Performance ** - Scalability **Security** - Data Governance - Data Security **Generative AI** - AI Text Generation - AI Text Summarization ## Top Apache Tajo Alternatives - [IBM Db2](https://www.g2.com/products/ibm-db2/reviews) - 4.1/5.0 (598 reviews) - [Amazon Redshift](https://www.g2.com/products/amazon-redshift/reviews) - 4.3/5.0 (369 reviews) - [Google Cloud BigQuery](https://www.g2.com/products/google-cloud-bigquery/reviews) - 4.5/5.0 (1,147 reviews)