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
- Yonghong Desktop has been installed.
- The JDBC JAR file has been obtained. For details, see 1.
- You have created a human-machine user, for example, hetu_user, in the cluster. For details, see Creating a HetuEngine User. For clusters with Ranger authentication enabled, you need to grant the Ranger permission to 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 a HetuEngine Compute Instance.
Procedure
- Open Yonghong Desktop and choose Create Connection > presto.
- 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.
- 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.
- Driver: Choose Custom > Select Custom Driver. Click , edit the driver name, click Upload File to upload the obtained JDBC JAR file, and click OK.
- 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.
- 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.
- 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.
Parent topic: System Interconnection
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
The system is busy. Please try again later.