Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-5741 External JDBC Read Support
  3. IMPALA-12470

Support different schemes for jdbc driver url when creating external jdbc table

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Critical
    • Resolution: Fixed
    • None
    • Impala 4.4.0
    • Frontend
    • None
    • ghx-label-6

    Description

      jdbc driver url is specified as table property 'driver.url' when creating a external jdbc table, like the sample below:

      CREATE TABLE test_postgres (
       id INT,
       string_col STRING)
      PRODUCED BY DATA SOURCE JdbcDataSource(
      '{"database.type":"POSTGRES",
      "jdbc.url":"jdbc:postgresql://localhost:5432/functional",
      "jdbc.driver":"org.postgresql.Driver",
      "driver.url":"hdfs://localhost:20500/test-warehouse/data-sources/jdbc-driver/postgresql-jdbc.jar",
      "dbcp.username":"hiveuser",
      "dbcp.password":"password",
      "table":"alltypes"}');
      

      In the initial patch, we only support to download the driver jar files from hdfs. We need to support different storage type, like 'file://', 's3a://', etc.

      Attachments

        Issue Links

          Activity

            People

              gaurav1086 gaurav singh
              wzhou Wenzhe Zhou
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 40m
                  40m