August 15, 2023

Defining the schema – Docs for ESB 6.x

  2. Talend for ESB Docs
  3. Docs 6.x
  4. Defining the schema – Docs for ESB 6.x

Defining the schema

  1. Double-click tHiveCreateTable to open its
    Component view.

    components-use_case-thiveload3.png

  2. Select the Use an existing connection
    check box and from Component list, select
    the connection configured in the tHiveConnection component you are using for this Job.
  3. Click the

    dotbutton.png

    button next to Edit
    schema     to open the schema editor.

  4. Click the

    plus_button.png

    button four times to add four rows and in the Column column, rename them to Id, FirstName, LastName and
    Reg_date, respectively.

    components-use_case-thiveload4.png

    Note that you cannot use the Hive reserved keywords to name the columns,
    such as location or date.
  5. In the Type column, select the type of
    the data in each column. In this scenario, Id is of the Integer type,
    Reg_date is of the Date type and the others are of the String type.
  6. In the DB type column, select the Hive
    type of each column corresponding to their data types you have defined. For
    example, Id is of INT and Reg_date is of
    TIMESTAMP.
  7. In the Data pattern column, define the
    pattern corresponding to that of the raw data. In this example, use the
    default one.
  8. 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