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.