Home Forums Hortonworks Sandbox Sandbox 2.0 tutorial 1 error

This topic contains 3 replies, has 2 voices, and was last updated by  Malek Safa 5 months, 2 weeks ago.

  • Creator
    Topic
  • #50475

    Malek Safa
    Participant

    Dears,
    I have just installed Hortonworks Sandbox 2.0 on Oracle Virtual Box (Microsoft version) and while trying to complete the first tutorial (tutorial 1) i have faced the below error:

    ERROR org.apache.pig.PigServer – exception during parsing: Error during parsing. Could not resolve org.apache.hcatalog.pig.HCatLoader using imports: [, java.lang., org.apache.pig.builtin., org.apache.pig.impl.builtin.]

    below is my Pig script:

    a = LOAD ‘nyse_stocks’ USING org.apache.hcatalog.pig.HCatLoader();
    b = filter a by stock_symbol == ‘IBM’;
    c = group b all;
    d = foreach c generate AVG(b.stock_volume);
    dump d;

    what should i do to fix this issue?

    Thank you.

Viewing 3 replies - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.

  • Author
    Replies
  • #50480

    Malek Safa
    Participant

    thank you Kevin, it is working now.

    Collapse
    #50479

    Kevin Risden
    Participant

    You need to check the useHCatalog box at the bottom of the pig editor in hue for the script before running it.

    Collapse
    #50477

    Malek Safa
    Participant

    i did find out many Resolutions like:

    Resolution:
    1. Login to sandbox as root.
    2. vi /usr/bin/pig
    3. Replace the last line with the following line:
    exec /usr/lib/pig/bin/pig -useHCatalog “$@”

    however i was not able to login to sandbox as root using; username: root and password: hadoop, it didn’t work saying that username or password is wrong.

    Collapse
Viewing 3 replies - 1 through 3 (of 3 total)