Get Started
Describes how to get started with HPE Ezmeral Unified Analytics Software.
Administration
Provides information about managing applications and clusters in HPE Ezmeral Unified Analytics Software.
Security
Describes security in HPE Ezmeral Unified Analytics Software.
Observability
Describes observability in HPE Ezmeral Unified Analytics Software.
Data Engineering
Data engineers can design and build pipelines that transform and transport data into usable formats for data consumers.
- Accessing Data in External S3 Object Stores
  Describes how to access data in external object stores from clients such as Spark and Kubeflow notebooks.
- EzPresto
  Describes the EzPresto SQL query engine and its featues.
  - Connecting Data Sources
    Provides instructions for connecting HPE Ezmeral Unified Analytics Software to external data sources.
    - Delta Connection Parameters
      List of Delta connection parameters, descriptions, default values, and supported data types.
    - Delta Thrift Connection Parameters
      List of Delta Thrift connection parameters, descriptions, default values, and supported data types.
    - Hive Connection Parameters
      List of Hive connection parameters, descriptions, default values, and supported data types.
    - Hive Glue Metastore Connection Parameters
      List of Hive Glue Metastore connection parameters, descriptions, default values, and supported data types.
    - Hive Thrift Metastore Connection Parameters
      List of Hive Thrift Metastore connection parameters, descriptions, default values, and supported data types.
    - Hive Discovery Metastore Connection Parameters
      Lists Hive discovery metastore connection parameters, parameter descriptions, default values, and supported data types.
    - MySQL Connection Parameters
      List of MySQL connection parameters, descriptions, default values, and supported data types.
    - Oracle Connection Parameters
      List of Oracle connection parameters, descriptions, default values, and supported data types.
    - Snowflake Connection Parameters
      List of Snowflake connection parameters, descriptions, default values, and supported data types.
    - SQL Server Connection Parameters
      List of SQL Server connection parameters, descriptions, default values, and supported data types.
    - Teradata Connection Parameters
      List of Teradata connection parameters, descriptions, default values, and supported data types.
    - PostgreSQL Connection Parameters
      List of PostgreSQL connection parameters, descriptions, default values, and supported data types.
    - Iceberg Connection Parameters
      List of Iceberg connection parameters, descriptions, default values, and supported data types.
    - Configuring a Hive Data Source with Kerberos Authentication
      Describes the required prerequisite steps to complete before you connect HPE Ezmeral Unified Analytics Software to a Hive data source that uses Kerberos authentication.
  - Using MAPRSASL to Authenticate to Hive Metastore on HPE Ezmeral Data Fabric
    Describes how to create a Hive data source connection that uses MAPRSASL to authenticate to a Hive Metastore on HPE Ezmeral Data Fabric.
  - Connecting to CSV and Parquet Data in an External S3 Data Source via Hive Connector
    Describes how to use the Hive connector with Presto in HPE Ezmeral Unified Analytics Software to connect to CSV and Parquet data in S3-based external data sources.
  - Connecting External Applications to EzPresto via JDBC
    Describes how to connect external applications and BI tools, such as Tableau and PowerBI, to EzPresto through the EzPresto JDBC endpoint.
  - Using Spark to Query EzPresto
    Describes how to use Spark to query EzPresto.
  - Connecting to EzPresto via Python Client
    Provides information for connecting to EzPresto from a Python client.
  - Caching Data
    Describes data caching and provides the steps for caching data in HPE Ezmeral Unified Analytics Software.
  - Submitting Presto Queries from Notebook
    Describes how to submit Presto queries from the notebook.
- Airflow
  Provides an overview of Apache Airflow in HPE Ezmeral Unified Analytics Software.
- Superset
  Provides a brief overview of Superset in HPE Ezmeral Unified Analytics Software.
Data Analytics
Provides a brief overview of data analytics in HPE Ezmeral Unified Analytics Software.
Data Science
Provides a brief overview of data science in HPE Ezmeral Unified Analytics Software.
Notebooks
Provides a brief overview of Notebooks in HPE Ezmeral Unified Analytics Software.
Glossary
Definitions for commonly used terms in HPE Ezmeral Unified Analytics environments.

Hive Discovery Metastore Connection Parameters

Lists Hive discovery metastore connection parameters, parameter descriptions, default values, and supported data types.

Use the Hive discovery metastore to query CSV and Parquet files. Hive discovery metastore automatically scans CSV files and Parquet footers in the specified directory to discover table schema. Hive discovery metastore does not require a Hive metastore service. For additional information, see Connecting to CSV and Parquet Data in an External S3 Data Source via Hive Connector.

The following sections list the required and optional Hive discovery metastore connection parameters.

Required Connection Parameters

The following table lists the required connection parameters:

Parameter	Description	Default Value	Data Type
Data Dir	Location of the directory where files are stored.		STRING

Optional Connection Parameters

The following table lists the optional connection parameters:

Parameter	Description	Default Value	Data Type
File Type	Type of files stored CSV or Parquet.		STRING
Csv Header	Specifies that the file contains a header line with the names of each column in the file.	false	BOOLEAN
Csv Separator	Specifies the string that separates columns within each row (line) of the file.	,	STRING
Csv Date Format	Specifies the format for date fields	yyyy-MM-dd	STRING
Csv Timestamp Format	Specifies the format for timestamp fields	yyyy-MM-dd HH:mm:ss	STRING
Csv Row Count	Specifies the number of rows used for schema discovery.	1000	INTEGER
Csv Escape	Specifies the escape character used in the csv file.	\	STRING

Partners Support Dev-Hub Community Training ALA Privacy Policy Glossary

HPE Ezmeral Unified Analytics Software 1.5 Documentation
Abstract	HPE Ezmeral Unified Analytics Software is a usage-based Software-as-a-Service (SaaS) model that operationalizes hybrid and multi-cloud modern analytical workloads through a simple user interface, easily installed and deployed in minutes. HPE Ezmeral Unified Analytics Software separates compute and storage for flexible, cost-efficient scalability to securely access data stored in multiple data platforms, enabling you to run traditional and advanced analytics workloads with open-source tools.
Published	November 2024
Edition	1.5.0