Updated on 2024-10-23 GMT+08:00

From HBase

Table 1 Parameter description

Type

Parameter

Description

Mandatory

Example Value

Basic parameters

Table Name

Name of the table to which data will be written. Click the icon next to the text box. The dialog box for selecting the table is displayed.

This parameter can be configured as a macro variable of date and time and a path name can contain multiple macro variables. When the macro variable of date and time works with a scheduled job, the incremental data can be synchronized periodically. For details, see Incremental Synchronization Using the Macro Variables of Date and Time.

NOTE:

If you have configured a macro variable of date and time and schedule a CDM job through DataArts Studio DataArts Factory, the system replaces the macro variable of date and time with (Planned start time of the data development jobOffset) rather than (Actual start time of the CDM jobOffset).

Yes

table

Migrate Entire Table

This parameter is displayed when the source and destination links are both HBase links.

All information about the table is transferred in binary mode. Entire HBase table migration transfers the timestamp information, and non-entire HBase table migration only transfers column values.

Yes

No

Column Family

Column family from which data is exported, for example, CF1&CF2

Yes

CF1&CF2

Advanced attributes

Split Rowkey

Whether to write rowkey data to the HBase column at the same time. The default value is No.

No

No

Rowkey Delimiter

This parameter is displayed when Split Rowkey is set to Yes.

The delimiter is used to split rowkeys. If this parameter is not set, rowkeys are not split. An example delimiter is |.

No

|

Start Time

Start time (included). The format is yyyy-MM-dd hh:mm:ss. The dateformat time macro variable function is supported. Examples: 2017-12-31 20:00:00, ${dateformat(yyyy-MM-dd, -1, DAY)} 02:00:00, and ${dateformat(yyyy-MM-dd HH:mm:ss, -1, DAY)}

No

2017-12-31 20:00:00, ${dateformat(yyyy-MM-dd, -1, DAY)} 02:00:00, and ${dateformat(yyyy-MM-dd HH:mm:ss, -1, DAY)}

End Time

End time (excluded) The format is yyyy-MM-dd hh:mm:ss. The dateformat time macro variable function is supported. Examples: 2018-01-01 20:00:00, ${dateformat(yyyy-MM-dd, -1, DAY)} 02:00:00, and ${dateformat(yyyy-MM-dd HH:mm:ss, -1, DAY)}

No

2018-01-01 20:00:00, ${dateformat(yyyy-MM-dd, -1, DAY)} 02:00:00, and ${dateformat(yyyy-MM-dd HH:mm:ss, -1, DAY)}

Start RowKey

Start RowKey

No

0001

End RowKey

End RowKey

No

0100