Configuring and Importing the JDBC/HCatalog Sample Project

Updated on 2024-08-12 GMT+08:00

View PDF

Scenario

To run the JDBC API example codes of the Hive component of MRS, perform the following operations.

NOTE:

The following uses the development of an application for connecting the Hive service in JDBC/HCatalog mode on Windows as an example.
The HCatalog sample can run only on Linux nodes.

Procedure

Obtain the sample project folder hive-jdbc-example or hcatalog-example in the src\hive-examples directory where the sample code is decompressed. For details, see Obtaining the MRS Application Development Sample Project.
For the hive-jdbc-example sample project, place the following files in the hive-jdbc-example\src\main\resources directory:
- Authentication files user.keytab and krb5.conf obtained in User Information for Cluster Authentication.
- Configuration files core-site.xml and hiveclient.properties obtained in .
Go to the client decompression path FusionInsight_Cluster_1_Services_ClientConfig_ConfigFiles\Hive\config and manually import the core-site.xml and hiveclient.properties files to the hive-jdbc-example\src\main\resources directory of the sample project.
Import the example project to the IntelliJ IDEA development environment.
1. On the IntelliJ IDEA menu bar, choose File>Open.... The Open File or Project window is displayed.
2. In the displayed window, select the folder hive-jdbc-example, and click OK. On Windows, the path cannot contain any space.
Set the IntelliJ IDEA text file coding format to prevent garbled characters.
1. On the IntelliJ IDEA menu bar, choose File>Settings.
  The Settings window is displayed.
2. In the navigating tree on the left, choose Editor>File Encodings. In theProject Encoding area and Global Encodingarea, set the value toUTF-8, and clickApplyandOK, as shown inFigure 1.
Figure 1 Setting the IntelliJ IDEA coding format
Set the JDK of the project.
1. On the IntelliJ IDEA menu bar, choose File>Settings.... The Settings window is displayed.
2. Choose Build, Execution, Deployment > Compiler > Java Compiler, select 8 from the Project bytecode version drop-down list box. Change the value of Target bytecode version to 8 for hive-jdbc-example.
3. ClickApplyandOK.
4. On the IntelliJ IDEA menu bar, choose File>Project Structure.... The Project Structure window is displayed.
5. Select SDKs, click the plus sign (+), and select JDK.
6. On the Select Home Directory for JDK page that is displayed, select the JDK directory and click OK.
7. After selecting the JDK, click Apply.
8. Select Project, select the JDK added in SDKs from the Project SDK drop-down list box, and select 8 - Lambdas, type annotations etc. from the Project language level drop-down list box.
9. ClickApply.
10. Choose Modules. On the Source page, change the value of Language level to 8 - Lambdas, type annotations etc.
  
  On the Dependencies page, change the value of Module SDK to the JDK added in SDKs.
11. ClickApplyandOK.
Configure Maven.
1. Add the configuration information such as the address of the open-source image repository to the setting.xml configuration file of the local Maven by referring to Configuring Huawei Open-Source Mirrors.
2. On the IntelliJ IDEA page, select File > Settings > Build, Execution, Deployment > Build Tools > Maven, select Override next to User settings file, and change the value of User settings file to the directory where the settings.xml file is stored. Ensure that the directory is <Local Maven installation directory>\conf\settings.xml.
  Figure 2 Directory for storing the settings.xml file
3. Click the drop-down list next to Maven home directory and select the Maven installation directory.
4. Click Apply, and then click OK.

Parent topic: Configuring and Importing Sample Projects

Previous topic: Configuring and Importing Sample Projects

Next topic: Configuring the Python Sample Project

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

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.

Chatbot