Using Yonghong BI to Access HetuEngine

Prerequisites

• Yonghong Desktop has been installed.
• The JDBC JAR file has been obtained. For details, see 1.
• A human-machine user, for example, hetu_user, has been created in the cluster. For details, see Creating a HetuEngine User. For clusters with Ranger authentication enabled, the Ranger permission must be added to user hetu_user based on service requirements. For details, see Adding a Ranger Access Permission Policy for HetuEngine.
• A compute instance has been created and is running properly. For details, see Creating HetuEngine Compute Instances.

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 either in the HSBroker mode. 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.