hortonworks sandbox pig script

Question

Hi I just setup the Hortonworks Sandbox on VirtualBox on Windows 7. I got everything up and running and started the pig tutorial. I want to run this simple table load pig script:

-- Get all IBM stocks
a = LOAD 'default.nyse_stocks' USING org.apache.hive.hcatalog.pig.HCatLoader();
b = filter a by stock_symbol == 'IBM';
dump b;

I get this error:

Failed to parse: Pig script failed to parse: 
<file script.pig, line 2, column 37> pig script failed to validate: org.apache.pig.backend.executionengine.ExecException: ERROR 1070: Could not resolve org.apache.hive.hcatalog.pig.HCatLoader using imports: [, java.lang., org.apache.pig.builtin., org.apache.pig.impl.builtin.]

Not sure want to do. Fairly new to Hadoop. Thanks

I tried the "pig -useHCatalog" option but still got the same error message. — Travis Payne, Jan 26 '15 at 19:12
So I used this. [link](http://idavit.blogspot.mx/2014/12/como-no-morir-en-el-intento-primer.html) . When I tried to run the -useHCatalog option with an ssh session it did not work but it completely worked on hue. Thanks for the responses. — Travis Payne, Jan 27 '15 at 17:23

beeks · Answer 1 · 2016-08-15T14:17:08.703

2

If anyone runs into this problem, like me, after working through the Hortonworks HDP 2.4 tutorials, the answer is:

   1. Open the script in the Pig view in Ambari
   2. Below the query editor, there are 'Arguments'
   3. Choose +Add, then type in -useHCatalog

edited Aug 15 '16 at 14:17

answered Mar 31 '16 at 21:15

beeks

223
2
8

score 0 · Answer 2 · answered Aug 10 '15 at 06:35

0

copy the jar file name hcatalog*.jar to the path “<%HADOOP_HOME>\bin\share\hcatalog"

answered Aug 10 '15 at 06:35

Mohan Raj

1,104
9
17

score 0 · Answer 3 · answered May 18 '16 at 19:36

0

The use of 'Arguments' (answer by beeks) works, by need to be careful with the case: -useHCatalog, not -useHcatalog.

answered May 18 '16 at 19:36

Venkat Rajan

1

hortonworks sandbox pig script

3 Answers3