Table Output
Overview
The Table Output operator exports output fields to specified columns in a relational database table.
Input and Output
- Input: fields to be exported
- Output: relational database table
Parameters
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:
|
map |
Yes |
None |
Data Processing Rule
The field values are exported to the table.
Example
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:
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.