location of Pig Script in HUE using HDP 2.1 sandbox.

to create new topics or reply. | New User Registration

This topic contains 1 reply, has 2 voices, and was last updated by  iandr413 1 year, 2 months ago.

  • Creator
  • #52751

    Jack Price

    I have created the pig script in HDP 2.1 sandbox using Hue interface and it works. But how do I download the scripts once I have done the tutorial lab. Where exactly is the directory for the scripts – if I wanted to use the hue file browser to download the scripts.
    It’s very frustrating to not be able to find the pig scripts – even though I can see the scripts in ‘My Scripts’ of Pig in Hue.
    Please help!

Viewing 1 replies (of 1 total)

You must be to reply to this topic. | Create Account

  • Author
  • #52759


    Hi Jack,
    These scripts are stored in the hue DB, not in the filesystem. You can access this db by invoking sqlite3. At command line try the following:
    sqlite3 /var/lib/hue/desktop.db
    then run .tables
    You can see there is a pig_pigscript table

    You can dump this data to a .json file by running the following:
    cd /usr/lib/hue/build/env/bin
    ./hue dumpdata pig > pig.json

    I hope this helps


Viewing 1 replies (of 1 total)
Hortonworks Data Platform
The Hortonworks Data Platform is a 100% open source distribution of Apache Hadoop that is truly enterprise grade having been built, tested and hardened with enterprise rigor.
Get started with Sandbox
Hortonworks Sandbox is a self-contained virtual machine with Apache Hadoop pre-configured alongside a set of hands-on, step-by-step Hadoop tutorials.
Modern Data Architecture
Tackle the challenges of big data. Hadoop integrates with existing EDW, RDBMS and MPP systems to deliver lower cost, higher capacity infrastructure.