Posted by on
Categories: Apache Cloudera Hadoop Hive SQL

California-based #Cloudera that designs open source technologies and develops apache hadoop-based enterprise analytic data management software, has announced the general availability of Cloudera Navigator Optimizer, alongside the release of Cloudera Enterprise 5.8. Since its limited beta release in November 2015, Cloudera Navigation Optimizer aims to aid customers augment their analytic database or data warehouse solution with #Hadoop and help offload SQL workloads for more efficient analytics processing. Posing as the newest update to Cloudera’s Big Data solutions and offerings, the optimization tool claims to provide database administrators (DBAs) the usage visibility to manage Hadoop data models and guidance to optimize query performance. In a company blog, Cloudera stated that it has helped customers “offload ETL (extract, transform and load) processes, Business Intelligence (BI) reports, ad-hoc workloads to Cloudera’s Hadoop platform,” after profiling and analyzing workloads for customers in identifying potential risks and optimizing data model to support various data needs. Reportedly, it evaluates structured query language (SQL) text in large, complex #SQL workloads so users can gain an in-depth understanding of their workloads, identify queries best-suited for Hadoop and modify them as needed for optimal efficiency via an easy-to-use web user interface. Its built-in optimization guidance for #Apache #Hive and Apache #Impala (incubating), a SQL engine also enables peak in performance for faster data preparation, BI and exploratory analytics, claims the company.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.