You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Joe McDonnell (Jira)" <ji...@apache.org> on 2023/10/13 00:27:00 UTC

[jira] [Created] (IMPALA-12496) query_test.test_ext_data_sources.TestExtDataSources fails on S3/Ozone

Joe McDonnell created IMPALA-12496:
--------------------------------------

             Summary: query_test.test_ext_data_sources.TestExtDataSources fails on S3/Ozone
                 Key: IMPALA-12496
                 URL: https://issues.apache.org/jira/browse/IMPALA-12496
             Project: IMPALA
          Issue Type: Bug
          Components: Infrastructure
    Affects Versions: Impala 4.4.0
            Reporter: Joe McDonnell


The query_test.test_ext_data_sources.TestExtDataSources hits failures on S3 and Ozone. The failure in test_verify_jdbc_table_properties is due to the different paths:
{noformat}
query_test/test_ext_data_sources.py:68: in test_verify_jdbc_table_properties
    assert properties['__IMPALA_DATA_SOURCE_LOCATION'] == \
E   assert 'ofs://localh...ta-source.jar' == 'hdfs://localh...ta-source.jar'
E     - ofs://localhost:9862/impala/test-warehouse/data-sources/jdbc-data-source.jar
E     ? ^               --- ^^^^^^^
E     + hdfs://localhost:20500/test-warehouse/data-sources/jdbc-data-source.jar
E     ? ^^ {noformat}
The failure in test_jdbc_data_source is different for Ozone vs S3:
{noformat}
S3:
beeswax/impala_beeswax.py:390: in wait_for_finished
    raise ImpalaBeeswaxException("Query aborted:" + error_log, None)
E   ImpalaBeeswaxException: ImpalaBeeswaxException:
E    Query aborted:Caught exception while trying to execute query:Cannot create PoolableConnectionFactory (FATAL: database "functional" does not exist)

Ozone:
beeswax/impala_beeswax.py:390: in wait_for_finished
    raise ImpalaBeeswaxException("Query aborted:" + error_log, None)
E   ImpalaBeeswaxException: ImpalaBeeswaxException:
E    Query aborted:Caught exception while trying to execute query:org.apache.impala.extdatasource.jdbc.exception.JdbcDatabaseAccessException: Unable to cache jdbc driver jar at location '/test-warehouse/data-sources/jdbc-drivers/postgresql-jdbc.jar'. Check that the file exists and is readable. Message: [Failed to get file info /test-warehouse/data-sources/jdbc-drivers/postgresql-jdbc.jar
E   Error(2): No such file or directory]{noformat}
Depending on how related these are, the different failures may need to be split out.

Introduce in IMPALA-5741 (https://github.com/apache/impala/commit/c2bd30a1b3b49ccc7770ec5ab4adeb0b75f40240)



--
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