Edit Table Columns Dialog Box
The Edit Table Columns dialog box defines the structure of the data table to output from a SQL Execute or R Execute operator.
SQL and R are dynamic languages that can generate arbitrary output at runtime. Because many big-data technologies are static (that is, the types are known in advance), Team Studio must validate that the values specified in this dialog box are the values SQL or R returns at runtime. This design ensures that in case of a mismatch, Team Studio can notify the user and advise them how to correct the problem.
When you first add a SQL Execute or R Execute operator and view the Result Table Structure, you see that it is empty. This result is expected because the SQL or R script has not run yet, and Team Studio does not yet know what column names should be in the output. After running the operator once, you can see that the column names from the alpine_output variable are populated. To add more columns to your output, you must ensure that they are present in the script as well as in the Result Table Structure columns.
To use the Edit Table Columns dialog box, provide the following.
| Name | Description |
|---|---|
| Column Name | For each column, specify a valid column name. |
| Column Type | For each column, specify the data type for the associated Column Name. |
| New Field | Click add a new table column to the structure. |
| Delete | Click to delete the column. |
| Down | Adjust the position of the column downwards. |
| Up | Adjust the position of the column upwards. |