Source Link Configurations of Loader Jobs

Updated on 2022-02-22 GMT+08:00

View PDF

Overview

When Loader jobs obtain data from different data sources, a link corresponding to a data source type needs to be selected and the link properties need to be configured.

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

obs-connector

**Table 1** Data source link properties of **obs-connector**
Parameter	Description
Bucket Name	OBS file system for storing source data.
Source Directory/File	Actual storage form of source data. It can be either all data files in a directory or a single data file contained in the file system.
File Format	Loader supports the following file formats of data stored in OBS: CSV_FILE: Specifies a text file. When the destination link is a database link, only the text file is supported. BINARY_FILE: Specifies binary files excluding text files.
Line Separator	Identifier of each line end of source data
Field Separator	Identifier of each field end of source data
Encoding Type	Text encoding type of source data. It takes effect on text files only.
File Split Type	The following types are supported: File: The number of files is assigned to a map task by the total number of files. The calculation formula is Total number of files/Extractors. Size: A file size is assigned to a map task by the total file size. The calculation formula is Total file size/Extractors.

generic-jdbc-connector

**Table 2** Data source link properties of **generic-jdbc-connector**
Parameter	Description
Schema/Tablespace	Name of the database storing source data. You can query and select it on the interface.
Table Name	Data table storing the source data. You can query and select it on the interface.
Partition Column	If multiple columns need to be read, use this column to split the result and obtain data.
Where Clause	Query statement used when accessing the database

ftp-connector or sftp-connector

**Table 3** Data source link properties of **ftp-connector** or **sftp-connector**
Parameter	Description
Source Directory/File	Actual storage form of source data. It can be either all data files in a directory or single data file contained in the file server.
File Format	Loader supports the following file formats of data stored in the file server: CSV_FILE: Specifies a text file. When the destination link is a database link, only the text file is supported. BINARY_FILE: Specifies binary files excluding text files.
Line Separator	Identifier of each line end of source data NOTE: If FTP or SFTP serves as a source link and File Format is set to BINARY_FILE, the value of Line Separator in the advanced properties is invalid.
Field Separator	Identifier of each field end of source data NOTE: If FTP or SFTP serves as a source link and File Format is set to BINARY_FILE, the value of Field Separator in the advanced properties is invalid.
Encoding Type	Text encoding type of source data. It takes effect on text files only.
File Split Type	The following types are supported: File: The number of files is assigned to a map task by the total number of files. The calculation formula is Total number of files/Extractors. Size: A file size is assigned to a map task by the total file size. The calculation formula is Total file size/Extractors.

hbase-connector

**Table 4** Data source link properties of **hbase-connector**
Parameter	Description
Table Name	HBase table storing source data

hdfs-connector

**Table 5** Data source link properties of **hdfs-connector**
Parameter	Description
Source Directory/File	Actual storage form of source data. It can be either all data files in a directory or single data file contained in HDFS.
File Format	Loader supports the following file formats of data stored in HDFS: CSV_FILE: Specifies a text file. When the destination link is a database link, only the text file is supported. BINARY_FILE: Specifies binary files excluding text files.
Line Separator	Identifier of each line end of source data NOTE: If HDFS serves as a source link and File Format is set to BINARY_FILE, the value of Line Separator in the advanced properties is invalid.
Field Separator	Identifier of each field end of source data NOTE: If HDFS serves as a source link and File Format is set to BINARY_FILE, the value of Field Separator in the advanced properties is invalid.
File Split Type	The following types are supported: File: The number of files is assigned to a map task by the total number of files. The calculation formula is Total number of files/Extractors. Size: A file size is assigned to a map task by the total file size. The calculation formula is Total file size/Extractors.

hive-connector

**Table 6** Data source link properties of **hive-connector**
Parameter	Description
Database Name	Name of the Hive database storing the data source. You can query and select it on the interface.
Table	Name of the Hive table storing the data source. You can query and select it on the interface.

Parent topic: Using Loader

Previous topic: Managing Loader Links (MRS 3.x and Later Versions)

Next topic: Destination Link Configurations of Loader Jobs

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