Table Output¶

Overview¶

The Table Output operator exports output fields to specified columns in a relational database table.

**Table 1** Operator parameters description¶
Parameter	Description	Node Type	Mandatory	Default Value
Output delimiter	Delimiter. Note This configuration applies only to the MySQL dedicated connector. If the data column content contains the default delimiter, you need to set a user-defined delimiter. Otherwise, data disorder may occur.	string	No	,
Line delimiter	Line delimiter, which can be any string specified by users based on the actual situation. Any character string is supported. The OS line delimiter is used by default. Note This configuration applies only to the MySQL dedicated connector. If the data column content contains the default delimiter, you need to set a user-defined delimiter. Otherwise, data disorder may occur.	string	No	`\n`
Output fields	Information about relational database output fields: field name: Names of output fields. table column name: Names of database table columns. type: Field type. The value must be consistent with the field type configured in the database. length: Field value length. If the actual field value is excessively long, the value is cut based on the configured length. When type is set to CHAR, spaces are added to the field value for supplement if the actual field value length is less than the configured length. When type is set to VARCHAR, no space is added to the field value for supplement if the actual field value length is less than the configured length.	map	Yes	None

The field values are exported to the table.

Use the data export from HBase to sqlserver2014 as an example.

In sqlserver2014, run the following statement to create an empty data test_1 for storing HBase data. Run the following statement:

create table test_1 (id int, name text, value text);

Use the HBase Input operator to generated three fields A, B, and C.

Use the Table Output operator to export A, B, and C to the test_1 table.

The command output is as follows:

last updated: 2024-11-14 12:28 UTC - commit: 9d95be538b931742820cff066f12ce18f037ed96