Adding an IoTDB Data Source

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

View PDF

This section applies to MRS 3.2.0 or later.

Add an IoTDB JDBC data source on HSConsole of a cluster in security mode.

The domain name of the cluster where the data source is located must be different from that of the HetuEngine cluster.
The cluster where the data source is located and the HetuEngine cluster nodes can communicate with each other.
A HetuEngine compute instance has been created.
By default, SSL is enabled for the IoTDB service in a security cluster. After SSL is enabled, you need to upload the truststore.jks file. For details about how to obtain the file, see Using the IoTDB Client.

Log in to FusionInsight Manager as a HetuEngine administrator and choose Cluster > Services > HetuEngine.
On the Dashboard tab page that is displayed, find the Basic Information area, and click the link next to HSConsole WebUI.

Choose Data Source and click Add Data Source. Configure parameters on the Add Data Source page.

In the Basic Configuration area, configure Name and choose JDBC > IoTDB for Data Source Type.

Configure parameters in the IoTDB Configuration area by referring to Table 1.

**Table 1** IoTDB configuration parameters
Parameter	Description	Example Value
Driver	The default value is iotdb.	iotdb
JDBC URL	JDBC URL for connecting to IoTDB. If the IoTDB data source uses an IPv4 address, the format is jdbc:iotdb:// P address 1 of the IoTDBServer service, IP address 2 of the IoTDBServer service:Port. If the IoTDB data source uses an IPv6 address, the format is jdbc:iotdb://[ P address 1 of the IoTDBServer service, IP address 2 of the IoTDBServer service]:Port.	IPv4: jdbc:iotdb://10.10.10.11,10.10.10.12:22260 IPv6: jdbc:iotdb://[10:10::10:11,10:10::10:12]:22260
Username	IoTDB username for connecting to the IoTDB data source	NOTE: If the cluster where IoTDB resides is in non-security mode, set this parameter to the default IoTDB user root.
Password	Password of the IoTDB username for connecting to the IoTDB data source	NOTE: If the cluster where the IoTDB service is installed is in non-security mode, obtain the password of user root from the administrator of this cluster.
Enable SSL	Whether SSL is enabled for the IoTDB service. SSL is enabled by default in a security cluster.	Yes
truststore File	After SSL is enabled for IoTDB, upload the truststore.jks file.	-

NOTE:

Service IP addresses of IoTDBServer:
Log in to FusionInsight Manager, choose Cluster > Services > IoTDB. On the page that is displayed, click the Instance tab. On this tab page, check Service IP Address of IoTDBServer.
Port number:
Log in to FusionInsight Manager, choose Cluster > Services > IoTDB. On the page that is displayed, click the Configurations tab. On this tab page, search for and check the value of IOTDB_SERVER_RPC_PORT. The default value is 22260.

Log in to the node where the cluster client is located and run the following commands to switch to the client installation directory and authenticate the user:

cd /opt/client

source bigdata_env

kinit User performing HetuEngine operations (If the cluster is in normal mode, skip this step.)
Run the following command to log in to the catalog of the data source:

hetu-cli --catalog Data source name --schema Database name

For example, run the following command:

hetu-cli --catalog iotdb_1 --schema root.ln
Run the following command. If the database table information can be viewed or no error is reported, the connection is successful.

show tables;

IoTDB can configure any label fields for time series. These IoTDB label fields and other data sources can be jointly queried through HetuEngine.
Any nodes from the IoTDB database level to the time series can be used as tables for data query on HetuEngine.

IoTDB data cannot be created but can be queried.
The IoTDB user who uses HetuEngine for query must at least be configured with the read permission on the root directory.

Parent topic: Adding a HetuEngine Data Source

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.