About using Cloudera Data Explorer (Hue) Hue provides a one-stop querying experience in Cloudera that leverages Hive and Impala SQL queries. Accessing and using Cloudera Data Explorer (Hue)Get started using Hue by analyzing and visualizing your data with Impala and Hive SQL query engines.Viewing Hive query detailsYou can search Hive query history, compare two queries, download debug bundles for troubleshooting, and view query details, a graphical representation of the query execution plan, and DAG information on the Job Browser page in Hue.Viewing Impala query detailsYou can view Impala query details, query plan, execution summary, and query metrics on the new Impala Queries tab on the Job Browser page in Hue, and use this information to tune and optimize your queries. You can also view Impala query profiles on the Impala tab.Terminating Hive queriesIf a query is running for longer than expected, or you have accidentally triggered it, then you can stop the query to free up the resources. Hue also allows you to stop multiple queries at once.Comparing Hive and Impala queries in Cloudera Data Explorer (Hue)You can compare two queries to know how each query is performing in terms of speed and cost-effectiveness. Hue compares various aspects of the two queries, based on which you can identify what changed between the executions of those two queries, and you can debug performance-related issues between different runs of the same query.Starting SQL AI Assistant in Cloudera Data Explorer (Hue)A SQL AI Assistant has been integrated into Data Explorer with the capability to leverage the power of Large Language Models (LLMs) for various SQL tasks. It helps you to create, edit, optimize, fix, and succinctly summarize queries using natural language and makes SQL development faster, easier, and less error-prone. You can also generate comments and insert them into your queries to improve readability.Enabling stored procedures for Hive in Cloudera Data HubTo create, edit, and drop procedures and functions that are written in Hive Hybrid Procedural SQL (HPL/SQL) using the Hue query editor, you must enable the hplsql option in the Hue Advanced Configuration Snippet.How to run a stored procedure from Cloudera Data Explorer (Hue) in Cloudera Data HubHPL/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. Hue provides a smart interface to run stored procedures.Using SQL to query HBase from Cloudera Data Explorer (Hue)Hue provides a simple SQL interface to create and manipulate SQL tables that are stored in HBase, and define and manipulate views on HBase tables using Apache Phoenix in addition to HBase shell and database API.Querying existing HBase tablesTo use SQL for querying data from existing HBase tables, you must create a view in Phoenix pointing to the HBase table.Enabling the SQL editor autocompleterAutocompleter 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.Rerunning a query from the Job Browser pageYou may need to reconfigure the query parameters post a query execution, based on the results. You can modify and rerun your historical queries from the Job Browser page.Using governance-based data discoveryHue 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.Using Amazon S3 with Cloudera Data Explorer (Hue)Hue can read to and write to an Amazon S3 bucket.Using Azure Data Lake Storage Gen2 with Cloudera Data Explorer (Hue)Hue can read to and write to an Azure Data Lake Storage (ADLS) Gen2.Using Amazon S3-compatible object stores with Data ExplorerLearn how Data Explorer supports accessing AWS S3-compatible object stores using the S3A connector.Using Google Cloud Storage with Cloudera Data Explorer (Hue)Hue can read to and write to Google Cloud Storage (GS) buckets.Disabling the automatic creation of user home directoriesIf you have enabled fine-grained authorization to access S3 buckets, ADLS Gen 2 storage, or Google Cloud Storage buckets, then Hue is configured to automatically create user home directories, by default. You can disable the automatic creation of user home directories by setting the autocreate_user_dir flag to false in the Hue Service Advanced Configuration Snippet.Granting permission to access S3, ABFS, GS File Browser in Cloudera Data Explorer (Hue)Only admin users can view and access S3, ABFS, and GS File Browser in Hue after enabling it. You must manually grant application permissions to non-admin users and groups for them to be able to view and access S3, ABFS, and GS File Browsers in Hue.Creating tables in Cloudera Data Explorer (Hue) by importing filesUsing Hue Importer, you can create Hive, Impala, and Iceberg tables from CVS and XLSX files. After enabling the File Browser for your cloud provider, you can import the file into Hue to create tables.Supported non-ASCII and special characters in Cloudera Data Explorer (Hue)Auto-generated files may often introduce non-alphanumeric characters in the file and directory names that Hue does not support. This might cause the files or directories to not appear on the Hue File Browser. Review the list of non-alphanumeric, non-ASCII, diacritics (accents) characters supported in Hue for the following operations: upload, create, list in folder, view, and rename.Options to rerun Oozie workflows in Cloudera Data Explorer (Hue)Oozie workflows consume time and resources to run. You can optimize the rerun of a failed Oozie workflow by selecting one of the following two options: “All or skip successful” or “Only failed”. These options enable you to select individual actions within your workflow that you want to rerun.Unsupported features in Cloudera Data Explorer (Hue)Learn about the Hue features that are not supported by Cloudera.Known limitations in Cloudera Data Explorer (Hue)Review the known limitations in Hue.
