Enterprise Data Preparation Administrator Guide > Administration Process > 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. 1. Search for hive-hcatalog-core.jar in the Cloudera CDH installation directory.
    2. You can generally find the .jar file in the following directory:
    /opt/cloudera/parcels/CDH/lib/hive-hcatalog/share/hcatalog/
  2. 2. Log in to Cloudera Manager, and then select Hive in the cluster.
  3. 3. Click the Configuration tab, then select the Advanced category.
  4. 4. Enter the path to the directory containing the .jar file in the Hive Auxiliary JARs Directory property.
    5. If the file is in the location noted, the path to the directory is:
    /opt/cloudera/parcels/CDH/lib/hive-hcatalog/share/hcatalog/
  5. 5. Ensure that the following property exists in the Hive configuration:
    6. Property: hive.reloadable.aux.jars.path
    Value: /opt/cloudera/parcels/CDH/jars
  6. 6. Restart the Hive server after you complete the configuration updates.