01:27:15 FAIL query_test/test_kudu.py::TestKuduOperations::()::test_kudu_upsert[exec_option: {'batch_size': 0, 'num_nodes': 0, 'disable_codegen_rows_threshold': 0, 'disable_codegen': False, 'abort_on_error': 1, 'exec_single_node_rows_threshold': 0} | table_format: text/none] 01:27:15 =================================== FAILURES =================================== 01:27:15 TestKuduOperations.test_kudu_upsert[exec_option: {'batch_size': 0, 'num_nodes': 0, 'disable_codegen_rows_threshold': 0, 'disable_codegen': False, 'abort_on_error': 1, 'exec_single_node_rows_threshold': 0} | table_format: text/none] 01:27:15 [gw9] linux2 -- Python 2.7.12 /home/ubuntu/Impala/bin/../infra/python/env/bin/python 01:27:15 query_test/test_kudu.py:90: in test_kudu_upsert 01:27:15 self.run_test_case('QueryTest/kudu_upsert', vector, use_db=unique_database) 01:27:15 common/impala_test_suite.py:454: in run_test_case 01:27:15 pytest.config.option.update_results, result_section='DML_RESULTS') 01:27:15 common/test_result_verifier.py:404: in verify_raw_results 01:27:15 VERIFIER_MAP[verifier](expected, actual) 01:27:15 common/test_result_verifier.py:231: in verify_query_result_is_equal 01:27:15 assert expected_results == actual_results 01:27:15 E assert Comparing QueryTestResults (expected vs actual): 01:27:15 E 1,'a',NULL,1,'a',NULL,-1,-2,3,0 == 1,'a',NULL,1,'a',NULL,-1,-2,3,0 01:27:15 E 10,'NULL',NULL,NULL,'NULL',NULL,NULL,NULL,NULL,NULL == 10,'NULL',NULL,NULL,'NULL',NULL,NULL,NULL,NULL,NULL 01:27:15 E 2,'t',Infinity,0,'you',false,NULL,-32768,0,0 == 2,'t',Infinity,0,'you',false,NULL,-32768,0,0 01:27:15 E 2147483647,'',-Infinity,9223372036854775807,'',true,-128,32767,NaN,-999999999 == 2147483647,'',-Infinity,9223372036854775807,'',true,-128,32767,NaN,-999999999 01:27:15 E 3,'todd',1,43,'c',true,3,3,3,3 == 3,'todd',1,43,'c',true,3,3,3,3 01:27:15 E 4,'f',5,6,'four',true,7,8,7.5,9 == 4,'f',5,6,'four',true,7,8,7.5,9 01:27:15 E 40,'e',0,43,'he',false,35,36,1.2,37 != 40,'he',0,43,'e',false,35,36,1.2,37 01:27:15 E 5,'five',0,10,'six',NULL,NULL,NULL,0.5,NULL == 5,'five',0,10,'six',NULL,NULL,NULL,0.5,NULL 01:27:15 E 6,'b',-6,40,'',NULL,0,0,10,11 == 6,'b',-6,40,'',NULL,0,0,10,11 01:27:15 E 7,'seven',0,-9223372036854775808,'NULL',true,7,1,2,3 == 7,'seven',0,-9223372036854775808,'NULL',true,7,1,2,3 01:27:15 E 8,'NULL',NULL,2,'hello',false,NULL,NULL,NULL,NULL == 8,'NULL',NULL,2,'hello',false,NULL,NULL,NULL,NULL 01:27:15 E 9,'nine',NULL,9,'NULL',true,NULL,NULL,NULL,NULL == 9,'nine',NULL,9,'NULL',true,NULL,NULL,NULL,NULL 01:27:15 ---------------------------- Captured stderr setup ----------------------------- 01:27:15 SET sync_ddl=False; 01:27:15 -- executing against localhost:21000 01:27:15 DROP DATABASE IF EXISTS `test_kudu_upsert_4c26ceb8` CASCADE; 01:27:15 01:27:15 SET sync_ddl=False; 01:27:15 -- executing against localhost:21000 01:27:15 CREATE DATABASE `test_kudu_upsert_4c26ceb8`; 01:27:15 01:27:15 MainThread: Created database "test_kudu_upsert_4c26ceb8" for test ID "query_test/test_kudu.py::TestKuduOperations::()::test_kudu_upsert[exec_option: {'batch_size': 0, 'num_nodes': 0, 'disable_codegen_rows_threshold': 0, 'disable_codegen': False, 'abort_on_error': 1, 'exec_single_node_rows_threshold': 0} | table_format: text/none]" 01:27:15 ----------------------------- Captured stderr call ----------------------------- 01:27:15 -- executing against localhost:21000 01:27:15 use test_kudu_upsert_4c26ceb8; 01:27:15 01:27:15 SET batch_size=0; 01:27:15 SET num_nodes=0; 01:27:15 SET disable_codegen_rows_threshold=0; 01:27:15 SET disable_codegen=False; 01:27:15 SET abort_on_error=1; 01:27:15 SET exec_single_node_rows_threshold=0; 01:27:15 -- executing against localhost:21000 01:27:15 create table tdata 01:27:15 (id int primary key, name string null, valf float null, vali bigint null, 01:27:15 valv string null, valb boolean null, valt tinyint null, vals smallint null, 01:27:15 vald double null, valdec decimal(9, 0) null) 01:27:15 PARTITION BY RANGE (PARTITION VALUES < 10, PARTITION 10 <= VALUES < 30, 01:27:15 PARTITION 30 <= VALUES) STORED AS KUDU; 01:27:15 01:27:15 -- executing against localhost:21000 01:27:15 insert into table tdata values 01:27:15 (40,'he',0,43,'e',false,35,36,1.2,37), 01:27:15 (1,'unknown',1,43,'aaaaaaaaaaaaaaaaaaaa',false,-1,-2,0,-3), 01:27:15 (2,'david',1,43,'b',false,0,0,0,0), 01:27:15 (3,'todd',1,43,'c',true,3,3,3,3); 01:27:15 01:27:15 -- executing against localhost:21000 01:27:15 upsert into table tdata values (4, 'a', 0, 1, 'b', false, 1, 2, 1.5, 4); 01:27:15 01:27:15 -- executing against localhost:21000 01:27:15 select * from tdata limit 1000; 01:27:15 01:27:15 -- executing against localhost:21000 01:27:15 upsert into table tdata values (4, 'b', -1, 1, 'a', true, 2, 3, 2.5, 5); 01:27:15 01:27:15 -- executing against localhost:21000 01:27:15 select * from tdata limit 1000; 01:27:15 01:27:15 -- executing against localhost:21000 01:27:15 upsert into table tdata values (10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); 01:27:15 01:27:15 -- executing against localhost:21000 01:27:15 select * from tdata limit 1000; 01:27:15 01:27:15 -- executing against localhost:21000 01:27:15 upsert into table tdata values (4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); 01:27:15 01:27:15 -- executing against localhost:21000 01:27:15 select * from tdata limit 1000; 01:27:15 01:27:15 -- executing against localhost:21000 01:27:15 upsert into table tdata values (4, 'four', 5, 6, 'f', true, 7, 8, 7.5, 9); 01:27:15 01:27:15 -- executing against localhost:21000 01:27:15 select * from tdata limit 1000; 01:27:15 01:27:15 -- executing against localhost:21000 01:27:15 upsert into table tdata values 01:27:15 (max_int(), '', cast('nan' as float), min_bigint(), '', true, max_tinyint(), 01:27:15 min_smallint(), cast('inf' as double), cast(999999999 as decimal(9, 0))); 01:27:15 01:27:15 -- executing against localhost:21000 01:27:15 select * from tdata limit 1000; 01:27:15 01:27:15 -- executing against localhost:21000 01:27:15 upsert into table tdata values 01:27:15 (max_int(), '', cast('-inf' as float), max_bigint(), '', true, min_tinyint(), 01:27:15 max_smallint(), cast('nan' as double), cast(-999999999 as decimal(9, 0))); 01:27:15 01:27:15 -- executing against localhost:21000 01:27:15 select * from tdata limit 1000; 01:27:15 01:27:15 -- executing against localhost:21000 01:27:15 upsert into table tdata (id, name, vali, valb, vald) values (5, 'five', -5, NULL, 0.5); 01:27:15 01:27:15 -- executing against localhost:21000 01:27:15 select * from tdata limit 1000; 01:27:15 01:27:15 -- executing against localhost:21000 01:27:15 upsert into table tdata (id, name, valf, valv, valb) values (5, NULL, 0, 'six', false); 01:27:15 01:27:15 -- executing against localhost:21000 01:27:15 select * from tdata limit 1000; 01:27:15 01:27:15 -- executing against localhost:21000 01:27:15 upsert into table tdata values 01:27:15 (1, 'one', NULL, 44, 'a', true, -1, -2, 0, 0), 01:27:15 (6, '', -6, 40, 'b', NULL, 0, 0, 10, 11), 01:27:15 (7, 'seven', 0, min_bigint(), NULL, true, 7, 1, 2, 3), 01:27:15 (2, 'you', cast('inf' as float), 0, 't', false, NULL, min_smallint(), 0, 0); 01:27:15 01:27:15 -- executing against localhost:21000 01:27:15 select * from tdata limit 1000; 01:27:15 01:27:15 -- executing against localhost:21000 01:27:15 upsert into table tdata (id, valb, name, vali) values 01:27:15 (1, true, NULL, 1), 01:27:15 (8, false, 'hello', 2), 01:27:15 (5, NULL, 'five', 10), 01:27:15 (9, true, 'nine', 9); 01:27:15 01:27:15 -- executing against localhost:21000 01:27:15 select * from tdata limit 1000; 01:27:15 01:27:15 -- executing against localhost:21000 01:27:15 upsert into table tdata 01:27:15 select id, 'a', valf, vali, valv, NULL, valt, vals, 3, valdec from tdata where id = 1; 01:27:15 01:27:15 -- executing against localhost:21000 01:27:15 select * from tdata limit 1000; 01:27:15 01:27:15 -- executing against localhost:21000 01:27:15 upsert into table tdata 01:27:15 select id, valv, valf, vali, name, valb, valt, vals, vald, valdec from tdata where id % 2 = 0; 01:27:15 01:27:15 -- executing against localhost:21000 01:27:15 select * from tdata limit 1000; 01:27:15 01:27:15 MainThread: Comparing QueryTestResults (expected vs actual): 01:27:15 1,'a',NULL,1,'a',NULL,-1,-2,3,0 == 1,'a',NULL,1,'a',NULL,-1,-2,3,0 01:27:15 10,'NULL',NULL,NULL,'NULL',NULL,NULL,NULL,NULL,NULL == 10,'NULL',NULL,NULL,'NULL',NULL,NULL,NULL,NULL,NULL 01:27:15 2,'t',Infinity,0,'you',false,NULL,-32768,0,0 == 2,'t',Infinity,0,'you',false,NULL,-32768,0,0 01:27:15 2147483647,'',-Infinity,9223372036854775807,'',true,-128,32767,NaN,-999999999 == 2147483647,'',-Infinity,9223372036854775807,'',true,-128,32767,NaN,-999999999 01:27:15 3,'todd',1,43,'c',true,3,3,3,3 == 3,'todd',1,43,'c',true,3,3,3,3 01:27:15 4,'f',5,6,'four',true,7,8,7.5,9 == 4,'f',5,6,'four',true,7,8,7.5,9 01:27:15 40,'e',0,43,'he',false,35,36,1.2,37 != 40,'he',0,43,'e',false,35,36,1.2,37 01:27:15 5,'five',0,10,'six',NULL,NULL,NULL,0.5,NULL == 5,'five',0,10,'six',NULL,NULL,NULL,0.5,NULL 01:27:15 6,'b',-6,40,'',NULL,0,0,10,11 == 6,'b',-6,40,'',NULL,0,0,10,11 01:27:15 7,'seven',0,-9223372036854775808,'NULL',true,7,1,2,3 == 7,'seven',0,-9223372036854775808,'NULL',true,7,1,2,3 01:27:15 8,'NULL',NULL,2,'hello',false,NULL,NULL,NULL,NULL == 8,'NULL',NULL,2,'hello',false,NULL,NULL,NULL,NULL 01:27:15 9,'nine',NULL,9,'NULL',true,NULL,NULL,NULL,NULL == 9,'nine',NULL,9,'NULL',true,NULL,NULL,NULL,NULL 01:27:15 = 1 failed, 1697 passed, 51 skipped, 36 xfailed, 1 xpassed in 2718.02 seconds ==