Installing the Impala UDFs

To use the Impala component, first install the UDFs. The UDFs for Impala are available in the pepimpala.so file. This file is available in the /opt/cloudera/parcels/PTY_BDP/pepimpala/ directory after installing the Big Data Protector. To install the Impala UDFs:

1. Load the pepimpala.so file to HDFS.
2. Execute the .sql scripts to load the Impala UDFs.

To install the Impala UDFs:

1. Ensure that the cluster is installed, configured, and running.

2. To create the /opt/protegrity/impala/udfs/ directory in HDFS, run the following command:

   sudo -u hdfs hadoop fs -mkdir -p /opt/protegrity/impala/udfs/
   

3. To assign Impala supergroup permissions to the /opt/protegrity/impala/udfs/ directory, run the following command:

   sudo -u hdfs hadoop fs -chown -R impala:supergroup /opt/protegrity/impala/udfs/
   

4. To navigate to the /opt/cloudera/parcels/PTY_BDP/pepimpala/ directory, run the following command:

   cd /opt/cloudera/parcels/PTY_BDP/pepimpala/
   

5. To load the pepimpala.so file to the /opt/Protegrity/impala/udfs/ directory, run the following command:

   sudo -u hdfs hadoop fs -put pepimpala<version>.so /opt/protegrity/impala/udfs
   

   In this case, the name of the shared objects file considered as pepimpala.so. Typically, the name of the shared objects file is pepimpala<xx>RHEL.so, where is the version of the file, which needs to be considered.

6. Navigate to the /opt/cloudera/parcels/PTY_BDP/pepimpala/sqlscripts/ directory.

   Note: This directory contains the SQL scripts to install the Protegrity UDFs for the Impala protector.

7. If you are not using a Kerberos-enabled Hadoop cluster, then execute the createobjects.sql script to install the Protegrity UDFs for the Impala protector.

   impala-shell -i <IP address of any Impala slave node> -f /opt/cloudera/parcels/PTY_BDP/pepimpala/sqlscripts/createobjects.sql
   

8. If you are using a Kerberos-enabled Hadoop cluster, then execute the createobjects.sql script to load the Protegrity UDFs for the Impala protector.

   impala-shell -i <IP address of any Impala slave node> -f /opt/cloudera/parcels/PTY_BDP/pepimpala/sqlscripts/createobjects.sql -k
   

   Note: For more information about registering the Impala UDFs using the helper script, refer Registering the Impala UDFs.