About using Hue
Hue provides a one-stop querying experience in Cloudera Data Warehouse (CDW) to leverage Hive and Impala SQL engines. You can also run
stored procedures (HPLSQL) and Unified Analytics queries.
Accessing and using Hue in Cloudera Data Warehouse Get started using Hue by analyzing and visualizing your data with Impala and Hive SQL query engines.How to run a stored procedure from Hue in Cloudera Data Warehouse HPL/SQL allows you to implement business logic using variables, expressions, flow-of-control statements, and iterations. HPL/SQL makes SQL-on-Hadoop more dynamic. You can leverage your existing procedural SQL skills, and use functions and statements to make your typical ETL development more productive. In Cloudera Data Warehouse, Hue provides a smart interface to run stored procedures.Enabling stored procedures for Hive in Cloudera Data Warehouse To create, edit, and drop procedures and functions that are written in Hive Hybrid Procedural SQL (HPL/SQL) using the Hue query editor in CDW, you must enable the hplsql option in the hue-safety-valve field.Enabling the SQL editor autocompleter Autocompleter provides finely tuned SQL suggestions for Hive and Impala dialects while you enter queries into the editor window. See Brand new Autocompleter for Hive and Impala in the Hue blog.Using governance-based data discovery Hue can use the metadata tagging, indexing, and search features available in Apache Atlas data management. After integrating Hue with Atlas, classifications and indexed entities can be accessed and viewed in Hue. This topic shows you how to use metadata classifications in Hue.List of supported non-alphanumeric characters for file and directory names in Hue Auto-generated files may often introduce non-alphanumeric characters in the filenames which are not supported by Hue. This might cause the files or directories to not appear on the Hue File Browser. Review the list of non-alphanumeric characters supported in Hue to avoid running into this issue.