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 "ASF subversion and git services (Jira)" <ji...@apache.org> on 2024/09/03 14:38:00 UTC

[jira] [Commented] (IMPALA-13343) TestTPCHJoinQueries.test_outer_joins create duplicate table

    [ https://issues.apache.org/jira/browse/IMPALA-13343?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17878901#comment-17878901 ] 

ASF subversion and git services commented on IMPALA-13343:
----------------------------------------------------------

Commit 60a7d6cb467f21b2c9659c3a6c504b1c49656a7b in impala's branch refs/heads/master from Riza Suminto
[ https://gitbox.apache.org/repos/asf?p=impala.git;h=60a7d6cb4 ]

IMPALA-13343: Use unique_database in test_outer_joins

TestTPCHJoinQueries.test_outer_joins run tpch-outer-joins.test, which
drop/create table default.t1 and default.t2. If two test_outer_joins
with different test vector run concurrently, one of them can hit error
like "AnalysisException: Table already exists: default.t1".

This patch change the test to use unique_database fixture and create
both t1 and t2 table in that unique database.

Testing:
- Run and pass TestTPCHJoinQueries.test_outer_joins using
  bin/run-all-tests.sh and NUM_TEST_ITERATIONS=10.
- Confirm that both t1 and t2 table are made within the unique database.

Change-Id: I9a260663c0bf8d2740883836194933edf2b8cff5
Reviewed-on: http://gerrit.cloudera.org:8080/21737
Reviewed-by: Michael Smith <mi...@cloudera.com>
Tested-by: Impala Public Jenkins <im...@cloudera.com>


> TestTPCHJoinQueries.test_outer_joins create duplicate table
> -----------------------------------------------------------
>
>                 Key: IMPALA-13343
>                 URL: https://issues.apache.org/jira/browse/IMPALA-13343
>             Project: IMPALA
>          Issue Type: Bug
>          Components: Test
>    Affects Versions: Impala 4.5.0
>            Reporter: Riza Suminto
>            Assignee: Riza Suminto
>            Priority: Minor
>             Fix For: Impala 4.5.0
>
>
> TestTPCHJoinQueries.test_outer_joins run tpch-outer-joins.test, which have following drop/create table query.
> {code:java}
> drop table if exists default.t1;
> drop table if exists default.t2;
> create table default.t1(`insert` bigint);
> create table default.t2(`select` bigint); {code}
> If two test_outer_joins with different test vector run concurrently, one of them can hit AnalysisException as follows:
> {code:java}
> query_test/test_join_queries.py:180: in test_outer_joins
>     self.run_test_case('tpch-outer-joins', vector)
> common/impala_test_suite.py:807: in run_test_case
>     user=test_section.get('USER', '').strip() or None)
> common/impala_test_suite.py:726: in __exec_in_impala
>     result = self.__execute_query(target_impalad_client, query, user=user)
> common/impala_test_suite.py:1097: in __execute_query
>     return impalad_client.execute(query, user=user)
> common/impala_connection.py:220: in execute
>     fetch_profile_after_close=fetch_profile_after_close)
> beeswax/impala_beeswax.py:190: in execute
>     handle = self.__execute_query(query_string.strip(), user=user)
> beeswax/impala_beeswax.py:381: in __execute_query
>     handle = self.execute_query_async(query_string, user=user)
> beeswax/impala_beeswax.py:375: in execute_query_async
>     handle = self.__do_rpc(lambda: self.imp_service.query(query,))
> beeswax/impala_beeswax.py:553: in __do_rpc
>     raise ImpalaBeeswaxException(self.__build_error_message(b), b)
> E   ImpalaBeeswaxException: Query 65446c2aeefc64b1:f305c36400000000 failed:
> E   AnalysisException: Table already exists: default.t1 {code}
> Both t1 and t2 table in test case should be created using unique database.



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