Home
7.4.0 Development
This section contains information related to application development for Ezmeral ecosystem components and HPE Ezmeral Data Fabric products, including the file system, Database (Key-Value and JSON), and Event Streams.
Ecosystem Components
The following sections provide information about each open-source project that is supported by the HPE Ezmeral Data Fabric.
Apache Drill
Working with Drill
Connecting Drill to Data Sources
Choose and configure storage plugins to enable Drill to connect to a data source.
maprdb Format Plugin for Drill
Drill supports access to HPE Ezmeral Data Fabric Database JSON and binary tables through the maprdb format plugin.

HPE Ezmeral Data Fabric – Customer-Managed 7.4.0 Documentation

7.4.0 Development
This section contains information related to application development for Ezmeral ecosystem components and HPE Ezmeral Data Fabric products, including the file system, Database (Key-Value and JSON), and Event Streams.
- Application Development Process
  Before you start developing applications on the HPE Ezmeral Data Fabric platform, consider how you will get the data into the platform, the storage format of the data, the type of processing or modeling that is required, and how the data will be accessed.
- File Store and Apps
  The following sections provide information about accessing the File Store with C and Java applications.
- HPE Ezmeral Data Fabric Database and Apps
  This section contains information about developing client applications for JSON and key-value tables.
- Apache Kafka Wire Protocol Service
  HPE Ezmeral Data Fabric Streams supports Apache Kafka Wire Protocol Service. Apache Kafka Wire Protocol Service is a TCP/IP service that emulates a Kafka cluster backed by HPE Ezmeral Data Fabric Streams. The service makes it possible for Apache Kafka clients written in any programming language to access topics in HPE Ezmeral Data Fabric Streams.
- HPE Ezmeral Data Fabric Streams and Apps
  HPE Ezmeral Data Fabric Streams brings integrated publish and subscribe messaging to HPE Ezmeral Data Fabric.
- MapReduce and Apps
  This section contains information associated with developing YARN applications.
- Kubernetes Interfaces for Data Fabric
  This section describes how to leverage the capabilities of the Kubernetes Interfaces for Data Fabric.
- Ecosystem Components
  The following sections provide information about each open-source project that is supported by the HPE Ezmeral Data Fabric.
  - Ecosystem Packs
  - Apache Airflow
    This topic provides an overview of Apache Airflow on HPE Ezmeral Data Fabric.
  - AsyncHBase
  - Cascading
  - Apache Drill
    - Drill Tutorial
    - Drill-on-YARN
    - Configuring Drill
      Lists the data-fabric-specific configuration for Drill.
    - Working with Drill
      - Connecting Drill to Data Sources
        Choose and configure storage plugins to enable Drill to connect to a data source.
        Drill Storage and Format Plugin Support Matrix
        maprdb Format Plugin for Drill
        Drill supports access to HPE Ezmeral Data Fabric Database JSON and binary tables through the maprdb format plugin.
        Modifying the maprdb Format Settings within the dfs Storage Plugin Configuration
        You can add or modify certain maprdb format plugin settings within the dfs storage plugin configuration on the Storage page in the Drill Web UI.
        Overriding Default maprdb Format Plugin Settings in drill-override.conf
        You can override the default maprdb format plugin settings that control the level of parallelism in Drill and the media type in the drill-override.conf file.
        Drill Options for the maprdb Format Plugin
        You can enable certain Drill options for the maprdb format plugin from the Options page in the Drill Web UI or from the command line using the SET and ALTER SYSTEM commands.
        HPE Ezmeral Data Fabric Database Tables
        The maprdb format plugin enables you to query binary and JSON tables like you would query files in a file system because HPE Ezmeral Data Fabric Database and the file system share the same namespace.
        Working with Joda-Time Format
        Describes queries on Joda-Time formatted columns and how to include annotations for successful queries.
        Configuring the Hive Storage Plugin
        Configuring the Kafka Storage Plugin
        To configure Kafka as a data source in Drill, update the <drill_home>/jars/3rdParty directory with the required JAR files, restart Drill, and configure the kafka storage plugin in the Drill Web UI.
        Configuring the HBase Storage Plugin
        As a Hadoop database, Apache HBase is a distributed, scalable, and big data store. Use and configure the HBase storage plugin to connect with Apache Drill.
      - Start the Drill Web UI
        The Drill Web UI is one of several client interfaces that you can use to access Drill.
      - Start the Drill Shell (SQLLine)
        SQLLine is a JDBC application packaged with Drill that serves as the Drill shell. When you issue queries from the SQLLine, the SQLLine client sends the queries to the connected Drillbit (Drill node).
      - Hive to Drill Type Mapping
    - Securing Drill
      An administrator can install Drill with the default security configuration or manually configure custom security for Drill.
    - Drill Drivers
      HPE Ezmeral Data Fabric provides Drill ODBC and JDBC drivers that you can download and use to connect Drill to BI tools. The drivers are updated periodically to include support for new functionality in Drill.
    - Drill Configuration Files
      The Drill installation includes configuration files with start-up options that you can modify prior to starting Drill.
    - Mask Sensitive Data in Query Logs and Profiles
      Starting in Drill 1.20.2 (EEP 9.0.0 installed on Core 7.1.0), you can define a set of rules in a JSON file to mask sensitive data in Drill query logs and query profiles.
    - Monitoring Drill Metrics
    - Optimizing Queries with Indexes
      HPE Ezmeral Data Fabric Database provides a highly scalable key-value database platform on which you can run SQL queries using Drill. As of the 6.0 release of the MapR Data Platform, HPE Ezmeral Data Fabric Database natively supports indexes on secondary fields in JSON tables.
    - Drill Limitations
      Provides information about Drill limitations and solutions where applicable.
    - Vulnerability Reports
      Provides vulnerability information in relation to Drill.
  - Hadoop
  - HBase
  - HBase Client and HPE Ezmeral Data Fabric Database Binary Tables
  - HCatalog
  - Hive
  - HttpFS
  - Hue
  - Livy
    Apache Livy is primarily used to provide integration between Hue and Spark.
  - HPE Ezmeral Data Fabric Streams Clients and Tools
    Describes the supported HPE Ezmeral Data Fabric Streams tools and clients.
  - NiFi
    This topic provides an overview of Apache NiFi on HPE Ezmeral Data Fabric.
  - Ranger
  - Apache Spark
  - YARN
  - Zeppelin
- Maven and the HPE Ezmeral Data Fabric
  This section discusses topics associated with Maven and the HPE Ezmeral Data Fabric.
- Developer's Reference
  This section contains in-depth information for the developer.
- API Documentation
  HPE Ezmeral Data Fabric supports public APIs for file system, HPE Ezmeral Data Fabric Database, and HPE Ezmeral Data Fabric Streams. These APIs are available for application-development purposes.

maprdb Format Plugin for Drill

Drill supports access to HPE Ezmeral Data Fabric Database JSON and binary tables through the maprdb format plugin.

When you install Drill, the maprdb format is automatically defined within the default dfs storage plugin configuration to make HPE Ezmeral Data Fabric Database a consumable data source for Drill. You can access the dfs storage plugin configuration from the Storage page in the Drill Web UI.

When you install Drill, you will see some options specific to the maprdb format plugin that you can change or configure. You can modify these options in the following places:

For additional information about storage plugins, see Plugin Configuration Basics.

(Topic last modified: 2020-07-13)