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: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to