Define Pig Script Dialog Box

Provides an interface to write the Pig statements for the operator, similar to the other "execute" script operators in Team Studio.

Pig Input
The results of the preceding operator (or operators) are passed along as Pig relations (for example, alpine_pig_input_1) and a sample script is provided for convenience. The Pig Execute Operator contains a reference to these Input Relations as well as lists of their column names.

There may be more than one input operator to a Pig Execute Operator. The names of the Input Relations (Alias) and Column Names are provided below the script area for ease of reference. You can double-click these labels to include them in the script.

Pig Output
The output of the Pig Execute script should be stored in the location specified in the Results Location and Results Name parameters. This is the default value provided in the alpine_pig_output variable statement of the script.
Attention: STORE statements in a Pig script are not supported for saving output. Instead, use alpine_pig_output = x;.
Assistance with Writing Pig
Auto-completion hints are available while you edit the Pig script. Type CTRL-Space (or CTRL-Shift-Space if you use Firefox).

For additional help with Pig Script, the Pig Syntax link shows a short overview of common Pig syntax.

Using the Define SQL Dialog Box
Auto-completion hints are available while you edit the script. Type CTRL-Space (or CTRL-Shift-Space if you use Firefox).