Using Yonghong BI to Access HetuEngine

Prerequisites

• Yonghong BI has been installed.
• The JDBC JAR file has been obtained. For details, see 1.
• A human-machine user has been created in the cluster. For details about how to create a user, see Creating a HetuEngine User.

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: For details, see "URL format" in 2.
   • Server Login: Select Username and Password and enter the username and password.

3. Click New Data Set. On the displayed page, change the save path by referring to Figure 2 and click OK.
   Figure 2 Changing a path
   

4. In the connection area, select hetu > hive > default > Views. In the New Data Set area on the right, select SQL Data Set.

   

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.