{noformat} 07:52:07 FAIL custom_cluster/test_permanent_udfs.py::TestUdfPersistence::()::test_java_udfs_from_impala 07:52:07 =================================== FAILURES =================================== 07:52:07 ________________ TestUdfPersistence.test_java_udfs_from_impala _________________ 07:52:07 custom_cluster/test_permanent_udfs.py:443: in test_java_udfs_from_impala 07:52:07 "SHOW FUNCTIONS IN %s like 'compatibility*'" % self.JAVA_FN_TEST_DB, 0) 07:52:07 custom_cluster/test_permanent_udfs.py:116: in verify_function_count 07:52:07 result = self.client.execute(query) 07:52:07 common/impala_connection.py:160: in execute 07:52:07 return self.__beeswax_client.execute(sql_stmt, user=user) 07:52:07 beeswax/impala_beeswax.py:173: in execute 07:52:07 handle = self.__execute_query(query_string.strip(), user=user) 07:52:07 beeswax/impala_beeswax.py:339: in __execute_query 07:52:07 handle = self.execute_query_async(query_string, user=user) 07:52:07 beeswax/impala_beeswax.py:335: in execute_query_async 07:52:07 return self.__do_rpc(lambda: self.imp_service.query(query,)) 07:52:07 beeswax/impala_beeswax.py:460: in __do_rpc 07:52:07 raise ImpalaBeeswaxException(self.__build_error_message(b), b) 07:52:07 E ImpalaBeeswaxException: ImpalaBeeswaxException: 07:52:07 E INNER EXCEPTION: 07:52:07 E MESSAGE: AnalysisException: Database does not exist: java_permanent_test 07:52:07 ---------------------------- Captured stdout setup ----------------------------- 07:52:07 Starting State Store logging to /data/jenkins/workspace/impala-cdh5-trunk-core-krpc/repos/Impala/logs/custom_cluster_tests/statestored.INFO 07:52:07 Starting Catalog Service logging to /data/jenkins/workspace/impala-cdh5-trunk-core-krpc/repos/Impala/logs/custom_cluster_tests/catalogd.INFO 07:52:07 Starting Impala Daemon logging to /data/jenkins/workspace/impala-cdh5-trunk-core-krpc/repos/Impala/logs/custom_cluster_tests/impalad.INFO 07:52:07 Starting Impala Daemon logging to /data/jenkins/workspace/impala-cdh5-trunk-core-krpc/repos/Impala/logs/custom_cluster_tests/impalad_node1.INFO 07:52:07 Starting Impala Daemon logging to /data/jenkins/workspace/impala-cdh5-trunk-core-krpc/repos/Impala/logs/custom_cluster_tests/impalad_node2.INFO 07:52:07 Impala Cluster Running with 3 nodes (3 coordinators, 3 executors). 07:52:07 ---------------------------- Captured stderr setup ----------------------------- 07:52:07 MainThread: Found 3 impalad/1 statestored/1 catalogd process(es) 07:52:07 MainThread: Getting num_known_live_backends from ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:25000 07:52:07 MainThread: Debug webpage not yet available. 07:52:07 MainThread: Debug webpage not yet available. 07:52:07 MainThread: Waiting for num_known_live_backends=3. Current value: 0 07:52:07 MainThread: Getting num_known_live_backends from ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:25000 07:52:07 MainThread: Waiting for num_known_live_backends=3. Current value: 1 07:52:07 MainThread: Getting num_known_live_backends from ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:25000 07:52:07 MainThread: Waiting for num_known_live_backends=3. Current value: 2 07:52:07 MainThread: Getting num_known_live_backends from ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:25000 07:52:07 MainThread: num_known_live_backends has reached value: 3 07:52:07 MainThread: Getting num_known_live_backends from ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:25001 07:52:07 MainThread: num_known_live_backends has reached value: 3 07:52:07 MainThread: Getting num_known_live_backends from ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:25002 07:52:07 MainThread: num_known_live_backends has reached value: 3 07:52:07 MainThread: Found 3 impalad/1 statestored/1 catalogd process(es) 07:52:07 MainThread: Getting metric: statestore.live-backends from ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:25010 07:52:07 MainThread: Metric 'statestore.live-backends' has reached desired value: 4 07:52:07 MainThread: Getting num_known_live_backends from ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:25000 07:52:07 MainThread: num_known_live_backends has reached value: 3 07:52:07 MainThread: Getting num_known_live_backends from ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:25001 07:52:07 MainThread: num_known_live_backends has reached value: 3 07:52:07 MainThread: Getting num_known_live_backends from ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:25002 07:52:07 MainThread: num_known_live_backends has reached value: 3 07:52:07 -- connecting to: localhost:21000 07:52:07 -- connecting to: ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 DROP DATABASE IF EXISTS udf_permanent_test CASCADE; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 DROP DATABASE IF EXISTS java_permanent_test CASCADE; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 DROP DATABASE IF EXISTS hive_impala_integration_db CASCADE; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 drop function if exists udf_permanent_test.identity(boolean); 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 drop function if exists udf_permanent_test.identity(tinyint); 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 drop function if exists udf_permanent_test.identity(smallint); 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 drop function if exists udf_permanent_test.identity(int); 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 drop function if exists udf_permanent_test.identity(bigint); 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 drop function if exists udf_permanent_test.identity(float); 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 drop function if exists udf_permanent_test.identity(double); 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 drop function if exists udf_permanent_test.identity(string); 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 drop function if exists udf_permanent_test.identity(timestamp); 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 drop function if exists udf_permanent_test.identity(decimal(9,0)); 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 drop function if exists udf_permanent_test.identity(decimal(18,1)); 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 drop function if exists udf_permanent_test.identity(decimal(38,10)); 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 drop function if exists udf_permanent_test.all_types_fn( 07:52:07 string, boolean, tinyint, smallint, int, bigint, float, double, decimal(2,0)); 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 drop function if exists udf_permanent_test.no_args(); 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 drop function if exists udf_permanent_test.var_and(boolean...); 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 drop function if exists udf_permanent_test.var_sum(int...); 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 drop function if exists udf_permanent_test.var_sum(double...); 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 drop function if exists udf_permanent_test.var_sum(string...); 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 drop function if exists udf_permanent_test.var_sum(decimal(4,2)...); 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 drop function if exists udf_permanent_test.var_sum_multiply(double, int...); 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 drop function if exists udf_permanent_test.constant_timestamp(); 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 drop function if exists udf_permanent_test.validate_arg_type(string); 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 drop function if exists udf_permanent_test.count_rows(); 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 drop function if exists udf_permanent_test.constant_arg(int); 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 drop function if exists udf_permanent_test.validate_open(int); 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 drop function if exists udf_permanent_test.mem_test(bigint); 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 drop function if exists udf_permanent_test.mem_test_leaks(bigint); 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 drop function if exists udf_permanent_test.unmangled_symbol(); 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 drop function if exists udf_permanent_test.four_args(int, int, int, int); 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 drop function if exists udf_permanent_test.five_args(int, int, int, int, int); 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 drop function if exists udf_permanent_test.six_args(int, int, int, int, int, int); 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 drop function if exists udf_permanent_test.seven_args(int, int, int, int, int, int, int); 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 drop function if exists udf_permanent_test.eight_args(int, int, int, int, int, int, int, int); 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 07:52:07 create database if not exists udf_permanent_test; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 07:52:07 create function udf_permanent_test.identity(boolean) returns boolean 07:52:07 location '/test-warehouse/libTestUdfs.so' symbol='Identity'; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 07:52:07 create function udf_permanent_test.identity(tinyint) returns tinyint 07:52:07 location '/test-warehouse/libTestUdfs.so' symbol='Identity'; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 07:52:07 create function udf_permanent_test.identity(smallint) returns smallint 07:52:07 location '/test-warehouse/libTestUdfs.so' symbol='Identity'; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 07:52:07 create function udf_permanent_test.identity(int) returns int 07:52:07 location '/test-warehouse/libTestUdfs.so' symbol='Identity'; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 07:52:07 create function udf_permanent_test.identity(bigint) returns bigint 07:52:07 location '/test-warehouse/libTestUdfs.so' symbol='Identity'; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 07:52:07 create function udf_permanent_test.identity(float) returns float 07:52:07 location '/test-warehouse/libTestUdfs.so' symbol='Identity'; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 07:52:07 create function udf_permanent_test.identity(double) returns double 07:52:07 location '/test-warehouse/libTestUdfs.so' symbol='Identity'; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 07:52:07 create function udf_permanent_test.identity(string) returns string 07:52:07 location '/test-warehouse/libTestUdfs.so' 07:52:07 symbol='_Z8IdentityPN10impala_udf15FunctionContextERKNS_9StringValE'; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 07:52:07 create function udf_permanent_test.identity(timestamp) returns timestamp 07:52:07 location '/test-warehouse/libTestUdfs.so' 07:52:07 symbol='_Z8IdentityPN10impala_udf15FunctionContextERKNS_12TimestampValE'; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 07:52:07 create function udf_permanent_test.identity(decimal(9,0)) returns decimal(9,0) 07:52:07 location '/test-warehouse/libTestUdfs.so' 07:52:07 symbol='_Z8IdentityPN10impala_udf15FunctionContextERKNS_10DecimalValE'; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 07:52:07 create function udf_permanent_test.identity(decimal(18,1)) returns decimal(18,1) 07:52:07 location '/test-warehouse/libTestUdfs.so' 07:52:07 symbol='_Z8IdentityPN10impala_udf15FunctionContextERKNS_10DecimalValE'; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 07:52:07 create function udf_permanent_test.identity(decimal(38,10)) returns decimal(38,10) 07:52:07 location '/test-warehouse/libTestUdfs.so' 07:52:07 symbol='_Z8IdentityPN10impala_udf15FunctionContextERKNS_10DecimalValE'; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 07:52:07 create function udf_permanent_test.all_types_fn( 07:52:07 string, boolean, tinyint, smallint, int, bigint, float, double, decimal(2,0)) 07:52:07 returns int 07:52:07 location '/test-warehouse/libTestUdfs.so' symbol='AllTypes'; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 07:52:07 create function udf_permanent_test.no_args() returns string 07:52:07 location '/test-warehouse/libTestUdfs.so' 07:52:07 symbol='_Z6NoArgsPN10impala_udf15FunctionContextE'; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 07:52:07 create function udf_permanent_test.var_and(boolean...) returns boolean 07:52:07 location '/test-warehouse/libTestUdfs.so' symbol='VarAnd'; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 07:52:07 create function udf_permanent_test.var_sum(int...) returns int 07:52:07 location '/test-warehouse/libTestUdfs.so' symbol='VarSum'; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 07:52:07 create function udf_permanent_test.var_sum(double...) returns double 07:52:07 location '/test-warehouse/libTestUdfs.so' symbol='VarSum'; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 07:52:07 create function udf_permanent_test.var_sum(string...) returns int 07:52:07 location '/test-warehouse/libTestUdfs.so' symbol='VarSum'; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 07:52:07 create function udf_permanent_test.var_sum(decimal(4,2)...) returns decimal(18,2) 07:52:07 location '/test-warehouse/libTestUdfs.so' symbol='VarSum'; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 07:52:07 create function udf_permanent_test.var_sum_multiply(double, int...) returns double 07:52:07 location '/test-warehouse/libTestUdfs.so' 07:52:07 symbol='_Z14VarSumMultiplyPN10impala_udf15FunctionContextERKNS_9DoubleValEiPKNS_6IntValE'; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 07:52:07 create function udf_permanent_test.constant_timestamp() returns timestamp 07:52:07 location '/test-warehouse/libTestUdfs.so' symbol='ConstantTimestamp'; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 07:52:07 create function udf_permanent_test.validate_arg_type(string) returns boolean 07:52:07 location '/test-warehouse/libTestUdfs.so' symbol='ValidateArgType'; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 07:52:07 create function udf_permanent_test.count_rows() returns bigint 07:52:07 location '/test-warehouse/libTestUdfs.so' symbol='Count' prepare_fn='CountPrepare' close_fn='CountClose'; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 07:52:07 create function udf_permanent_test.constant_arg(int) returns int 07:52:07 location '/test-warehouse/libTestUdfs.so' symbol='ConstantArg' prepare_fn='ConstantArgPrepare' close_fn='ConstantArgClose'; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 07:52:07 create function udf_permanent_test.validate_open(int) returns boolean 07:52:07 location '/test-warehouse/libTestUdfs.so' symbol='ValidateOpen' 07:52:07 prepare_fn='ValidateOpenPrepare' close_fn='ValidateOpenClose'; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 07:52:07 create function udf_permanent_test.mem_test(bigint) returns bigint 07:52:07 location '/test-warehouse/libTestUdfs.so' symbol='MemTest' 07:52:07 prepare_fn='MemTestPrepare' close_fn='MemTestClose'; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 07:52:07 create function udf_permanent_test.mem_test_leaks(bigint) returns bigint 07:52:07 location '/test-warehouse/libTestUdfs.so' symbol='MemTest' 07:52:07 prepare_fn='MemTestPrepare'; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 drop function if exists udf_permanent_test.test_count(int); 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 drop function if exists udf_permanent_test.hll(int); 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 drop function if exists udf_permanent_test.sum_small_decimal(decimal(9,2)); 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 create database if not exists udf_permanent_test; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 07:52:07 create aggregate function udf_permanent_test.test_count(int) returns bigint 07:52:07 location '/test-warehouse/libudasample.so' update_fn='CountUpdate'; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 07:52:07 create aggregate function udf_permanent_test.hll(int) returns string 07:52:07 location '/test-warehouse/libudasample.so' update_fn='HllUpdate'; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 07:52:07 create aggregate function udf_permanent_test.sum_small_decimal(decimal(9,2)) 07:52:07 returns decimal(9,2) location '/test-warehouse/libudasample.so' update_fn='SumSmallDecimalUpdate'; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 drop function if exists udf_permanent_test.trunc_sum(double); 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 07:52:07 create database if not exists udf_permanent_test; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 07:52:07 create aggregate function udf_permanent_test.trunc_sum(double) 07:52:07 returns bigint intermediate double location '/test-warehouse/libTestUdas.so' 07:52:07 update_fn='TruncSumUpdate' merge_fn='TruncSumMerge' 07:52:07 serialize_fn='TruncSumSerialize' finalize_fn='TruncSumFinalize'; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 CREATE DATABASE IF NOT EXISTS java_permanent_test; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 CREATE DATABASE IF NOT EXISTS hive_impala_integration_db; 07:52:07 07:52:07 ----------------------------- Captured stdout call ----------------------------- 07:52:07 Starting State Store logging to /data/jenkins/workspace/impala-cdh5-trunk-core-krpc/repos/Impala/logs/custom_cluster_tests/statestored.INFO 07:52:07 Starting Catalog Service logging to /data/jenkins/workspace/impala-cdh5-trunk-core-krpc/repos/Impala/logs/custom_cluster_tests/catalogd.INFO 07:52:07 Starting Impala Daemon logging to /data/jenkins/workspace/impala-cdh5-trunk-core-krpc/repos/Impala/logs/custom_cluster_tests/impalad.INFO 07:52:07 Starting Impala Daemon logging to /data/jenkins/workspace/impala-cdh5-trunk-core-krpc/repos/Impala/logs/custom_cluster_tests/impalad_node1.INFO 07:52:07 Starting Impala Daemon logging to /data/jenkins/workspace/impala-cdh5-trunk-core-krpc/repos/Impala/logs/custom_cluster_tests/impalad_node2.INFO 07:52:07 Impala Cluster Running with 3 nodes (3 coordinators, 3 executors). 07:52:07 Starting State Store logging to /data/jenkins/workspace/impala-cdh5-trunk-core-krpc/repos/Impala/logs/custom_cluster_tests/statestored.INFO 07:52:07 Starting Catalog Service logging to /data/jenkins/workspace/impala-cdh5-trunk-core-krpc/repos/Impala/logs/custom_cluster_tests/catalogd.INFO 07:52:07 Starting Impala Daemon logging to /data/jenkins/workspace/impala-cdh5-trunk-core-krpc/repos/Impala/logs/custom_cluster_tests/impalad.INFO 07:52:07 Starting Impala Daemon logging to /data/jenkins/workspace/impala-cdh5-trunk-core-krpc/repos/Impala/logs/custom_cluster_tests/impalad_node1.INFO 07:52:07 Starting Impala Daemon logging to /data/jenkins/workspace/impala-cdh5-trunk-core-krpc/repos/Impala/logs/custom_cluster_tests/impalad_node2.INFO 07:52:07 Impala Cluster Running with 3 nodes (3 coordinators, 3 executors). 07:52:07 ----------------------------- Captured stderr call ----------------------------- 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 SHOW FUNCTIONS in java_permanent_test; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 create function java_permanent_test.identity(boolean) returns boolean location 'hdfs://localhost:20500/test-warehouse/impala-hive-udfs.jar' symbol='org.apache.impala.TestUdf'; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 CREATE FUNCTION java_permanent_test.identity LOCATION 'hdfs://localhost:20500/test-warehouse/impala-hive-udfs.jar' symbol='org.apache.impala.TestUdf' 07:52:07 ; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 create function java_permanent_test.identity(int) returns int location '/test-warehouse/libTestUdfs.so' symbol='Identity'; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 CREATE FUNCTION java_permanent_test.identity LOCATION 'hdfs://localhost:20500/test-warehouse/impala-hive-udfs.jar' symbol='org.apache.impala.TestUdf' 07:52:07 ; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 CREATE FUNCTION java_permanent_test.identity_java LOCATION 'hdfs://localhost:20500/test-warehouse/impala-hive-udfs.jar' symbol='org.apache.impala.TestUdf' 07:52:07 ; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 create function java_permanent_test.identity_java(boolean) returns boolean location 'hdfs://localhost:20500/test-warehouse/impala-hive-udfs.jar' symbol='org.apache.impala.TestUdf'; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 create function java_permanent_test.identity_java(int) returns int location '/test-warehouse/libTestUdfs.so' symbol='Identity'; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 create function if not exists java_permanent_test.identity_java(int) returns int location '/test-warehouse/libTestUdfs.so' symbol='Identity'; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 SHOW FUNCTIONS in java_permanent_test; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 DROP FUNCTION IF EXISTS java_permanent_test.impala_java; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 07:52:07 CREATE FUNCTION java_permanent_test.compatibility LOCATION 'hdfs://localhost:20500/test-warehouse/impala-hive-udfs.jar' symbol='org.apache.impala.JavaUdfTest' 07:52:07 ; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 SHOW FUNCTIONS IN java_permanent_test like 'compatibility*'; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 SHOW FUNCTIONS in java_permanent_test; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 INVALIDATE METADATA; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 SHOW FUNCTIONS IN java_permanent_test; 07:52:07 07:52:07 MainThread: Found 3 impalad/1 statestored/1 catalogd process(es) 07:52:07 MainThread: Getting num_known_live_backends from ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:25000 07:52:07 MainThread: Debug webpage not yet available. 07:52:07 MainThread: Debug webpage not yet available. 07:52:07 MainThread: Waiting for num_known_live_backends=3. Current value: 0 07:52:07 MainThread: Getting num_known_live_backends from ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:25000 07:52:07 MainThread: Waiting for num_known_live_backends=3. Current value: 1 07:52:07 MainThread: Getting num_known_live_backends from ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:25000 07:52:07 MainThread: Waiting for num_known_live_backends=3. Current value: 2 07:52:07 MainThread: Getting num_known_live_backends from ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:25000 07:52:07 MainThread: num_known_live_backends has reached value: 3 07:52:07 MainThread: Getting num_known_live_backends from ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:25001 07:52:07 MainThread: num_known_live_backends has reached value: 3 07:52:07 MainThread: Getting num_known_live_backends from ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:25002 07:52:07 MainThread: num_known_live_backends has reached value: 3 07:52:07 MainThread: Found 3 impalad/1 statestored/1 catalogd process(es) 07:52:07 MainThread: Getting metric: statestore.live-backends from ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:25010 07:52:07 MainThread: Metric 'statestore.live-backends' has reached desired value: 4 07:52:07 MainThread: Getting num_known_live_backends from ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:25000 07:52:07 MainThread: num_known_live_backends has reached value: 3 07:52:07 MainThread: Getting num_known_live_backends from ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:25001 07:52:07 MainThread: num_known_live_backends has reached value: 3 07:52:07 MainThread: Getting num_known_live_backends from ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:25002 07:52:07 MainThread: num_known_live_backends has reached value: 3 07:52:07 -- connecting to: ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 SHOW FUNCTIONS IN java_permanent_test; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 DROP FUNCTION compatibility(smallint); 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 SHOW FUNCTIONS IN java_permanent_test like 'compatibility*'; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 DROP FUNCTION java_permanent_test.compatibility; 07:52:07 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 SHOW FUNCTIONS IN java_permanent_test like 'compatibility*'; 07:52:07 07:52:07 MainThread: Found 3 impalad/1 statestored/1 catalogd process(es) 07:52:07 MainThread: Getting num_known_live_backends from ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:25000 07:52:07 MainThread: Debug webpage not yet available. 07:52:07 MainThread: 'backends' 07:52:07 MainThread: Waiting for num_known_live_backends=3. Current value: None 07:52:07 MainThread: Getting num_known_live_backends from ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:25000 07:52:07 MainThread: Waiting for num_known_live_backends=3. Current value: 0 07:52:07 MainThread: Getting num_known_live_backends from ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:25000 07:52:07 MainThread: Waiting for num_known_live_backends=3. Current value: 0 07:52:07 MainThread: Getting num_known_live_backends from ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:25000 07:52:07 MainThread: Waiting for num_known_live_backends=3. Current value: 1 07:52:07 MainThread: Getting num_known_live_backends from ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:25000 07:52:07 MainThread: Waiting for num_known_live_backends=3. Current value: 2 07:52:07 MainThread: Getting num_known_live_backends from ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:25000 07:52:07 MainThread: num_known_live_backends has reached value: 3 07:52:07 MainThread: Getting num_known_live_backends from ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:25001 07:52:07 MainThread: num_known_live_backends has reached value: 3 07:52:07 MainThread: Getting num_known_live_backends from ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:25002 07:52:07 MainThread: num_known_live_backends has reached value: 3 07:52:07 MainThread: Found 3 impalad/1 statestored/1 catalogd process(es) 07:52:07 MainThread: Getting metric: statestore.live-backends from ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:25010 07:52:07 MainThread: Metric 'statestore.live-backends' has reached desired value: 4 07:52:07 MainThread: Getting num_known_live_backends from ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:25000 07:52:07 MainThread: num_known_live_backends has reached value: 3 07:52:07 MainThread: Getting num_known_live_backends from ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:25001 07:52:07 MainThread: num_known_live_backends has reached value: 3 07:52:07 MainThread: Getting num_known_live_backends from ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:25002 07:52:07 MainThread: num_known_live_backends has reached value: 3 07:52:07 -- connecting to: ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 -- executing against ec2-m2-4xlarge-centos-6-4-0ca1.vpc.cloudera.com:21000 07:52:07 SHOW FUNCTIONS IN java_permanent_test like 'compatibility*'; 07:52:07 07:52:07 ======== 1 failed, 76 passed, 38 skipped, 1 xfailed in 4748.36 seconds ========= {noformat}