Define Variables Dialog Box

This dialog box allows you to specify the expression to create new variable columns.

To add a variable, provide the following information:

  • Variable Name - the name of the variable to be created.
  • Data Type - the data type of the variable.
  • SQL Expression - define the variable.

Using the Dialog

  • To add another variable, select "Create." A new row is added to the variable table.
  • To remove a variable, select "Delete" in the corresponding row.
  • To modify an existing variable definition, edit any of the fields.
  • To apply the expression to multiple columns, select the "multi" option.

Defining Multiple Variables

Select the "multi" option to define an expression for multiple columns.

The original expression is populated with from the first dialog box.

Specify the expression to create the new Variable column(s).

To add a variable, provide the following information:

  • Variable Name - the name of the variable to be created.
  • Data Type - the data type of the variable
  • Pig Expression - the expression in Pig defining the variable.

Using the Dialog

  • To add another variable, select "Create." A new row is added to the variable table.
  • To remove a variable, select "Delete" in the corresponding row.
  • To modify an existing variable definition, edit any of the fields.
  • To apply the expression to multiple columns, select the "multi" option.

Select the "multi" option to define an expression for multiple columns.

The original expression is populated with from the first dialog.

Related reference