Page History

...

Now let's follow the below steps to install/configure Ranger Hive plugin.

• Start by extracting binaries at the appropriate place.
            cd /usr/local
            sudo tar zxf ~/dev/ranger/target/ranger-0.4.0-hive-plugin.tar.gz
            sudo ln -s ranger-0.4.0-hive-plugin ranger-hive-plugin
            cd ranger-hive-plugin
• Now let’s edit the install.properties file. Here are the relevant lines that you should edit:
            POLICY_MGR_URL=http://localhost:6080
            REPOSITORY_NAME=hivedev
            XAAUDIT.DB.HOSTNAME=localhost
            XAAUDIT.DB.DATABASE_NAME=ranger
            XAAUDIT.DB.USER_NAME=rangerlogger
            XAAUDIT.DB.PASSWORD=rangerlogger
• Now enable the hive-plugin by running the enable-hive-plugin.sh command (Remember to set JAVA_HOME)
            cd /usr/local/ranger-hive-plugin
            ./enable-hive-plugin.sh
• Now edit the xasecure-audit.xml file.
  • cd /usr/local/hive/conf
  • Change the xasecure-audit.xml file. Make sure the JDBC properties are correct.

                   <property> <name>xasecure.audit.jpa.javax.persistence.jdbc.url</name>
                   <value>jdbc:mysql://localhost/ranger</value>
                   </property>
                   <property>
                   <name>xasecure.audit.jpa.javax.persistence.jdbc.user</name>
                   <value>rangerlogger</value>
                   </property>
                   <property> <name>xasecure.audit.jpa.javax.persistence.jdbc.password</name>
                   <value>rangerlogger</value>
                   </property>

• Once these changes are done Restart hive. This should start the association of ranger-hive-plugin with hive.
• You can verify by logging into the Ranger Admin Web interface -> Audit Tab -> Agents
  
  

...