Writing the sample data to the MapR OJAI database - 7.0

MapRDB

author
Talend Documentation Team
EnrichVersion
7.0
EnrichProdName
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Open Studio for Big Data
Talend Real-Time Big Data Platform
task
Data Governance > Third-party systems > Database components > MapRDB components
Data Quality and Preparation > Third-party systems > Database components > MapRDB components
Design and Development > Third-party systems > Database components > MapRDB components
EnrichPlatform
Talend Studio

Procedure

  1. Double-click tMapROjaiOutput to open its Component view.
  2. In the Table field, enter the name of the table to be used in your MapR OJAI database.
  3. From the DB Version list, select the MapR OJAI database version you are using.

    At runtime, tMapROjaiOutput automatically reads the connection information to the database from the \opt\mapr\conf\mapr-clusters.conf file of your MapR client.

    In this example, the content of this file reads as follows:
    mapr521   mapr521:7222
  4. From the Action on table drop-down list, select Drop table if exists and create and then from the Action on data drop-down list, select Insert.
  5. In the Mapping table, the columns from the schema has automatically appears in the Column column. In the Parent field path column, enter Name within double quotation marks in the firstname row and the lastname row and enter Status within double quotation marks in the sex row, the married row and the age row.

    This configuration groups the candidates' first names and last names in the Name field and their sexes, marriage status and ages in the Status field in the outputted data flow.

  6. Press F6 to run the Job.