Help Center/ Data Lake Insight/ Developer Guide/ SQL Jobs/ Submitting a Spark SQL Job Using JDBC/ Downloading the JDBC Driver Package
Updated on 2024-07-04 GMT+08:00
View PDF
Share

Downloading the JDBC Driver Package

Scenario

To connect to DLI, JDBC is utilized. You can obtain the JDBC installation package from Maven or download the JDBC driver file from the DLI management console.

(Recommended) Method 1: Obtaining the JDBC Installation Package from Maven

Click DLI JDBC Driver to obtain the latest JDBC installation package.

Once JDBC 2.X has undergone function reconstruction, query results can only be accessed from DLI job buckets. To utilize this feature, certain conditions must be met:

  • On the DLI management console, choose Global Configuration > Project to configure the job bucket.
  • Submit a service ticket to request the whitelisting of the feature that allows writing query results to buckets.
If Maven is used, include the following Maven configuration items that huaweicloud-dli-jdbc depends on: 
1
2
3
4
5
 
 <dependency>
    <groupId>com.huawei.dli</groupId>
    <artifactId>huaweicloud-dli-jdbc</artifactId>
    <version>x.x.x</version>
 </dependency>
  • For details about how to configure the Huawei Maven image source, visit Huawei Open-source Image Site, select Huawei SDK, and click HuaweiCloud SDK.

Method 2: Downloading the JDBC Driver File from the DLI Management Console

  1. Log in to the DLI management console.
  2. Click SDK Download in the Common Links area on the right of the Overview page.
  3. On the DLI SDK DOWNLOAD page, select a driver and download it.

    • JDBC driver package

      For example, click huaweicloud-dli-jdbc-1.2.5 to download the JDBC driver package of version 1.2.5.

      The JDBC driver package is named huaweicloud-dli-jdbc-<version>.zip. It can be used in all versions of all platforms (such as Linux and Windows) and depends on JDK 1.7 or later versions.

      If Maven is used, include the following Maven configuration items that huaweicloud-dli-jdbc depends on: 
      1
2
3
4
5
      		 
       <dependency>
    <groupId>com.huawei.dli</groupId>
    <artifactId>huaweicloud-dli-jdbc</artifactId>
    <version>x.x.x</version>
 </dependency>
      • For details about how to configure the Huawei Maven image source, visit Huawei Open-source Image Site, select Huawei SDK, and click HuaweiCloud SDK.