Cloudera Navigator Optimizer profiles and analyzes the query text in SQL workloads. This analysis helps you gain in-depth understanding of your workloads, identify and offload queries best-suited for Hadoop, and optimize your workloads already running on Hive or Impala.

Use Navigator Optimizer to

• Identify workloads to move to Hadoop: Offloading non-operational enterprise data warehouse (EDW) workloads to Hadoop can help you increase the efficiency of your EDW system.
• Optimize workloads already running on Hadoop: Use Navigator Optimizer to see what is happening with your workloads running on Hadoop and get recommendations for optimizing them.
• Slice and dice workloads by custom attributes: Add custom attribute information to your query workload file and Navigator Optimizer can pivot its analysis based on those custom attributes. For example, you can identify data access patterns for specific users, applications, or reports.
• Get risk alerts based on Hive and Impala best practices: Before you offload a workload to Hive or Impala, Navigator Optimizer can assess the risk based on compatibility and complexity of these queries and suggest fixes for them.

For more information about Navigator Optimizer, see www.cloudera.com/products/cloudera-navigator-optimizer.html