Pig and HCatalog

Question

I am getting the following error when I run "pig -useHCatalog".

Exception inthread"main"java.lang.NoClassDefFoundError:/usr/lib/hive/lib/libthrift-    
0/9/1/jar:/usr/lib/hive/lib/hive-exec-0/12/0/2/0/6/0-76/jar:/usr/lib/hive/lib/libfb303-
0/9/0/jar:/usr/lib/hive/lib/jdo-api-3/0/1/jar:/usr/lib/hive/lib/slf4j-api-1/7/2/jar
Caused by: java.lang.ClassNotFoundException: .usr.lib.hive.lib.libthrift-
0.9.1.jar:.usr.lib.hive.lib.hive-exec-0.12.0.2.0.6.0-76.jar:.usr.lib.hive.lib.libfb303-
    0.9.0.jar:.usr.lib.hive.lib.jdo-api-3.0.1.jar:.usr.lib.hive.lib.slf4j-api-1.7.2.jar
        at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
Could not find the main class: /usr/lib/hive/lib/libthrift-   
0.9.1.jar:/usr/lib/hive/lib/hive-exec-0.12.0.2.0.6.0-76.jar:/usr/lib/hive/lib/libfb303-
0.9.0.jar:/usr/lib/hive/lib/jdo-api-3.0.1.jar:/usr/lib/hive/lib/slf4j-api-1.7.2.jar.  
Program will exit

I have defined all the environement variables (including PIG_CLASSPATH) as below and also defined pig.additiona.jars in the pig.properties files

   export HADOOP_GROUP=hadoop ;
    export HADOOP_HOME=/usr/lib/hadoop
    export HCAT_HOME=/usr/lib/hcatalog
    export HIVE_HOME=/usr/lib/hive
    export templeton_host=$TEMPLETON_HOST
    export user_name=hcat
    export PIG_CLASSPATH=$HCAT_HOME/share/hcatalog/hcatalog-*.jar:\
    $HIVE_HOME/lib/hive-metastore-*.jar:$HIVE_HOME/lib/libthrift-*.jar:\
    $HIVE_HOME/lib/hive-exec-*.jar:$HIVE_HOME/lib/libfb303-*.jar:\
    $HIVE_HOME/lib/jdo2-api-*-ec.jar:$HIVE_HOME/conf:$HADOOP_CONF_DIR:\
    $HIVE_HOME/lib/slf4j-api-*.jar:/usr/lib/hive/lib/libthrift-    
    0.9.1.jar:/usr/lib/hive/lib/hive-exec-0.12.0.2.0.6.0-76.jar:/usr/lib/hive/lib/libfb303-
    0.9.0.jar:/usr/lib/hive/lib/jdo-api-3.0.1.jar:/usr/lib/hive/lib/slf4j-api-1.7.2.jar

    export PIG_OPTS=-Dhive.metastore.uris=thrift://$HIVE_HOST:$HIVE_PORT

In pig.properties file,

pig.additional.jars=/usr/lib/hive/lib/libthrift-0.9.1.jar:/usr/lib/hive/lib/hive-exec-   
   0.12.0.2.0.6.0-76.jar:/usr/lib/hive/lib/libfb303-0.9.0.jar:/usr/lib/hive/lib/jdo-api-  
   3.0.1.jar:/usr/lib/hive/lib/slf4j-api-1.7.2.jar

Please let me know how this could be resolved. Thanks!

Answer 1

Follow the steps mentioned here to install/configure HCatalog and integrate it with Pig.

Answer 2

You need to configure your environment variables in ~./bashrc

• export SQOOP_HOME=/usr/lib/sqoop
• export HBASE_HOME=/usr/local/Hbase
• export HIVE_HOME=/usr/local/hive
• export HCAT_HOME=/usr/local/hive/hcatalog