[IMPALA-4782] test_compute_stats fails with "Table mixed_types already exists"

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: Impala 2.9.0
• Component/s: Catalog
• Labels: broken-build
• Target Version: Product Backlog
• Assignee: Unassigned
• Reporter: Thomas Tauber-Marshall
• Created: 18/Jan/17 20:26
• Updated: 27/Apr/17 21:26
• Resolved: 27/Apr/17 21:26

Description

08:20:30  TestComputeStats.test_compute_stats[exec_option: {'disable_codegen': False, 'abort_on_error': 1, 'exec_single_node_rows_threshold': 0, 'batch_size': 0, 'num_nodes': 0} | table_format: text/none] 
08:20:30 [gw1] linux2 -- Python 2.6.6 /data/jenkins/workspace/impala-umbrella-build-and-test/repos/Impala/bin/../infra/python/env/bin/python
08:20:30 metadata/test_compute_stats.py:47: in test_compute_stats
08:20:30     self.run_test_case('QueryTest/compute-stats-decimal', vector, unique_database)
08:20:30 common/impala_test_suite.py:324: in run_test_case
08:20:30     result = self.__execute_query(target_impalad_client, query, user=user)
08:20:30 common/impala_test_suite.py:532: in __execute_query
08:20:30     return impalad_client.execute(query, user=user)
08:20:30 common/impala_connection.py:160: in execute
08:20:30     return self.__beeswax_client.execute(sql_stmt, user=user)
08:20:30 beeswax/impala_beeswax.py:173: in execute
08:20:30     handle = self.__execute_query(query_string.strip(), user=user)
08:20:30 beeswax/impala_beeswax.py:337: in __execute_query
08:20:30     handle = self.execute_query_async(query_string, user=user)
08:20:30 beeswax/impala_beeswax.py:333: in execute_query_async
08:20:30     return self.__do_rpc(lambda: self.imp_service.query(query,))
08:20:30 beeswax/impala_beeswax.py:458: in __do_rpc
08:20:30     raise ImpalaBeeswaxException(self.__build_error_message(b), b)
08:20:30 E   ImpalaBeeswaxException: ImpalaBeeswaxException:
08:20:30 E    INNER EXCEPTION: <class 'beeswaxd.ttypes.BeeswaxException'>
08:20:30 E    MESSAGE: 
08:20:30 E   ImpalaRuntimeException: Error making 'createTable' RPC to Hive Metastore: 
08:20:30 E   CAUSED BY: AlreadyExistsException: Table mixed_types already exists
08:20:30 ---------------------------- Captured stderr setup -----------------------------
08:20:30 -- connecting to: localhost:21000
08:20:30 SET sync_ddl=False;
08:20:30 -- executing against localhost:21000
08:20:30 DROP DATABASE IF EXISTS `test_compute_stats_650013a0` CASCADE;
08:20:30 
08:20:30 SET sync_ddl=False;
08:20:30 -- executing against localhost:21000
08:20:30 CREATE DATABASE `test_compute_stats_650013a0`;
08:20:30 
08:20:30 MainThread: Created database "test_compute_stats_650013a0" for test ID "metadata/test_compute_stats.py::TestComputeStats::()::test_compute_stats[exec_option: {'disable_codegen': False, 'abort_on_error': 1, 'exec_single_node_rows_threshold': 0, 'batch_size': 0, 'num_nodes': 0} | table_format: text/none]"

Possibly related to: https://issues.cloudera.org/browse/IMPALA-4583