[jira] [Created] (IMPALA-14153) postgresql driver version conflicts when build on Apache Hive 3

["Quanlong Huang (Jira)" <ji...@apache.org>]

Quanlong Huang created IMPALA-14153:
---------------------------------------

             Summary: postgresql driver version conflicts when build on Apache Hive 3
                 Key: IMPALA-14153
                 URL: https://issues.apache.org/jira/browse/IMPALA-14153
             Project: IMPALA
          Issue Type: Bug
          Components: Infrastructure
            Reporter: Quanlong Huang


In a local build on Apache Hive 3.1.3, I see HMS logs have the following error:
{noformat}
2025-06-15T20:14:40,926 ERROR [main] pool.HikariPool: HikariPool-1 - Exception during pool initialization.
org.postgresql.util.PSQLException: The authentication type 10 is not supported. Check that you have configured the pg_hba.conf file to include the client's IP address or subnet, and that it is using an authentication scheme supported by the driver.
        at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:624) ~[postgresql-9.4.1208.jre7.jar:9.4.1208.jre7]
        at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:208) ~[postgresql-9.4.1208.jre7.jar:9.4.1208.jre7]
        at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66) ~[postgresql-9.4.1208.jre7.jar:9.4.1208.jre7]
        at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:215) ~[postgresql-9.4.1208.jre7.jar:9.4.1208.jre7]
        at org.postgresql.Driver.makeConnection(Driver.java:406) ~[postgresql-9.4.1208.jre7.jar:9.4.1208.jre7]
        at org.postgresql.Driver.connect(Driver.java:274) ~[postgresql-9.4.1208.jre7.jar:9.4.1208.jre7]
        at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:95) ~[HikariCP-2.6.1.jar:?]{noformat}
There are two driver jars in the classpath:
{code}
/root/impala/toolchain/apache_components/apache-hive-3.1.3-bin/lib/postgresql-9.4.1208.jre7.jar
/root/impala/fe/target/dependency/postgresql-42.5.6.jar{code}
If the old version is picked, the above error occurs. Manually removed the old version resolves the issue. We need to automate this when building on Apache Hive 3 (i.e. USE_APACHE_COMPONENTS=true).



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org