Before you create a data migration or synchronization task, you must configure the data sources. This topic describes how to create a Hive data source in OceanBase Migration Service (OMS) Community Edition.
Prerequisites
You have obtained the IP address and port number of the related database.
You have created a database user for data migration or synchronization.
We recommend that you create a dedicated database user for the data migration or synchronization task and grant the required data operation privileges to the user. For more information, see Create a database user.
Procedure
Log in to the console of OMS Community Edition.
In the left-side navigation pane, click Data Source Management.
On the Data Source Management page, click New Data Source in the upper-right corner.
In the New Data Source dialog box, select Hive for Data Source Type.
Configure the following parameters.
Parameter Description Data Source Identifier We recommend that you set it to a combination of digits and letters. It must not contain any spaces and cannot exceed 32 characters in length. Notice
The data source identifier must be globally unique in the system of OMS Community Edition.
Region Select the region where the data source resides from the drop-down list. The region is the value that you set for the cm_regionparameter when you deployed OMS Community Edition.Notice
- This parameter is displayed only when multiple regions are available.
- Make sure that the mappings between the data source and the region are consistent. Otherwise, the migration and synchronization performance can be poor.
Host IP Address The IP address of the host where the database is located. Port The port number of the host where the database is located. Default value: 10000.Database Username The username of the Hive database user for data migration or synchronization. Database Password (Optional) The password of the database user. Thrift Host The address of the Thrift host. - Start the Metastore service to provide Thrift connections.
shell nohup bin/hive --service metastore > 1.log & - Start the HiveServer2 service to allow JDBC connectivity to the Hive database.
shell nohup bin/hive --service hiveserver2 > 2.log&
Thrift Port (Optional) The port number of the Thrift host. Default value: 9083.Remarks (Optional) Additional information about the data source. Click Test Connection to verify the network connection between OMS Community Edition and the data source, as well as the validity of the username and password.
After the test is passed, click OK.