Configuring the output schema

Procedure

Double-click tELTHiveOutput to open its Component view.
If this component does not have the same schema of the preceding component, a warning icon appears. In this case, click the Sync columns button to retrieve the schema from the preceding one and once done, the warning icon disappears.
In the Default table name field, enter the output table you want to write data in. In this example, it is agg_result.
In the Field partition table, click to add one row. This allows you to write data in the partition column of the agg_result table.
This partition column was defined the moment we created the agg_result table using partitioned by (type string) in the Create statement presented earlier. This partition column is type, which describes the type of a customer.
In Partition column, enter type in double quotation marks and in Partition value, enter prospective in double quotation marks.

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!