[Enhancement] split chunk of HashTable #50686
GitHub Actions / SQL-Tester Report
failed
Sep 21, 2024 in 0s
692 tests run, 82 passed, 0 skipped, 610 failed.
Annotations
Check failure on line 1 in TestSQLCases
github-actions / SQL-Tester Report
TestSQLCases.testArrayAgg
True is not false : sql result not match: actual with E(E: (1064, 'java.lang.RuntimeException: org.apache.thrift.transport.TTransportException: java.net.SocketException: Connection reset'))
Raw output
[Stacktrace]:
Traceback (most recent call last):
File "/usr/lib/python3.8/unittest/case.py", line 60, in testPartExecutor
yield
File "/usr/lib/python3.8/unittest/case.py", line 676, in run
self._callTestMethod(testMethod)
File "/usr/lib/python3.8/unittest/case.py", line 633, in _callTestMethod
method()
File "/usr/local/lib/python3.8/dist-packages/nose/case.py", line 170, in runTest
self.test(*self.arg)
File "/usr/local/lib/python3.8/dist-packages/parameterized/parameterized.py", line 620, in standalone_func
return func(*(a + p.args), **p.kwargs, **kw)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sql_annotation.py", line 48, in wrapper
raise e
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sql_annotation.py", line 43, in wrapper
res = func(*args, **kwargs)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/test_sql_cases.py", line 384, in test_sql_basic
self.check(sql_id, sql, expect_res, actual_res, order, ori_sql)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sr_sql_lib.py", line 1336, in check
tools.assert_false(str(act).startswith("E: "), "sql result not match: actual with E(%s)" % str(act))
File "/usr/lib/python3.8/unittest/case.py", line 759, in assertFalse
raise self.failureException(msg)
AssertionError: True is not false : sql result not match: actual with E(E: (1064, 'java.lang.RuntimeException: org.apache.thrift.transport.TTransportException: java.net.SocketException: Connection reset'))
[Standard Output]:
?[1;32m------------------------------------------------------------ ?[0m
?[1;32m[case name]: testArrayAgg ?[0m
?[1;32m[case file]: sql/test_agg_function/R/test_array_agg ?[0m
?[1;32m------------------------------------------------------------ ?[0m
[SQL]: CREATE DATABASE test_db_bbf4ba6d690344cab095b22ef66446e0;
[SQL]: USE test_db_bbf4ba6d690344cab095b22ef66446e0;
→ case db: ['test_db_bbf4ba6d690344cab095b22ef66446e0']
→ case resource: []
CREATE TABLE `ss` (
`id` int(11) NULL COMMENT "",
`name` varchar(255) NULL COMMENT "",
`subject` varchar(255) NULL COMMENT "",
`score` int(11) NULL COMMENT "",
arr array<int>,
mmap map<int,varchar(20)>
) ENGINE=OLAP
DUPLICATE KEY(`id`)
DISTRIBUTED BY HASH(`id`) BUCKETS 4
PROPERTIES (
"replication_num" = "1",
"enable_persistent_index" = "false",
"replicated_storage" = "true",
"compression" = "LZ4"
);
?[1;32m******************** [FINISH] testArrayAgg ******************** ?[0m
Check failure on line 1 in TestSQLCases
github-actions / SQL-Tester Report
TestSQLCases.test57
True is not false : sql result not match: actual with E(E: (1064, 'java.lang.RuntimeException: org.apache.thrift.transport.TTransportException: java.net.SocketException: Connection reset'))
Raw output
[Stacktrace]:
Traceback (most recent call last):
File "/usr/lib/python3.8/unittest/case.py", line 60, in testPartExecutor
yield
File "/usr/lib/python3.8/unittest/case.py", line 676, in run
self._callTestMethod(testMethod)
File "/usr/lib/python3.8/unittest/case.py", line 633, in _callTestMethod
method()
File "/usr/local/lib/python3.8/dist-packages/nose/case.py", line 170, in runTest
self.test(*self.arg)
File "/usr/local/lib/python3.8/dist-packages/parameterized/parameterized.py", line 620, in standalone_func
return func(*(a + p.args), **p.kwargs, **kw)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sql_annotation.py", line 48, in wrapper
raise e
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sql_annotation.py", line 43, in wrapper
res = func(*args, **kwargs)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/test_sql_cases.py", line 384, in test_sql_basic
self.check(sql_id, sql, expect_res, actual_res, order, ori_sql)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sr_sql_lib.py", line 1336, in check
tools.assert_false(str(act).startswith("E: "), "sql result not match: actual with E(%s)" % str(act))
File "/usr/lib/python3.8/unittest/case.py", line 759, in assertFalse
raise self.failureException(msg)
AssertionError: True is not false : sql result not match: actual with E(E: (1064, 'java.lang.RuntimeException: org.apache.thrift.transport.TTransportException: java.net.SocketException: Connection reset'))
[Standard Output]:
?[1;32m------------------------------------------------------------ ?[0m
?[1;32m[case name]: test57 ?[0m
?[1;32m[case file]: sql/test_generate_series/R/test_generate_series ?[0m
?[1;32m------------------------------------------------------------ ?[0m
[SQL]: CREATE DATABASE test_db_db9212b879544fc2bf581c2980c505ee;
[SQL]: USE test_db_db9212b879544fc2bf581c2980c505ee;
→ case db: ['test_db_db9212b879544fc2bf581c2980c505ee']
→ case resource: []
CREATE TABLE t_numbers (start int, end int) DUPLICATE KEY(start) DISTRIBUTED BY HASH(start) BUCKETS 1;
?[1;32m******************** [FINISH] test57 ******************** ?[0m
Check failure on line 1 in TestSQLCases
github-actions / SQL-Tester Report
TestSQLCases.test56
True is not false : sql result not match: actual with E(E: (1064, 'java.lang.RuntimeException: org.apache.thrift.transport.TTransportException: java.net.SocketException: Connection reset'))
Raw output
[Stacktrace]:
Traceback (most recent call last):
File "/usr/lib/python3.8/unittest/case.py", line 60, in testPartExecutor
yield
File "/usr/lib/python3.8/unittest/case.py", line 676, in run
self._callTestMethod(testMethod)
File "/usr/lib/python3.8/unittest/case.py", line 633, in _callTestMethod
method()
File "/usr/local/lib/python3.8/dist-packages/nose/case.py", line 170, in runTest
self.test(*self.arg)
File "/usr/local/lib/python3.8/dist-packages/parameterized/parameterized.py", line 620, in standalone_func
return func(*(a + p.args), **p.kwargs, **kw)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sql_annotation.py", line 48, in wrapper
raise e
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sql_annotation.py", line 43, in wrapper
res = func(*args, **kwargs)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/test_sql_cases.py", line 384, in test_sql_basic
self.check(sql_id, sql, expect_res, actual_res, order, ori_sql)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sr_sql_lib.py", line 1336, in check
tools.assert_false(str(act).startswith("E: "), "sql result not match: actual with E(%s)" % str(act))
File "/usr/lib/python3.8/unittest/case.py", line 759, in assertFalse
raise self.failureException(msg)
AssertionError: True is not false : sql result not match: actual with E(E: (1064, 'java.lang.RuntimeException: org.apache.thrift.transport.TTransportException: java.net.SocketException: Connection reset'))
[Standard Output]:
?[1;32m------------------------------------------------------------ ?[0m
?[1;32m[case name]: test56 ?[0m
?[1;32m[case file]: sql/test_generate_series/R/test_generate_series ?[0m
?[1;32m------------------------------------------------------------ ?[0m
[SQL]: CREATE DATABASE test_db_c6934ee620464ef2bdf0fff30ab737b7;
[SQL]: USE test_db_c6934ee620464ef2bdf0fff30ab737b7;
→ case db: ['test_db_c6934ee620464ef2bdf0fff30ab737b7']
→ case resource: []
CREATE TABLE t2(c0 INT) duplicate key(c0) DISTRIBUTED BY HASH(c0) BUCKETS 1 PROPERTIES('replication_num'='1');
?[1;32m******************** [FINISH] test56 ******************** ?[0m
Check failure on line 1 in TestSQLCases
github-actions / SQL-Tester Report
TestSQLCases.testArrayPredicate
True is not false : sql result not match: actual with E(E: (1064, 'java.lang.RuntimeException: org.apache.thrift.TException: java.net.ConnectException: Connection refused (Connection refused)'))
Raw output
[Stacktrace]:
Traceback (most recent call last):
File "/usr/lib/python3.8/unittest/case.py", line 60, in testPartExecutor
yield
File "/usr/lib/python3.8/unittest/case.py", line 676, in run
self._callTestMethod(testMethod)
File "/usr/lib/python3.8/unittest/case.py", line 633, in _callTestMethod
method()
File "/usr/local/lib/python3.8/dist-packages/nose/case.py", line 170, in runTest
self.test(*self.arg)
File "/usr/local/lib/python3.8/dist-packages/parameterized/parameterized.py", line 620, in standalone_func
return func(*(a + p.args), **p.kwargs, **kw)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sql_annotation.py", line 48, in wrapper
raise e
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sql_annotation.py", line 43, in wrapper
res = func(*args, **kwargs)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/test_sql_cases.py", line 384, in test_sql_basic
self.check(sql_id, sql, expect_res, actual_res, order, ori_sql)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sr_sql_lib.py", line 1336, in check
tools.assert_false(str(act).startswith("E: "), "sql result not match: actual with E(%s)" % str(act))
File "/usr/lib/python3.8/unittest/case.py", line 759, in assertFalse
raise self.failureException(msg)
AssertionError: True is not false : sql result not match: actual with E(E: (1064, 'java.lang.RuntimeException: org.apache.thrift.TException: java.net.ConnectException: Connection refused (Connection refused)'))
[Standard Output]:
?[1;32m------------------------------------------------------------ ?[0m
?[1;32m[case name]: testArrayPredicate ?[0m
?[1;32m[case file]: sql/test_array/R/test_array ?[0m
?[1;32m------------------------------------------------------------ ?[0m
[SQL]: CREATE DATABASE test_db_33f8b0571c4f467dba3edfa012f3a4c7;
[SQL]: USE test_db_33f8b0571c4f467dba3edfa012f3a4c7;
→ case db: ['test_db_33f8b0571c4f467dba3edfa012f3a4c7']
→ case resource: []
CREATE TABLE array_data_type
(c1 int,
c2 array<bigint>,
c3 array<bigint>,
c4 array<bigint> not null,
c5 array<bigint> not null)
PRIMARY KEY(c1)
DISTRIBUTED BY HASH(c1)
BUCKETS 1
PROPERTIES ("replication_num" = "1");
?[1;32m******************** [FINISH] testArrayPredicate ******************** ?[0m
Check failure on line 1 in TestSQLCases
github-actions / SQL-Tester Report
TestSQLCases.test
Element counts were not equal:
First has 1, Second has 0: '6'
First has 0, Second has 1: "E: (1064, 'Backend node not found. Check if any backend node is down.backend: [172.26.190.236 alive: true inBlacklist: false] [172.26.190.235 alive: true inBlacklist: true] [172.26.190.234 alive: true inBlacklist: false] ')" : sql result not match:
- [SQL]: select count(*) as c from lineitem l1 join lineitem l3 on l3.l_orderkey = l1.l_orderkey and l3.l_suppkey <> l1.l_suppkey;
- [exp]: ['6']
- [act]: ["E: (1064, 'Backend node not found. Check if any backend node is down.backend: [172.26.190.236 alive: true inBlacklist: false] [172.26.190.235 alive: true inBlacklist: true] [172.26.190.234 alive: true inBlacklist: false] ')"]
---
Raw output
[Stacktrace]:
Traceback (most recent call last):
File "/usr/lib/python3.8/unittest/case.py", line 60, in testPartExecutor
yield
File "/usr/lib/python3.8/unittest/case.py", line 676, in run
self._callTestMethod(testMethod)
File "/usr/lib/python3.8/unittest/case.py", line 633, in _callTestMethod
method()
File "/usr/local/lib/python3.8/dist-packages/nose/case.py", line 170, in runTest
self.test(*self.arg)
File "/usr/local/lib/python3.8/dist-packages/parameterized/parameterized.py", line 620, in standalone_func
return func(*(a + p.args), **p.kwargs, **kw)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sql_annotation.py", line 48, in wrapper
raise e
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sql_annotation.py", line 43, in wrapper
res = func(*args, **kwargs)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/test_sql_cases.py", line 384, in test_sql_basic
self.check(sql_id, sql, expect_res, actual_res, order, ori_sql)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sr_sql_lib.py", line 1480, in check
tools.assert_count_equal(
File "/usr/lib/python3.8/unittest/case.py", line 1272, in assertCountEqual
self.fail(msg)
File "/usr/lib/python3.8/unittest/case.py", line 753, in fail
raise self.failureException(msg)
AssertionError: Element counts were not equal:
First has 1, Second has 0: '6'
First has 0, Second has 1: "E: (1064, 'Backend node not found. Check if any backend node is down.backend: [172.26.190.236 alive: true inBlacklist: false] [172.26.190.235 alive: true inBlacklist: true] [172.26.190.234 alive: true inBlacklist: false] ')" : sql result not match:
- [SQL]: select count(*) as c from lineitem l1 join lineitem l3 on l3.l_orderkey = l1.l_orderkey and l3.l_suppkey <> l1.l_suppkey;
- [exp]: ['6']
- [act]: ["E: (1064, 'Backend node not found. Check if any backend node is down.backend: [172.26.190.236 alive: true inBlacklist: false] [172.26.190.235 alive: true inBlacklist: true] [172.26.190.234 alive: true inBlacklist: false] ')"]
---
[Standard Output]:
?[1;32m------------------------------------------------------------ ?[0m
?[1;32m[case name]: test ?[0m
?[1;32m[case file]: sql/test_join/R/test_interleaving_join ?[0m
?[1;32m------------------------------------------------------------ ?[0m
[SQL]: CREATE DATABASE test_db_27baec066b1f4dbb8469822afb8db666;
[SQL]: USE test_db_27baec066b1f4dbb8469822afb8db666;
→ case db: ['test_db_27baec066b1f4dbb8469822afb8db666']
→ case resource: []
CREATE TABLE `lineitem` (
`l_orderkey` int(11) NOT NULL COMMENT "",
`l_partkey` int(11) NOT NULL COMMENT "",
`l_suppkey` int(11)
) ENGINE=OLAP
DUPLICATE KEY(`l_orderkey`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`l_orderkey`) BUCKETS 1
PROPERTIES (
"compression" = "LZ4",
"fast_schema_evolution" = "true",
"replicated_storage" = "true",
"replication_num" = "1"
);
insert into lineitem values (1,1,1),(1,2,1),(1,3,2),(11,1,11),(11,2,1),(2,3,2),(2,3,null);
set pipeline_dop = 1;
set chunk_size = 2;
set interleaving_group_size =0;
select count(*) as c from lineitem l1 join lineitem l3 on l3.l_orderkey = l1.l_orderkey and l3.l_suppkey <> l1.l_suppkey;
?[1;32m******************** [FINISH] test ******************** ?[0m
Check failure on line 1 in TestSQLCases
github-actions / SQL-Tester Report
TestSQLCases.testArrayUniqueAgg
True is not false : sql result not match: actual with E(E: (1064, 'java.lang.RuntimeException: org.apache.thrift.TException: java.net.ConnectException: Connection refused (Connection refused)'))
Raw output
[Stacktrace]:
Traceback (most recent call last):
File "/usr/lib/python3.8/unittest/case.py", line 60, in testPartExecutor
yield
File "/usr/lib/python3.8/unittest/case.py", line 676, in run
self._callTestMethod(testMethod)
File "/usr/lib/python3.8/unittest/case.py", line 633, in _callTestMethod
method()
File "/usr/local/lib/python3.8/dist-packages/nose/case.py", line 170, in runTest
self.test(*self.arg)
File "/usr/local/lib/python3.8/dist-packages/parameterized/parameterized.py", line 620, in standalone_func
return func(*(a + p.args), **p.kwargs, **kw)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sql_annotation.py", line 48, in wrapper
raise e
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sql_annotation.py", line 43, in wrapper
res = func(*args, **kwargs)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/test_sql_cases.py", line 384, in test_sql_basic
self.check(sql_id, sql, expect_res, actual_res, order, ori_sql)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sr_sql_lib.py", line 1336, in check
tools.assert_false(str(act).startswith("E: "), "sql result not match: actual with E(%s)" % str(act))
File "/usr/lib/python3.8/unittest/case.py", line 759, in assertFalse
raise self.failureException(msg)
AssertionError: True is not false : sql result not match: actual with E(E: (1064, 'java.lang.RuntimeException: org.apache.thrift.TException: java.net.ConnectException: Connection refused (Connection refused)'))
[Standard Output]:
?[1;32m------------------------------------------------------------ ?[0m
?[1;32m[case name]: testArrayUniqueAgg ?[0m
?[1;32m[case file]: sql/test_agg_function/R/test_array_unique_agg ?[0m
?[1;32m------------------------------------------------------------ ?[0m
[SQL]: CREATE DATABASE test_db_60819d3439b942bbbcdc1cf9c498c941;
[SQL]: USE test_db_60819d3439b942bbbcdc1cf9c498c941;
→ case db: ['test_db_60819d3439b942bbbcdc1cf9c498c941']
→ case resource: []
CREATE TABLE `array_unique_agg_test` (
id int,
s_1 Array<String>,
i_1 Array<BigInt>,
f_1 Array<Double>,
d_1 Array<DECIMAL(26, 2)>,
ai_1 Array<Array<BigInt>>
) ENGINE=OLAP
DUPLICATE KEY(`id`)
DISTRIBUTED BY HASH(`id`) BUCKETS 4
PROPERTIES (
"replication_num" = "1",
"enable_persistent_index" = "false",
"replicated_storage" = "true",
"compression" = "LZ4"
);
?[1;32m******************** [FINISH] testArrayUniqueAgg ******************** ?[0m
Check failure on line 1 in TestSQLCases
github-actions / SQL-Tester Report
TestSQLCases.testArrayVarchar
True is not false : sql result not match: actual with E(E: (1064, 'java.lang.RuntimeException: org.apache.thrift.TException: java.net.ConnectException: Connection refused (Connection refused)'))
Raw output
[Stacktrace]:
Traceback (most recent call last):
File "/usr/lib/python3.8/unittest/case.py", line 60, in testPartExecutor
yield
File "/usr/lib/python3.8/unittest/case.py", line 676, in run
self._callTestMethod(testMethod)
File "/usr/lib/python3.8/unittest/case.py", line 633, in _callTestMethod
method()
File "/usr/local/lib/python3.8/dist-packages/nose/case.py", line 170, in runTest
self.test(*self.arg)
File "/usr/local/lib/python3.8/dist-packages/parameterized/parameterized.py", line 620, in standalone_func
return func(*(a + p.args), **p.kwargs, **kw)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sql_annotation.py", line 48, in wrapper
raise e
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sql_annotation.py", line 43, in wrapper
res = func(*args, **kwargs)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/test_sql_cases.py", line 384, in test_sql_basic
self.check(sql_id, sql, expect_res, actual_res, order, ori_sql)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sr_sql_lib.py", line 1336, in check
tools.assert_false(str(act).startswith("E: "), "sql result not match: actual with E(%s)" % str(act))
File "/usr/lib/python3.8/unittest/case.py", line 759, in assertFalse
raise self.failureException(msg)
AssertionError: True is not false : sql result not match: actual with E(E: (1064, 'java.lang.RuntimeException: org.apache.thrift.TException: java.net.ConnectException: Connection refused (Connection refused)'))
[Standard Output]:
?[1;32m------------------------------------------------------------ ?[0m
?[1;32m[case name]: testArrayVarchar ?[0m
?[1;32m[case file]: sql/test_array/R/test_array ?[0m
?[1;32m------------------------------------------------------------ ?[0m
[SQL]: CREATE DATABASE test_db_83ac3d5285054c428f64f16ea4995449;
[SQL]: USE test_db_83ac3d5285054c428f64f16ea4995449;
→ case db: ['test_db_83ac3d5285054c428f64f16ea4995449']
→ case resource: []
CREATE TABLE array_data_type_1
(c1 int,
c2 array<datetime>,
c3 array<float>,
c4 array<varchar(10)>,
c5 array<varchar(20)>,
c6 array<array<varchar(10)>>)
PRIMARY KEY(c1)
DISTRIBUTED BY HASH(c1)
BUCKETS 1
PROPERTIES ("replication_num" = "1");
?[1;32m******************** [FINISH] testArrayVarchar ******************** ?[0m
Check failure on line 1 in TestSQLCases
github-actions / SQL-Tester Report
TestSQLCases.testCorr
True is not false : sql result not match: actual with E(E: (1064, 'java.lang.RuntimeException: org.apache.thrift.TException: java.net.ConnectException: Connection refused (Connection refused)'))
Raw output
[Stacktrace]:
Traceback (most recent call last):
File "/usr/lib/python3.8/unittest/case.py", line 60, in testPartExecutor
yield
File "/usr/lib/python3.8/unittest/case.py", line 676, in run
self._callTestMethod(testMethod)
File "/usr/lib/python3.8/unittest/case.py", line 633, in _callTestMethod
method()
File "/usr/local/lib/python3.8/dist-packages/nose/case.py", line 170, in runTest
self.test(*self.arg)
File "/usr/local/lib/python3.8/dist-packages/parameterized/parameterized.py", line 620, in standalone_func
return func(*(a + p.args), **p.kwargs, **kw)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sql_annotation.py", line 48, in wrapper
raise e
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sql_annotation.py", line 43, in wrapper
res = func(*args, **kwargs)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/test_sql_cases.py", line 384, in test_sql_basic
self.check(sql_id, sql, expect_res, actual_res, order, ori_sql)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sr_sql_lib.py", line 1336, in check
tools.assert_false(str(act).startswith("E: "), "sql result not match: actual with E(%s)" % str(act))
File "/usr/lib/python3.8/unittest/case.py", line 759, in assertFalse
raise self.failureException(msg)
AssertionError: True is not false : sql result not match: actual with E(E: (1064, 'java.lang.RuntimeException: org.apache.thrift.TException: java.net.ConnectException: Connection refused (Connection refused)'))
[Standard Output]:
?[1;32m------------------------------------------------------------ ?[0m
?[1;32m[case name]: testCorr ?[0m
?[1;32m[case file]: sql/test_agg_function/R/test_statistic ?[0m
?[1;32m------------------------------------------------------------ ?[0m
[SQL]: CREATE DATABASE test_db_4b4ce40a5103446580b572056a37b1fd;
[SQL]: USE test_db_4b4ce40a5103446580b572056a37b1fd;
→ case db: ['test_db_4b4ce40a5103446580b572056a37b1fd']
→ case resource: []
CREATE TABLE aggtest(
no int,
k decimal(10,2) ,
v decimal(10,2))
DUPLICATE KEY (no)
DISTRIBUTED BY HASH (no)
PROPERTIES (
"replication_num" = "1",
"storage_format" = "v2"
);
?[1;32m******************** [FINISH] testCorr ******************** ?[0m
Check failure on line 1 in TestSQLCases
github-actions / SQL-Tester Report
TestSQLCases.testCovarPop
True is not false : sql result not match: actual with E(E: (1064, 'java.lang.RuntimeException: org.apache.thrift.TException: java.net.ConnectException: Connection refused (Connection refused)'))
Raw output
[Stacktrace]:
Traceback (most recent call last):
File "/usr/lib/python3.8/unittest/case.py", line 60, in testPartExecutor
yield
File "/usr/lib/python3.8/unittest/case.py", line 676, in run
self._callTestMethod(testMethod)
File "/usr/lib/python3.8/unittest/case.py", line 633, in _callTestMethod
method()
File "/usr/local/lib/python3.8/dist-packages/nose/case.py", line 170, in runTest
self.test(*self.arg)
File "/usr/local/lib/python3.8/dist-packages/parameterized/parameterized.py", line 620, in standalone_func
return func(*(a + p.args), **p.kwargs, **kw)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sql_annotation.py", line 48, in wrapper
raise e
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sql_annotation.py", line 43, in wrapper
res = func(*args, **kwargs)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/test_sql_cases.py", line 384, in test_sql_basic
self.check(sql_id, sql, expect_res, actual_res, order, ori_sql)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sr_sql_lib.py", line 1336, in check
tools.assert_false(str(act).startswith("E: "), "sql result not match: actual with E(%s)" % str(act))
File "/usr/lib/python3.8/unittest/case.py", line 759, in assertFalse
raise self.failureException(msg)
AssertionError: True is not false : sql result not match: actual with E(E: (1064, 'java.lang.RuntimeException: org.apache.thrift.TException: java.net.ConnectException: Connection refused (Connection refused)'))
[Standard Output]:
?[1;32m------------------------------------------------------------ ?[0m
?[1;32m[case name]: testCovarPop ?[0m
?[1;32m[case file]: sql/test_agg_function/R/test_statistic ?[0m
?[1;32m------------------------------------------------------------ ?[0m
[SQL]: CREATE DATABASE test_db_e9b876fdc1324e3b94f9cc1300a15ecb;
[SQL]: USE test_db_e9b876fdc1324e3b94f9cc1300a15ecb;
→ case db: ['test_db_e9b876fdc1324e3b94f9cc1300a15ecb']
→ case resource: []
CREATE TABLE aggtest(
no int,
k decimal(10,2) ,
v decimal(10,2))
DUPLICATE KEY (no)
DISTRIBUTED BY HASH (no)
PROPERTIES (
"replication_num" = "1",
"storage_format" = "v2"
);
?[1;32m******************** [FINISH] testCovarPop ******************** ?[0m
Check failure on line 1 in TestSQLCases
github-actions / SQL-Tester Report
TestSQLCases.testCovarSamp
True is not false : sql result not match: actual with E(E: (1064, 'java.lang.RuntimeException: org.apache.thrift.TException: java.net.ConnectException: Connection refused (Connection refused)'))
Raw output
[Stacktrace]:
Traceback (most recent call last):
File "/usr/lib/python3.8/unittest/case.py", line 60, in testPartExecutor
yield
File "/usr/lib/python3.8/unittest/case.py", line 676, in run
self._callTestMethod(testMethod)
File "/usr/lib/python3.8/unittest/case.py", line 633, in _callTestMethod
method()
File "/usr/local/lib/python3.8/dist-packages/nose/case.py", line 170, in runTest
self.test(*self.arg)
File "/usr/local/lib/python3.8/dist-packages/parameterized/parameterized.py", line 620, in standalone_func
return func(*(a + p.args), **p.kwargs, **kw)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sql_annotation.py", line 48, in wrapper
raise e
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sql_annotation.py", line 43, in wrapper
res = func(*args, **kwargs)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/test_sql_cases.py", line 384, in test_sql_basic
self.check(sql_id, sql, expect_res, actual_res, order, ori_sql)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sr_sql_lib.py", line 1336, in check
tools.assert_false(str(act).startswith("E: "), "sql result not match: actual with E(%s)" % str(act))
File "/usr/lib/python3.8/unittest/case.py", line 759, in assertFalse
raise self.failureException(msg)
AssertionError: True is not false : sql result not match: actual with E(E: (1064, 'java.lang.RuntimeException: org.apache.thrift.TException: java.net.ConnectException: Connection refused (Connection refused)'))
[Standard Output]:
?[1;32m------------------------------------------------------------ ?[0m
?[1;32m[case name]: testCovarSamp ?[0m
?[1;32m[case file]: sql/test_agg_function/R/test_statistic ?[0m
?[1;32m------------------------------------------------------------ ?[0m
[SQL]: CREATE DATABASE test_db_481fc682d6aa4a20bc380041b9c64993;
[SQL]: USE test_db_481fc682d6aa4a20bc380041b9c64993;
→ case db: ['test_db_481fc682d6aa4a20bc380041b9c64993']
→ case resource: []
CREATE TABLE aggtest(
no int,
k decimal(10,2) ,
v decimal(10,2))
DUPLICATE KEY (no)
DISTRIBUTED BY HASH (no)
PROPERTIES (
"replication_num" = "1",
"storage_format" = "v2"
);
?[1;32m******************** [FINISH] testCovarSamp ******************** ?[0m
Check failure on line 1 in TestSQLCases
github-actions / SQL-Tester Report
TestSQLCases.testEmptyArray
True is not false : sql result not match: actual with E(E: (1064, 'java.lang.RuntimeException: org.apache.thrift.TException: java.net.ConnectException: Connection refused (Connection refused)'))
Raw output
[Stacktrace]:
Traceback (most recent call last):
File "/usr/lib/python3.8/unittest/case.py", line 60, in testPartExecutor
yield
File "/usr/lib/python3.8/unittest/case.py", line 676, in run
self._callTestMethod(testMethod)
File "/usr/lib/python3.8/unittest/case.py", line 633, in _callTestMethod
method()
File "/usr/local/lib/python3.8/dist-packages/nose/case.py", line 170, in runTest
self.test(*self.arg)
File "/usr/local/lib/python3.8/dist-packages/parameterized/parameterized.py", line 620, in standalone_func
return func(*(a + p.args), **p.kwargs, **kw)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sql_annotation.py", line 48, in wrapper
raise e
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sql_annotation.py", line 43, in wrapper
res = func(*args, **kwargs)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/test_sql_cases.py", line 384, in test_sql_basic
self.check(sql_id, sql, expect_res, actual_res, order, ori_sql)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sr_sql_lib.py", line 1336, in check
tools.assert_false(str(act).startswith("E: "), "sql result not match: actual with E(%s)" % str(act))
File "/usr/lib/python3.8/unittest/case.py", line 759, in assertFalse
raise self.failureException(msg)
AssertionError: True is not false : sql result not match: actual with E(E: (1064, 'java.lang.RuntimeException: org.apache.thrift.TException: java.net.ConnectException: Connection refused (Connection refused)'))
[Standard Output]:
?[1;32m------------------------------------------------------------ ?[0m
?[1;32m[case name]: testEmptyArray ?[0m
?[1;32m[case file]: sql/test_array/R/test_array ?[0m
?[1;32m------------------------------------------------------------ ?[0m
[SQL]: CREATE DATABASE test_db_2d3ec4eebefc4e9b914e11897d868550;
[SQL]: USE test_db_2d3ec4eebefc4e9b914e11897d868550;
→ case db: ['test_db_2d3ec4eebefc4e9b914e11897d868550']
→ case resource: []
with t0 as (
select c1 from (values([])) as t(c1)
)
select
array_concat(c1, [1])
from t0;
with t0 as (
select c1 from (values([])) as t(c1)
)
select
array_concat([1], c1)
from t0;
select array_concat(c1, [[]])
from (select c1 from (values([])) as t(c1)) t;
select array_concat(c1, [[1]])
from (select c1 from (values([])) as t(c1)) t;
select array_concat(c1, [[1]])
from (select c1 from (values([[]])) as t(c1)) t;
select array_concat(c1, [map{'a':1}])
from (select c1 from (values([map()])) as t(c1)) t;
select array_concat(c1, [map{'a':1}])
from (select c1 from (values([])) as t(c1)) t;
select array_concat(c1, [named_struct('a', 1, 'b', 2, 'c', 3)])
from (select c1 from (values([])) as t(c1)) t;
CREATE TABLE `t2` (
`pk` bigint(20) NOT NULL COMMENT "",
`aas_1` array<array<array<varchar(65533)>>> NULL COMMENT "",
`aad_1` array<array<array<DECIMAL128(26,2)>>> NULL COMMENT ""
) ENGINE=OLAP
DUPLICATE KEY(`pk`)
DISTRIBUTED BY HASH(`pk`) BUCKETS 3
PROPERTIES (
"replication_num" = "1",
"enable_persistent_index" = "false",
"replicated_storage" = "true",
"fast_schema_evolution" = "true",
"compression" = "LZ4"
);
?[1;32m******************** [FINISH] testEmptyArray ******************** ?[0m
Check failure on line 1 in TestSQLCases
github-actions / SQL-Tester Report
TestSQLCases.testCsvFilesSink2
Element counts were not equal:
First has 1, Second has 0: '1\tA'
First has 1, Second has 0: '2\tB'
First has 0, Second has 1: "E: (1064, 'Backend node not found. Check if any backend node is down.backend: [172.26.190.236 alive: true inBlacklist: false] [172.26.190.235 alive: true inBlacklist: true] [172.26.190.234 alive: true inBlacklist: false] ')" : sql result not match:
- [SQL]: select * from files (
"path" = "oss://${oss_bucket}/test_sink/testCsvFilesSink2/927ec20b02b14f98960d31b0f80a50cf/*",
"format" = "csv"
);
- [exp]: ['1\tA', '2\tB']
- [act]: ["E: (1064, 'Backend node not found. Check if any backend node is down.backend: [172.26.190.236 alive: true inBlacklist: false] [172.26.190.235 alive: true inBlacklist: true] [172.26.190.234 alive: true inBlacklist: false] ')"]
---Raw output
[Stacktrace]:
Traceback (most recent call last):
File "/usr/lib/python3.8/unittest/case.py", line 60, in testPartExecutor
yield
File "/usr/lib/python3.8/unittest/case.py", line 676, in run
self._callTestMethod(testMethod)
File "/usr/lib/python3.8/unittest/case.py", line 633, in _callTestMethod
method()
File "/usr/local/lib/python3.8/dist-packages/nose/case.py", line 170, in runTest
self.test(*self.arg)
File "/usr/local/lib/python3.8/dist-packages/parameterized/parameterized.py", line 620, in standalone_func
return func(*(a + p.args), **p.kwargs, **kw)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sql_annotation.py", line 48, in wrapper
raise e
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sql_annotation.py", line 43, in wrapper
res = func(*args, **kwargs)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/test_sql_cases.py", line 384, in test_sql_basic
self.check(sql_id, sql, expect_res, actual_res, order, ori_sql)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sr_sql_lib.py", line 1480, in check
tools.assert_count_equal(
File "/usr/lib/python3.8/unittest/case.py", line 1272, in assertCountEqual
self.fail(msg)
File "/usr/lib/python3.8/unittest/case.py", line 753, in fail
raise self.failureException(msg)
AssertionError: Element counts were not equal:
First has 1, Second has 0: '1\tA'
First has 1, Second has 0: '2\tB'
First has 0, Second has 1: "E: (1064, 'Backend node not found. Check if any backend node is down.backend: [172.26.190.236 alive: true inBlacklist: false] [172.26.190.235 alive: true inBlacklist: true] [172.26.190.234 alive: true inBlacklist: false] ')" : sql result not match:
- [SQL]: select * from files (
"path" = "oss://${oss_bucket}/test_sink/testCsvFilesSink2/927ec20b02b14f98960d31b0f80a50cf/*",
"format" = "csv"
);
- [exp]: ['1\tA', '2\tB']
- [act]: ["E: (1064, 'Backend node not found. Check if any backend node is down.backend: [172.26.190.236 alive: true inBlacklist: false] [172.26.190.235 alive: true inBlacklist: true] [172.26.190.234 alive: true inBlacklist: false] ')"]
---
[Standard Output]:
?[1;32m------------------------------------------------------------ ?[0m
?[1;32m[case name]: testCsvFilesSink2 ?[0m
?[1;32m[case file]: sql/test_sink/R/test_csv_file_sink ?[0m
?[1;32m------------------------------------------------------------ ?[0m
[SQL]: CREATE DATABASE test_db_e29b6300f44749eba807202453d22ebc;
[SQL]: USE test_db_e29b6300f44749eba807202453d22ebc;
→ case db: ['test_db_e29b6300f44749eba807202453d22ebc']
→ case resource: []
insert into files (
"path" = "oss://${oss_bucket}/test_sink/testCsvFilesSink2/927ec20b02b14f98960d31b0f80a50cf/",
"format" = "csv",
"compression" = "uncompressed"
)
select 1 as k1, "A" as k2 union select 2 as k1, "B" as k2;
select * from files (
"path" = "oss://${oss_bucket}/test_sink/testCsvFilesSink2/927ec20b02b14f98960d31b0f80a50cf/*",
"format" = "csv"
);
?[1;32m******************** [FINISH] testCsvFilesSink2 ******************** ?[0m
Check failure on line 1 in TestSQLCases
github-actions / SQL-Tester Report
TestSQLCases.testFilesSinkWithGlobalShuffle
Element counts were not equal:
First has 1, Second has 0: '1\tA'
First has 0, Second has 1: "E: (1064, 'Access storage error. Error message: failed to get file schema: Unable to validate object, host: 172.26.190.235')" : sql result not match:
- [SQL]: select * from files (
"path" = "oss://${oss_bucket}/test_sink/test_global_shuffle/a5853fe2492544fcbf664a29bbc3d333/1/*",
"format" = "parquet"
);
- [exp]: ['1\tA']
- [act]: ["E: (1064, 'Access storage error. Error message: failed to get file schema: Unable to validate object, host: 172.26.190.235')"]
---Raw output
[Stacktrace]:
Traceback (most recent call last):
File "/usr/lib/python3.8/unittest/case.py", line 60, in testPartExecutor
yield
File "/usr/lib/python3.8/unittest/case.py", line 676, in run
self._callTestMethod(testMethod)
File "/usr/lib/python3.8/unittest/case.py", line 633, in _callTestMethod
method()
File "/usr/local/lib/python3.8/dist-packages/nose/case.py", line 170, in runTest
self.test(*self.arg)
File "/usr/local/lib/python3.8/dist-packages/parameterized/parameterized.py", line 620, in standalone_func
return func(*(a + p.args), **p.kwargs, **kw)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sql_annotation.py", line 48, in wrapper
raise e
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sql_annotation.py", line 43, in wrapper
res = func(*args, **kwargs)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/test_sql_cases.py", line 384, in test_sql_basic
self.check(sql_id, sql, expect_res, actual_res, order, ori_sql)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sr_sql_lib.py", line 1480, in check
tools.assert_count_equal(
File "/usr/lib/python3.8/unittest/case.py", line 1272, in assertCountEqual
self.fail(msg)
File "/usr/lib/python3.8/unittest/case.py", line 753, in fail
raise self.failureException(msg)
AssertionError: Element counts were not equal:
First has 1, Second has 0: '1\tA'
First has 0, Second has 1: "E: (1064, 'Access storage error. Error message: failed to get file schema: Unable to validate object, host: 172.26.190.235')" : sql result not match:
- [SQL]: select * from files (
"path" = "oss://${oss_bucket}/test_sink/test_global_shuffle/a5853fe2492544fcbf664a29bbc3d333/1/*",
"format" = "parquet"
);
- [exp]: ['1\tA']
- [act]: ["E: (1064, 'Access storage error. Error message: failed to get file schema: Unable to validate object, host: 172.26.190.235')"]
---
[Standard Output]:
?[1;32m------------------------------------------------------------ ?[0m
?[1;32m[case name]: testFilesSinkWithGlobalShuffle ?[0m
?[1;32m[case file]: sql/test_sink/R/test_global_shuffle ?[0m
?[1;32m------------------------------------------------------------ ?[0m
[SQL]: CREATE DATABASE test_db_7cbdb48047d145b09c84851725fdfefc;
[SQL]: USE test_db_7cbdb48047d145b09c84851725fdfefc;
→ case db: ['test_db_7cbdb48047d145b09c84851725fdfefc']
→ case resource: []
set enable_connector_sink_global_shuffle = true;
insert into files (
"path" = "oss://${oss_bucket}/test_sink/test_global_shuffle/a5853fe2492544fcbf664a29bbc3d333/1/",
"format"="parquet",
"compression" = "uncompressed"
)
select 1 as k1, "A" as k2;
insert into files (
"path" = "oss://${oss_bucket}/test_sink/test_global_shuffle/a5853fe2492544fcbf664a29bbc3d333/2/",
"format"="parquet",
"compression" = "uncompressed",
"partition_by"="k1"
)
select 2 as k1, "B" as k2;
select * from files (
"path" = "oss://${oss_bucket}/test_sink/test_global_shuffle/a5853fe2492544fcbf664a29bbc3d333/1/*",
"format" = "parquet"
);
?[1;32m******************** [FINISH] testFilesSinkWithGlobalShuffle ******************** ?[0m
Check failure on line 1 in TestSQLCases
github-actions / SQL-Tester Report
TestSQLCases.testGlobalRuntimeFilter
True is not false : sql result not match: actual with E(E: (1064, 'java.lang.RuntimeException: org.apache.thrift.TException: java.net.ConnectException: Connection refused (Connection refused)'))
Raw output
[Stacktrace]:
Traceback (most recent call last):
File "/usr/lib/python3.8/unittest/case.py", line 60, in testPartExecutor
yield
File "/usr/lib/python3.8/unittest/case.py", line 676, in run
self._callTestMethod(testMethod)
File "/usr/lib/python3.8/unittest/case.py", line 633, in _callTestMethod
method()
File "/usr/local/lib/python3.8/dist-packages/nose/case.py", line 170, in runTest
self.test(*self.arg)
File "/usr/local/lib/python3.8/dist-packages/parameterized/parameterized.py", line 620, in standalone_func
return func(*(a + p.args), **p.kwargs, **kw)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sql_annotation.py", line 48, in wrapper
raise e
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sql_annotation.py", line 43, in wrapper
res = func(*args, **kwargs)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/test_sql_cases.py", line 384, in test_sql_basic
self.check(sql_id, sql, expect_res, actual_res, order, ori_sql)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sr_sql_lib.py", line 1336, in check
tools.assert_false(str(act).startswith("E: "), "sql result not match: actual with E(%s)" % str(act))
File "/usr/lib/python3.8/unittest/case.py", line 759, in assertFalse
raise self.failureException(msg)
AssertionError: True is not false : sql result not match: actual with E(E: (1064, 'java.lang.RuntimeException: org.apache.thrift.TException: java.net.ConnectException: Connection refused (Connection refused)'))
[Standard Output]:
?[1;32m------------------------------------------------------------ ?[0m
?[1;32m[case name]: testGlobalRuntimeFilter ?[0m
?[1;32m[case file]: sql/test_grf/R/test_grf ?[0m
?[1;32m------------------------------------------------------------ ?[0m
[SQL]: CREATE DATABASE test_db_45c4c3a0c448416bacb747be527cc52b;
[SQL]: USE test_db_45c4c3a0c448416bacb747be527cc52b;
→ case db: ['test_db_45c4c3a0c448416bacb747be527cc52b']
→ case resource: []
CREATE TABLE left_tbl
(c1 int,
c2 int)
DISTRIBUTED BY HASH(c1) BUCKETS 3
PROPERTIES ("replication_num" = "1");
?[1;32m******************** [FINISH] testGlobalRuntimeFilter ******************** ?[0m
Check failure on line 1 in TestSQLCases
github-actions / SQL-Tester Report
TestSQLCases.testGroupConcat
True is not false : sql result not match: actual with E(E: (1064, 'java.lang.RuntimeException: org.apache.thrift.TException: java.net.ConnectException: Connection refused (Connection refused)'))
Raw output
[Stacktrace]:
Traceback (most recent call last):
File "/usr/lib/python3.8/unittest/case.py", line 60, in testPartExecutor
yield
File "/usr/lib/python3.8/unittest/case.py", line 676, in run
self._callTestMethod(testMethod)
File "/usr/lib/python3.8/unittest/case.py", line 633, in _callTestMethod
method()
File "/usr/local/lib/python3.8/dist-packages/nose/case.py", line 170, in runTest
self.test(*self.arg)
File "/usr/local/lib/python3.8/dist-packages/parameterized/parameterized.py", line 620, in standalone_func
return func(*(a + p.args), **p.kwargs, **kw)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sql_annotation.py", line 48, in wrapper
raise e
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sql_annotation.py", line 43, in wrapper
res = func(*args, **kwargs)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/test_sql_cases.py", line 384, in test_sql_basic
self.check(sql_id, sql, expect_res, actual_res, order, ori_sql)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sr_sql_lib.py", line 1336, in check
tools.assert_false(str(act).startswith("E: "), "sql result not match: actual with E(%s)" % str(act))
File "/usr/lib/python3.8/unittest/case.py", line 759, in assertFalse
raise self.failureException(msg)
AssertionError: True is not false : sql result not match: actual with E(E: (1064, 'java.lang.RuntimeException: org.apache.thrift.TException: java.net.ConnectException: Connection refused (Connection refused)'))
[Standard Output]:
?[1;32m------------------------------------------------------------ ?[0m
?[1;32m[case name]: testGroupConcat ?[0m
?[1;32m[case file]: sql/test_agg_function/R/test_group_concat ?[0m
?[1;32m------------------------------------------------------------ ?[0m
[SQL]: CREATE DATABASE test_db_bbab61c16aa642a0a4d1fd0761dd9f78;
[SQL]: USE test_db_bbab61c16aa642a0a4d1fd0761dd9f78;
→ case db: ['test_db_bbab61c16aa642a0a4d1fd0761dd9f78']
→ case resource: []
CREATE TABLE IF NOT EXISTS `lineorder` (
`lo_orderkey` int(11) NOT NULL COMMENT "",
`lo_shipmode` varchar(11) NOT NULL COMMENT ""
) ENGINE=OLAP
DUPLICATE KEY(`lo_orderkey`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`lo_orderkey`) BUCKETS 48
PROPERTIES (
"replication_num" = "1"
);
?[1;32m******************** [FINISH] testGroupConcat ******************** ?[0m
Check failure on line 1 in TestSQLCases
github-actions / SQL-Tester Report
TestSQLCases.testExternalMysqlJoin
Element counts were not equal:
First has 1, Second has 0: '2'
First has 0, Second has 1: "E: (1064, 'Backend node not found. Check if any backend node is down.backend: [172.26.190.236 alive: true inBlacklist: true] [172.26.190.235 alive: false inBlacklist: true] [172.26.190.234 alive: true inBlacklist: false] ')" : sql result not match:
- [SQL]: select count(*) from external_allstring l join [broadcast] allstring r on l.v1=r.v1;
- [exp]: ['2']
- [act]: ["E: (1064, 'Backend node not found. Check if any backend node is down.backend: [172.26.190.236 alive: true inBlacklist: true] [172.26.190.235 alive: false inBlacklist: true] [172.26.190.234 alive: true inBlacklist: false] ')"]
---
Raw output
[Stacktrace]:
Traceback (most recent call last):
File "/usr/lib/python3.8/unittest/case.py", line 60, in testPartExecutor
yield
File "/usr/lib/python3.8/unittest/case.py", line 676, in run
self._callTestMethod(testMethod)
File "/usr/lib/python3.8/unittest/case.py", line 633, in _callTestMethod
method()
File "/usr/local/lib/python3.8/dist-packages/nose/case.py", line 170, in runTest
self.test(*self.arg)
File "/usr/local/lib/python3.8/dist-packages/parameterized/parameterized.py", line 620, in standalone_func
return func(*(a + p.args), **p.kwargs, **kw)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sql_annotation.py", line 48, in wrapper
raise e
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sql_annotation.py", line 43, in wrapper
res = func(*args, **kwargs)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/test_sql_cases.py", line 384, in test_sql_basic
self.check(sql_id, sql, expect_res, actual_res, order, ori_sql)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sr_sql_lib.py", line 1480, in check
tools.assert_count_equal(
File "/usr/lib/python3.8/unittest/case.py", line 1272, in assertCountEqual
self.fail(msg)
File "/usr/lib/python3.8/unittest/case.py", line 753, in fail
raise self.failureException(msg)
AssertionError: Element counts were not equal:
First has 1, Second has 0: '2'
First has 0, Second has 1: "E: (1064, 'Backend node not found. Check if any backend node is down.backend: [172.26.190.236 alive: true inBlacklist: true] [172.26.190.235 alive: false inBlacklist: true] [172.26.190.234 alive: true inBlacklist: false] ')" : sql result not match:
- [SQL]: select count(*) from external_allstring l join [broadcast] allstring r on l.v1=r.v1;
- [exp]: ['2']
- [act]: ["E: (1064, 'Backend node not found. Check if any backend node is down.backend: [172.26.190.236 alive: true inBlacklist: true] [172.26.190.235 alive: false inBlacklist: true] [172.26.190.234 alive: true inBlacklist: false] ')"]
---
[Standard Output]:
?[1;32m------------------------------------------------------------ ?[0m
?[1;32m[case name]: testExternalMysqlJoin ?[0m
?[1;32m[case file]: sql/test_external_mysql/R/test_external_mysql_join ?[0m
?[1;32m------------------------------------------------------------ ?[0m
→ case db: ['db_b288637373864b6789cf91d906a190ba']
→ case resource: []
create database db_b288637373864b6789cf91d906a190ba;
use db_b288637373864b6789cf91d906a190ba;
CREATE TABLE `allstring` (
`v1` varchar(20) NOT NULL COMMENT "",
`v2` varchar(20) NOT NULL COMMENT "",
`v3` varchar(20) NOT NULL COMMENT ""
) ENGINE=OLAP
DUPLICATE KEY(`v1`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`v1`) BUCKETS 1
PROPERTIES (
"replication_num" = "1",
"enable_persistent_index" = "false",
"replicated_storage" = "false",
"compression" = "LZ4"
);
insert into allstring values ('"key"',"1", "2");
insert into allstring values ("'key'","1", "2");
CREATE EXTERNAL TABLE external_allstring
(
`v1` varchar(20) NOT NULL COMMENT "",
`v2` varchar(20) NOT NULL COMMENT "",
`v3` varchar(20) NOT NULL COMMENT ""
)
ENGINE=mysql
PROPERTIES
(
"host" = "172.26.190.233",
"port" = "9032",
"user" = "root",
"password" = "",
"database" = "db_b288637373864b6789cf91d906a190ba",
"table" = "allstring"
);
select count(*) from external_allstring l join [broadcast] allstring r on l.v1=r.v1;
?[1;32m******************** [FINISH] testExternalMysqlJoin ******************** ?[0m
Check failure on line 1 in TestSQLCases
github-actions / SQL-Tester Report
TestSQLCases.testIcebergHadoopCatalog
Element counts were not equal:
First has 1, Second has 0: '1\tA'
First has 0, Second has 1: "E: (1064, 'Do not support get partitions from catalog type: HADOOP_CATALOG')" : sql result not match:
- [SQL]: select * from ice_hadoop07beb42d35ee41f29890b33b6120f169.ice_hadoop_db07beb42d35ee41f29890b33b6120f169.test;
- [exp]: ['1\tA']
- [act]: ["E: (1064, 'Do not support get partitions from catalog type: HADOOP_CATALOG')"]
---
Raw output
[Stacktrace]:
Traceback (most recent call last):
File "/usr/lib/python3.8/unittest/case.py", line 60, in testPartExecutor
yield
File "/usr/lib/python3.8/unittest/case.py", line 676, in run
self._callTestMethod(testMethod)
File "/usr/lib/python3.8/unittest/case.py", line 633, in _callTestMethod
method()
File "/usr/local/lib/python3.8/dist-packages/nose/case.py", line 170, in runTest
self.test(*self.arg)
File "/usr/local/lib/python3.8/dist-packages/parameterized/parameterized.py", line 620, in standalone_func
return func(*(a + p.args), **p.kwargs, **kw)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sql_annotation.py", line 48, in wrapper
raise e
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sql_annotation.py", line 43, in wrapper
res = func(*args, **kwargs)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/test_sql_cases.py", line 384, in test_sql_basic
self.check(sql_id, sql, expect_res, actual_res, order, ori_sql)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sr_sql_lib.py", line 1480, in check
tools.assert_count_equal(
File "/usr/lib/python3.8/unittest/case.py", line 1272, in assertCountEqual
self.fail(msg)
File "/usr/lib/python3.8/unittest/case.py", line 753, in fail
raise self.failureException(msg)
AssertionError: Element counts were not equal:
First has 1, Second has 0: '1\tA'
First has 0, Second has 1: "E: (1064, 'Do not support get partitions from catalog type: HADOOP_CATALOG')" : sql result not match:
- [SQL]: select * from ice_hadoop07beb42d35ee41f29890b33b6120f169.ice_hadoop_db07beb42d35ee41f29890b33b6120f169.test;
- [exp]: ['1\tA']
- [act]: ["E: (1064, 'Do not support get partitions from catalog type: HADOOP_CATALOG')"]
---
[Standard Output]:
?[1;32m------------------------------------------------------------ ?[0m
?[1;32m[case name]: testIcebergHadoopCatalog ?[0m
?[1;32m[case file]: sql/test_catalog/R/test_iceberg_hadoop_catalog ?[0m
?[1;32m------------------------------------------------------------ ?[0m
→ case db: ['ice_hadoop07beb42d35ee41f29890b33b6120f169.ice_hadoop_db07beb42d35ee41f29890b33b6120f169']
→ case resource: []
[SHELL]: ossutil64 mkdir oss://${oss_bucket}/test_catalog/test_iceberg_hadoop_catalog/07beb42d35ee41f29890b33b6120f169 >/dev/null || echo "exit 0" >/dev/null
create external catalog `ice_hadoop07beb42d35ee41f29890b33b6120f169`
properties (
"type" = "iceberg",
"iceberg.catalog.type" = "hadoop",
"iceberg.catalog.warehouse"="oss://${oss_bucket}/test_catalog/test_iceberg_hadoop_catalog/07beb42d35ee41f29890b33b6120f169"
);
create database ice_hadoop07beb42d35ee41f29890b33b6120f169.ice_hadoop_db07beb42d35ee41f29890b33b6120f169;
create table ice_hadoop07beb42d35ee41f29890b33b6120f169.ice_hadoop_db07beb42d35ee41f29890b33b6120f169.test (
c0 int,
c1 string
);
insert into ice_hadoop07beb42d35ee41f29890b33b6120f169.ice_hadoop_db07beb42d35ee41f29890b33b6120f169.test values (1, "A");
select * from ice_hadoop07beb42d35ee41f29890b33b6120f169.ice_hadoop_db07beb42d35ee41f29890b33b6120f169.test;
?[1;32m******************** [FINISH] testIcebergHadoopCatalog ******************** ?[0m
Check failure on line 1 in TestSQLCases
github-actions / SQL-Tester Report
TestSQLCases.testLegacyGroupConcat
True is not false : sql result not match: actual with E(E: (1064, 'java.lang.RuntimeException: org.apache.thrift.TException: java.net.ConnectException: Connection refused (Connection refused)'))
Raw output
[Stacktrace]:
Traceback (most recent call last):
File "/usr/lib/python3.8/unittest/case.py", line 60, in testPartExecutor
yield
File "/usr/lib/python3.8/unittest/case.py", line 676, in run
self._callTestMethod(testMethod)
File "/usr/lib/python3.8/unittest/case.py", line 633, in _callTestMethod
method()
File "/usr/local/lib/python3.8/dist-packages/nose/case.py", line 170, in runTest
self.test(*self.arg)
File "/usr/local/lib/python3.8/dist-packages/parameterized/parameterized.py", line 620, in standalone_func
return func(*(a + p.args), **p.kwargs, **kw)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sql_annotation.py", line 48, in wrapper
raise e
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sql_annotation.py", line 43, in wrapper
res = func(*args, **kwargs)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/test_sql_cases.py", line 384, in test_sql_basic
self.check(sql_id, sql, expect_res, actual_res, order, ori_sql)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sr_sql_lib.py", line 1336, in check
tools.assert_false(str(act).startswith("E: "), "sql result not match: actual with E(%s)" % str(act))
File "/usr/lib/python3.8/unittest/case.py", line 759, in assertFalse
raise self.failureException(msg)
AssertionError: True is not false : sql result not match: actual with E(E: (1064, 'java.lang.RuntimeException: org.apache.thrift.TException: java.net.ConnectException: Connection refused (Connection refused)'))
[Standard Output]:
?[1;32m------------------------------------------------------------ ?[0m
?[1;32m[case name]: testLegacyGroupConcat ?[0m
?[1;32m[case file]: sql/test_agg_function/R/test_group_concat ?[0m
?[1;32m------------------------------------------------------------ ?[0m
[SQL]: CREATE DATABASE test_db_a174f1f73be546859b3fca098124f824;
[SQL]: USE test_db_a174f1f73be546859b3fca098124f824;
→ case db: ['test_db_a174f1f73be546859b3fca098124f824']
→ case resource: []
CREATE TABLE t1 (
id tinyint(4) NULL,
value varchar(65533) NULL
) ENGINE=OLAP
DISTRIBUTED BY HASH(id)
PROPERTIES (
"replication_num" = "1"
);
?[1;32m******************** [FINISH] testLegacyGroupConcat ******************** ?[0m
Check failure on line 1 in TestSQLCases
github-actions / SQL-Tester Report
TestSQLCases.testHiveSequenceFormat
Element counts were not equal:
First has 1, Second has 0: '7\t13\t74\t13000000000\t6.15\t4.376\t57.30\tworld\tChar \tVarchar\t1\t2022-01-01 10:00:00\t2022-01-01\t["A","B","C"]\t{"key2":2,"key1":1}\t{"name":"John","age":30}'
First has 0, Second has 1: "E: (1064, 'Backend node not found. Check if any backend node is down.')" : sql result not match:
- [SQL]: select * from test_hive_sequence_format where col_string = 'world';
- [exp]: ['7\t13\t74\t13000000000\t6.15\t4.376\t57.30\tworld\tChar \tVarchar\t1\t2022-01-01 10:00:00\t2022-01-01\t["A","B","C"]\t{"key2":2,"key1":1}\t{"name":"John","age":30}']
- [act]: ["E: (1064, 'Backend node not found. Check if any backend node is down.')"]
---Raw output
[Stacktrace]:
Traceback (most recent call last):
File "/usr/lib/python3.8/unittest/case.py", line 60, in testPartExecutor
yield
File "/usr/lib/python3.8/unittest/case.py", line 676, in run
self._callTestMethod(testMethod)
File "/usr/lib/python3.8/unittest/case.py", line 633, in _callTestMethod
method()
File "/usr/local/lib/python3.8/dist-packages/nose/case.py", line 170, in runTest
self.test(*self.arg)
File "/usr/local/lib/python3.8/dist-packages/parameterized/parameterized.py", line 620, in standalone_func
return func(*(a + p.args), **p.kwargs, **kw)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sql_annotation.py", line 48, in wrapper
raise e
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sql_annotation.py", line 43, in wrapper
res = func(*args, **kwargs)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/test_sql_cases.py", line 384, in test_sql_basic
self.check(sql_id, sql, expect_res, actual_res, order, ori_sql)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sr_sql_lib.py", line 1480, in check
tools.assert_count_equal(
File "/usr/lib/python3.8/unittest/case.py", line 1272, in assertCountEqual
self.fail(msg)
File "/usr/lib/python3.8/unittest/case.py", line 753, in fail
raise self.failureException(msg)
AssertionError: Element counts were not equal:
First has 1, Second has 0: '7\t13\t74\t13000000000\t6.15\t4.376\t57.30\tworld\tChar \tVarchar\t1\t2022-01-01 10:00:00\t2022-01-01\t["A","B","C"]\t{"key2":2,"key1":1}\t{"name":"John","age":30}'
First has 0, Second has 1: "E: (1064, 'Backend node not found. Check if any backend node is down.')" : sql result not match:
- [SQL]: select * from test_hive_sequence_format where col_string = 'world';
- [exp]: ['7\t13\t74\t13000000000\t6.15\t4.376\t57.30\tworld\tChar \tVarchar\t1\t2022-01-01 10:00:00\t2022-01-01\t["A","B","C"]\t{"key2":2,"key1":1}\t{"name":"John","age":30}']
- [act]: ["E: (1064, 'Backend node not found. Check if any backend node is down.')"]
---
[Standard Output]:
?[1;32m------------------------------------------------------------ ?[0m
?[1;32m[case name]: testHiveSequenceFormat ?[0m
?[1;32m[case file]: sql/test_external_file/R/test_hive_jni_format ?[0m
?[1;32m------------------------------------------------------------ ?[0m
[SQL]: CREATE DATABASE test_db_7e488d7aa71f42809a0500b9d2b0a30b;
[SQL]: USE test_db_7e488d7aa71f42809a0500b9d2b0a30b;
→ case db: ['test_db_7e488d7aa71f42809a0500b9d2b0a30b']
→ case resource: []
[SHELL]: echo "oss://${oss_bucket}/test_hive_format/c9fc5577c7af41ad999efdc492a20dcd/sequence_format/"
[SHELL]: ossutil64 mkdir oss://${oss_bucket}/test_hive_format/c9fc5577c7af41ad999efdc492a20dcd/sequence_format/ > /dev/null || echo "exit 0" >/dev/null
[SHELL]: ossutil64 cp --force ../be/test/exec/test_data/jni_scanner/test_hive_format/row_1.seq oss://${oss_bucket}/test_hive_format/c9fc5577c7af41ad999efdc492a20dcd/sequence_format/ | grep -Pv "(average|elapsed)"
[SHELL]: ossutil64 cp --force ../be/test/exec/test_data/jni_scanner/test_hive_format/row_2.seq oss://${oss_bucket}/test_hive_format/c9fc5577c7af41ad999efdc492a20dcd/sequence_format/ | grep -Pv "(average|elapsed)"
CREATE EXTERNAL TABLE test_hive_sequence_format
(
col_tinyint TINYINT,
col_smallint SMALLINT,
col_int INT,
col_bigint BIGINT,
col_float FLOAT,
col_double DOUBLE,
col_decimal DECIMAL(10,2),
col_string STRING,
col_char CHAR(10),
col_varchar VARCHAR(20),
col_boolean BOOLEAN,
col_timestamp DATETIME,
col_date DATE,
col_array ARRAY<STRING>,
col_map MAP<STRING, INT>,
col_struct STRUCT<name STRING, age INT>
)
ENGINE=file
PROPERTIES
(
"path" = "oss://${oss_bucket}/test_hive_format/c9fc5577c7af41ad999efdc492a20dcd/sequence_format/",
"format" = "sequence"
);
select * from test_hive_sequence_format where col_string = 'world';
?[1;32m******************** [FINISH] testHiveSequenceFormat ******************** ?[0m
Check failure on line 1 in TestSQLCases
github-actions / SQL-Tester Report
TestSQLCases.testExternalMysqlCaluse
True is not false : sql result not match: actual with E(E: (1064, 'A error occurred: errorCode=2001 errorMessage:Connection reset by peer, host: unknown'))
Raw output
[Stacktrace]:
Traceback (most recent call last):
File "/usr/lib/python3.8/unittest/case.py", line 60, in testPartExecutor
yield
File "/usr/lib/python3.8/unittest/case.py", line 676, in run
self._callTestMethod(testMethod)
File "/usr/lib/python3.8/unittest/case.py", line 633, in _callTestMethod
method()
File "/usr/local/lib/python3.8/dist-packages/nose/case.py", line 170, in runTest
self.test(*self.arg)
File "/usr/local/lib/python3.8/dist-packages/parameterized/parameterized.py", line 620, in standalone_func
return func(*(a + p.args), **p.kwargs, **kw)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sql_annotation.py", line 48, in wrapper
raise e
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sql_annotation.py", line 43, in wrapper
res = func(*args, **kwargs)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/test_sql_cases.py", line 384, in test_sql_basic
self.check(sql_id, sql, expect_res, actual_res, order, ori_sql)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sr_sql_lib.py", line 1336, in check
tools.assert_false(str(act).startswith("E: "), "sql result not match: actual with E(%s)" % str(act))
File "/usr/lib/python3.8/unittest/case.py", line 759, in assertFalse
raise self.failureException(msg)
AssertionError: True is not false : sql result not match: actual with E(E: (1064, 'A error occurred: errorCode=2001 errorMessage:Connection reset by peer, host: unknown'))
[Standard Output]:
?[1;32m------------------------------------------------------------ ?[0m
?[1;32m[case name]: testExternalMysqlCaluse ?[0m
?[1;32m[case file]: sql/test_external_mysql/R/test_external_mysql_clause ?[0m
?[1;32m------------------------------------------------------------ ?[0m
→ case db: ['db_57ddb43acfe34e8b972ce3b0e201c228']
→ case resource: []
create database db_57ddb43acfe34e8b972ce3b0e201c228;
use db_57ddb43acfe34e8b972ce3b0e201c228;
CREATE TABLE `t00` (
`id` int,
`s` string
) ENGINE=OLAP
DUPLICATE KEY(`id`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`id`) BUCKETS 1
PROPERTIES (
"replication_num" = "1",
"enable_persistent_index" = "false",
"replicated_storage" = "false",
"compression" = "LZ4"
);
insert into t00 values(1, "hello"), (2, "world"), (3, null);
CREATE EXTERNAL TABLE mysql_ext
(
`id` int,
`s` string
)
ENGINE=mysql
PROPERTIES
(
"host" = "172.26.190.233",
"port" = "9032",
"user" = "root",
"password" = "",
"database" = "db_57ddb43acfe34e8b972ce3b0e201c228",
"table" = "t00"
);
set cbo_derive_join_is_null_predicate = true;
select * from mysql_ext x inner join t00 on x.s = t00.s where t00.id = 3;
?[1;32m******************** [FINISH] testExternalMysqlCaluse ******************** ?[0m
Check failure on line 1 in TestSQLCases
github-actions / SQL-Tester Report
TestSQLCases.testHiveRcbinayFormat
Element counts were not equal:
First has 1, Second has 0: '7\t13\t74\t13000000000\t6.15\t4.376\t57.30\tworld\tChar \tVarchar\t1\t2022-01-01 10:00:00\t2022-01-01\t["A","B","C"]\t{"key2":2,"key1":1}\t{"name":"John","age":30}'
First has 0, Second has 1: "E: (1064, 'Backend node not found. Check if any backend node is down.')" : sql result not match:
- [SQL]: select * from test_hive_rcbinary_format where col_string = 'world';
- [exp]: ['7\t13\t74\t13000000000\t6.15\t4.376\t57.30\tworld\tChar \tVarchar\t1\t2022-01-01 10:00:00\t2022-01-01\t["A","B","C"]\t{"key2":2,"key1":1}\t{"name":"John","age":30}']
- [act]: ["E: (1064, 'Backend node not found. Check if any backend node is down.')"]
---Raw output
[Stacktrace]:
Traceback (most recent call last):
File "/usr/lib/python3.8/unittest/case.py", line 60, in testPartExecutor
yield
File "/usr/lib/python3.8/unittest/case.py", line 676, in run
self._callTestMethod(testMethod)
File "/usr/lib/python3.8/unittest/case.py", line 633, in _callTestMethod
method()
File "/usr/local/lib/python3.8/dist-packages/nose/case.py", line 170, in runTest
self.test(*self.arg)
File "/usr/local/lib/python3.8/dist-packages/parameterized/parameterized.py", line 620, in standalone_func
return func(*(a + p.args), **p.kwargs, **kw)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sql_annotation.py", line 48, in wrapper
raise e
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sql_annotation.py", line 43, in wrapper
res = func(*args, **kwargs)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/test_sql_cases.py", line 384, in test_sql_basic
self.check(sql_id, sql, expect_res, actual_res, order, ori_sql)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sr_sql_lib.py", line 1480, in check
tools.assert_count_equal(
File "/usr/lib/python3.8/unittest/case.py", line 1272, in assertCountEqual
self.fail(msg)
File "/usr/lib/python3.8/unittest/case.py", line 753, in fail
raise self.failureException(msg)
AssertionError: Element counts were not equal:
First has 1, Second has 0: '7\t13\t74\t13000000000\t6.15\t4.376\t57.30\tworld\tChar \tVarchar\t1\t2022-01-01 10:00:00\t2022-01-01\t["A","B","C"]\t{"key2":2,"key1":1}\t{"name":"John","age":30}'
First has 0, Second has 1: "E: (1064, 'Backend node not found. Check if any backend node is down.')" : sql result not match:
- [SQL]: select * from test_hive_rcbinary_format where col_string = 'world';
- [exp]: ['7\t13\t74\t13000000000\t6.15\t4.376\t57.30\tworld\tChar \tVarchar\t1\t2022-01-01 10:00:00\t2022-01-01\t["A","B","C"]\t{"key2":2,"key1":1}\t{"name":"John","age":30}']
- [act]: ["E: (1064, 'Backend node not found. Check if any backend node is down.')"]
---
[Standard Output]:
?[1;32m------------------------------------------------------------ ?[0m
?[1;32m[case name]: testHiveRcbinayFormat ?[0m
?[1;32m[case file]: sql/test_external_file/R/test_hive_jni_format ?[0m
?[1;32m------------------------------------------------------------ ?[0m
[SQL]: CREATE DATABASE test_db_e2e0af51c0c74d688ce1f09746e8f555;
[SQL]: USE test_db_e2e0af51c0c74d688ce1f09746e8f555;
→ case db: ['test_db_e2e0af51c0c74d688ce1f09746e8f555']
→ case resource: []
[SHELL]: echo "oss://${oss_bucket}/test_hive_format/36bbf61cbee344e49205fb56decded0e/rcbinary_format/"
[SHELL]: ossutil64 mkdir oss://${oss_bucket}/test_hive_format/36bbf61cbee344e49205fb56decded0e/rcbinary_format/ > /dev/null || echo "exit 0" >/dev/null
[SHELL]: ossutil64 cp --force ../be/test/exec/test_data/jni_scanner/test_hive_format/row_1.rcbinary oss://${oss_bucket}/test_hive_format/36bbf61cbee344e49205fb56decded0e/rcbinary_format/ | grep -Pv "(average|elapsed)"
[SHELL]: ossutil64 cp --force ../be/test/exec/test_data/jni_scanner/test_hive_format/row_2.rcbinary oss://${oss_bucket}/test_hive_format/36bbf61cbee344e49205fb56decded0e/rcbinary_format/ | grep -Pv "(average|elapsed)"
CREATE EXTERNAL TABLE test_hive_rcbinary_format
(
col_tinyint TINYINT,
col_smallint SMALLINT,
col_int INT,
col_bigint BIGINT,
col_float FLOAT,
col_double DOUBLE,
col_decimal DECIMAL(10,2),
col_string STRING,
col_char CHAR(10),
col_varchar VARCHAR(20),
col_boolean BOOLEAN,
col_timestamp DATETIME,
col_date DATE,
col_array ARRAY<STRING>,
col_map MAP<STRING, INT>,
col_struct STRUCT<name STRING, age INT>
)
ENGINE=file
PROPERTIES
(
"path" = "oss://${oss_bucket}/test_hive_format/36bbf61cbee344e49205fb56decded0e/rcbinary_format/",
"format" = "rcbinary"
);
select * from test_hive_rcbinary_format where col_string = 'world';
?[1;32m******************** [FINISH] testHiveRcbinayFormat ******************** ?[0m
Check failure on line 1 in TestSQLCases
github-actions / SQL-Tester Report
TestSQLCases.testMannWhitney
Element counts were not equal:
First has 1, Second has 0: '[50, 1]'
First has 0, Second has 1: "E: (1064, 'Backend node not found. Check if any backend node is down.backend: [172.26.190.236 alive: false inBlacklist: true] [172.26.190.235 alive: false inBlacklist: true] [172.26.190.234 alive: true inBlacklist: true] ')" : sql result not match:
- [SQL]: select
mann_whitney_u_test(x, t, 'two-sided', 0)
from
TABLE(generate_series(1, 10)) as numbers(x), TABLE(generate_series(0, 1)) as idx(t);
- [exp]: ['[50, 1]']
- [act]: ["E: (1064, 'Backend node not found. Check if any backend node is down.backend: [172.26.190.236 alive: false inBlacklist: true] [172.26.190.235 alive: false inBlacklist: true] [172.26.190.234 alive: true inBlacklist: true] ')"]
---Raw output
[Stacktrace]:
Traceback (most recent call last):
File "/usr/lib/python3.8/unittest/case.py", line 60, in testPartExecutor
yield
File "/usr/lib/python3.8/unittest/case.py", line 676, in run
self._callTestMethod(testMethod)
File "/usr/lib/python3.8/unittest/case.py", line 633, in _callTestMethod
method()
File "/usr/local/lib/python3.8/dist-packages/nose/case.py", line 170, in runTest
self.test(*self.arg)
File "/usr/local/lib/python3.8/dist-packages/parameterized/parameterized.py", line 620, in standalone_func
return func(*(a + p.args), **p.kwargs, **kw)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sql_annotation.py", line 48, in wrapper
raise e
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sql_annotation.py", line 43, in wrapper
res = func(*args, **kwargs)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/test_sql_cases.py", line 384, in test_sql_basic
self.check(sql_id, sql, expect_res, actual_res, order, ori_sql)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sr_sql_lib.py", line 1480, in check
tools.assert_count_equal(
File "/usr/lib/python3.8/unittest/case.py", line 1272, in assertCountEqual
self.fail(msg)
File "/usr/lib/python3.8/unittest/case.py", line 753, in fail
raise self.failureException(msg)
AssertionError: Element counts were not equal:
First has 1, Second has 0: '[50, 1]'
First has 0, Second has 1: "E: (1064, 'Backend node not found. Check if any backend node is down.backend: [172.26.190.236 alive: false inBlacklist: true] [172.26.190.235 alive: false inBlacklist: true] [172.26.190.234 alive: true inBlacklist: true] ')" : sql result not match:
- [SQL]: select
mann_whitney_u_test(x, t, 'two-sided', 0)
from
TABLE(generate_series(1, 10)) as numbers(x), TABLE(generate_series(0, 1)) as idx(t);
- [exp]: ['[50, 1]']
- [act]: ["E: (1064, 'Backend node not found. Check if any backend node is down.backend: [172.26.190.236 alive: false inBlacklist: true] [172.26.190.235 alive: false inBlacklist: true] [172.26.190.234 alive: true inBlacklist: true] ')"]
---
[Standard Output]:
?[1;32m------------------------------------------------------------ ?[0m
?[1;32m[case name]: testMannWhitney ?[0m
?[1;32m[case file]: sql/test_agg_function/R/test_mann_whitney ?[0m
?[1;32m------------------------------------------------------------ ?[0m
[SQL]: CREATE DATABASE test_db_afea1792c70d4abb9c6b12a1db21a1b6;
[SQL]: USE test_db_afea1792c70d4abb9c6b12a1db21a1b6;
→ case db: ['test_db_afea1792c70d4abb9c6b12a1db21a1b6']
→ case resource: []
select
mann_whitney_u_test(x, t, 'two-sided', 0)
from
TABLE(generate_series(1, 10)) as numbers(x), TABLE(generate_series(0, 1)) as idx(t);
?[1;32m******************** [FINISH] testMannWhitney ******************** ?[0m
Check failure on line 1 in TestSQLCases
github-actions / SQL-Tester Report
TestSQLCases.testHiveRctextFormat
Element counts were not equal:
First has 1, Second has 0: '2'
First has 0, Second has 1: "E: (1064, 'Failed to find backend to execute')" : sql result not match:
- [SQL]: select count(*) from test_hive_rctext_format;
- [exp]: ['2']
- [act]: ["E: (1064, 'Failed to find backend to execute')"]
---
Raw output
[Stacktrace]:
Traceback (most recent call last):
File "/usr/lib/python3.8/unittest/case.py", line 60, in testPartExecutor
yield
File "/usr/lib/python3.8/unittest/case.py", line 676, in run
self._callTestMethod(testMethod)
File "/usr/lib/python3.8/unittest/case.py", line 633, in _callTestMethod
method()
File "/usr/local/lib/python3.8/dist-packages/nose/case.py", line 170, in runTest
self.test(*self.arg)
File "/usr/local/lib/python3.8/dist-packages/parameterized/parameterized.py", line 620, in standalone_func
return func(*(a + p.args), **p.kwargs, **kw)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sql_annotation.py", line 48, in wrapper
raise e
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sql_annotation.py", line 43, in wrapper
res = func(*args, **kwargs)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/test_sql_cases.py", line 384, in test_sql_basic
self.check(sql_id, sql, expect_res, actual_res, order, ori_sql)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sr_sql_lib.py", line 1480, in check
tools.assert_count_equal(
File "/usr/lib/python3.8/unittest/case.py", line 1272, in assertCountEqual
self.fail(msg)
File "/usr/lib/python3.8/unittest/case.py", line 753, in fail
raise self.failureException(msg)
AssertionError: Element counts were not equal:
First has 1, Second has 0: '2'
First has 0, Second has 1: "E: (1064, 'Failed to find backend to execute')" : sql result not match:
- [SQL]: select count(*) from test_hive_rctext_format;
- [exp]: ['2']
- [act]: ["E: (1064, 'Failed to find backend to execute')"]
---
[Standard Output]:
?[1;32m------------------------------------------------------------ ?[0m
?[1;32m[case name]: testHiveRctextFormat ?[0m
?[1;32m[case file]: sql/test_external_file/R/test_hive_jni_format ?[0m
?[1;32m------------------------------------------------------------ ?[0m
[SQL]: CREATE DATABASE test_db_76df9bcedc7940b4883ecfc68a094b5e;
[SQL]: USE test_db_76df9bcedc7940b4883ecfc68a094b5e;
→ case db: ['test_db_76df9bcedc7940b4883ecfc68a094b5e']
→ case resource: []
[SHELL]: echo "oss://${oss_bucket}/test_hive_format/1a7ff7557eb7421980adbf7f12c9dfb2/rctext_format/"
[SHELL]: ossutil64 mkdir oss://${oss_bucket}/test_hive_format/1a7ff7557eb7421980adbf7f12c9dfb2/rctext_format/ > /dev/null || echo "exit 0" >/dev/null
[SHELL]: ossutil64 cp --force ../be/test/exec/test_data/jni_scanner/test_hive_format/row_1.rctext oss://${oss_bucket}/test_hive_format/1a7ff7557eb7421980adbf7f12c9dfb2/rctext_format/ | grep -Pv "(average|elapsed)"
[SHELL]: ossutil64 cp --force ../be/test/exec/test_data/jni_scanner/test_hive_format/row_2.rctext oss://${oss_bucket}/test_hive_format/1a7ff7557eb7421980adbf7f12c9dfb2/rctext_format/ | grep -Pv "(average|elapsed)"
CREATE EXTERNAL TABLE test_hive_rctext_format
(
col_tinyint TINYINT,
col_smallint SMALLINT,
col_int INT,
col_bigint BIGINT,
col_float FLOAT,
col_double DOUBLE,
col_decimal DECIMAL(10,2),
col_string STRING,
col_char CHAR(10),
col_varchar VARCHAR(20),
col_boolean BOOLEAN,
col_timestamp DATETIME,
col_date DATE,
col_array ARRAY<STRING>,
col_map MAP<STRING, INT>,
col_struct STRUCT<name STRING, age INT>
)
ENGINE=file
PROPERTIES
(
"path" = "oss://${oss_bucket}/test_hive_format/1a7ff7557eb7421980adbf7f12c9dfb2/rctext_format/",
"format" = "rctext"
);
select * from test_hive_rctext_format where col_string = 'world';
select * from test_hive_rctext_format where abs(col_float - 1.23) < 0.01 ;
select col_tinyint,col_decimal,col_array from test_hive_rctext_format;
set enable_rewrite_simple_agg_to_hdfs_scan = true;
select count(*) from test_hive_rctext_format;
?[1;32m******************** [FINISH] testHiveRctextFormat ******************** ?[0m
Check failure on line 1 in TestSQLCases
github-actions / SQL-Tester Report
TestSQLCases.testHiveAvroFormat
Element counts were not equal:
First has 1, Second has 0: '1\t2\t3\t10000000000\t1.23\t3.14\t100.50\tyou\tare \tbeautiful\t0\t2023-10-29 10:00:00\t2023-10-29\t["D","E","F"]\t{"k1":3,"k2":5}\t{"name":"chandler","age":54}'
First has 0, Second has 1: "E: (1064, 'Failed to find backend to execute')" : sql result not match:
- [SQL]: select * from test_hive_avro_format where abs(col_float - 1.23) < 0.01 ;
- [exp]: ['1\t2\t3\t10000000000\t1.23\t3.14\t100.50\tyou\tare \tbeautiful\t0\t2023-10-29 10:00:00\t2023-10-29\t["D","E","F"]\t{"k1":3,"k2":5}\t{"name":"chandler","age":54}']
- [act]: ["E: (1064, 'Failed to find backend to execute')"]
---Raw output
[Stacktrace]:
Traceback (most recent call last):
File "/usr/lib/python3.8/unittest/case.py", line 60, in testPartExecutor
yield
File "/usr/lib/python3.8/unittest/case.py", line 676, in run
self._callTestMethod(testMethod)
File "/usr/lib/python3.8/unittest/case.py", line 633, in _callTestMethod
method()
File "/usr/local/lib/python3.8/dist-packages/nose/case.py", line 170, in runTest
self.test(*self.arg)
File "/usr/local/lib/python3.8/dist-packages/parameterized/parameterized.py", line 620, in standalone_func
return func(*(a + p.args), **p.kwargs, **kw)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sql_annotation.py", line 48, in wrapper
raise e
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sql_annotation.py", line 43, in wrapper
res = func(*args, **kwargs)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/test_sql_cases.py", line 384, in test_sql_basic
self.check(sql_id, sql, expect_res, actual_res, order, ori_sql)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sr_sql_lib.py", line 1480, in check
tools.assert_count_equal(
File "/usr/lib/python3.8/unittest/case.py", line 1272, in assertCountEqual
self.fail(msg)
File "/usr/lib/python3.8/unittest/case.py", line 753, in fail
raise self.failureException(msg)
AssertionError: Element counts were not equal:
First has 1, Second has 0: '1\t2\t3\t10000000000\t1.23\t3.14\t100.50\tyou\tare \tbeautiful\t0\t2023-10-29 10:00:00\t2023-10-29\t["D","E","F"]\t{"k1":3,"k2":5}\t{"name":"chandler","age":54}'
First has 0, Second has 1: "E: (1064, 'Failed to find backend to execute')" : sql result not match:
- [SQL]: select * from test_hive_avro_format where abs(col_float - 1.23) < 0.01 ;
- [exp]: ['1\t2\t3\t10000000000\t1.23\t3.14\t100.50\tyou\tare \tbeautiful\t0\t2023-10-29 10:00:00\t2023-10-29\t["D","E","F"]\t{"k1":3,"k2":5}\t{"name":"chandler","age":54}']
- [act]: ["E: (1064, 'Failed to find backend to execute')"]
---
[Standard Output]:
?[1;32m------------------------------------------------------------ ?[0m
?[1;32m[case name]: testHiveAvroFormat ?[0m
?[1;32m[case file]: sql/test_external_file/R/test_hive_jni_format ?[0m
?[1;32m------------------------------------------------------------ ?[0m
[SQL]: CREATE DATABASE test_db_b3f7e68d4ee64a5c9ea3eaf5483a30e6;
[SQL]: USE test_db_b3f7e68d4ee64a5c9ea3eaf5483a30e6;
→ case db: ['test_db_b3f7e68d4ee64a5c9ea3eaf5483a30e6']
→ case resource: []
[SHELL]: echo "oss://${oss_bucket}/test_hive_format/fd8504d18f3f4e24a650144a81097a34/avro_format/"
[SHELL]: ossutil64 mkdir oss://${oss_bucket}/test_hive_format/fd8504d18f3f4e24a650144a81097a34/avro_format/ > /dev/null || echo "exit 0" >/dev/null
[SHELL]: ossutil64 cp --force ../be/test/exec/test_data/jni_scanner/test_hive_format/row_1.avro oss://${oss_bucket}/test_hive_format/fd8504d18f3f4e24a650144a81097a34/avro_format/ | grep -Pv "(average|elapsed)"
[SHELL]: ossutil64 cp --force ../be/test/exec/test_data/jni_scanner/test_hive_format/row_2.avro oss://${oss_bucket}/test_hive_format/fd8504d18f3f4e24a650144a81097a34/avro_format/ | grep -Pv "(average|elapsed)"
CREATE EXTERNAL TABLE test_hive_avro_format
(
col_tinyint TINYINT,
col_smallint SMALLINT,
col_int INT,
col_bigint BIGINT,
col_float FLOAT,
col_double DOUBLE,
col_decimal DECIMAL(10,2),
col_string STRING,
col_char CHAR(10),
col_varchar VARCHAR(20),
col_boolean BOOLEAN,
col_timestamp DATETIME,
col_date DATE,
col_array ARRAY<STRING>,
col_map MAP<STRING, INT>,
col_struct STRUCT<name STRING, age INT>
)
ENGINE=file
PROPERTIES
(
"path" = "oss://${oss_bucket}/test_hive_format/fd8504d18f3f4e24a650144a81097a34/avro_format/",
"format" = "avro"
);
select * from test_hive_avro_format where col_string = 'world';
select * from test_hive_avro_format where abs(col_float - 1.23) < 0.01 ;
?[1;32m******************** [FINISH] testHiveAvroFormat ******************** ?[0m
Check failure on line 1 in TestSQLCases
github-actions / SQL-Tester Report
TestSQLCases.testIcebergSinkCaseInsensitive
True is not false : sql result not match: actual with E(E: (1064, 'rpc failed with 172.26.190.234: exec rpc error. backend [id=10003] [host=172.26.190.234]'))
Raw output
[Stacktrace]:
Traceback (most recent call last):
File "/usr/lib/python3.8/unittest/case.py", line 60, in testPartExecutor
yield
File "/usr/lib/python3.8/unittest/case.py", line 676, in run
self._callTestMethod(testMethod)
File "/usr/lib/python3.8/unittest/case.py", line 633, in _callTestMethod
method()
File "/usr/local/lib/python3.8/dist-packages/nose/case.py", line 170, in runTest
self.test(*self.arg)
File "/usr/local/lib/python3.8/dist-packages/parameterized/parameterized.py", line 620, in standalone_func
return func(*(a + p.args), **p.kwargs, **kw)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sql_annotation.py", line 48, in wrapper
raise e
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sql_annotation.py", line 43, in wrapper
res = func(*args, **kwargs)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/test_sql_cases.py", line 384, in test_sql_basic
self.check(sql_id, sql, expect_res, actual_res, order, ori_sql)
File "/_work/github-runner-8zvtcrW7SFSoZ/starrocks/starrocks/test/lib/sr_sql_lib.py", line 1336, in check
tools.assert_false(str(act).startswith("E: "), "sql result not match: actual with E(%s)" % str(act))
File "/usr/lib/python3.8/unittest/case.py", line 759, in assertFalse
raise self.failureException(msg)
AssertionError: True is not false : sql result not match: actual with E(E: (1064, 'rpc failed with 172.26.190.234: exec rpc error. backend [id=10003] [host=172.26.190.234]'))
[Standard Output]:
?[1;32m------------------------------------------------------------ ?[0m
?[1;32m[case name]: testIcebergSinkCaseInsensitive ?[0m
?[1;32m[case file]: sql/test_sink/R/test_iceberg_sink ?[0m
?[1;32m------------------------------------------------------------ ?[0m
→ case db: ['ice_hadoopb8d633df04e14f1ba7ba4f64ff6d85ff.ice_hadoop_dbb8d633df04e14f1ba7ba4f64ff6d85ff']
→ case resource: []
[SHELL]: ossutil64 mkdir oss://${oss_bucket}/test_sink/test_iceberg_sink_case_insensitive/b8d633df04e14f1ba7ba4f64ff6d85ff >/dev/null || echo "exit 0" >/dev/null
create external catalog `ice_hadoopb8d633df04e14f1ba7ba4f64ff6d85ff`
properties (
"type" = "iceberg",
"iceberg.catalog.type" = "hadoop",
"iceberg.catalog.warehouse"="oss://${oss_bucket}/test_sink/test_iceberg_sink_case_insensitive/b8d633df04e14f1ba7ba4f64ff6d85ff"
);
create database ice_hadoopb8d633df04e14f1ba7ba4f64ff6d85ff.ice_hadoop_dbb8d633df04e14f1ba7ba4f64ff6d85ff;
create table ice_hadoopb8d633df04e14f1ba7ba4f64ff6d85ff.ice_hadoop_dbb8d633df04e14f1ba7ba4f64ff6d85ff.test (
C0 int,
C1 string
) partition by (C1);
insert into ice_hadoopb8d633df04e14f1ba7ba4f64ff6d85ff.ice_hadoop_dbb8d633df04e14f1ba7ba4f64ff6d85ff.test (C0, C1) values (1, "A");
?[1;32m******************** [FINISH] testIcebergSinkCaseInsensitive ******************** ?[0m
Loading