Double-click the second tHCatalogOperation component, labelled HCatalog_CreateTable in this example, to
open its Basic settings view on the
- Define the same HCatalog connection details using the same procedure as for the first tHCatalogOperation component.
Click the Schema list box and select
Repository, then click the
[...] button next to the field that
appears to open the Repository
Content dialog box, expand and
select schema. Click OK to confirm your
choice and close the dialog box. The generic schema of access_log is automatically applied to the
Alternatively, you can directly select the generic schema of access_log from the Repository tree view and then drag and drop it onto this component to apply the schema.
- From the Operation on list, select Table; from the Operation list, select Drop if exist and create.
- In the Table field, enter a name for the table to be created, weblog in this example.
Select the Set partitions check box
and click the [...] button next to
Edit schema to set a partition and
The partition schema must not contain any column name defined in the table schema. In this example, the partition schema column is named ipaddresses.
- Upon completion of the component settings, press Ctrl+S to save your Job configurations.