Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here. Want to know more about what has changed? Check out the Community News blog.

Pig Editor Error- ErrorCode [EJ001], Message [Could not locate Oozie sharelib] on QuickStart VM

SOLVED Go to solution

Pig Editor Error- ErrorCode [EJ001], Message [Could not locate Oozie sharelib] on QuickStart VM

New Contributor

Hi,

 

I am new to Hadoop. I am trying to run below basic statement in Pig Editor. I am using Cloudera Quickstart VM.

                   sample_07 = LOAD 'sample_07' USING org.apache.hcatalog.pig.HCatLoader();

 

However, I am getting below error while running the script. I have not added any properties at the time of run. Please help.

 

           ErrorCode [EJ001], Message [Could not locate Oozie sharelib]

 

Thanks

Sach

 

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Pig Editor Error- ErrorCode [EJ001], Message [Could not locate Oozie sharelib] on QuickStart VM

New Contributor

Hi,

 

After adding site_hive.xml file to pig script using properties, I am able to run pig scripts.  

 

Thanks for all your help.

 

Sach

6 REPLIES 6

Re: Pig Editor Error- ErrorCode [EJ001], Message [Could not locate Oozie sharelib] on QuickStart VM

New Contributor

Hi,

 

  Please help on this.

 

Thanks

Sach

Re: Pig Editor Error- ErrorCode [EJ001], Message [Could not locate Oozie sharelib] on QuickStart VM

New Contributor

Hi.

 

I had the same problem. It turns out that they have a bug in the VM, misconfigured oozie service.

 

What I did is:

1. Open CDH VM in VMWare Player / Workstation

2. Open system console - appears on top desktop's toolbar

3. Write the following lines:

3.1. sudo service oozie stop

3.2. sudo oozie-setup sharelib create -fs /user/oozie/share/lib/mr1 -locallib /usr/lib/oozie/oozie-sharelib-mr1.tar.gz 

3.3. sudo service oozie start

 

Then try running Pig script again. Worked for me.

 

What this does is reinstalling share/lib required libraries.

See details here: http://www.cloudera.com/content/cloudera-content/cloudera-docs/CDH5/latest/CDH5-Installation-Guide/c...

 

Hope it helps you too.

 

David.

Highlighted

Re: Pig Editor Error- ErrorCode [EJ001], Message [Could not locate Oozie sharelib] on QuickStart VM

New Contributor

Thanks a lot, David.

 

I am able to move forward and stuck with below error while running Pig script.

 

 

[main] ERROR org.apache.pig.tools.grunt.Grunt - ERROR 2245: Cannot get schema from loadFunc org.apache.hcatalog.pig.HCatLoader

 

Please advice.

 

Thanks

Sach

Re: Pig Editor Error- ErrorCode [EJ001], Message [Could not locate Oozie sharelib] on QuickStart VM

New Contributor

I am not familiar with this error but Googling around leads me to this, maybe it helps: http://stackoverflow.com/questions/22304947/cannot-load-hive-table-into-pig-via-hcatalog

 

Re: Pig Editor Error- ErrorCode [EJ001], Message [Could not locate Oozie sharelib] on QuickStart VM

New Contributor
 

Re: Pig Editor Error- ErrorCode [EJ001], Message [Could not locate Oozie sharelib] on QuickStart VM

New Contributor

Hi,

 

After adding site_hive.xml file to pig script using properties, I am able to run pig scripts.  

 

Thanks for all your help.

 

Sach