2. Instructions

This section provides you instructions on the following:

 2.1. Deploying Talend Open Studio

Use the following instructions to set-up Talend Open Studio:

  1. Download and launch the application.

    1. Download the Talend Open Studio add-on for HDP from here.

    2. After the download is complete, unzip the contents in an install location.

    3. Invoke the executable file corresponding to your operating system.

    4. Read and accept the end user license agreement.

  2. Create a new project.

    1. Provide a project name (for example, HDPIntro) and click the Create button.

    2. Click Finish on the New Project dialog.

    3. Select the newly created project and click Open.

    4. The Connect To TalendForge dialog appears, you can choose to register or click Skip to continue.

    5. You should now see the progress information bar and a welcome window. Wait for the application to initialize and then click Start now! to continue. Talend Open Studio (TOS) main window appears and is now ready for use.

 2.2. Writing Talend job for data import

This section provides instructions on designing a simple job of importing a file into the Hadoop cluster.

  1. Create a new job.

    1. In the Repository tree view, right-click the “Job Designs” node.

    2. From the contextual menu, select “Create job”.

    3. In the “New Job” wizard provide a name (for example HDPJob) and click “Finish”.

    4. An empty design workspace corresponding to the Job name opens up.

  2. Create a sample input file.

    1. Under the /tmp directory of your TOS master deployment machine, create a text file (for example: input.txt) with the following contents:

      101;Adam;Wiley;Sales
      102;Brian;Chester;Service
      103;Julian;Cross;Sales
      104;Dylan;Moore;Marketing
      105;Chris;Murphy;Service
      106;Brian;Collingwood;Service
      107;Michael;Muster;Marketing
      108;Miley;Rhodes;Sales
      109;Chris;Coughlan;Sales
      110;Aaron;King;Marketing
              

  3. Build the job. Jobs are composed of components that are available in the Palette.

    1. Expand the Big Data tab in the Palette.

    2. Click on the component tHDFSPut and click on the design workspace to drop this component.

    3. Double-click tHDFSPut to define component in its Basic Settings view.

    4. Set the values in the Basic Settings corresponding to your HDP cluster (see the screenshot given below):

  4. Run the job. You now have a working job. You can run it by clicking the green play icon.

    You should see the following:

  5. Verify the import operation. From the gateway machine or the HDFS client, open a console window and execute the following command:

    hadoop dfs -ls /user/testuser/data.txt
    

    You should see the following result on your terminal window:

    Found 1 items
    -rw-r--r-- 3 testuser testuser
    252 2012-06-12 12:52 /user/
    testuser/data.txt
    

    This message indicates that the local file was successfully created in your Hadoop cluster.

 2.3. Modifying the job to perform data analysis

Use the following instructions to aggregate data using Apache Pig.

  1. Add Pig component from the Big Data Palette.

    1. Expand the Pig tab in the Big Data Palette.

    2. Click on the component tPigLoad and place it in the design workspace.

  2. Define basic settings for Pig component.

    1. Double-click tPigLoad component to define its Basic Settings.

    2. Click the Edit Schema button (“” button). Define the schema of the input data as shown below and click OK:

    3. Provide the values for the mode, configuration, NameNode URI, JobTracker host, load function, and input file URI fields as shown.

      [Important]Important

      Ensure that the NameNode URI and the JobTracker host corresponds to accurate values available in your HDP cluster. The Input File URI corresponds to the path of the previously imported input.txt file.

  3. Connect the Pig and HDFS components to define the workflow.

    1. Right-click the source component (tHDFSPut) on your design workspace.

    2. From the contextual menu, select Trigger -> On Subjob Ok.

    3. Click the target component (tPigLoad).

  4. Add and connect Pig aggregate component.

    1. Add the component tPigAggregate next to tPigLoad.

    2. From the contextual menu, right-click on tPigLoad and select -> Pig Combine.

    3. Click on tPigAggregate.

  5. Define basic settings for Pig Aggregate component.

    1. Double-click tPigAggregate to define the component in its Basic Settings.

    2. Click on the “Edit schema” button and define the output schema as shown below:

  6. Define aggregation function for the data.

    1. Add a column to Group by, choose dept.

    2. In the Operations table, choose the people_count in the Additional Output column, function as count and input column id as shown:

  7. Add and connect Pig data storage component

    1. Add the component tPigStoreResult next to tPigAggregate.

    2. From the contextual menu, right-click on tPigLoad, select Row -> Pig Combine and click on tPigStoreResult.

  8. Define basic settings for data storage component.

    1. Double-click tPigStoreResult to define the component in its Basic Settings view.

    2. Specify the result directory on HDFS as shown:

  9. Run the modified Talend job. The modified Talend job is ready for execution.

    Save the job and click the play icon to run as instructed in Step 4.

  10. Verify the results.

    1. From the gateway machine or the HDFS client, open a console window and execute the following command:

      hadoop dfs -cat /user/testuser/output/part-r-00000
      
    2. You should see the following output:

      Sales;4
      Service;3
      Marketing;3