Table of Contents

Search

  1. About the Enterprise Data Preparation Administrator Guide
  2. Introduction to Enterprise Data Preparation Administration
  3. Getting Started
  4. Administration Process
  5. User Account Setup
  6. Search Configuration
  7. Roles, Privileges, and Profiles
  8. Data Asset Access and Publication Management
  9. Masking Sensitive Data
  10. Monitoring Enterprise Data Preparation
  11. Backing Up and Restoring Enterprise Data Preparation
  12. Managing the Data Lakehouse
  13. Schedule Export, Import and Publish Activities
  14. Interactive Data Preparation Service
  15. Enterprise Data Preparation Service

Enterprise Data Preparation Administrator Guide

Enterprise Data Preparation Administrator Guide

Enable JSON Data Preparation

Enable JSON Data Preparation

Ensure that the following requirements are met to enable users to prepare and publish JSON files.

Hive System User Privileges

When you prepare a JSON Lines file,
Enterprise Data Preparation
uses the HDFS working directory configured for the
Enterprise Data Preparation
Service as a staging area.
Enterprise Data Preparation
also uses the staging schema from the Hadoop connection configured for the
Enterprise Data Preparation
Service.
If SQL Standards Based Authorization in HiveServer2 is enabled on Hive, ensure that the
hive
system user has read, write, and execute privileges on the directory configured as the HDFS working directory.

Cloudera CDH Configuration

If you integrate
Enterprise Data Preparation
with a Cloudera CDH Hadoop cluster, complete the following configuration steps to enable publication of JSON files.
  1. Search for hive-hcatalog-core.jar in the Cloudera CDH installation directory.
    You can generally find the .jar file in the following directory:
    /opt/cloudera/parcels/CDH/lib/hive-hcatalog/share/hcatalog/
  2. Log in to Cloudera Manager, and then select
    Hive
    in the cluster.
  3. Click the
    Configuration
    tab, then select the
    Advanced
    category.
  4. Enter the path to the directory containing the .jar file in the Hive Auxiliary JARs Directory property.
    If the file is in the location noted, the path to the directory is:
    /opt/cloudera/parcels/CDH/lib/hive-hcatalog/share/hcatalog/
  5. Ensure that the following property exists in the Hive configuration:
    Property: hive.reloadable.aux.jars.path
    Value: /opt/cloudera/parcels/CDH/jars
  6. Restart the Hive server after you complete the configuration updates.