August 15, 2023

Mapping the schemas – Docs for ESB 6.x

  2. Talend for ESB Docs
  3. Docs 6.x
  4. Mapping the schemas – Docs for ESB 6.x

Mapping the schemas

  1. Click ELT Hive Map Editor to map the
    schemas

    use_case-telthivemap7.png

  2. On the input side (left in the figure), click the Add alias button to add the table to be used.

    add_alias.png

  3. In the pop-up window, select the customer table, then click OK.
  4. Repeat the operations to select the state_city table.
  5. Drag and drop the idstate column from
    the customer table onto the id column of the state_city table. Thus an inner join is created
    automatically.
  6. On the output side (the right side in the figure), the agg_result table is empty at first. Click

    Button_Plus.png

    at the bottom of this side to add as many columns as
    required and rename them to replicate the schema of the agg_result table you created earlier in Hive.

    use_case-telthivemap8.png

    Note:

    The type column is the partition
    column of the agg_result table and
    should not be replicated in this schema. For further information about
    the partition column of the Hive table, see the Hive manual.

  7. From the customer table, drop id, name,
    address, and sum1 to the corresponding columns in the agg_result table.
  8. From the state_city table, drop
    postal, state, capital and
    mostpopulouscity to the corresponding
    columns in the agg_result table.
  9. Click OK to validate these
    changes.
Document get from Talend https://help.talend.com
Thank you for watching.
Docs 6.x
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x