Help Center/ MapReduce Service/ Best Practices/ System Interconnection/ Using Yonghong BI to Access HetuEngine
Updated on 2024-05-06 GMT+08:00

Using Yonghong BI to Access HetuEngine

Use Yonghong Desktop 9.1 as an example to describe how to access HetuEngine in a security cluster.

Prerequisites

Procedure

  1. Open Yonghong Desktop and choose Create Connection > presto.

  2. On the data source configuration page, set parameters by referring to Figure 1. User and Password are the username and password of the created human-machine user. After the configuration is complete, click Test Connection.

    Figure 1 Configuring the data source
    • Driver: Choose Custom > Select Custom Driver. Click , edit the driver name, click Upload File to upload the obtained JDBC JAR file, and click OK.

    • URL: Enter the URL required for using either HSFabric or HSBroker. For details, see Table 1.
    • Server Login: Select Username and Password and enter the username and password.

  3. Click New Data Set. On the page that is displayed, modify the save path and change the file name by referring to Figure 2, and click OK.

    Figure 2 Modifying the save path and changing the file name

  4. Select the file name of the data set created in 3 under DemoAll. The default file name Untitled-0 is used as an example. Choose Untitled-0 > hive > default > Views and select SQL Data Set under New Data Set in the right pane.

  5. In the Connection area, select the new data set created in 3. All table information is displayed. Select a table, for example, test, and click Refresh Data. All table information is displayed in the Data Details area on the right.