Managing Loader Jobs

Updated on 2022-12-14 GMT+08:00

View PDF

Scenario

You can create, view, edit, and delete jobs on the Loader page.

This section applies to versions earlier than MRS 3.x.

Prerequisites

You have accessed the Loader page. For details, see Loader Page.

Creating a Job

On the Loader page, click New job.
In Connection, set parameters.
1. In Name, enter a job name.
2. In From link and To link, select links accordingly.
  After you select a link of a type, data is obtained from the specified source and saved to the destination.
  
  NOTE:
  
  If no available link exists, click Add a new link.
In From, configure the job of the source link.

For details, see Source Link Configurations of Loader Jobs.
In To, configure the job of the destination link.

For details, see Destination Link Configurations of Loader Jobs.
Check whether a database link is selected in To link.

Database links include:
- generic-jdbc-connector
- hbase-connector
- hive-connector
If you set To link to a database link, you need to configure a mapping between service data and a field in the database table.
- If you set it to a database link, go to 6.
- If you do not set it to a database link, go to 7.

In Field Mapping, enter a field mapping. Then proceed to 7.

Field Mapping specifies a mapping between each column of user data and a field in the database table.

**Table 1** **Field Mapping** properties
Parameter	Description
Column Num	Field sequence of service data
Sample	First row of sample values of service data
Column Family	When To link is hbase-connector, you can select a column family for storing data.
Destination Field	Field for storing data
Type	Type of the field selected by the user
Row Key	When To link is hbase-connector, you need to select Destination Field as a row key.

NOTE:

If the value of From is a connector of a file type, for example, SFTP, FTP, OBS, and HDFS files, the value of Field Mapping is the first row of data in the file. Ensure that the first row of data is complete. Otherwise, the Loader job will not extract columns that are not mapped.

In Task Config, set job running parameters.

**Table 2** Loader job running properties
Parameter	Description
Extractors	Number of Map tasks
Loaders	Number of Reduce tasks This parameter is displayed only when the destination field is HBase or Hive.
Max. Error Records in a Single Shard	Error record threshold. If the number of error records of a single Map task exceeds the threshold, the task automatically stops and the obtained data is not returned. NOTE: Data is read and written in batches for MYSQL and MPPDB of generic-jdbc-connector by default. Errors are recorded once at most for each batch of data.
Dirty Data Directory	Specifies the directory for saving dirty data. If you leave this parameter blank, dirty data will not be saved.

Click Save.

Viewing a Job

Access the Loader page. The Loader job management page is displayed by default.
- If Kerberos authentication is enabled for the cluster, all jobs created by the current user are displayed by default and other users' jobs cannot be displayed.
- If Kerberos authentication is disabled for the cluster, all Loader jobs of the cluster are displayed.
In Sqoop Jobs, enter a job name to filter the job.
Click Refresh to obtain the latest job status.

Editing a Job

Access the Loader page. The Loader job management page is displayed by default.
Click the job name to go to the edit page.
Modify the job configuration parameters based on service requirements.
Click Save.

NOTE:

Basic job operations in the navigation bar on the left are Run, Copy, Delete, Disable, History Record, and Show Job JSON Definition.

Deleting a Job

Access the Loader page.
In the row of the specified job, click .

You can also select one or more jobs and click Delete Job in the upper right corner of the job list.
In the dialog box, click Yes, delete it.

If the state of a Loader job is Running, the job fails to be deleted.

Parent topic: Using Loader

Previous topic: Destination Link Configurations of Loader Jobs

Next topic: Preparing a Driver for MySQL Database Link

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.

Chatbot