To Hive
Data can be rapidly imported to MRS Hive.
Type |
Parameter |
Description |
Example Value |
---|---|---|---|
Basic parameters |
Database |
Database name. Click the icon next to the text box. The dialog box for selecting the database is displayed. |
default |
Table Name |
Destination table name. 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 job – Offset) rather than (Actual start time of the CDM job – Offset). |
TBL_X |
|
Hive Write Mode |
Mode of writing data to Hive
|
LOAD_OVERWRITE |
|
Partition Values |
In TRUNCATE mode, multiple partitions are supported. You only need to enter values in the corresponding text boxes. In LOAD_OVERWRITE mode, data can be written to only one partition. |
- |
|
Advanced attributes |
Source side null value conversion value |
Null value conversion type
|
TO_NULL |
Newline character processing mode |
Policy for processing the newline characters in the data written to Hive textfile tables. You can select Delete, Replace with another character string, or Do not process. |
Delete |
|
Newline Replacement String |
This parameter is available when Processing mode of newline characters is set to Replace with another character string. It indicates the string that will replace newline characters. |
N/A |
|
Executing Analyze Statements |
After all data is written, the ANALYZE TABLE statement is asynchronously executed to accelerate the Hive table query. The SQL statement is as follows:
NOTE:
|
Yes |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot