The multi-faceted Navigator Optimizer "makes it easy to move the right workloads to Hadoop, and actively manages data to take advantage of Hadoop's benefits," its site says.

When introduced last November, it was described by Cloudera as "a unique, workload optimization tool (available via SaaS) that helps DBAs, data warehouse architects, and data analysts adopt an informed and systematic approach to getting optimal results with Hadoop. In summary, Cloudera Navigator Optimizer profiles and analyzes the 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 on Hadoop -- all via an easy-to-use Web UI."

Another enhancement noted by Cloudera in its updated enterprise solution is cloud-native, high-performance analytics added to its Impala component (updated to v2.6), a massively parallel processing (MPP) SQL query engine. "Impala now supports Amazon S3 -- joining Hive and Apache Spark -- to enable analysts to get instant insights from all their data, including data stored in cloud environments," the company said.

The SQL development experience has also been improved with a redesigned Hue (standing for Hadoop User Experience) an open source Web GUI SQL editor for interacting with Hadoop. Cloudera said, "Within the open-source Hue interface, SQL developers can easily explore and discover available tables through quickviews; quickly design queries with autocomplete suggestions; and get immediate assistance for debugging queries before they run for efficient troubleshooting. In addition, queries and results can be seamlessly shared with other users and groups, with the ability to directly set access permissions on results for trusted security."