Details
-
Bug
-
Status: Resolved
-
Blocker
-
Resolution: Fixed
-
Impala 2.8.0
Description
The exhaustive builds on RHEL7 hits the following error.
Stacktrace query_test/test_kudu.py:62: in test_kudu_alter_table self.run_test_case('QueryTest/kudu_alter', vector, use_db=unique_database) common/impala_test_suite.py:321: in run_test_case result = self.__execute_query(target_impalad_client, query, user=user) common/impala_test_suite.py:525: in __execute_query return impalad_client.execute(query, user=user) common/impala_connection.py:160: in execute return self.__beeswax_client.execute(sql_stmt, user=user) beeswax/impala_beeswax.py:173: in execute handle = self.__execute_query(query_string.strip(), user=user) beeswax/impala_beeswax.py:337: in __execute_query handle = self.execute_query_async(query_string, user=user) beeswax/impala_beeswax.py:333: in execute_query_async return self.__do_rpc(lambda: self.imp_service.query(query,)) beeswax/impala_beeswax.py:458: in __do_rpc raise ImpalaBeeswaxException(self.__build_error_message(b), b) E ImpalaBeeswaxException: ImpalaBeeswaxException: E INNER EXCEPTION: <class 'beeswaxd.ttypes.BeeswaxException'> E MESSAGE: AnalysisException: Target table 'test_kudu_alter_table_8df0adc5.tbl_to_alter' has fewer columns (3) than the SELECT / VALUES clause returns (5) Standard Error SET sync_ddl=False; -- executing against localhost:21000 DROP DATABASE IF EXISTS `test_kudu_alter_table_8df0adc5` CASCADE; SET sync_ddl=False; -- executing against localhost:21000 CREATE DATABASE `test_kudu_alter_table_8df0adc5`; MainThread: Created database "test_kudu_alter_table_8df0adc5" for test ID "query_test/test_kudu.py::TestKuduOperations::()::test_kudu_alter_table[exec_option: {'disable_codegen': True, 'abort_on_error': 1, 'exec_single_node_rows_threshold': 0, 'batch_size': 0, 'num_nodes': 0} | table_format: text/none]" -- executing against localhost:21000 use test_kudu_alter_table_8df0adc5; SET disable_codegen=True; SET abort_on_error=1; SET exec_single_node_rows_threshold=0; SET batch_size=0; SET num_nodes=0; -- executing against localhost:21000 create table simple (id int primary key, name string, valf float, vali bigint) distribute by hash (id) into 3 buckets stored as kudu; -- executing against localhost:21000 alter table simple set tblproperties ( 'kudu.master_addresses' = 'localhost' ); -- executing against localhost:21000 describe formatted simple; -- executing against localhost:21000 alter table simple set tblproperties ('kudu.master_addresses' = '127.0.0.1'); -- executing against localhost:21000 alter table simple set tblproperties ('kudu.master_addresses' = 'invalid_host'); -- executing against localhost:21000 alter table simple rename to simple_new; -- executing against localhost:21000 select count(*) from simple_new; -- executing against localhost:21000 create table tbl_to_alter (id int primary key, name string null, vali bigint not null) distribute by range (id) (partition 1 < values <= 10) stored as kudu tblproperties('kudu.table_name'='tbl_to_alter'); -- executing against localhost:21000 alter table tbl_to_alter add range partition 10 < values <= 20; -- executing against localhost:21000 insert into tbl_to_alter values (15, 'name', 100); -- executing against localhost:21000 select * from tbl_to_alter limit 1000; -- executing against localhost:21000 alter table tbl_to_alter add range partition value = 100; -- executing against localhost:21000 insert into tbl_to_alter values (100, 'name1', 1000); -- executing against localhost:21000 select * from tbl_to_alter limit 1000; -- executing against localhost:21000 alter table tbl_to_alter add range partition 1000 < values; -- executing against localhost:21000 alter table tbl_to_alter add range partition 10 < values <= 30; -- executing against localhost:21000 alter table tbl_to_alter add if not exists range partition 10 < values <= 30; -- executing against localhost:21000 alter table tbl_to_alter drop range partition value = 100; -- executing against localhost:21000 select * from tbl_to_alter; -- executing against localhost:21000 alter table tbl_to_alter drop range partition 10 < values <= 20; -- executing against localhost:21000 alter table tbl_to_alter drop range partition 1 < values <= 10; -- executing against localhost:21000 alter table tbl_to_alter drop range partition 1000 < values; -- executing against localhost:21000 select count(*), count(id) from tbl_to_alter where id = 1 and cast(sin(id) as boolean) = true; -- executing against localhost:21000 insert into tbl_to_alter values (1, 'name', 100); -- executing against localhost:21000 alter table tbl_to_alter add range partition 1 < values <= 20; -- executing against localhost:21000 alter table tbl_to_alter add columns (new_col1 int not null default 10, new_col2 bigint not null default 1000); -- executing against localhost:21000 insert into tbl_to_alter values (2, 'test', 100, 1, 100);