MERGE SONARCLOUD FE

[Enhancement] support alter persistent index type in shared-data pk t… #2724

Sign in to view logs

GitHub Actions / SQL-Tester Report (Release ubuntu) failed Nov 11, 2024 in 0s

778 tests run, 761 passed, 0 skipped, 17 failed.

Annotations

Check failure on line 1 in TestSQLCases

github-actions / SQL-Tester Report (Release ubuntu)

TestSQLCases.test_auto_refresh

Element counts were not equal:
First has 1, Second has 0:  '5'
First has 0, Second has 1:  '3' : sql result not match:
- [SQL]: SELECT count(*) FROM mv1;
- [exp]: ['5']
- [act]: ['3']
---

Raw output


            [Stacktrace]: 
Traceback (most recent call last):
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 60, in testPartExecutor
    yield
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 676, in run
    self._callTestMethod(testMethod)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 633, in _callTestMethod
    method()
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/nose/case.py", line 170, in runTest
    self.test(*self.arg)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/parameterized/parameterized.py", line 620, in standalone_func
    return func(*(a + p.args), **p.kwargs, **kw)
  File "/home/runner/_work/starrocks/starrocks/test/lib/sql_annotation.py", line 48, in wrapper
    raise e
  File "/home/runner/_work/starrocks/starrocks/test/lib/sql_annotation.py", line 43, in wrapper
    res = func(*args, **kwargs)
  File "/home/runner/_work/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 "/home/runner/_work/starrocks/starrocks/test/lib/sr_sql_lib.py", line 1480, in check
    tools.assert_count_equal(
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 1272, in assertCountEqual
    self.fail(msg)
  File "/root/.pyenv/versions/3.8.19/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:  '5'
First has 0, Second has 1:  '3' : sql result not match:
- [SQL]: SELECT count(*) FROM mv1;
- [exp]: ['5']
- [act]: ['3']
---

[Standard Output]: 
?[1;32m------------------------------------------------------------ ?[0m
?[1;32m[case name]: test_auto_refresh ?[0m
?[1;32m[case file]: sql/test_materialized_view/R/test_auto_refresh ?[0m
?[1;32m------------------------------------------------------------ ?[0m
	 → case db: ['db_58844ae7d71b4c6690d8827d9af4c742']
	 → case resource: []
create database db_58844ae7d71b4c6690d8827d9af4c742;
use db_58844ae7d71b4c6690d8827d9af4c742;
CREATE TABLE t1 (
    __time datetime,
    c1 int
)
PARTITION BY date_trunc('DAY', __time);
INSERT INTO t1 VALUES 
    ('2024-04-01', 1),
    ('2024-04-02', 1),
    ('2024-04-03', 1),
    ('2024-04-04', 1),
    ('2024-04-05', 1);
CREATE MATERIALIZED VIEW `mv1`
PARTITION BY (`__time`)
REFRESH ASYNC
PROPERTIES (
    "auto_refresh_partitions_limit" = "3",
    "partition_refresh_number" = "-1"
)
AS select * from t1;
[FUNCTION]: wait_mv_refresh_count('db_58844ae7d71b4c6690d8827d9af4c742', 'mv1', 1)
select count(*) from information_schema.materialized_views 
            join information_schema.task_runs using(task_name)
            where table_schema='db_58844ae7d71b4c6690d8827d9af4c742' and table_name='mv1' and (state = 'SUCCESS' or state = 'MERGED')
        
{'status': True, 'result': ((0,),), 'msg': None, 'desc': (('count(*)', 8, None, 20, 20, 0, True),)}
current refresh count is 0, expect is 1
{'status': True, 'result': ((0,),), 'msg': None, 'desc': (('count(*)', 8, None, 20, 20, 0, True),)}
current refresh count is 0, expect is 1
{'status': True, 'result': ((0,),), 'msg': None, 'desc': (('count(*)', 8, None, 20, 20, 0, True),)}
current refresh count is 0, expect is 1
{'status': True, 'result': ((1,),), 'msg': None, 'desc': (('count(*)', 8, None, 20, 20, 0, True),)}
SELECT count(*) FROM mv1;
?[1;32m******************** [FINISH] test_auto_refresh ******************** ?[0m

Check failure on line 1 in TestSQLCases

github-actions / SQL-Tester Report (Release ubuntu)

TestSQLCases.test_basic_create_index

TimedOutException: exceed the process-timeout limit!

Raw output


            [Stacktrace]: 
Traceback (most recent call last):
  File "/home/runner/_work/starrocks/starrocks/test/lib/sql_annotation.py", line 43, in wrapper
    res = func(*args, **kwargs)
  File "/home/runner/_work/starrocks/starrocks/test/test_sql_cases.py", line 369, in test_sql_basic
    actual_res, actual_res_log, var, order = self.execute_single_statement(sql, sql_id, record_mode)
  File "/home/runner/_work/starrocks/starrocks/test/lib/sr_sql_lib.py", line 1217, in execute_single_statement
    actual_res = eval("self.%s" % sql)
  File "<string>", line 1, in <module>
  File "/home/runner/_work/starrocks/starrocks/test/lib/sr_sql_lib.py", line 2064, in wait_alter_table_finish
    time.sleep(0.5)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/nose/plugins/multiprocess.py", line 204, in signalhandler
    raise TimedOutException()
nose.plugins.multiprocess.TimedOutException: 'Timed Out'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 60, in testPartExecutor
    yield
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 676, in run
    self._callTestMethod(testMethod)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 633, in _callTestMethod
    method()
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/nose/case.py", line 170, in runTest
    self.test(*self.arg)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/parameterized/parameterized.py", line 620, in standalone_func
    return func(*(a + p.args), **p.kwargs, **kw)
  File "/home/runner/_work/starrocks/starrocks/test/lib/sql_annotation.py", line 46, in wrapper
    raise AssertionError("TimedOutException: exceed the process-timeout limit!")
AssertionError: TimedOutException: exceed the process-timeout limit!

[Standard Output]: 
?[1;32m------------------------------------------------------------ ?[0m
?[1;32m[case name]: test_basic_create_index ?[0m
?[1;32m[case file]: sql/test_inverted_index/R/test_inverted_index ?[0m
?[1;32m------------------------------------------------------------ ?[0m
[SQL]: CREATE DATABASE test_db_86e6920726134aac82d3e44e7450c815;
[SQL]: USE test_db_86e6920726134aac82d3e44e7450c815;
	 → case db: ['test_db_86e6920726134aac82d3e44e7450c815']
	 → case resource: []
ADMIN SET FRONTEND CONFIG("enable_experimental_gin" = "true");
set low_cardinality_optimize_v2 = false;
set cbo_enable_low_cardinality_optimize = false;
CREATE TABLE `t_test_basic_create_index_pk` (
  `id1` bigint(20) NOT NULL COMMENT "",
  `id2` bigint(20) NOT NULL COMMENT "",
  `id3` bigint(20) NOT NULL COMMENT ""
) ENGINE=OLAP 
PRIMARY KEY(`id1`)
DISTRIBUTED BY HASH(`id1`) BUCKETS 1 
PROPERTIES (
"replication_num" = "1",
"enable_persistent_index" = "false",
"replicated_storage" = "false",
"compression" = "LZ4"
);
CREATE INDEX index_1 ON t_test_basic_create_index_pk (id2) USING BITMAP;
[FUNCTION]: wait_alter_table_finish()
CREATE INDEX index_2 ON t_test_basic_create_index_pk (id3) USING BITMAP;
[FUNCTION]: wait_alter_table_finish()
CREATE TABLE `t_test_basic_create_index_dup` (
  `id1` bigint(20) NOT NULL COMMENT "",
  `id2` bigint(20) NOT NULL COMMENT "",
  `id3` bigint(20) NOT NULL COMMENT "",
  `id4` string NOT NULL COMMENT "",
  `id5` string NOT NULL COMMENT "",
  `id6` bigint(20) NOT NULL COMMENT "",
  `id7` string NOT NULL COMMENT ""
) ENGINE=OLAP 
DUPLICATE KEY(`id1`)
DISTRIBUTED BY HASH(`id1`) BUCKETS 1 
PROPERTIES (
"replication_num" = "1",
"enable_persistent_index" = "false",
"replicated_storage" = "false",
"compression" = "LZ4"
);
CREATE INDEX index_1 ON t_test_basic_create_index_dup (id2) USING BITMAP;
[FUNCTION]: wait_alter_table_finish()
CREATE INDEX index_2 ON t_test_basic_create_index_dup (id3) USING BITMAP;
[FUNCTION]: wait_alter_table_finish()
CREATE INDEX index_3 ON t_test_basic_create_index_dup (id4) USING GIN;
[FUNCTION]: wait_alter_table_finish()
CREATE INDEX index_4 ON t_test_basic_create_index_dup (id5) USING GIN;
[FUNCTION]: wait_alter_table_finish()
?[1;32m******************** [FINISH] test_basic_create_index ******************** ?[0m

Check failure on line 1 in TestSQLCases

github-actions / SQL-Tester Report (Release ubuntu)

TestSQLCases.test_generated_column_rewrite

Element counts were not equal:
First has 1, Second has 0:  'OUTPUT EXPRS:2: g1'
First has 1, Second has 0:  ' PARTITION: UNPARTITIONED'
First has 1, Second has 0:  ' RESULT SINK'
First has 1, Second has 0:  ' 0:EMPTYSET'
First has 0, Second has 1:  'EXECUTE IN FE'
First has 0, Second has 1:  ' OUTPUT EXPRS:2: g1'
First has 0, Second has 1:  '  PARTITION: UNPARTITIONED'
First has 0, Second has 1:  '  RESULT SINK'
First has 0, Second has 1:  '  0:EMPTYSET' : sql result not match:
- [SQL]: explain select * from (select id + 1 as v from t) t2;
- [exp]: ['PLAN FRAGMENT 0', 'OUTPUT EXPRS:2: g1', ' PARTITION: UNPARTITIONED', '', ' RESULT SINK', '', ' 0:EMPTYSET']
- [act]: ['EXECUTE IN FE', 'PLAN FRAGMENT 0', ' OUTPUT EXPRS:2: g1', '  PARTITION: UNPARTITIONED', '', '  RESULT SINK', '', '  0:EMPTYSET']
---

Raw output


            [Stacktrace]: 
Traceback (most recent call last):
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 60, in testPartExecutor
    yield
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 676, in run
    self._callTestMethod(testMethod)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 633, in _callTestMethod
    method()
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/nose/case.py", line 170, in runTest
    self.test(*self.arg)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/parameterized/parameterized.py", line 620, in standalone_func
    return func(*(a + p.args), **p.kwargs, **kw)
  File "/home/runner/_work/starrocks/starrocks/test/lib/sql_annotation.py", line 48, in wrapper
    raise e
  File "/home/runner/_work/starrocks/starrocks/test/lib/sql_annotation.py", line 43, in wrapper
    res = func(*args, **kwargs)
  File "/home/runner/_work/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 "/home/runner/_work/starrocks/starrocks/test/lib/sr_sql_lib.py", line 1480, in check
    tools.assert_count_equal(
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 1272, in assertCountEqual
    self.fail(msg)
  File "/root/.pyenv/versions/3.8.19/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:  'OUTPUT EXPRS:2: g1'
First has 1, Second has 0:  ' PARTITION: UNPARTITIONED'
First has 1, Second has 0:  ' RESULT SINK'
First has 1, Second has 0:  ' 0:EMPTYSET'
First has 0, Second has 1:  'EXECUTE IN FE'
First has 0, Second has 1:  ' OUTPUT EXPRS:2: g1'
First has 0, Second has 1:  '  PARTITION: UNPARTITIONED'
First has 0, Second has 1:  '  RESULT SINK'
First has 0, Second has 1:  '  0:EMPTYSET' : sql result not match:
- [SQL]: explain select * from (select id + 1 as v from t) t2;
- [exp]: ['PLAN FRAGMENT 0', 'OUTPUT EXPRS:2: g1', ' PARTITION: UNPARTITIONED', '', ' RESULT SINK', '', ' 0:EMPTYSET']
- [act]: ['EXECUTE IN FE', 'PLAN FRAGMENT 0', ' OUTPUT EXPRS:2: g1', '  PARTITION: UNPARTITIONED', '', '  RESULT SINK', '', '  0:EMPTYSET']
---

[Standard Output]: 
?[1;32m------------------------------------------------------------ ?[0m
?[1;32m[case name]: test_generated_column_rewrite ?[0m
?[1;32m[case file]: sql/test_materialized_column/R/test_generated_column_rewrite ?[0m
?[1;32m------------------------------------------------------------ ?[0m
	 → case db: ['test_generated_column_rewrite']
	 → case resource: []
CREATE DATABASE test_generated_column_rewrite;
USE test_generated_column_rewrite;
CREATE TABLE t (id BIGINT NOT NULL, g1 bigint null as id + 1) DUPLICATE KEY (id) DISTRIBUTED BY HASH(id) BUCKETS 1 PROPERTIES("replication_num" = "1");
insert into t1 values(1);
explain select * from (select id + 1 as v from t) t2;
?[1;32m******************** [FINISH] test_generated_column_rewrite ******************** ?[0m

Check failure on line 1 in TestSQLCases

github-actions / SQL-Tester Report (Release ubuntu)

TestSQLCases.test_jvm_udf

True is not false : sql result not match: actual with E(E: (1064, "Getting syntax error at line 3, column 0. Detail message: Unexpected input 'symbol', the most similar input is {<EOF>, ';'}."))

Raw output


            [Stacktrace]: 
Traceback (most recent call last):
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 60, in testPartExecutor
    yield
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 676, in run
    self._callTestMethod(testMethod)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 633, in _callTestMethod
    method()
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/nose/case.py", line 170, in runTest
    self.test(*self.arg)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/parameterized/parameterized.py", line 620, in standalone_func
    return func(*(a + p.args), **p.kwargs, **kw)
  File "/home/runner/_work/starrocks/starrocks/test/lib/sql_annotation.py", line 48, in wrapper
    raise e
  File "/home/runner/_work/starrocks/starrocks/test/lib/sql_annotation.py", line 43, in wrapper
    res = func(*args, **kwargs)
  File "/home/runner/_work/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 "/home/runner/_work/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 "/root/.pyenv/versions/3.8.19/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, "Getting syntax error at line 3, column 0. Detail message: Unexpected input 'symbol', the most similar input is {<EOF>, ';'}."))

[Standard Output]: 
?[1;32m------------------------------------------------------------ ?[0m
?[1;32m[case name]: test_jvm_udf ?[0m
?[1;32m[case file]: sql/test_udf/R/test_jvm_udf ?[0m
?[1;32m------------------------------------------------------------ ?[0m
[SQL]: CREATE DATABASE test_db_51e66784689c4a02ac4e4a907a31773d;
[SQL]: USE test_db_51e66784689c4a02ac4e4a907a31773d;
	 → case db: ['test_db_51e66784689c4a02ac4e4a907a31773d']
	 → case resource: []
set enable_group_execution = true;
CREATE AGGREGATE FUNCTION sumbigint(bigint)
RETURNS bigint
symbol = "Sumbigint"
type = "StarrocksJar"
file = "http://starrocks-thirdparty.oss-cn-zhangjiakou.aliyuncs.com/starrocks-jdbc%2FSumbigint.jar";
?[1;32m******************** [FINISH] test_jvm_udf ******************** ?[0m

Check failure on line 1 in TestSQLCases

github-actions / SQL-Tester Report (Release ubuntu)

TestSQLCases.test_dictionary_error

TimedOutException: exceed the process-timeout limit!

Raw output


            [Stacktrace]: 
Traceback (most recent call last):
  File "/home/runner/_work/starrocks/starrocks/test/lib/sql_annotation.py", line 43, in wrapper
    res = func(*args, **kwargs)
  File "/home/runner/_work/starrocks/starrocks/test/test_sql_cases.py", line 369, in test_sql_basic
    actual_res, actual_res_log, var, order = self.execute_single_statement(sql, sql_id, record_mode)
  File "/home/runner/_work/starrocks/starrocks/test/lib/sr_sql_lib.py", line 1217, in execute_single_statement
    actual_res = eval("self.%s" % sql)
  File "<string>", line 1, in <module>
  File "/home/runner/_work/starrocks/starrocks/test/lib/sr_sql_lib.py", line 2536, in wait_refresh_dictionary_finish
    time.sleep(0.5)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/nose/plugins/multiprocess.py", line 204, in signalhandler
    raise TimedOutException()
nose.plugins.multiprocess.TimedOutException: 'Timed Out'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 60, in testPartExecutor
    yield
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 676, in run
    self._callTestMethod(testMethod)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 633, in _callTestMethod
    method()
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/nose/case.py", line 170, in runTest
    self.test(*self.arg)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/parameterized/parameterized.py", line 620, in standalone_func
    return func(*(a + p.args), **p.kwargs, **kw)
  File "/home/runner/_work/starrocks/starrocks/test/lib/sql_annotation.py", line 46, in wrapper
    raise AssertionError("TimedOutException: exceed the process-timeout limit!")
AssertionError: TimedOutException: exceed the process-timeout limit!

[Standard Output]: 
?[1;32m------------------------------------------------------------ ?[0m
?[1;32m[case name]: test_dictionary_error ?[0m
?[1;32m[case file]: sql/test_dictionary/R/test_dictionary ?[0m
?[1;32m------------------------------------------------------------ ?[0m
[SQL]: CREATE DATABASE test_db_3ffa9e057ba149699221dfa5754c68da;
[SQL]: USE test_db_3ffa9e057ba149699221dfa5754c68da;
	 → case db: ['test_db_3ffa9e057ba149699221dfa5754c68da']
	 → case resource: []
CREATE TABLE `t_dictionary_error` (
  `id1` BIGINT NOT NULL COMMENT "",
  `id2` BIGINT NOT NULL COMMENT "",
  `id3` BIGINT NOT NULL COMMENT ""
) ENGINE=OLAP 
PRIMARY KEY(`id1`)
DISTRIBUTED BY HASH(`id1`) BUCKETS 1 
PROPERTIES (
"replication_num" = "1",
"enable_persistent_index" = "false",
"replicated_storage" = "true",
"compression" = "LZ4"
);
INSERT INTO t_dictionary_error VALUES (1, 2, 3);
DROP DICTIONARY test_dictionary_error_1;
CREATE DICTIONARY test_dictionary_error_1 USING t_dictionary_error (id1 KEY, id2 VALUE);
[FUNCTION]: wait_refresh_dictionary_finish("test_dictionary_error_1", "FINISHED")
CREATE DICTIONARY test_dictionary_error_1 USING t_dictionary_error (id1 KEY, id2 VALUE);
DROP DICTIONARY test_dictionary_error_1;
DROP DICTIONARY test_dictionary_error_2;
CREATE DICTIONARY test_dictionary_error_2 USING t_dictionary_error (id1 KEY, id1 VALUE);
CREATE DICTIONARY test_dictionary_error_2 USING t_dictionary_error (id1 KEY, id2 KEY);
CREATE DICTIONARY test_dictionary_error_2 USING t_dictionary_error (id1 VALUE, id2 VALUE);
CREATE DICTIONARY test_dictionary_error_2 USING t_dictionary_error (id1 KEY, id2 VALUE)
PROPERTIES("dictionary_warm_up" = "abc", "dictionary_memory_limit" = "1024", "dictionary_refresh_interval" = "3600");
CREATE DICTIONARY test_dictionary_error_2 USING t_dictionary_error (id1 KEY, id2 VALUE)
PROPERTIES("dictionary_warm_up" = "TRUE", "dictionary_memory_limit" = "abc", "dictionary_refresh_interval" = "3600");
CREATE DICTIONARY test_dictionary_error_2 USING t_dictionary_error (id1 KEY, id2 VALUE)
PROPERTIES("dictionary_warm_up" = "TRUE", "dictionary_memory_limit" = "1024", "dictionary_refresh_interval" = "abc");
CREATE DICTIONARY test_dictionary_error_2 USING t_dictionary_error (id1 KEY, id2 VALUE)
PROPERTIES("abc" = "bcd", "dictionary_memory_limit" = "1024", "dictionary_refresh_interval" = "abc");
CREATE DICTIONARY test_dictionary_error_2 USING t_dictionary_error (id1 KEY, id2 VALUE)
PROPERTIES("dictionary_warm_up" = "abc", "abc" = "bcd", "dictionary_refresh_interval" = "3600");
CREATE DICTIONARY test_dictionary_error_2 USING t_dictionary_error (id1 KEY, id2 VALUE)
PROPERTIES("dictionary_warm_up" = "abc", "dictionary_memory_limit" = "1024", "abc" = "bcd");
CREATE DICTIONARY test_dictionary_error_2 USING t_dictionary_error (id1 KEY, id2 VALUE)
PROPERTIES("dicTionary_warM_up" = "tRue", "dictionaRy_memory_liMit" = "1024", "dictiOnary_reFResh_inTerval" = "3600");
[FUNCTION]: wait_refresh_dictionary_finish("test_dictionary_error_2", "FINISHED")
DROP DICTIONARY test_dictionary_error_2;
DROP DICTIONARY test_dictionary_error_3;
CREATE DICTIONARY test_dictionary_error_3 USING t_dictionary_error (id1 KEY, id2 VALUE)
PROPERTIES("dictionaRy_memory_liMit" = "1024");
[FUNCTION]: wait_refresh_dictionary_finish("test_dictionary_error_3", "FINISHED")
DROP DICTIONARY test_dictionary_error_3;
CREATE DICTIONARY test_dictionary_error_3 USING t_dictionary_error (id1 KEY, id2 VALUE)
PROPERTIES("dictionaRy_memory_liMit" = "1024Mb");
[FUNCTION]: wait_refresh_dictionary_finish("test_dictionary_error_3", "FINISHED")
DROP DICTIONARY test_dictionary_error_3;
CREATE DICTIONARY test_dictionary_error_3 USING t_dictionary_error (id1 KEY, id2 VALUE)
PROPERTIES("dictionaRy_memory_liMit" = "1024mB");
[FUNCTION]: wait_refresh_dictionary_finish("test_dictionary_error_3", "FINISHED")
DROP DICTIONARY test_dictionary_error_3;
CREATE DICTIONARY test_dictionary_error_3 USING t_dictionary_error (id1 KEY, id2 VALUE)
PROPERTIES("dictionaRy_memory_liMit" = "1024Gb");
[FUNCTION]: wait_refresh_dictionary_finish("test_dictionary_error_3", "FINISHED")
DROP DICTIONARY test_dictionary_error_3;
CREATE DICTIONARY test_dictionary_error_3 USING t_dictionary_error (id1 KEY, id2 VALUE)
PROPERTIES("dictionaRy_memory_liMit" = "1024GB");
[FUNCTION]: wait_refresh_dictionary_finish("test_dictionary_error_3", "FINISHED")
DROP DICTIONARY test_dictionary_error_3;
CREATE DICTIONARY test_dictionary_error_3 USING t_dictionary_error (id1 KEY, id2 VALUE)
PROPERTIES("dictionaRy_memory_liMit" = "1024b");
[FUNCTION]: wait_refresh_dictionary_finish("test_dictionary_error_3", "FINISHED")
DROP DICTIONARY test_dictionary_error_3;
CREATE DICTIONARY test_dictionary_error_3 USING t_dictionary_error (id1 KEY, id2 VALUE)
PROPERTIES("dictionaRy_memory_liMit" = "1024B");
[FUNCTION]: wait_refresh_dictionary_finish("test_dictionary_error_3", "FINISHED")
DROP DICTIONARY test_dictionary_error_3;
CREATE DICTIONARY test_dictionary_error_3 USING t_dictionary_error (id1 KEY, id2 VALUE)
PROPERTIES("dictionaRy_memory_liMit" = "1024kB");
[FUNCTION]: wait_refresh_dictionary_finish("test_dictionary_error_3", "FINISHED")
DROP DICTIONARY test_dictionary_error_3;
CREATE DICTIONARY test_dictionary_error_3 USING t_dictionary_error (id1 KEY, id2 VALUE)
PROPERTIES("dictionaRy_memory_liMit" = "1024KB");
[FUNCTION]: wait_refresh_dictionary_finish("test_dictionary_error_3", "FINISHED")
DROP DICTIONARY test_dictionary_error_3;
CREATE DICTIONARY test_dictionary_error_3 USING t_dictionary_error (id1 KEY, id2 VALUE)
PROPERTIES("dictionaRy_memory_liMit" = "1024G");
[FUNCTION]: wait_refresh_dictionary_finish("test_dictionary_error_3", "FINISHED")
DROP DICTIONARY test_dictionary_error_3;
CREATE DICTIONARY test_dictionary_error_3 USING t_dictionary_error (id1 KEY, id2 VALUE)
PROPERTIES("dictionaRy_memory_liMit" = "1024M");
[FUNCTION]: wait_refresh_dictionary_finish("test_dictionary_error_3", "FINISHED")
?[1;32m******************** [FINISH] test_dictionary_error ******************** ?[0m

Check failure on line 1 in TestSQLCases

github-actions / SQL-Tester Report (Release ubuntu)

TestSQLCases.test_mv_partition_compensate_hive

TimedOutException: exceed the process-timeout limit!

Raw output


            [Stacktrace]: 
Traceback (most recent call last):
  File "/home/runner/_work/starrocks/starrocks/test/lib/sql_annotation.py", line 43, in wrapper
    res = func(*args, **kwargs)
  File "/home/runner/_work/starrocks/starrocks/test/test_sql_cases.py", line 369, in test_sql_basic
    actual_res, actual_res_log, var, order = self.execute_single_statement(sql, sql_id, record_mode)
  File "/home/runner/_work/starrocks/starrocks/test/lib/sr_sql_lib.py", line 1235, in execute_single_statement
    actual_res = self.execute_sql(statement, conn=conn)
  File "/home/runner/_work/starrocks/starrocks/test/lib/sr_sql_lib.py", line 726, in execute_sql
    cursor.execute(sql)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/pymysql/cursors.py", line 153, in execute
    result = self._query(query)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/pymysql/cursors.py", line 322, in _query
    conn.query(q)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/pymysql/connections.py", line 563, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/pymysql/connections.py", line 825, in _read_query_result
    result.read()
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/pymysql/connections.py", line 1199, in read
    first_packet = self.connection._read_packet()
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/pymysql/connections.py", line 744, in _read_packet
    packet_header = self._read_bytes(4)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/pymysql/connections.py", line 782, in _read_bytes
    data = self._rfile.read(num_bytes)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/socket.py", line 669, in readinto
    return self._sock.recv_into(b)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/nose/plugins/multiprocess.py", line 204, in signalhandler
    raise TimedOutException()
nose.plugins.multiprocess.TimedOutException: 'Timed Out'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 60, in testPartExecutor
    yield
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 676, in run
    self._callTestMethod(testMethod)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 633, in _callTestMethod
    method()
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/nose/case.py", line 170, in runTest
    self.test(*self.arg)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/parameterized/parameterized.py", line 620, in standalone_func
    return func(*(a + p.args), **p.kwargs, **kw)
  File "/home/runner/_work/starrocks/starrocks/test/lib/sql_annotation.py", line 46, in wrapper
    raise AssertionError("TimedOutException: exceed the process-timeout limit!")
AssertionError: TimedOutException: exceed the process-timeout limit!

[Standard Output]: 
?[1;32m------------------------------------------------------------ ?[0m
?[1;32m[case name]: test_mv_partition_compensate_hive ?[0m
?[1;32m[case file]: sql/test_materialized_view/R/test_mv_partition_compensate_hive ?[0m
?[1;32m------------------------------------------------------------ ?[0m
	 → case db: ['mv_hive_db_293f431eb96c465db587798099cf288d', 'db_293f431eb96c465db587798099cf288d']
	 → case resource: []
create external catalog mv_hive_293f431eb96c465db587798099cf288d
properties
(
    "type" = "hive",
    "hive.catalog.type" = "hive",
    "hive.metastore.uris" = "thrift://172.20.190.199:9083"
);
set enable_materialized_view_transparent_union_rewrite = true;
set catalog mv_hive_293f431eb96c465db587798099cf288d;
create database mv_hive_db_293f431eb96c465db587798099cf288d;
use mv_hive_db_293f431eb96c465db587798099cf288d;
CREATE TABLE t1 (
  num int,
  dt date
)
PARTITION BY (dt);
INSERT INTO t1 VALUES 
  (1,"2020-06-15"),(2,"2020-06-18"),(3,"2020-06-21"),(4,"2020-06-24"),
  (1,"2020-07-02"),(2,"2020-07-05"),(3,"2020-07-08"),(4,"2020-07-11"),
  (1,"2020-07-16"),(2,"2020-07-19"),(3,"2020-07-22"),(4,"2020-07-25"),
  (2,"2020-06-15"),(3,"2020-06-18"),(4,"2020-06-21"),(5,"2020-06-24"),
  (2,"2020-07-02"),(3,"2020-07-05"),(4,"2020-07-08"),(5,"2020-07-11");
CREATE TABLE t2 (
  num int,
  dt string
)
PARTITION BY (dt);
INSERT INTO t2 VALUES 
  (1,"2020-06-15"),(2,"2020-06-18"),(3,"2020-06-21"),(4,"2020-06-24"),
  (1,"2020-07-02"),(2,"2020-07-05"),(3,"2020-07-08"),(4,"2020-07-11"),
  (1,"2020-07-16"),(2,"2020-07-19"),(3,"2020-07-22"),(4,"2020-07-25"),
  (2,"2020-06-15"),(3,"2020-06-18"),(4,"2020-06-21"),(5,"2020-06-24"),
  (2,"2020-07-02"),(3,"2020-07-05"),(4,"2020-07-08"),(5,"2020-07-11");
set catalog default_catalog;
create database db_293f431eb96c465db587798099cf288d;
use db_293f431eb96c465db587798099cf288d;
CREATE MATERIALIZED VIEW test_mv1 
PARTITION BY dt 
REFRESH DEFERRED MANUAL AS 
  SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 GROUP BY dt;
REFRESH MATERIALIZED VIEW test_mv1 WITH SYNC MODE;
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt !='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt>='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt>'2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt>'2020-06-15' and dt < '2020-07-22' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt>'2020-06-15' and dt <= '2020-07-22' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where (dt>'2020-06-15' and dt <= '2020-06-22') or dt>'2020-07-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt in ('2020-06-15', '2020-06-22', '2020-07-01') GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where date_trunc('day', dt) ='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where date_trunc('month', dt) ='2020-06-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where date_trunc('month', dt) ='2020-07-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 GROUP BY dt;", "test_mv1")
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt !='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt>='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt>'2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt>'2020-06-15' and dt < '2020-07-22' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt>'2020-06-15' and dt <= '2020-07-22' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where (dt>'2020-06-15' and dt <= '2020-06-22') or dt>'2020-07-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt in ('2020-06-15', '2020-06-22', '2020-07-01') GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where date_trunc('day', dt) ='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where date_trunc('month', dt) ='2020-06-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where date_trunc('month', dt) ='2020-07-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 GROUP BY dt order by dt;
INSERT INTO mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 VALUES (3, "2020-06-15");
[FUNCTION]: check_no_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_no_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where date_trunc('day', dt) ='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_no_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt in ('2020-06-15', '2020-06-22', '2020-07-01') GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where date_trunc('day', dt) ='2020-06-21' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt !='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt>'2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt>'2020-06-15' and dt < '2020-07-22' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt>'2020-06-15' and dt <= '2020-07-22' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where (dt>'2020-06-15' and dt <= '2020-06-22') or dt>'2020-07-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt in ('2020-06-21', '2020-07-25') GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where date_trunc('month', dt) ='2020-07-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt between '2020-06-16' and '2020-07-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt between '2020-06-15' and '2020-07-01' GROUP BY dt;", "test_mv1", "UNION")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt>='2020-06-15' GROUP BY dt;", "test_mv1", "UNION")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt in ('2020-06-15', '2020-06-21', '2020-07-25') GROUP BY dt;", "test_mv1", "UNION")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where date_trunc('month', dt) ='2020-06-01' GROUP BY dt;", "test_mv1", "UNION")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 GROUP BY dt;", "test_mv1", "UNION")
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt !='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt>='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt>'2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt>'2020-06-15' and dt < '2020-07-22' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt>'2020-06-15' and dt <= '2020-07-22' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where (dt>'2020-06-15' and dt <= '2020-06-22') or dt>'2020-07-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt in ('2020-06-22', '2020-07-01') GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt in ('2020-06-15', '2020-06-22', '2020-07-01') GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt between '2020-06-15' and '2020-07-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where date_trunc('day', dt) ='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where date_trunc('month', dt) ='2020-06-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where date_trunc('month', dt) ='2020-07-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 GROUP BY dt order by dt;
drop materialized view default_catalog.db_293f431eb96c465db587798099cf288d.test_mv1;
CREATE MATERIALIZED VIEW test_mv1 
PARTITION BY date_trunc('day', dt)
REFRESH DEFERRED MANUAL AS 
  SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 GROUP BY dt;
REFRESH MATERIALIZED VIEW test_mv1 WITH SYNC MODE;
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt !='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt>='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt>'2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt>'2020-06-15' and dt < '2020-07-22' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt>'2020-06-15' and dt <= '2020-07-22' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where (dt>'2020-06-15' and dt <= '2020-06-22') or dt>'2020-07-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt in ('2020-06-15', '2020-06-22', '2020-07-01') GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where date_trunc('day', dt) ='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where date_trunc('month', dt) ='2020-06-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where date_trunc('month', dt) ='2020-07-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 GROUP BY dt;", "test_mv1")
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt !='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt>='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt>'2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt>'2020-06-15' and dt < '2020-07-22' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt>'2020-06-15' and dt <= '2020-07-22' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where (dt>'2020-06-15' and dt <= '2020-06-22') or dt>'2020-07-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt in ('2020-06-15', '2020-06-22', '2020-07-01') GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where date_trunc('day', dt) ='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where date_trunc('month', dt) ='2020-06-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where date_trunc('month', dt) ='2020-07-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 GROUP BY dt order by dt;
INSERT INTO mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 VALUES (3, "2020-06-15");
[FUNCTION]: check_no_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_no_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where date_trunc('day', dt) ='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_no_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt in ('2020-06-15', '2020-06-22', '2020-07-01') GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where date_trunc('day', dt) ='2020-06-21' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt !='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt>'2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt>'2020-06-15' and dt < '2020-07-22' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt>'2020-06-15' and dt <= '2020-07-22' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where (dt>'2020-06-15' and dt <= '2020-06-22') or dt>'2020-07-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt in ('2020-06-21', '2020-07-25') GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where date_trunc('month', dt) ='2020-07-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt between '2020-06-16' and '2020-07-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt between '2020-06-15' and '2020-07-01' GROUP BY dt;", "test_mv1", "UNION")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt>='2020-06-15' GROUP BY dt;", "test_mv1", "UNION")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt in ('2020-06-15', '2020-06-21', '2020-07-25') GROUP BY dt;", "test_mv1", "UNION")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where date_trunc('month', dt) ='2020-06-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 GROUP BY dt;", "test_mv1", "UNION")
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt !='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt>='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt>'2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt>'2020-06-15' and dt < '2020-07-22' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt>'2020-06-15' and dt <= '2020-07-22' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where (dt>'2020-06-15' and dt <= '2020-06-22') or dt>'2020-07-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt in ('2020-06-22', '2020-07-01') GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt in ('2020-06-15', '2020-06-22', '2020-07-01') GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where dt between '2020-06-15' and '2020-07-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where date_trunc('day', dt) ='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where date_trunc('month', dt) ='2020-06-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 where date_trunc('month', dt) ='2020-07-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t1 GROUP BY dt order by dt;
drop materialized view default_catalog.db_293f431eb96c465db587798099cf288d.test_mv1;
CREATE MATERIALIZED VIEW test_mv1 
PARTITION BY str2date(dt, '%Y-%m-%d')
REFRESH DEFERRED MANUAL AS 
  SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 GROUP BY dt;
REFRESH MATERIALIZED VIEW test_mv1 WITH SYNC MODE;
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 where dt='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 where dt !='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 where dt>='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 where dt>'2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 where dt>'2020-06-15' and dt < '2020-07-22' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 where dt>'2020-06-15' and dt <= '2020-07-22' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 where (dt>'2020-06-15' and dt <= '2020-06-22') or dt>'2020-07-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 where dt in ('2020-06-15', '2020-06-22', '2020-07-01') GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 where date_trunc('day', dt) ='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 where date_trunc('month', dt) ='2020-06-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 where date_trunc('month', dt) ='2020-07-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 GROUP BY dt;", "test_mv1")
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 where dt='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 where dt !='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 where dt>='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 where dt>'2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 where dt>'2020-06-15' and dt < '2020-07-22' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 where dt>'2020-06-15' and dt <= '2020-07-22' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 where (dt>'2020-06-15' and dt <= '2020-06-22') or dt>'2020-07-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 where dt in ('2020-06-15', '2020-06-22', '2020-07-01') GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 where date_trunc('day', dt) ='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 where date_trunc('month', dt) ='2020-06-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 where date_trunc('month', dt) ='2020-07-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 GROUP BY dt order by dt;
INSERT INTO mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 VALUES (3, "2020-06-15");
[FUNCTION]: check_no_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 where dt='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 where date_trunc('day', dt) ='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_no_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 where dt in ('2020-06-15', '2020-06-22', '2020-07-01') GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 where date_trunc('day', dt) ='2020-06-21' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 where dt !='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 where dt>'2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 where dt>'2020-06-15' and dt < '2020-07-22' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 where dt>'2020-06-15' and dt <= '2020-07-22' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 where (dt>'2020-06-15' and dt <= '2020-06-22') or dt>'2020-07-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 where dt in ('2020-06-21', '2020-07-25') GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 where date_trunc('month', dt) ='2020-07-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 where dt between '2020-06-16' and '2020-07-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 where dt between '2020-06-15' and '2020-07-01' GROUP BY dt;", "test_mv1", "UNION")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 where dt>='2020-06-15' GROUP BY dt;", "test_mv1", "UNION")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 where dt in ('2020-06-15', '2020-06-21', '2020-07-25') GROUP BY dt;", "test_mv1", "UNION")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 where date_trunc('month', dt) ='2020-06-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 GROUP BY dt;", "test_mv1", "UNION")
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 where dt='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 where dt !='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 where dt>='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 where dt>'2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 where dt>'2020-06-15' and dt < '2020-07-22' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 where dt>'2020-06-15' and dt <= '2020-07-22' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 where (dt>'2020-06-15' and dt <= '2020-06-22') or dt>'2020-07-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 where dt in ('2020-06-22', '2020-07-01') GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 where dt in ('2020-06-15', '2020-06-22', '2020-07-01') GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 where dt between '2020-06-15' and '2020-07-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 where date_trunc('day', dt) ='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 where date_trunc('month', dt) ='2020-06-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 where date_trunc('month', dt) ='2020-07-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 GROUP BY dt order by dt;
drop materialized view default_catalog.db_293f431eb96c465db587798099cf288d.test_mv1;
CREATE MATERIALIZED VIEW test_mv1 
PARTITION BY date_trunc('day', format_dt)
REFRESH DEFERRED MANUAL AS 
  SELECT dt, str2date(dt, '%Y-%m-%d') as format_dt, sum(num) FROM mv_hive_293f431eb96c465db587798099cf288d.mv_hive_db_293f431eb96c465db587798099cf288d.t2 GROUP BY dt;
?[1;32m******************** [FINISH] test_mv_partition_compensate_hive ******************** ?[0m

Check failure on line 1 in TestSQLCases

github-actions / SQL-Tester Report (Release ubuntu)

TestSQLCases.test_mv_partition_compensate_olap

TimedOutException: exceed the process-timeout limit!

Raw output


            [Stacktrace]: 
Traceback (most recent call last):
  File "/home/runner/_work/starrocks/starrocks/test/lib/sql_annotation.py", line 43, in wrapper
    res = func(*args, **kwargs)
  File "/home/runner/_work/starrocks/starrocks/test/test_sql_cases.py", line 369, in test_sql_basic
    actual_res, actual_res_log, var, order = self.execute_single_statement(sql, sql_id, record_mode)
  File "/home/runner/_work/starrocks/starrocks/test/lib/sr_sql_lib.py", line 1217, in execute_single_statement
    actual_res = eval("self.%s" % sql)
  File "<string>", line 1, in <module>
  File "/home/runner/_work/starrocks/starrocks/test/lib/sr_sql_lib.py", line 1953, in check_hit_materialized_view
    time.sleep(1)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/nose/plugins/multiprocess.py", line 204, in signalhandler
    raise TimedOutException()
nose.plugins.multiprocess.TimedOutException: 'Timed Out'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 60, in testPartExecutor
    yield
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 676, in run
    self._callTestMethod(testMethod)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 633, in _callTestMethod
    method()
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/nose/case.py", line 170, in runTest
    self.test(*self.arg)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/parameterized/parameterized.py", line 620, in standalone_func
    return func(*(a + p.args), **p.kwargs, **kw)
  File "/home/runner/_work/starrocks/starrocks/test/lib/sql_annotation.py", line 46, in wrapper
    raise AssertionError("TimedOutException: exceed the process-timeout limit!")
AssertionError: TimedOutException: exceed the process-timeout limit!

[Standard Output]: 
?[1;32m------------------------------------------------------------ ?[0m
?[1;32m[case name]: test_mv_partition_compensate_olap ?[0m
?[1;32m[case file]: sql/test_materialized_view/R/test_mv_partition_compensate_olap ?[0m
?[1;32m------------------------------------------------------------ ?[0m
	 → case db: ['db_9375c27df50c4707aaee7f664932fb38']
	 → case resource: []
create database db_9375c27df50c4707aaee7f664932fb38;
use db_9375c27df50c4707aaee7f664932fb38;
set enable_materialized_view_transparent_union_rewrite = true;
CREATE TABLE t1 (
  num int,
  dt date
)
DUPLICATE KEY(`num`)
PARTITION BY RANGE(`dt`)
(
  PARTITION p20200615 VALUES [("2020-06-15 00:00:00"), ("2020-06-16 00:00:00")),
  PARTITION p20200618 VALUES [("2020-06-18 00:00:00"), ("2020-06-19 00:00:00")),
  PARTITION p20200621 VALUES [("2020-06-21 00:00:00"), ("2020-06-22 00:00:00")),
  PARTITION p20200624 VALUES [("2020-06-24 00:00:00"), ("2020-06-25 00:00:00")),
  PARTITION p20200702 VALUES [("2020-07-02 00:00:00"), ("2020-07-03 00:00:00")),
  PARTITION p20200705 VALUES [("2020-07-05 00:00:00"), ("2020-07-06 00:00:00")),
  PARTITION p20200708 VALUES [("2020-07-08 00:00:00"), ("2020-07-09 00:00:00")),
  PARTITION p20200716 VALUES [("2020-07-16 00:00:00"), ("2020-07-17 00:00:00")),
  PARTITION p20200719 VALUES [("2020-07-19 00:00:00"), ("2020-07-20 00:00:00")),
  PARTITION p20200722 VALUES [("2020-07-22 00:00:00"), ("2020-07-23 00:00:00")),
  PARTITION p20200725 VALUES [("2020-07-25 00:00:00"), ("2020-07-26 00:00:00")),
  PARTITION p20200711 VALUES [("2020-07-11 00:00:00"), ("2020-07-12 00:00:00"))
)
DISTRIBUTED BY HASH(`num`);
INSERT INTO t1 VALUES 
  (1,"2020-06-15"),(2,"2020-06-18"),(3,"2020-06-21"),(4,"2020-06-24"),
  (1,"2020-07-02"),(2,"2020-07-05"),(3,"2020-07-08"),(4,"2020-07-11"),
  (1,"2020-07-16"),(2,"2020-07-19"),(3,"2020-07-22"),(4,"2020-07-25"),
  (2,"2020-06-15"),(3,"2020-06-18"),(4,"2020-06-21"),(5,"2020-06-24"),
  (2,"2020-07-02"),(3,"2020-07-05"),(4,"2020-07-08"),(5,"2020-07-11");
CREATE TABLE t2 (
  num int,
  dt datetime
)
DUPLICATE KEY(`num`)
PARTITION BY RANGE(`dt`)
(
  PARTITION p20200615 VALUES [("2020-06-15 00:00:00"), ("2020-06-16 00:00:00")),
  PARTITION p20200618 VALUES [("2020-06-18 00:00:00"), ("2020-06-19 00:00:00")),
  PARTITION p20200621 VALUES [("2020-06-21 00:00:00"), ("2020-06-22 00:00:00")),
  PARTITION p20200624 VALUES [("2020-06-24 00:00:00"), ("2020-06-25 00:00:00")),
  PARTITION p20200702 VALUES [("2020-07-02 00:00:00"), ("2020-07-03 00:00:00")),
  PARTITION p20200705 VALUES [("2020-07-05 00:00:00"), ("2020-07-06 00:00:00")),
  PARTITION p20200708 VALUES [("2020-07-08 00:00:00"), ("2020-07-09 00:00:00")),
  PARTITION p20200716 VALUES [("2020-07-16 00:00:00"), ("2020-07-17 00:00:00")),
  PARTITION p20200719 VALUES [("2020-07-19 00:00:00"), ("2020-07-20 00:00:00")),
  PARTITION p20200722 VALUES [("2020-07-22 00:00:00"), ("2020-07-23 00:00:00")),
  PARTITION p20200725 VALUES [("2020-07-25 00:00:00"), ("2020-07-26 00:00:00")),
  PARTITION p20200711 VALUES [("2020-07-11 00:00:00"), ("2020-07-12 00:00:00"))
)
DISTRIBUTED BY HASH(`num`);
INSERT INTO t2 VALUES 
  (1,"2020-06-15"),(2,"2020-06-18"),(3,"2020-06-21"),(4,"2020-06-24"),
  (1,"2020-07-02"),(2,"2020-07-05"),(3,"2020-07-08"),(4,"2020-07-11"),
  (1,"2020-07-16"),(2,"2020-07-19"),(3,"2020-07-22"),(4,"2020-07-25"),
  (2,"2020-06-15"),(3,"2020-06-18"),(4,"2020-06-21"),(5,"2020-06-24"),
  (2,"2020-07-02"),(3,"2020-07-05"),(4,"2020-07-08"),(5,"2020-07-11");
CREATE TABLE t3 (
  num int,
  dt datetime
)
DUPLICATE KEY(`num`)
PARTITION BY  date_trunc('day', dt) 
DISTRIBUTED BY HASH(`num`);
INSERT INTO t3 VALUES 
  (1,"2020-06-15"),(2,"2020-06-18"),(3,"2020-06-21"),(4,"2020-06-24"),
  (1,"2020-07-02"),(2,"2020-07-05"),(3,"2020-07-08"),(4,"2020-07-11"),
  (1,"2020-07-16"),(2,"2020-07-19"),(3,"2020-07-22"),(4,"2020-07-25"),
  (2,"2020-06-15"),(3,"2020-06-18"),(4,"2020-06-21"),(5,"2020-06-24"),
  (2,"2020-07-02"),(3,"2020-07-05"),(4,"2020-07-08"),(5,"2020-07-11");
CREATE MATERIALIZED VIEW test_mv1 
PARTITION BY dt 
REFRESH DEFERRED MANUAL AS 
  SELECT dt,sum(num) FROM t1 GROUP BY dt;
REFRESH MATERIALIZED VIEW test_mv1 WITH SYNC MODE;
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t1 where dt='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t1 where dt !='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t1 where dt>='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t1 where dt>'2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t1 where dt>'2020-06-15' and dt < '2020-07-22' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t1 where dt>'2020-06-15' and dt <= '2020-07-22' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t1 where (dt>'2020-06-15' and dt <= '2020-06-22') or dt>'2020-07-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t1 where dt in ('2020-06-15', '2020-06-22', '2020-07-01') GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t1 where date_trunc('day', dt) ='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t1 where date_trunc('month', dt) ='2020-06-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t1 where date_trunc('month', dt) ='2020-07-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t1 GROUP BY dt;", "test_mv1")
SELECT dt,sum(num) FROM t1 where dt='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t1 where dt !='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t1 where dt>='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t1 where dt>'2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t1 where dt>'2020-06-15' and dt < '2020-07-22' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t1 where dt>'2020-06-15' and dt <= '2020-07-22' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t1 where (dt>'2020-06-15' and dt <= '2020-06-22') or dt>'2020-07-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t1 where dt in ('2020-06-15', '2020-06-22', '2020-07-01') GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t1 where date_trunc('day', dt) ='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t1 where date_trunc('month', dt) ='2020-06-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t1 where date_trunc('month', dt) ='2020-07-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t1 GROUP BY dt order by dt;
INSERT INTO t1 VALUES (3, "2020-06-15");
[FUNCTION]: check_no_hit_materialized_view("SELECT dt,sum(num) FROM t1 where dt='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_no_hit_materialized_view("SELECT dt,sum(num) FROM t1 where date_trunc('day', dt) ='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_no_hit_materialized_view("SELECT dt,sum(num) FROM t1 where dt in ('2020-06-15', '2020-06-22', '2020-07-01') GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t1 where date_trunc('day', dt) ='2020-06-21' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t1 where dt !='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t1 where dt>'2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t1 where dt>'2020-06-15' and dt < '2020-07-22' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t1 where dt>'2020-06-15' and dt <= '2020-07-22' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t1 where (dt>'2020-06-15' and dt <= '2020-06-22') or dt>'2020-07-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t1 where date_trunc('month', dt) ='2020-07-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t1 where dt between '2020-06-15' and '2020-07-01' GROUP BY dt;", "test_mv1", "UNION")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t1 where dt>='2020-06-15' GROUP BY dt;", "test_mv1", "UNION")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t1 where dt in ('2020-06-15', '2020-06-21', '2020-07-25') GROUP BY dt;", "test_mv1", "UNION")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t1 where date_trunc('month', dt) ='2020-06-01' GROUP BY dt;", "test_mv1", "UNION")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t1 GROUP BY dt;", "test_mv1", "UNION")
SELECT dt,sum(num) FROM t1 where dt='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t1 where dt !='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t1 where dt>='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t1 where dt>'2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t1 where dt>'2020-06-15' and dt < '2020-07-22' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t1 where dt>'2020-06-15' and dt <= '2020-07-22' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t1 where (dt>'2020-06-15' and dt <= '2020-06-22') or dt>'2020-07-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t1 where dt in ('2020-06-15', '2020-06-22', '2020-07-01') GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t1 where date_trunc('day', dt) ='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t1 where date_trunc('month', dt) ='2020-06-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t1 where date_trunc('month', dt) ='2020-07-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t1 where dt between '2020-06-15' and '2020-07-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t1 GROUP BY dt order by dt;
drop materialized view default_catalog.db_9375c27df50c4707aaee7f664932fb38.test_mv1;
CREATE MATERIALIZED VIEW test_mv1 
PARTITION BY date_trunc('day', dt)
REFRESH DEFERRED MANUAL AS 
  SELECT dt,sum(num) FROM t1 GROUP BY dt;
REFRESH MATERIALIZED VIEW test_mv1 WITH SYNC MODE;
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t1 where dt='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t1 where dt !='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t1 where dt>='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t1 where dt>'2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t1 where dt>'2020-06-15' and dt < '2020-07-22' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t1 where dt>'2020-06-15' and dt <= '2020-07-22' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t1 where (dt>'2020-06-15' and dt <= '2020-06-22') or dt>'2020-07-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t1 where dt in ('2020-06-15', '2020-06-22', '2020-07-01') GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t1 where date_trunc('day', dt) ='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t1 where date_trunc('month', dt) ='2020-06-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t1 where date_trunc('month', dt) ='2020-07-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t1 GROUP BY dt;", "test_mv1")
SELECT dt,sum(num) FROM t1 where dt='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t1 where dt !='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t1 where dt>='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t1 where dt>'2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t1 where dt>'2020-06-15' and dt < '2020-07-22' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t1 where dt>'2020-06-15' and dt <= '2020-07-22' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t1 where (dt>'2020-06-15' and dt <= '2020-06-22') or dt>'2020-07-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t1 where dt in ('2020-06-15', '2020-06-22', '2020-07-01') GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t1 where date_trunc('day', dt) ='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t1 where date_trunc('month', dt) ='2020-06-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t1 where date_trunc('month', dt) ='2020-07-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t1 GROUP BY dt order by dt;
INSERT INTO t1 VALUES (3, "2020-06-15");
[FUNCTION]: check_no_hit_materialized_view("SELECT dt,sum(num) FROM t1 where dt='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_no_hit_materialized_view("SELECT dt,sum(num) FROM t1 where date_trunc('day', dt) ='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_no_hit_materialized_view("SELECT dt,sum(num) FROM t1 where dt in ('2020-06-15', '2020-06-22', '2020-07-01') GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t1 where date_trunc('day', dt) ='2020-06-21' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t1 where dt !='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t1 where dt>'2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t1 where dt>'2020-06-15' and dt < '2020-07-22' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t1 where dt>'2020-06-15' and dt <= '2020-07-22' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t1 where (dt>'2020-06-15' and dt <= '2020-06-22') or dt>'2020-07-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t1 where date_trunc('month', dt) ='2020-07-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t1 where dt between '2020-06-15' and '2020-07-01' GROUP BY dt;", "test_mv1", "UNION")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t1 where dt>='2020-06-15' GROUP BY dt;", "test_mv1", "UNION")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t1 where dt in ('2020-06-15', '2020-06-21', '2020-07-25') GROUP BY dt;", "test_mv1", "UNION")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t1 where date_trunc('month', dt) ='2020-06-01' GROUP BY dt;", "test_mv1", "UNION")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t1 GROUP BY dt;", "test_mv1", "UNION")
SELECT dt,sum(num) FROM t1 where dt='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t1 where dt !='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t1 where dt>='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t1 where dt>'2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t1 where dt>'2020-06-15' and dt < '2020-07-22' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t1 where dt>'2020-06-15' and dt <= '2020-07-22' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t2 where (dt>'2020-06-15' and dt <= '2020-06-22') or dt>'2020-07-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t2 where dt in ('2020-06-15', '2020-06-22', '2020-07-01') GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t2 where date_trunc('day', dt) ='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t2 where date_trunc('month', dt) ='2020-06-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t2 where date_trunc('month', dt) ='2020-07-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t2 where dt between '2020-06-15' and '2020-07-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t2 GROUP BY dt order by dt;
drop materialized view default_catalog.db_9375c27df50c4707aaee7f664932fb38.test_mv1;
CREATE MATERIALIZED VIEW test_mv1 
PARTITION BY date_trunc('day', dt)
REFRESH DEFERRED MANUAL AS 
  SELECT dt,sum(num) FROM t2 GROUP BY dt;
REFRESH MATERIALIZED VIEW test_mv1 WITH SYNC MODE;
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t2 where dt='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t2 where dt !='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t2 where dt>='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t2 where dt>'2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t2 where dt>'2020-06-15' and dt < '2020-07-22' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t2 where dt>'2020-06-15' and dt <= '2020-07-22' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t2 where (dt>'2020-06-15' and dt <= '2020-06-22') or dt>'2020-07-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t2 where dt in ('2020-06-15', '2020-06-22', '2020-07-01') GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t2 where date_trunc('day', dt) ='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t2 where date_trunc('month', dt) ='2020-06-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t2 where date_trunc('month', dt) ='2020-07-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t2 GROUP BY dt;", "test_mv1")
SELECT dt,sum(num) FROM t2 where dt='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t2 where dt !='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t2 where dt>='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t2 where dt>'2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t2 where dt>'2020-06-15' and dt < '2020-07-22' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t2 where dt>'2020-06-15' and dt <= '2020-07-22' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t2 where (dt>'2020-06-15' and dt <= '2020-06-22') or dt>'2020-07-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t2 where dt in ('2020-06-15', '2020-06-22', '2020-07-01') GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t2 where date_trunc('day', dt) ='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t2 where date_trunc('month', dt) ='2020-06-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t2 where date_trunc('month', dt) ='2020-07-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t2 GROUP BY dt order by dt;
INSERT INTO t2 VALUES (3, "2020-06-15");
[FUNCTION]: check_no_hit_materialized_view("SELECT dt,sum(num) FROM t2 where dt='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_no_hit_materialized_view("SELECT dt,sum(num) FROM t2 where date_trunc('day', dt) ='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_no_hit_materialized_view("SELECT dt,sum(num) FROM t2 where dt in ('2020-06-15', '2020-06-22', '2020-07-01') GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t2 where date_trunc('day', dt) ='2020-06-21' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t2 where dt !='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t2 where dt>'2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t2 where dt>'2020-06-15' and dt < '2020-07-22' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t2 where dt>'2020-06-15' and dt <= '2020-07-22' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t2 where (dt>'2020-06-15' and dt <= '2020-06-22') or dt>'2020-07-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t2 where date_trunc('month', dt) ='2020-07-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t2 where dt between '2020-06-15' and '2020-07-01' GROUP BY dt;", "test_mv1", "UNION")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t2 where dt>='2020-06-15' GROUP BY dt;", "test_mv1", "UNION")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t2 where dt in ('2020-06-15', '2020-06-21', '2020-07-25') GROUP BY dt;", "test_mv1", "UNION")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t2 where date_trunc('month', dt) ='2020-06-01' GROUP BY dt;", "test_mv1", "UNION")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t2 GROUP BY dt;", "test_mv1", "UNION")
SELECT dt,sum(num) FROM t2 where dt='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t2 where dt !='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t2 where dt>='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t2 where dt>'2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t2 where dt>'2020-06-15' and dt < '2020-07-22' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t2 where dt>'2020-06-15' and dt <= '2020-07-22' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t2 where (dt>'2020-06-15' and dt <= '2020-06-22') or dt>'2020-07-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t2 where dt in ('2020-06-15', '2020-06-22', '2020-07-01') GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t2 where date_trunc('day', dt) ='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t2 where date_trunc('month', dt) ='2020-06-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t2 where date_trunc('month', dt) ='2020-07-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t2 where dt between '2020-06-15' and '2020-07-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM t2 GROUP BY dt order by dt;
drop materialized view default_catalog.db_9375c27df50c4707aaee7f664932fb38.test_mv1;
CREATE MATERIALIZED VIEW test_mv1 
PARTITION BY dt
REFRESH DEFERRED MANUAL AS 
  SELECT dt, date_trunc('day', dt) as format_dt,sum(num) FROM t2 GROUP BY dt;
REFRESH MATERIALIZED VIEW test_mv1 WITH SYNC MODE;
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM t2 where dt='2020-06-15' GROUP BY dt;", "test_mv1")
?[1;32m******************** [FINISH] test_mv_partition_compensate_olap ******************** ?[0m

Check failure on line 1 in TestSQLCases

github-actions / SQL-Tester Report (Release ubuntu)

TestSQLCases.test_mv_partition_union_rewrite_mode_iceberg

TimedOutException: exceed the process-timeout limit!

Raw output


            [Stacktrace]: 
Traceback (most recent call last):
  File "/home/runner/_work/starrocks/starrocks/test/lib/sql_annotation.py", line 43, in wrapper
    res = func(*args, **kwargs)
  File "/home/runner/_work/starrocks/starrocks/test/test_sql_cases.py", line 369, in test_sql_basic
    actual_res, actual_res_log, var, order = self.execute_single_statement(sql, sql_id, record_mode)
  File "/home/runner/_work/starrocks/starrocks/test/lib/sr_sql_lib.py", line 1217, in execute_single_statement
    actual_res = eval("self.%s" % sql)
  File "<string>", line 1, in <module>
  File "/home/runner/_work/starrocks/starrocks/test/lib/sr_sql_lib.py", line 1953, in check_hit_materialized_view
    time.sleep(1)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/nose/plugins/multiprocess.py", line 204, in signalhandler
    raise TimedOutException()
nose.plugins.multiprocess.TimedOutException: 'Timed Out'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 60, in testPartExecutor
    yield
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 676, in run
    self._callTestMethod(testMethod)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 633, in _callTestMethod
    method()
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/nose/case.py", line 170, in runTest
    self.test(*self.arg)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/parameterized/parameterized.py", line 620, in standalone_func
    return func(*(a + p.args), **p.kwargs, **kw)
  File "/home/runner/_work/starrocks/starrocks/test/lib/sql_annotation.py", line 46, in wrapper
    raise AssertionError("TimedOutException: exceed the process-timeout limit!")
AssertionError: TimedOutException: exceed the process-timeout limit!

[Standard Output]: 
?[1;32m------------------------------------------------------------ ?[0m
?[1;32m[case name]: test_mv_partition_union_rewrite_mode_iceberg ?[0m
?[1;32m[case file]: sql/test_materialized_view/R/test_mv_partition_union_rewrite_mode_iceberg ?[0m
?[1;32m------------------------------------------------------------ ?[0m
	 → case db: ['mv_ice_db_97dec18121624d1dbec97bd91239332f', 'db_97dec18121624d1dbec97bd91239332f']
	 → case resource: []
create external catalog mv_iceberg_97dec18121624d1dbec97bd91239332f
properties
(
    "type" = "iceberg",
    "iceberg.catalog.type" = "hive",
    "hive.metastore.uris" = "thrift://172.20.190.199:9083"
);
set new_planner_optimize_timeout=10000;
set enable_materialized_view_transparent_union_rewrite = true;
set catalog mv_iceberg_97dec18121624d1dbec97bd91239332f;
create database mv_ice_db_97dec18121624d1dbec97bd91239332f;
use mv_ice_db_97dec18121624d1dbec97bd91239332f;
CREATE TABLE t1 (
  num int,
  dt date
)
PARTITION BY (dt);
INSERT INTO t1 VALUES 
  (1,"2020-06-15"),(2,"2020-06-18"),(3,"2020-06-21"),(4,"2020-06-24"),
  (1,"2020-07-02"),(2,"2020-07-05"),(3,"2020-07-08"),(4,"2020-07-11"),
  (1,"2020-07-16"),(2,"2020-07-19"),(3,"2020-07-22"),(4,"2020-07-25"),
  (2,"2020-06-15"),(3,"2020-06-18"),(4,"2020-06-21"),(5,"2020-06-24"),
  (2,"2020-07-02"),(3,"2020-07-05"),(4,"2020-07-08"),(5,"2020-07-11");
CREATE TABLE t2 (
  num int,
  dt string
)
PARTITION BY (dt);
INSERT INTO t2 VALUES 
  (1,"2020-06-15"),(2,"2020-06-18"),(3,"2020-06-21"),(4,"2020-06-24"),
  (1,"2020-07-02"),(2,"2020-07-05"),(3,"2020-07-08"),(4,"2020-07-11"),
  (1,"2020-07-16"),(2,"2020-07-19"),(3,"2020-07-22"),(4,"2020-07-25"),
  (2,"2020-06-15"),(3,"2020-06-18"),(4,"2020-06-21"),(5,"2020-06-24"),
  (2,"2020-07-02"),(3,"2020-07-05"),(4,"2020-07-08"),(5,"2020-07-11");
set catalog default_catalog;
create database db_97dec18121624d1dbec97bd91239332f;
use db_97dec18121624d1dbec97bd91239332f;
CREATE MATERIALIZED VIEW test_mv1 
PARTITION BY dt 
REFRESH DEFERRED MANUAL AS 
  SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 GROUP BY dt;
REFRESH MATERIALIZED VIEW test_mv1 WITH SYNC MODE;
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt !='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt>='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt>'2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt>'2020-06-15' and dt < '2020-07-22' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt>'2020-06-15' and dt <= '2020-07-22' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where (dt>'2020-06-15' and dt <= '2020-06-22') or dt>'2020-07-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt in ('2020-06-15', '2020-06-22', '2020-07-01') GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where date_trunc('day', dt) ='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where date_trunc('month', dt) ='2020-06-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where date_trunc('month', dt) ='2020-07-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 GROUP BY dt;", "test_mv1")
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt !='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt>='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt>'2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt>'2020-06-15' and dt < '2020-07-22' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt>'2020-06-15' and dt <= '2020-07-22' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where (dt>'2020-06-15' and dt <= '2020-06-22') or dt>'2020-07-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt in ('2020-06-15', '2020-06-22', '2020-07-01') GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where date_trunc('day', dt) ='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where date_trunc('month', dt) ='2020-06-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where date_trunc('month', dt) ='2020-07-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 GROUP BY dt order by dt;
INSERT INTO mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 VALUES (3, "2020-06-15");
[FUNCTION]: check_no_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_no_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where date_trunc('day', dt) ='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_no_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt in ('2020-06-15', '2020-06-22', '2020-07-01') GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where date_trunc('day', dt) ='2020-06-21' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt !='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt>'2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt>'2020-06-15' and dt < '2020-07-22' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt>'2020-06-15' and dt <= '2020-07-22' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where (dt>'2020-06-15' and dt <= '2020-06-22') or dt>'2020-07-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt in ('2020-06-21', '2020-07-25') GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where date_trunc('month', dt) ='2020-07-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt between '2020-06-16' and '2020-07-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt between '2020-06-15' and '2020-07-01' GROUP BY dt;", "test_mv1", "UNION")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt>='2020-06-15' GROUP BY dt;", "test_mv1", "UNION")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt in ('2020-06-15', '2020-06-21', '2020-07-25') GROUP BY dt;", "test_mv1", "UNION")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where date_trunc('month', dt) ='2020-06-01' GROUP BY dt;", "test_mv1", "UNION")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 GROUP BY dt;", "test_mv1", "UNION")
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt !='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt>='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt>'2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt>'2020-06-15' and dt < '2020-07-22' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt>'2020-06-15' and dt <= '2020-07-22' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where (dt>'2020-06-15' and dt <= '2020-06-22') or dt>'2020-07-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt in ('2020-06-22', '2020-07-01') GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt in ('2020-06-15', '2020-06-22', '2020-07-01') GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt between '2020-06-15' and '2020-07-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where date_trunc('day', dt) ='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where date_trunc('month', dt) ='2020-06-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where date_trunc('month', dt) ='2020-07-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 GROUP BY dt order by dt;
drop materialized view default_catalog.db_97dec18121624d1dbec97bd91239332f.test_mv1;
CREATE MATERIALIZED VIEW test_mv1 
PARTITION BY date_trunc('day', dt)
REFRESH DEFERRED MANUAL AS 
  SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 GROUP BY dt;
REFRESH MATERIALIZED VIEW test_mv1 WITH SYNC MODE;
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt !='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt>='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt>'2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt>'2020-06-15' and dt < '2020-07-22' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt>'2020-06-15' and dt <= '2020-07-22' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where (dt>'2020-06-15' and dt <= '2020-06-22') or dt>'2020-07-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt in ('2020-06-15', '2020-06-22', '2020-07-01') GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where date_trunc('day', dt) ='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where date_trunc('month', dt) ='2020-06-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where date_trunc('month', dt) ='2020-07-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 GROUP BY dt;", "test_mv1")
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt !='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt>='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt>'2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt>'2020-06-15' and dt < '2020-07-22' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt>'2020-06-15' and dt <= '2020-07-22' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where (dt>'2020-06-15' and dt <= '2020-06-22') or dt>'2020-07-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt in ('2020-06-15', '2020-06-22', '2020-07-01') GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where date_trunc('day', dt) ='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where date_trunc('month', dt) ='2020-06-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where date_trunc('month', dt) ='2020-07-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 GROUP BY dt order by dt;
INSERT INTO mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 VALUES (3, "2020-06-15");
[FUNCTION]: check_no_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_no_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where date_trunc('day', dt) ='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_no_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt in ('2020-06-15', '2020-06-22', '2020-07-01') GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where date_trunc('day', dt) ='2020-06-21' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt !='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt>'2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt>'2020-06-15' and dt < '2020-07-22' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt>'2020-06-15' and dt <= '2020-07-22' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where (dt>'2020-06-15' and dt <= '2020-06-22') or dt>'2020-07-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt in ('2020-06-21', '2020-07-25') GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where date_trunc('month', dt) ='2020-07-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt between '2020-06-16' and '2020-07-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt between '2020-06-15' and '2020-07-01' GROUP BY dt;", "test_mv1", "UNION")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt>='2020-06-15' GROUP BY dt;", "test_mv1", "UNION")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt in ('2020-06-15', '2020-06-21', '2020-07-25') GROUP BY dt;", "test_mv1", "UNION")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where date_trunc('month', dt) ='2020-06-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 GROUP BY dt;", "test_mv1", "UNION")
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt !='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt>='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt>'2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt>'2020-06-15' and dt < '2020-07-22' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt>'2020-06-15' and dt <= '2020-07-22' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where (dt>'2020-06-15' and dt <= '2020-06-22') or dt>'2020-07-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt in ('2020-06-22', '2020-07-01') GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt in ('2020-06-15', '2020-06-22', '2020-07-01') GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where dt between '2020-06-15' and '2020-07-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where date_trunc('day', dt) ='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where date_trunc('month', dt) ='2020-06-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 where date_trunc('month', dt) ='2020-07-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t1 GROUP BY dt order by dt;
drop materialized view default_catalog.db_97dec18121624d1dbec97bd91239332f.test_mv1;
CREATE MATERIALIZED VIEW test_mv1 
PARTITION BY str2date(dt, '%Y-%m-%d')
REFRESH DEFERRED MANUAL AS 
  SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t2 GROUP BY dt;
REFRESH MATERIALIZED VIEW test_mv1 WITH SYNC MODE;
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t2 where dt='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t2 where dt !='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t2 where dt>='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t2 where dt>'2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t2 where dt>'2020-06-15' and dt < '2020-07-22' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t2 where dt>'2020-06-15' and dt <= '2020-07-22' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t2 where (dt>'2020-06-15' and dt <= '2020-06-22') or dt>'2020-07-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t2 where dt in ('2020-06-15', '2020-06-22', '2020-07-01') GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t2 where date_trunc('day', dt) ='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t2 where date_trunc('month', dt) ='2020-06-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t2 where date_trunc('month', dt) ='2020-07-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t2 GROUP BY dt;", "test_mv1")
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t2 where dt='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t2 where dt !='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t2 where dt>='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t2 where dt>'2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t2 where dt>'2020-06-15' and dt < '2020-07-22' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t2 where dt>'2020-06-15' and dt <= '2020-07-22' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t2 where (dt>'2020-06-15' and dt <= '2020-06-22') or dt>'2020-07-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t2 where dt in ('2020-06-15', '2020-06-22', '2020-07-01') GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t2 where date_trunc('day', dt) ='2020-06-15' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t2 where date_trunc('month', dt) ='2020-06-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t2 where date_trunc('month', dt) ='2020-07-01' GROUP BY dt order by dt;
SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t2 GROUP BY dt order by dt;
INSERT INTO mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t2 VALUES (3, "2020-06-15");
[FUNCTION]: check_no_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t2 where dt='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t2 where date_trunc('day', dt) ='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_no_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t2 where dt in ('2020-06-15', '2020-06-22', '2020-07-01') GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t2 where date_trunc('day', dt) ='2020-06-21' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t2 where dt !='2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t2 where dt>'2020-06-15' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t2 where dt>'2020-06-15' and dt < '2020-07-22' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t2 where dt>'2020-06-15' and dt <= '2020-07-22' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t2 where (dt>'2020-06-15' and dt <= '2020-06-22') or dt>'2020-07-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t2 where dt in ('2020-06-21', '2020-07-25') GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t2 where date_trunc('month', dt) ='2020-07-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t2 where dt between '2020-06-16' and '2020-07-01' GROUP BY dt;", "test_mv1")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t2 where dt between '2020-06-15' and '2020-07-01' GROUP BY dt;", "test_mv1", "UNION")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t2 where dt>='2020-06-15' GROUP BY dt;", "test_mv1", "UNION")
[FUNCTION]: check_hit_materialized_view("SELECT dt,sum(num) FROM mv_iceberg_97dec18121624d1dbec97bd91239332f.mv_ice_db_97dec18121624d1dbec97bd91239332f.t2 where dt in ('2020-06-15', '2020-06-21', '2020-07-25') GROUP BY dt;", "test_mv1", "UNION")
?[1;32m******************** [FINISH] test_mv_partition_union_rewrite_mode_iceberg ******************** ?[0m

Check failure on line 1 in TestSQLCases

github-actions / SQL-Tester Report (Release ubuntu)

TestSQLCases.test_online_optimize_table

'FINISHED' != 'CANCELLED'
- FINISHED
+ CANCELLED
 : wait alter table finish error

Raw output


            [Stacktrace]: 
Traceback (most recent call last):
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 60, in testPartExecutor
    yield
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 676, in run
    self._callTestMethod(testMethod)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 633, in _callTestMethod
    method()
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/nose/case.py", line 170, in runTest
    self.test(*self.arg)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/parameterized/parameterized.py", line 620, in standalone_func
    return func(*(a + p.args), **p.kwargs, **kw)
  File "/home/runner/_work/starrocks/starrocks/test/lib/sql_annotation.py", line 48, in wrapper
    raise e
  File "/home/runner/_work/starrocks/starrocks/test/lib/sql_annotation.py", line 43, in wrapper
    res = func(*args, **kwargs)
  File "/home/runner/_work/starrocks/starrocks/test/test_sql_cases.py", line 369, in test_sql_basic
    actual_res, actual_res_log, var, order = self.execute_single_statement(sql, sql_id, record_mode)
  File "/home/runner/_work/starrocks/starrocks/test/lib/sr_sql_lib.py", line 1217, in execute_single_statement
    actual_res = eval("self.%s" % sql)
  File "<string>", line 1, in <module>
  File "/home/runner/_work/starrocks/starrocks/test/lib/sr_sql_lib.py", line 2103, in wait_optimize_table_finish
    tools.assert_equal(expect_status, status, "wait alter table finish error")
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 912, in assertEqual
    assertion_func(first, second, msg=msg)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 1292, in assertMultiLineEqual
    self.fail(self._formatMessage(msg, standardMsg))
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 753, in fail
    raise self.failureException(msg)
AssertionError: 'FINISHED' != 'CANCELLED'
- FINISHED
+ CANCELLED
 : wait alter table finish error

[Standard Output]: 
?[1;32m------------------------------------------------------------ ?[0m
?[1;32m[case name]: test_online_optimize_table ?[0m
?[1;32m[case file]: sql/test_optimize_table/R/test_optimize_table ?[0m
?[1;32m------------------------------------------------------------ ?[0m
[SQL]: CREATE DATABASE test_db_ed1ae094ba01424f9e3e9c387fe18be4;
[SQL]: USE test_db_ed1ae094ba01424f9e3e9c387fe18be4;
	 → case db: ['test_db_ed1ae094ba01424f9e3e9c387fe18be4']
	 → case resource: []
create table t(k int, k1 date) PARTITION BY RANGE(`k1`)
(
    PARTITION `p202006` VALUES LESS THAN ("2020-07-01"),
    PARTITION `p202007` VALUES LESS THAN ("2020-08-01"),
    PARTITION `p202008` VALUES LESS THAN ("2020-09-01")
) distributed by hash(k) buckets 10;
insert into t values(1, '2020-06-01'),(2, '2020-07-01'),(3, '2020-08-01');
show create table t;
alter table t distributed by hash(k);
insert into t values(4, '2020-06-01'),(5, '2020-07-01'),(6, '2020-08-01');
select sleep(1);
insert into t values(4, '2020-06-01'),(5, '2020-07-01'),(6, '2020-08-01');
select sleep(1);
insert into t values(4, '2020-06-01'),(5, '2020-07-01'),(6, '2020-08-01');
select sleep(1);
insert into t values(4, '2020-06-01'),(5, '2020-07-01'),(6, '2020-08-01');
select sleep(1);
insert into t values(4, '2020-06-01'),(5, '2020-07-01'),(6, '2020-08-01');
select sleep(1);
insert into t values(4, '2020-06-01'),(5, '2020-07-01'),(6, '2020-08-01');
select sleep(1);
insert into t values(4, '2020-06-01'),(5, '2020-07-01'),(6, '2020-08-01');
select sleep(1);
insert into t values(4, '2020-06-01'),(5, '2020-07-01'),(6, '2020-08-01');
select sleep(1);
insert into t values(4, '2020-06-01'),(5, '2020-07-01'),(6, '2020-08-01');
select sleep(1);
insert into t values(4, '2020-06-01'),(5, '2020-07-01'),(6, '2020-08-01');
select sleep(1);
insert into t values(4, '2020-06-01'),(5, '2020-07-01'),(6, '2020-08-01');
select sleep(1);
insert into t values(4, '2020-06-01'),(5, '2020-07-01'),(6, '2020-08-01');
select sleep(1);
insert into t values(4, '2020-06-01'),(5, '2020-07-01'),(6, '2020-08-01');
select sleep(1);
insert into t values(4, '2020-06-01'),(5, '2020-07-01'),(6, '2020-08-01');
select sleep(1);
insert into t values(4, '2020-06-01'),(5, '2020-07-01'),(6, '2020-08-01');
select sleep(1);
insert into t values(4, '2020-06-01'),(5, '2020-07-01'),(6, '2020-08-01');
select sleep(1);
insert into t values(4, '2020-06-01'),(5, '2020-07-01'),(6, '2020-08-01');
select sleep(1);
insert into t values(4, '2020-06-01'),(5, '2020-07-01'),(6, '2020-08-01');
select sleep(1);
insert into t values(4, '2020-06-01'),(5, '2020-07-01'),(6, '2020-08-01');
select sleep(1);
insert into t values(4, '2020-06-01'),(5, '2020-07-01'),(6, '2020-08-01');
select sleep(1);
select count(*) from t;
[FUNCTION]: wait_optimize_table_finish()
?[1;32m******************** [FINISH] test_online_optimize_table ******************** ?[0m

Check failure on line 1 in TestSQLCases

github-actions / SQL-Tester Report (Release ubuntu)

TestSQLCases.test_online_optimize_table_pk

'FINISHED' != 'CANCELLED'
- FINISHED
+ CANCELLED
 : wait alter table finish error

Raw output


            [Stacktrace]: 
Traceback (most recent call last):
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 60, in testPartExecutor
    yield
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 676, in run
    self._callTestMethod(testMethod)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 633, in _callTestMethod
    method()
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/nose/case.py", line 170, in runTest
    self.test(*self.arg)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/parameterized/parameterized.py", line 620, in standalone_func
    return func(*(a + p.args), **p.kwargs, **kw)
  File "/home/runner/_work/starrocks/starrocks/test/lib/sql_annotation.py", line 48, in wrapper
    raise e
  File "/home/runner/_work/starrocks/starrocks/test/lib/sql_annotation.py", line 43, in wrapper
    res = func(*args, **kwargs)
  File "/home/runner/_work/starrocks/starrocks/test/test_sql_cases.py", line 369, in test_sql_basic
    actual_res, actual_res_log, var, order = self.execute_single_statement(sql, sql_id, record_mode)
  File "/home/runner/_work/starrocks/starrocks/test/lib/sr_sql_lib.py", line 1217, in execute_single_statement
    actual_res = eval("self.%s" % sql)
  File "<string>", line 1, in <module>
  File "/home/runner/_work/starrocks/starrocks/test/lib/sr_sql_lib.py", line 2103, in wait_optimize_table_finish
    tools.assert_equal(expect_status, status, "wait alter table finish error")
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 912, in assertEqual
    assertion_func(first, second, msg=msg)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 1292, in assertMultiLineEqual
    self.fail(self._formatMessage(msg, standardMsg))
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 753, in fail
    raise self.failureException(msg)
AssertionError: 'FINISHED' != 'CANCELLED'
- FINISHED
+ CANCELLED
 : wait alter table finish error

[Standard Output]: 
?[1;32m------------------------------------------------------------ ?[0m
?[1;32m[case name]: test_online_optimize_table_pk ?[0m
?[1;32m[case file]: sql/test_optimize_table/R/test_optimize_table ?[0m
?[1;32m------------------------------------------------------------ ?[0m
[SQL]: CREATE DATABASE test_db_749b51746f834e7d9c86c9eac85706e7;
[SQL]: USE test_db_749b51746f834e7d9c86c9eac85706e7;
	 → case db: ['test_db_749b51746f834e7d9c86c9eac85706e7']
	 → case resource: []
create table t(k int) primary key(k) distributed by hash(k) buckets 10;
show create table t;
insert into t values(1);
alter table t distributed by hash(k);
insert into t values(2);
select sleep(1);
insert into t values(3);
select sleep(1);
insert into t values(4);
select sleep(1);
insert into t values(5);
select sleep(1);
insert into t values(6);
select sleep(1);
insert into t values(7);
select sleep(1);
insert into t values(8);
select sleep(1);
insert into t values(9);
select sleep(1);
insert into t values(10);
select sleep(1);
insert into t values(11);
select sleep(1);
insert into t values(12);
select sleep(1);
insert into t values(13);
select sleep(1);
insert into t values(14);
select sleep(1);
insert into t values(15);
select sleep(1);
insert into t values(16);
select sleep(1);
insert into t values(17);
select sleep(1);
insert into t values(18);
select sleep(1);
insert into t values(19);
select sleep(1);
insert into t values(20);
select * from t;
[FUNCTION]: wait_optimize_table_finish()
?[1;32m******************** [FINISH] test_online_optimize_table_pk ******************** ?[0m

Check failure on line 1 in TestSQLCases

github-actions / SQL-Tester Report (Release ubuntu)

TestSQLCases.test_online_optimize_table_stream_load

'FINISHED' != 'CANCELLED'
- FINISHED
+ CANCELLED
 : wait alter table finish error

Raw output


            [Stacktrace]: 
Traceback (most recent call last):
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 60, in testPartExecutor
    yield
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 676, in run
    self._callTestMethod(testMethod)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 633, in _callTestMethod
    method()
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/nose/case.py", line 170, in runTest
    self.test(*self.arg)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/parameterized/parameterized.py", line 620, in standalone_func
    return func(*(a + p.args), **p.kwargs, **kw)
  File "/home/runner/_work/starrocks/starrocks/test/lib/sql_annotation.py", line 48, in wrapper
    raise e
  File "/home/runner/_work/starrocks/starrocks/test/lib/sql_annotation.py", line 43, in wrapper
    res = func(*args, **kwargs)
  File "/home/runner/_work/starrocks/starrocks/test/test_sql_cases.py", line 369, in test_sql_basic
    actual_res, actual_res_log, var, order = self.execute_single_statement(sql, sql_id, record_mode)
  File "/home/runner/_work/starrocks/starrocks/test/lib/sr_sql_lib.py", line 1217, in execute_single_statement
    actual_res = eval("self.%s" % sql)
  File "<string>", line 1, in <module>
  File "/home/runner/_work/starrocks/starrocks/test/lib/sr_sql_lib.py", line 2103, in wait_optimize_table_finish
    tools.assert_equal(expect_status, status, "wait alter table finish error")
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 912, in assertEqual
    assertion_func(first, second, msg=msg)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 1292, in assertMultiLineEqual
    self.fail(self._formatMessage(msg, standardMsg))
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 753, in fail
    raise self.failureException(msg)
AssertionError: 'FINISHED' != 'CANCELLED'
- FINISHED
+ CANCELLED
 : wait alter table finish error

[Standard Output]: 
?[1;32m------------------------------------------------------------ ?[0m
?[1;32m[case name]: test_online_optimize_table_stream_load ?[0m
?[1;32m[case file]: sql/test_optimize_table/R/test_optimize_table ?[0m
?[1;32m------------------------------------------------------------ ?[0m
	 → case db: ['db_ff5e09814aa74027a37c2378d1a4781b']
	 → case resource: []
create database db_ff5e09814aa74027a37c2378d1a4781b;
use db_ff5e09814aa74027a37c2378d1a4781b;
create table t(k int, k1 date) PARTITION BY RANGE(`k1`)
(
    PARTITION `p202006` VALUES LESS THAN ("2020-07-01"),
    PARTITION `p202007` VALUES LESS THAN ("2020-08-01"),
    PARTITION `p202008` VALUES LESS THAN ("2020-09-01")
) distributed by hash(k) buckets 10;
insert into t values(1, '2020-06-01'),(2, '2020-07-01'),(3, '2020-08-01');
show create table t;
alter table t distributed by hash(k);
[SHELL]: curl --location-trusted -u root: -T /home/runner/_work/starrocks/starrocks/test/lib/../common/data/stream_load/sr_8486.csv -XPUT http://172.21.245.61:8034/api/db_ff5e09814aa74027a37c2378d1a4781b/t/_stream_load
select sleep(1);
[SHELL]: curl --location-trusted -u root: -T /home/runner/_work/starrocks/starrocks/test/lib/../common/data/stream_load/sr_8486.csv -XPUT http://172.21.245.61:8034/api/db_ff5e09814aa74027a37c2378d1a4781b/t/_stream_load
select sleep(1);
[SHELL]: curl --location-trusted -u root: -T /home/runner/_work/starrocks/starrocks/test/lib/../common/data/stream_load/sr_8486.csv -XPUT http://172.21.245.61:8034/api/db_ff5e09814aa74027a37c2378d1a4781b/t/_stream_load
select sleep(1);
[SHELL]: curl --location-trusted -u root: -T /home/runner/_work/starrocks/starrocks/test/lib/../common/data/stream_load/sr_8486.csv -XPUT http://172.21.245.61:8034/api/db_ff5e09814aa74027a37c2378d1a4781b/t/_stream_load
select sleep(1);
[SHELL]: curl --location-trusted -u root: -T /home/runner/_work/starrocks/starrocks/test/lib/../common/data/stream_load/sr_8486.csv -XPUT http://172.21.245.61:8034/api/db_ff5e09814aa74027a37c2378d1a4781b/t/_stream_load
select sleep(1);
[SHELL]: curl --location-trusted -u root: -T /home/runner/_work/starrocks/starrocks/test/lib/../common/data/stream_load/sr_8486.csv -XPUT http://172.21.245.61:8034/api/db_ff5e09814aa74027a37c2378d1a4781b/t/_stream_load
select sleep(1);
[SHELL]: curl --location-trusted -u root: -T /home/runner/_work/starrocks/starrocks/test/lib/../common/data/stream_load/sr_8486.csv -XPUT http://172.21.245.61:8034/api/db_ff5e09814aa74027a37c2378d1a4781b/t/_stream_load
select sleep(1);
[SHELL]: curl --location-trusted -u root: -T /home/runner/_work/starrocks/starrocks/test/lib/../common/data/stream_load/sr_8486.csv -XPUT http://172.21.245.61:8034/api/db_ff5e09814aa74027a37c2378d1a4781b/t/_stream_load
select sleep(1);
[SHELL]: curl --location-trusted -u root: -T /home/runner/_work/starrocks/starrocks/test/lib/../common/data/stream_load/sr_8486.csv -XPUT http://172.21.245.61:8034/api/db_ff5e09814aa74027a37c2378d1a4781b/t/_stream_load
select sleep(1);
[SHELL]: curl --location-trusted -u root: -T /home/runner/_work/starrocks/starrocks/test/lib/../common/data/stream_load/sr_8486.csv -XPUT http://172.21.245.61:8034/api/db_ff5e09814aa74027a37c2378d1a4781b/t/_stream_load
select sleep(1);
[SHELL]: curl --location-trusted -u root: -T /home/runner/_work/starrocks/starrocks/test/lib/../common/data/stream_load/sr_8486.csv -XPUT http://172.21.245.61:8034/api/db_ff5e09814aa74027a37c2378d1a4781b/t/_stream_load
select sleep(1);
[SHELL]: curl --location-trusted -u root: -T /home/runner/_work/starrocks/starrocks/test/lib/../common/data/stream_load/sr_8486.csv -XPUT http://172.21.245.61:8034/api/db_ff5e09814aa74027a37c2378d1a4781b/t/_stream_load
select sleep(1);
[SHELL]: curl --location-trusted -u root: -T /home/runner/_work/starrocks/starrocks/test/lib/../common/data/stream_load/sr_8486.csv -XPUT http://172.21.245.61:8034/api/db_ff5e09814aa74027a37c2378d1a4781b/t/_stream_load
select sleep(1);
[SHELL]: curl --location-trusted -u root: -T /home/runner/_work/starrocks/starrocks/test/lib/../common/data/stream_load/sr_8486.csv -XPUT http://172.21.245.61:8034/api/db_ff5e09814aa74027a37c2378d1a4781b/t/_stream_load
select sleep(1);
[SHELL]: curl --location-trusted -u root: -T /home/runner/_work/starrocks/starrocks/test/lib/../common/data/stream_load/sr_8486.csv -XPUT http://172.21.245.61:8034/api/db_ff5e09814aa74027a37c2378d1a4781b/t/_stream_load
select sleep(1);
[SHELL]: curl --location-trusted -u root: -T /home/runner/_work/starrocks/starrocks/test/lib/../common/data/stream_load/sr_8486.csv -XPUT http://172.21.245.61:8034/api/db_ff5e09814aa74027a37c2378d1a4781b/t/_stream_load
select sleep(1);
[SHELL]: curl --location-trusted -u root: -T /home/runner/_work/starrocks/starrocks/test/lib/../common/data/stream_load/sr_8486.csv -XPUT http://172.21.245.61:8034/api/db_ff5e09814aa74027a37c2378d1a4781b/t/_stream_load
select sleep(1);
[SHELL]: curl --location-trusted -u root: -T /home/runner/_work/starrocks/starrocks/test/lib/../common/data/stream_load/sr_8486.csv -XPUT http://172.21.245.61:8034/api/db_ff5e09814aa74027a37c2378d1a4781b/t/_stream_load
select sleep(1);
[SHELL]: curl --location-trusted -u root: -T /home/runner/_work/starrocks/starrocks/test/lib/../common/data/stream_load/sr_8486.csv -XPUT http://172.21.245.61:8034/api/db_ff5e09814aa74027a37c2378d1a4781b/t/_stream_load
select sleep(1);
[SHELL]: curl --location-trusted -u root: -T /home/runner/_work/starrocks/starrocks/test/lib/../common/data/stream_load/sr_8486.csv -XPUT http://172.21.245.61:8034/api/db_ff5e09814aa74027a37c2378d1a4781b/t/_stream_load
select sleep(1);
select count(*) from t;
[FUNCTION]: wait_optimize_table_finish()
?[1;32m******************** [FINISH] test_online_optimize_table_stream_load ******************** ?[0m

Check failure on line 1 in TestSQLCases

github-actions / SQL-Tester Report (Release ubuntu)

TestSQLCases.test_online_optimize_table_expr_partition

Element counts were not equal:
First has 1, Second has 0:  'DISTRIBUTED BY HASH(`k`)'
First has 0, Second has 1:  'DISTRIBUTED BY HASH(`k`) BUCKETS 10 ' : sql result not match:
- [SQL]: show create table t;
- [exp]: ['t\tCREATE TABLE `t` (', '  `k` int(11) NULL COMMENT "",', '  `k1` date NULL COMMENT ""', ') ENGINE=OLAP ', 'DUPLICATE KEY(`k`, `k1`)', "PARTITION BY date_trunc('day', k1)", 'DISTRIBUTED BY HASH(`k`)', 'PROPERTIES (', '"compression" = "LZ4",', '"fast_schema_evolution" = "true",', '"replicated_storage" = "true",', '"replication_num" = "3"', ');']
- [act]: ['t\tCREATE TABLE `t` (', '  `k` int(11) NULL COMMENT "",', '  `k1` date NULL COMMENT ""', ') ENGINE=OLAP ', 'DUPLICATE KEY(`k`, `k1`)', "PARTITION BY date_trunc('day', k1)", 'DISTRIBUTED BY HASH(`k`) BUCKETS 10 ', 'PROPERTIES (', '"compression" = "LZ4",', '"fast_schema_evolution" = "true",', '"replicated_storage" = "true",', '"replication_num" = "3"', ');']
---

Raw output


            [Stacktrace]: 
Traceback (most recent call last):
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 60, in testPartExecutor
    yield
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 676, in run
    self._callTestMethod(testMethod)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 633, in _callTestMethod
    method()
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/nose/case.py", line 170, in runTest
    self.test(*self.arg)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/parameterized/parameterized.py", line 620, in standalone_func
    return func(*(a + p.args), **p.kwargs, **kw)
  File "/home/runner/_work/starrocks/starrocks/test/lib/sql_annotation.py", line 48, in wrapper
    raise e
  File "/home/runner/_work/starrocks/starrocks/test/lib/sql_annotation.py", line 43, in wrapper
    res = func(*args, **kwargs)
  File "/home/runner/_work/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 "/home/runner/_work/starrocks/starrocks/test/lib/sr_sql_lib.py", line 1480, in check
    tools.assert_count_equal(
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 1272, in assertCountEqual
    self.fail(msg)
  File "/root/.pyenv/versions/3.8.19/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:  'DISTRIBUTED BY HASH(`k`)'
First has 0, Second has 1:  'DISTRIBUTED BY HASH(`k`) BUCKETS 10 ' : sql result not match:
- [SQL]: show create table t;
- [exp]: ['t\tCREATE TABLE `t` (', '  `k` int(11) NULL COMMENT "",', '  `k1` date NULL COMMENT ""', ') ENGINE=OLAP ', 'DUPLICATE KEY(`k`, `k1`)', "PARTITION BY date_trunc('day', k1)", 'DISTRIBUTED BY HASH(`k`)', 'PROPERTIES (', '"compression" = "LZ4",', '"fast_schema_evolution" = "true",', '"replicated_storage" = "true",', '"replication_num" = "3"', ');']
- [act]: ['t\tCREATE TABLE `t` (', '  `k` int(11) NULL COMMENT "",', '  `k1` date NULL COMMENT ""', ') ENGINE=OLAP ', 'DUPLICATE KEY(`k`, `k1`)', "PARTITION BY date_trunc('day', k1)", 'DISTRIBUTED BY HASH(`k`) BUCKETS 10 ', 'PROPERTIES (', '"compression" = "LZ4",', '"fast_schema_evolution" = "true",', '"replicated_storage" = "true",', '"replication_num" = "3"', ');']
---

[Standard Output]: 
?[1;32m------------------------------------------------------------ ?[0m
?[1;32m[case name]: test_online_optimize_table_expr_partition ?[0m
?[1;32m[case file]: sql/test_optimize_table/R/test_optimize_table ?[0m
?[1;32m------------------------------------------------------------ ?[0m
[SQL]: CREATE DATABASE test_db_80db6a89cae644a88fc1135d45cb9f6c;
[SQL]: USE test_db_80db6a89cae644a88fc1135d45cb9f6c;
	 → case db: ['test_db_80db6a89cae644a88fc1135d45cb9f6c']
	 → case resource: []
create table t(k int, k1 date) PARTITION BY date_trunc('day', k1)
distributed by hash(k) buckets 10;
insert into t values(1, '2020-06-01'),(2, '2020-07-01'),(3, '2020-08-01');
show create table t;
alter table t distributed by hash(k);
insert into t values(4, '2020-06-01'),(5, '2020-07-01'),(6, '2020-08-01');
select sleep(1);
insert into t values(4, '2020-06-01'),(5, '2020-07-01'),(6, '2020-08-01');
select sleep(1);
insert into t values(4, '2020-06-02'),(5, '2020-07-01'),(6, '2020-08-02');
select sleep(1);
insert into t values(4, '2020-06-01'),(5, '2020-07-02'),(6, '2020-08-02');
select sleep(1);
insert into t values(4, '2020-06-03'),(5, '2020-07-01'),(6, '2020-08-03');
select sleep(1);
insert into t values(4, '2020-06-01'),(5, '2020-07-03'),(6, '2020-08-03');
select sleep(1);
insert into t values(4, '2020-06-01'),(5, '2020-07-01'),(6, '2020-08-04');
select sleep(1);
insert into t values(4, '2020-06-04'),(5, '2020-07-04'),(6, '2020-08-04');
select sleep(1);
insert into t values(4, '2020-06-05'),(5, '2020-07-01'),(6, '2020-08-05');
select sleep(1);
insert into t values(4, '2020-06-01'),(5, '2020-07-05'),(6, '2020-08-05');
select sleep(1);
insert into t values(4, '2020-06-06'),(5, '2020-07-06'),(6, '2020-08-06');
select sleep(1);
insert into t values(4, '2020-06-01'),(5, '2020-07-01'),(6, '2020-08-06');
select sleep(1);
insert into t values(4, '2020-06-07'),(5, '2020-07-01'),(6, '2020-08-07');
select sleep(1);
insert into t values(4, '2020-06-07'),(5, '2020-07-07'),(6, '2020-08-07');
select sleep(1);
insert into t values(4, '2020-06-03'),(5, '2020-07-01'),(6, '2020-08-04');
select sleep(1);
insert into t values(4, '2020-06-03'),(5, '2020-07-01'),(6, '2020-08-04');
select sleep(1);
insert into t values(4, '2020-06-04'),(5, '2020-07-01'),(6, '2020-08-06');
select sleep(1);
insert into t values(4, '2020-06-04'),(5, '2020-07-01'),(6, '2020-08-06');
select sleep(1);
insert into t values(4, '2020-06-10'),(5, '2020-07-10'),(6, '2020-08-10');
select sleep(1);
insert into t values(4, '2020-06-10'),(5, '2020-07-10'),(6, '2020-08-10');
select sleep(1);
select count(*) from t;
[FUNCTION]: wait_optimize_table_finish()
show create table t;
?[1;32m******************** [FINISH] test_online_optimize_table_expr_partition ******************** ?[0m

Check failure on line 1 in TestSQLCases

github-actions / SQL-Tester Report (Release ubuntu)

TestSQLCases.test_nest_loop_join

TimedOutException: exceed the process-timeout limit!

Raw output


            [Stacktrace]: 
Traceback (most recent call last):
  File "/home/runner/_work/starrocks/starrocks/test/lib/sql_annotation.py", line 43, in wrapper
    res = func(*args, **kwargs)
  File "/home/runner/_work/starrocks/starrocks/test/test_sql_cases.py", line 369, in test_sql_basic
    actual_res, actual_res_log, var, order = self.execute_single_statement(sql, sql_id, record_mode)
  File "/home/runner/_work/starrocks/starrocks/test/lib/sr_sql_lib.py", line 1235, in execute_single_statement
    actual_res = self.execute_sql(statement, conn=conn)
  File "/home/runner/_work/starrocks/starrocks/test/lib/sr_sql_lib.py", line 726, in execute_sql
    cursor.execute(sql)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/pymysql/cursors.py", line 153, in execute
    result = self._query(query)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/pymysql/cursors.py", line 322, in _query
    conn.query(q)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/pymysql/connections.py", line 563, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/pymysql/connections.py", line 825, in _read_query_result
    result.read()
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/pymysql/connections.py", line 1199, in read
    first_packet = self.connection._read_packet()
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/pymysql/connections.py", line 744, in _read_packet
    packet_header = self._read_bytes(4)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/pymysql/connections.py", line 782, in _read_bytes
    data = self._rfile.read(num_bytes)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/socket.py", line 669, in readinto
    return self._sock.recv_into(b)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/nose/plugins/multiprocess.py", line 204, in signalhandler
    raise TimedOutException()
nose.plugins.multiprocess.TimedOutException: 'Timed Out'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 60, in testPartExecutor
    yield
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 676, in run
    self._callTestMethod(testMethod)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 633, in _callTestMethod
    method()
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/nose/case.py", line 170, in runTest
    self.test(*self.arg)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/parameterized/parameterized.py", line 620, in standalone_func
    return func(*(a + p.args), **p.kwargs, **kw)
  File "/home/runner/_work/starrocks/starrocks/test/lib/sql_annotation.py", line 46, in wrapper
    raise AssertionError("TimedOutException: exceed the process-timeout limit!")
AssertionError: TimedOutException: exceed the process-timeout limit!

[Standard Output]: 
?[1;32m------------------------------------------------------------ ?[0m
?[1;32m[case name]: test_nest_loop_join ?[0m
?[1;32m[case file]: sql/test_nest_loop_join/R/test_nest_loop_join ?[0m
?[1;32m------------------------------------------------------------ ?[0m
[SQL]: CREATE DATABASE test_db_58557281755c42c6a5db4c7f2f29314d;
[SQL]: USE test_db_58557281755c42c6a5db4c7f2f29314d;
	 → case db: ['test_db_58557281755c42c6a5db4c7f2f29314d']
	 → case resource: []
CREATE TABLE `t1` (
  `c1` int(11) NULL COMMENT "",
  `c2` int(11) NULL COMMENT ""
) ENGINE=OLAP
DUPLICATE KEY(`c1`)
DISTRIBUTED BY HASH(`c1`) BUCKETS 1
PROPERTIES (
"replication_num" = "1"
);
CREATE TABLE `t2` (
  `c1` int(11) NULL COMMENT "",
  `c2` int(11) NULL COMMENT ""
) ENGINE=OLAP
DUPLICATE KEY(`c1`)
DISTRIBUTED BY HASH(`c1`) BUCKETS 1
PROPERTIES (
"replication_num" = "1"
);
CREATE TABLE `t3` (
  `c1` int(11) NULL COMMENT "",
  `c2` int(11) NULL COMMENT ""
) ENGINE=OLAP
DUPLICATE KEY(`c1`)
DISTRIBUTED BY HASH(`c1`) BUCKETS 1
PROPERTIES (
"replication_num" = "1"
);
CREATE TABLE `t4` (
  `c1` int(11) NULL COMMENT "",
  `c2` int(11) NULL COMMENT ""
) ENGINE=OLAP
DUPLICATE KEY(`c1`)
DISTRIBUTED BY HASH(`c1`) BUCKETS 1
PROPERTIES (
"replication_num" = "1"
);
insert into t1 select generate_series, generate_series from table(generate_series(1, 5));
insert into t2 select generate_series, generate_series from table(generate_series(1, 2));
insert into t3 select generate_series, generate_series from table(generate_series(1, 9));
insert into t4 select generate_series, generate_series from table(generate_series(2, 8));
select t1.c2, t2.c2 from t1 join [broadcast] t2 on t1.c1>t2.c1 order by t1.c2, t2.c2;
select t1.c2, t2.c2 from t1 left join [broadcast] t2 on t1.c1>t2.c1 order by t1.c2, t2.c2;
select t1.c2 from t1 left semi join [broadcast] t2 on t1.c1>t2.c1 order by t1.c2;
select t1.c2 from t1 left anti join [broadcast] t2 on t1.c1>t2.c1 order by t1.c2;
select t1.c2, t3.c2 from t1 right outer join [shuffle] t3 on t1.c1>t3.c1 order by t1.c2, t3.c2;
select t1.c2, t4.c2 from t1 full outer join [shuffle] t4 on t1.c1>t4.c1 order by t1.c2, t4.c2;
select t3.c2 from t1 right semi join [shuffle] t3 on t1.c1>t3.c1 order by t3.c2;
select t4.c2 from t1 right anti join [shuffle] t4 on t1.c1>t4.c1 order by t4.c2;
select t1.c2, t2.c2 from t1 join [broadcast] t2 on t1.c1>t2.c1 where t2.c1<1 order by t1.c2, t2.c2;
select t1.c2, t3.c2 from t1 left join [broadcast] (select * from t2 where t2.c1 < 1) t3 on t1.c1>t3.c1 order by t1.c2, t3.c2;
select t1.c2 from t1 left semi join [broadcast] (select * from t2 where t2.c1 < 1) t3 on t1.c1>t3.c1 order by t1.c2;
select t1.c2 from t1 left anti join [broadcast] (select * from t2 where t2.c1 < 1) t3 on t1.c1>t3.c1 order by t1.c2;
select t1.c2, t3.c2 from t1 right outer join [shuffle] (select * from t2 where t2.c1 < 1) t3 on t1.c1>t3.c1 order by t1.c2, t3.c2;
select t1.c2, t3.c2 from t1 full outer join [shuffle] (select * from t2 where t2.c1 < 1) t3 on t1.c1>t3.c1 order by t1.c2, t3.c2;
select t3.c2 from t1 right semi join [shuffle] (select * from t2 where t2.c1 < 1) t3 on t1.c1>t3.c1 order by t3.c2;
select t3.c2 from t1 right anti join [shuffle] (select * from t2 where t2.c1 < 1) t3 on t1.c1>t3.c1 order by t3.c2;
select t3.c2, t2.c2 from (select * from t1 where t1.c1<1) t3 join [broadcast] t2 on t3.c1>t2.c1 order by t3.c2, t2.c2;
select t3.c2, t2.c2 from (select * from t1 where t1.c1<1) t3 left join [broadcast] t2 on t3.c1>t2.c1 order by t3.c2, t2.c2;
select t3.c2 from (select * from t1 where t1.c1<1) t3 left semi join [broadcast] t2 on t3.c1>t2.c1 order by t3.c2;
select t3.c2 from (select * from t1 where t1.c1<1) t3 left anti join [broadcast] t2 on t3.c1>t2.c1 order by t3.c2;
select t3.c2, t2.c2 from (select * from t1 where t1.c1<1) t3 right outer join [shuffle] t2 on t3.c1>t2.c1 order by t3.c2, t2.c2;
select t3.c2, t2.c2 from (select * from t1 where t1.c1<1) t3 full outer join [shuffle] t2 on t3.c1>t2.c1 order by t3.c2, t2.c2;
select t2.c2 from (select * from t1 where t1.c1<1) t3 right semi join [shuffle] t2 on t3.c1>t2.c1 order by t2.c2;
select t2.c2 from (select * from t1 where t1.c1<1) t3 right anti join [shuffle] t2 on t3.c1>t2.c1 order by t2.c2;
truncate table t1;
truncate table t2;
insert into t1 select generate_series, generate_series from table(generate_series(1, 4098));
insert into t2 select generate_series, generate_series from table(generate_series(2, 8));
select count(*) from t1 join [broadcast] t2 on t1.c1>t2.c1;
select t1.c2, t2.c2 from t1 join [broadcast] t2 on t1.c1>t2.c1 order by t1.c2, t2.c2 limit 10;
select t1.c2, t2.c2 from t1 join [broadcast] t2 on t1.c1>t2.c1 order by t1.c2 desc, t2.c2 desc limit 10;
select sum(t1.c2), sum(t2.c2) from t1 join [broadcast] t2 on t1.c1>t2.c1;
truncate table t1;
truncate table t2;
insert into t1 select generate_series, generate_series from table(generate_series(2, 8));
insert into t2 select generate_series, generate_series from table(generate_series(1, 4098));
select count(*) from t1 join [broadcast] t2 on t1.c1>t2.c1;
select t1.c2, t2.c2 from t1 join [broadcast] t2 on t1.c1>t2.c1 order by t1.c2, t2.c2 limit 10;
select t1.c2, t2.c2 from t1 join [broadcast] t2 on t1.c1>t2.c1 order by t1.c2 desc, t2.c2 desc limit 10;
select sum(t1.c2), sum(t2.c2) from t1 join [broadcast] t2 on t1.c1>t2.c1;
truncate table t1;
truncate table t2;
insert into t1 select generate_series, generate_series from table(generate_series(1, 10000));
insert into t2 select generate_series, generate_series from table(generate_series(1, 10000));
select count(*) from t1 join [broadcast] t2 on t1.c1>t2.c1;
select t1.c2, t2.c2 from t1 join [broadcast] t2 on t1.c1>t2.c1 order by t1.c2, t2.c2 limit 10;
select t1.c2, t2.c2 from t1 join [broadcast] t2 on t1.c1>t2.c1 order by t1.c2 desc, t2.c2 desc limit 10;
select sum(t1.c2), sum(t2.c2) from t1 join [broadcast] t2 on t1.c1>t2.c1;
truncate table t1;
truncate table t2;
insert into t1 select generate_series, generate_series from table(generate_series(1, 9998));
insert into t2 select generate_series, generate_series from table(generate_series(1, 10000));
select count(*) from t1 join [broadcast] t2 on t1.c1>t2.c1;
?[1;32m******************** [FINISH] test_nest_loop_join ******************** ?[0m

Check failure on line 1 in TestSQLCases

github-actions / SQL-Tester Report (Release ubuntu)

TestSQLCases.test_spill_nl_join

TimedOutException: exceed the process-timeout limit!

Raw output


            [Stacktrace]: 
Traceback (most recent call last):
  File "/home/runner/_work/starrocks/starrocks/test/lib/sql_annotation.py", line 43, in wrapper
    res = func(*args, **kwargs)
  File "/home/runner/_work/starrocks/starrocks/test/test_sql_cases.py", line 369, in test_sql_basic
    actual_res, actual_res_log, var, order = self.execute_single_statement(sql, sql_id, record_mode)
  File "/home/runner/_work/starrocks/starrocks/test/lib/sr_sql_lib.py", line 1235, in execute_single_statement
    actual_res = self.execute_sql(statement, conn=conn)
  File "/home/runner/_work/starrocks/starrocks/test/lib/sr_sql_lib.py", line 726, in execute_sql
    cursor.execute(sql)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/pymysql/cursors.py", line 153, in execute
    result = self._query(query)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/pymysql/cursors.py", line 322, in _query
    conn.query(q)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/pymysql/connections.py", line 563, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/pymysql/connections.py", line 825, in _read_query_result
    result.read()
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/pymysql/connections.py", line 1199, in read
    first_packet = self.connection._read_packet()
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/pymysql/connections.py", line 744, in _read_packet
    packet_header = self._read_bytes(4)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/pymysql/connections.py", line 782, in _read_bytes
    data = self._rfile.read(num_bytes)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/socket.py", line 669, in readinto
    return self._sock.recv_into(b)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/nose/plugins/multiprocess.py", line 204, in signalhandler
    raise TimedOutException()
nose.plugins.multiprocess.TimedOutException: 'Timed Out'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 60, in testPartExecutor
    yield
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 676, in run
    self._callTestMethod(testMethod)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 633, in _callTestMethod
    method()
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/nose/case.py", line 170, in runTest
    self.test(*self.arg)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/parameterized/parameterized.py", line 620, in standalone_func
    return func(*(a + p.args), **p.kwargs, **kw)
  File "/home/runner/_work/starrocks/starrocks/test/lib/sql_annotation.py", line 46, in wrapper
    raise AssertionError("TimedOutException: exceed the process-timeout limit!")
AssertionError: TimedOutException: exceed the process-timeout limit!

[Standard Output]: 
?[1;32m------------------------------------------------------------ ?[0m
?[1;32m[case name]: test_spill_nl_join ?[0m
?[1;32m[case file]: sql/test_spill/R/test_spill_nl_join ?[0m
?[1;32m------------------------------------------------------------ ?[0m
[SQL]: CREATE DATABASE test_db_cfc52a1c3a904f04a3e2fe8aeb2cdf6f;
[SQL]: USE test_db_cfc52a1c3a904f04a3e2fe8aeb2cdf6f;
	 → case db: ['test_db_cfc52a1c3a904f04a3e2fe8aeb2cdf6f']
	 → case resource: []
set enable_spill=true;
set spill_mode="force";
set pipeline_dop = 2;
set @spillable_operator_mask = bit_shift_left(1, 4);
set @@spillable_operator_mask = @spillable_operator_mask;
create table t0 (
    c0 INT,
    c1 BIGINT
) DUPLICATE KEY(c0) DISTRIBUTED BY HASH(c0) BUCKETS 1 PROPERTIES('replication_num' = '1');
insert into t0 SELECT generate_series, 4096 - generate_series FROM TABLE(generate_series(1,  2048));
select count(*) from t0 l join [broadcast] t0 r;
select l.*, r.* from t0 l join [broadcast] t0 r where l.c0 + r.c0 < 10 order by l.c0, l.c1, r.c0, r.c1;
select count(*) from t0 l join [broadcast] t0 r where r.c0 = 1;
select count(*) from t0 l join [broadcast] t0 r where r.c0 < 0;
select count(*) from t0 l join [broadcast] t0 r where l.c0 < 0;
?[1;32m******************** [FINISH] test_spill_nl_join ******************** ?[0m

Check failure on line 1 in TestSQLCases

github-actions / SQL-Tester Report (Release ubuntu)

TestSQLCases.test_transparent_mv_hive

TimedOutException: exceed the process-timeout limit!

Raw output


            [Stacktrace]: 
Traceback (most recent call last):
  File "/home/runner/_work/starrocks/starrocks/test/lib/sql_annotation.py", line 43, in wrapper
    res = func(*args, **kwargs)
  File "/home/runner/_work/starrocks/starrocks/test/test_sql_cases.py", line 369, in test_sql_basic
    actual_res, actual_res_log, var, order = self.execute_single_statement(sql, sql_id, record_mode)
  File "/home/runner/_work/starrocks/starrocks/test/lib/sr_sql_lib.py", line 1217, in execute_single_statement
    actual_res = eval("self.%s" % sql)
  File "<string>", line 1, in <module>
  File "/home/runner/_work/starrocks/starrocks/test/lib/sr_sql_lib.py", line 1967, in print_hit_materialized_view
    time.sleep(1)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/nose/plugins/multiprocess.py", line 204, in signalhandler
    raise TimedOutException()
nose.plugins.multiprocess.TimedOutException: 'Timed Out'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 60, in testPartExecutor
    yield
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 676, in run
    self._callTestMethod(testMethod)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 633, in _callTestMethod
    method()
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/nose/case.py", line 170, in runTest
    self.test(*self.arg)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/parameterized/parameterized.py", line 620, in standalone_func
    return func(*(a + p.args), **p.kwargs, **kw)
  File "/home/runner/_work/starrocks/starrocks/test/lib/sql_annotation.py", line 46, in wrapper
    raise AssertionError("TimedOutException: exceed the process-timeout limit!")
AssertionError: TimedOutException: exceed the process-timeout limit!

[Standard Output]: 
?[1;32m------------------------------------------------------------ ?[0m
?[1;32m[case name]: test_transparent_mv_hive ?[0m
?[1;32m[case file]: sql/test_transparent_mv/R/test_transparent_mv_hive ?[0m
?[1;32m------------------------------------------------------------ ?[0m
	 → case db: ['mv_hive_db_d5502bb945c9450b9baf225ddeed87e6', 'db_d5502bb945c9450b9baf225ddeed87e6']
	 → case resource: []
create external catalog mv_hive_d5502bb945c9450b9baf225ddeed87e6
properties
(
    "type" = "hive",
    "hive.catalog.type" = "hive",
    "hive.metastore.uris" = "thrift://172.20.190.199:9083"
);
set new_planner_optimize_timeout=10000;
set enable_materialized_view_transparent_union_rewrite = true;
set catalog mv_hive_d5502bb945c9450b9baf225ddeed87e6;
create database mv_hive_db_d5502bb945c9450b9baf225ddeed87e6;
use mv_hive_db_d5502bb945c9450b9baf225ddeed87e6;
CREATE TABLE t1 (
  num int,
  dt date
)
PARTITION BY (dt);
INSERT INTO t1 VALUES 
  (1,"2020-06-15"),(2,"2020-06-18"),(3,"2020-06-21"),(4,"2020-06-24"),
  (1,"2020-07-02"),(2,"2020-07-05"),(3,"2020-07-08"),(4,"2020-07-11"),
  (1,"2020-07-16"),(2,"2020-07-19"),(3,"2020-07-22"),(4,"2020-07-25"),
  (2,"2020-06-15"),(3,"2020-06-18"),(4,"2020-06-21"),(5,"2020-06-24"),
  (2,"2020-07-02"),(3,"2020-07-05"),(4,"2020-07-08"),(5,"2020-07-11");
CREATE TABLE t2 (
  num int,
  dt string
)
PARTITION BY (dt);
INSERT INTO t2 VALUES 
  (1,"2020-06-15"),(2,"2020-06-18"),(3,"2020-06-21"),(4,"2020-06-24"),
  (1,"2020-07-02"),(2,"2020-07-05"),(3,"2020-07-08"),(4,"2020-07-11"),
  (1,"2020-07-16"),(2,"2020-07-19"),(3,"2020-07-22"),(4,"2020-07-25"),
  (2,"2020-06-15"),(3,"2020-06-18"),(4,"2020-06-21"),(5,"2020-06-24"),
  (2,"2020-07-02"),(3,"2020-07-05"),(4,"2020-07-08"),(5,"2020-07-11");
set catalog default_catalog;
create database db_d5502bb945c9450b9baf225ddeed87e6;
use db_d5502bb945c9450b9baf225ddeed87e6;
CREATE MATERIALIZED VIEW test_mv1 
PARTITION BY dt 
REFRESH DEFERRED MANUAL 
PROPERTIES ("transparent_mv_rewrite_mode" = "true")
AS 
  SELECT dt, sum(num) as num FROM mv_hive_d5502bb945c9450b9baf225ddeed87e6.mv_hive_db_d5502bb945c9450b9baf225ddeed87e6.t1 GROUP BY dt;
REFRESH MATERIALIZED VIEW test_mv1 WITH SYNC MODE;
[FUNCTION]: print_hit_materialized_view("SELECT dt, num FROM test_mv1 order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt, num FROM test_mv1 where dt='2020-06-15' order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt, num FROM test_mv1 where dt!='2020-06-15' order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt, num FROM test_mv1 where dt>='2020-06-15' order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt, num FROM test_mv1 where dt>='2020-06-15' and num > 10 order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt, num FROM test_mv1 where dt>='2020-06-15' and 1 < num < 10 order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 where dt='2020-06-15' GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 where dt !='2020-06-15' GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 where dt>='2020-06-15' GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 where dt>'2020-06-15' GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 where dt>'2020-06-15' and dt < '2020-07-22' GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 where dt>'2020-06-15' and dt <= '2020-07-22' GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 where (dt>'2020-06-15' and dt <= '2020-06-22') or dt>'2020-07-01' GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 where dt in ('2020-06-15', '2020-06-22', '2020-07-01') GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 where date_trunc('day', dt) ='2020-06-15' GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 where date_trunc('month', dt) ='2020-06-01' GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 where date_trunc('month', dt) ='2020-07-01' GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
SELECT dt, num FROM test_mv1 order by 1, 2 limit 3;
SELECT dt, num FROM test_mv1 where dt='2020-06-15' order by 1, 2 limit 3;
SELECT dt, num FROM test_mv1 where dt!='2020-06-15' order by 1, 2 limit 3;
SELECT dt, num FROM test_mv1 where dt>='2020-06-15' order by 1, 2 limit 3;
SELECT dt, num FROM test_mv1 where dt>='2020-06-15' and num > 10 order by 1, 2 limit 3;
SELECT dt, num FROM test_mv1 where dt>='2020-06-15' and 1 < num < 10 order by 1, 2 limit 3;
SELECT dt,sum(num) FROM test_mv1 where dt='2020-06-15' GROUP BY dt order by 1, 2 limit 3;
SELECT dt,sum(num) FROM test_mv1 where dt !='2020-06-15' GROUP BY dt order by 1, 2 limit 3;
SELECT dt,sum(num) FROM test_mv1 where dt>='2020-06-15' GROUP BY dt order by 1, 2 limit 3;
SELECT dt,sum(num) FROM test_mv1 where dt>'2020-06-15' GROUP BY dt order by 1, 2 limit 3;
SELECT dt,sum(num) FROM test_mv1 where dt>'2020-06-15' and dt < '2020-07-22' GROUP BY dt order by 1, 2 limit 3;
SELECT dt,sum(num) FROM test_mv1 where dt>'2020-06-15' and dt <= '2020-07-22' GROUP BY dt order by 1, 2 limit 3;
SELECT dt,sum(num) FROM test_mv1 where (dt>'2020-06-15' and dt <= '2020-06-22') or dt>'2020-07-01' GROUP BY dt order by 1, 2 limit 3;
SELECT dt,sum(num) FROM test_mv1 where dt in ('2020-06-15', '2020-06-22', '2020-07-01') GROUP BY dt order by 1, 2 limit 3;
SELECT dt,sum(num) FROM test_mv1 where date_trunc('day', dt) ='2020-06-15' GROUP BY dt order by 1, 2 limit 3;
SELECT dt,sum(num) FROM test_mv1 where date_trunc('month', dt) ='2020-06-01' GROUP BY dt order by 1, 2 limit 3;
SELECT dt,sum(num) FROM test_mv1 where date_trunc('month', dt) ='2020-07-01' GROUP BY dt order by 1, 2 limit 3;
SELECT dt,sum(num) FROM test_mv1 GROUP BY dt order by 1, 2 limit 3;
INSERT INTO mv_hive_d5502bb945c9450b9baf225ddeed87e6.mv_hive_db_d5502bb945c9450b9baf225ddeed87e6.t1 VALUES (3, "2020-06-15");
[FUNCTION]: print_hit_materialized_view("SELECT dt, num FROM test_mv1 order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt, num FROM test_mv1 where dt='2020-06-15' order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt, num FROM test_mv1 where dt!='2020-06-15' order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt, num FROM test_mv1 where dt>='2020-06-15' order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt, num FROM test_mv1 where dt>='2020-06-15' and num > 10 order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt, num FROM test_mv1 where dt>='2020-06-15' and 1 < num < 10 order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 where dt='2020-06-15' GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 where dt !='2020-06-15' GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 where dt>='2020-06-15' GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 where dt>'2020-06-15' GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 where dt>'2020-06-15' and dt < '2020-07-22' GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 where dt>'2020-06-15' and dt <= '2020-07-22' GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 where (dt>'2020-06-15' and dt <= '2020-06-22') or dt>'2020-07-01' GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 where dt in ('2020-06-15', '2020-06-22', '2020-07-02') GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 where date_trunc('day', dt) ='2020-06-15' GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 where date_trunc('month', dt) ='2020-06-01' GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 where date_trunc('month', dt) ='2020-07-01' GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
SELECT dt, num FROM test_mv1 order by 1, 2 limit 3;
SELECT dt, num FROM test_mv1 where dt='2020-06-15' order by 1, 2 limit 3;
SELECT dt, num FROM test_mv1 where dt!='2020-06-15' order by 1, 2 limit 3;
SELECT dt, num FROM test_mv1 where dt>='2020-06-15' order by 1, 2 limit 3;
SELECT dt, num FROM test_mv1 where dt>='2020-06-15' and num > 10 order by 1, 2 limit 3;
SELECT dt, num FROM test_mv1 where dt>='2020-06-15' and 1 < num < 10 order by 1, 2 limit 3;
SELECT dt,sum(num) FROM test_mv1 where dt='2020-06-15' GROUP BY dt order by 1, 2 limit 3;
SELECT dt,sum(num) FROM test_mv1 where dt !='2020-06-15' GROUP BY dt order by 1, 2 limit 3;
SELECT dt,sum(num) FROM test_mv1 where dt>='2020-06-15' GROUP BY dt order by 1, 2 limit 3;
SELECT dt,sum(num) FROM test_mv1 where dt>'2020-06-15' GROUP BY dt order by 1, 2 limit 3;
SELECT dt,sum(num) FROM test_mv1 where dt>'2020-06-15' and dt < '2020-07-22' GROUP BY dt order by 1, 2 limit 3;
SELECT dt,sum(num) FROM test_mv1 where dt>'2020-06-15' and dt <= '2020-07-22' GROUP BY dt order by 1, 2 limit 3;
SELECT dt,sum(num) FROM test_mv1 where (dt>'2020-06-15' and dt <= '2020-06-22') or dt>'2020-07-02' GROUP BY dt order by 1, 2 limit 3;
SELECT dt,sum(num) FROM test_mv1 where dt in ('2020-06-15', '2020-06-22', '2020-07-01') GROUP BY dt order by 1, 2 limit 3;
SELECT dt,sum(num) FROM test_mv1 where date_trunc('day', dt) ='2020-06-15' GROUP BY dt order by 1, 2 limit 3;
SELECT dt,sum(num) FROM test_mv1 where date_trunc('month', dt) ='2020-06-01' GROUP BY dt order by 1, 2 limit 3;
SELECT dt,sum(num) FROM test_mv1 where date_trunc('month', dt) ='2020-07-01' GROUP BY dt order by 1, 2 limit 3;
SELECT dt,sum(num) FROM test_mv1 GROUP BY dt order by 1, 2 limit 3;
drop materialized view default_catalog.db_d5502bb945c9450b9baf225ddeed87e6.test_mv1;
CREATE MATERIALIZED VIEW test_mv1 
PARTITION BY date_trunc('day', dt)
REFRESH DEFERRED MANUAL 
PROPERTIES ("transparent_mv_rewrite_mode" = "true")
AS 
  SELECT dt,sum(num) as num FROM mv_hive_d5502bb945c9450b9baf225ddeed87e6.mv_hive_db_d5502bb945c9450b9baf225ddeed87e6.t1 GROUP BY dt;
REFRESH MATERIALIZED VIEW test_mv1 WITH SYNC MODE;
INSERT INTO mv_hive_d5502bb945c9450b9baf225ddeed87e6.mv_hive_db_d5502bb945c9450b9baf225ddeed87e6.t1 VALUES (3, "2020-06-15");
[FUNCTION]: print_hit_materialized_view("SELECT dt, num FROM test_mv1 order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt, num FROM test_mv1 where dt='2020-06-15' order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt, num FROM test_mv1 where dt!='2020-06-15' order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt, num FROM test_mv1 where dt>='2020-06-15' order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt, num FROM test_mv1 where dt>='2020-06-15' and num > 10 order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt, num FROM test_mv1 where dt>='2020-06-15' and 1 < num < 10 order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 where dt='2020-06-15' GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 where dt !='2020-06-15' GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 where dt>='2020-06-15' GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 where dt>'2020-06-15' GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 where dt>'2020-06-15' and dt < '2020-07-22' GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 where dt>'2020-06-15' and dt <= '2020-07-22' GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 where (dt>'2020-06-15' and dt <= '2020-06-22') or dt>'2020-07-01' GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 where dt in ('2020-06-15', '2020-06-22', '2020-07-02') GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 where date_trunc('day', dt) ='2020-06-15' GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 where date_trunc('month', dt) ='2020-06-01' GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 where date_trunc('month', dt) ='2020-07-01' GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
SELECT dt, num FROM test_mv1 order by 1, 2 limit 3;
SELECT dt, num FROM test_mv1 where dt='2020-06-15' order by 1, 2 limit 3;
SELECT dt, num FROM test_mv1 where dt!='2020-06-15' order by 1, 2 limit 3;
SELECT dt, num FROM test_mv1 where dt>='2020-06-15' order by 1, 2 limit 3;
SELECT dt, num FROM test_mv1 where dt>='2020-06-15' and num > 10 order by 1, 2 limit 3;
SELECT dt, num FROM test_mv1 where dt>='2020-06-15' and 1 < num < 10 order by 1, 2 limit 3;
SELECT dt,sum(num) FROM test_mv1 where dt='2020-06-15' GROUP BY dt order by 1, 2 limit 3;
SELECT dt,sum(num) FROM test_mv1 where dt !='2020-06-15' GROUP BY dt order by 1, 2 limit 3;
SELECT dt,sum(num) FROM test_mv1 where dt>='2020-06-15' GROUP BY dt order by 1, 2 limit 3;
SELECT dt,sum(num) FROM test_mv1 where dt>'2020-06-15' GROUP BY dt order by 1, 2 limit 3;
SELECT dt,sum(num) FROM test_mv1 where dt>'2020-06-15' and dt < '2020-07-22' GROUP BY dt order by 1, 2 limit 3;
SELECT dt,sum(num) FROM test_mv1 where dt>'2020-06-15' and dt <= '2020-07-22' GROUP BY dt order by 1, 2 limit 3;
SELECT dt,sum(num) FROM test_mv1 where (dt>'2020-06-15' and dt <= '2020-06-22') or dt>'2020-07-01' GROUP BY dt order by 1, 2 limit 3;
SELECT dt,sum(num) FROM test_mv1 where dt in ('2020-06-15', '2020-06-22', '2020-07-02') GROUP BY dt order by 1, 2 limit 3;
SELECT dt,sum(num) FROM test_mv1 where date_trunc('day', dt) ='2020-06-15' GROUP BY dt order by 1, 2 limit 3;
SELECT dt,sum(num) FROM test_mv1 where date_trunc('month', dt) ='2020-06-01' GROUP BY dt order by 1, 2 limit 3;
SELECT dt,sum(num) FROM test_mv1 where date_trunc('month', dt) ='2020-07-01' GROUP BY dt order by 1, 2 limit 3;
SELECT dt,sum(num) FROM test_mv1 GROUP BY dt order by 1, 2 limit 3;
drop materialized view default_catalog.db_d5502bb945c9450b9baf225ddeed87e6.test_mv1;
CREATE MATERIALIZED VIEW test_mv1 
PARTITION BY str2date(dt, '%Y-%m-%d')
REFRESH DEFERRED MANUAL 
PROPERTIES ("transparent_mv_rewrite_mode" = "true")
AS 
  SELECT dt,sum(num) as num FROM mv_hive_d5502bb945c9450b9baf225ddeed87e6.mv_hive_db_d5502bb945c9450b9baf225ddeed87e6.t2 GROUP BY dt;
REFRESH MATERIALIZED VIEW test_mv1 WITH SYNC MODE;
INSERT INTO mv_hive_d5502bb945c9450b9baf225ddeed87e6.mv_hive_db_d5502bb945c9450b9baf225ddeed87e6.t2 VALUES (3, "2020-06-16");
[FUNCTION]: print_hit_materialized_view("SELECT dt, num FROM test_mv1 order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt, num FROM test_mv1 where dt='2020-06-15' order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt, num FROM test_mv1 where dt!='2020-06-15' order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt, num FROM test_mv1 where dt>='2020-06-15' order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt, num FROM test_mv1 where dt>='2020-06-15' and num > 10 order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt, num FROM test_mv1 where dt>='2020-06-15' and 1 < num < 10 order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 where dt='2020-06-15' GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 where dt !='2020-06-15' GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 where dt>='2020-06-15' GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 where dt>'2020-06-15' GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 where dt>'2020-06-15' and dt < '2020-07-22' GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 where dt>'2020-06-15' and dt <= '2020-07-22' GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 where (dt>'2020-06-15' and dt <= '2020-06-22') or dt>'2020-07-01' GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 where dt in ('2020-06-15', '2020-06-22', '2020-07-01') GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 where date_trunc('day', dt) ='2020-06-15' GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 where date_trunc('month', dt) ='2020-06-01' GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 where date_trunc('month', dt) ='2020-07-01' GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
SELECT dt, num FROM test_mv1 order by 1, 2 limit 3;
SELECT dt, num FROM test_mv1 where dt='2020-06-15' order by 1, 2 limit 3;
SELECT dt, num FROM test_mv1 where dt!='2020-06-15' order by 1, 2 limit 3;
SELECT dt, num FROM test_mv1 where dt>='2020-06-15' order by 1, 2 limit 3;
SELECT dt, num FROM test_mv1 where dt>='2020-06-15' and num > 10 order by 1, 2 limit 3;
SELECT dt, num FROM test_mv1 where dt>='2020-06-15' and 1 < num < 10 order by 1, 2 limit 3;
SELECT dt,sum(num) FROM test_mv1 where dt='2020-06-15' GROUP BY dt order by 1, 2 limit 3;
SELECT dt,sum(num) FROM test_mv1 where dt !='2020-06-15' GROUP BY dt order by 1, 2 limit 3;
SELECT dt,sum(num) FROM test_mv1 where dt>='2020-06-15' GROUP BY dt order by 1, 2 limit 3;
SELECT dt,sum(num) FROM test_mv1 where dt>'2020-06-15' GROUP BY dt order by 1, 2 limit 3;
SELECT dt,sum(num) FROM test_mv1 where dt>'2020-06-15' and dt < '2020-07-22' GROUP BY dt order by 1, 2 limit 3;
SELECT dt,sum(num) FROM test_mv1 where dt>'2020-06-15' and dt <= '2020-07-22' GROUP BY dt order by 1, 2 limit 3;
SELECT dt,sum(num) FROM test_mv1 where (dt>'2020-06-15' and dt <= '2020-06-22') or dt>'2020-07-01' GROUP BY dt order by 1, 2 limit 3;
SELECT dt,sum(num) FROM test_mv1 where dt in ('2020-06-15', '2020-06-22', '2020-07-01') GROUP BY dt order by 1, 2 limit 3;
SELECT dt,sum(num) FROM test_mv1 where date_trunc('day', dt) ='2020-06-15' GROUP BY dt order by 1, 2 limit 3;
SELECT dt,sum(num) FROM test_mv1 where date_trunc('month', dt) ='2020-06-01' GROUP BY dt order by 1, 2 limit 3;
SELECT dt,sum(num) FROM test_mv1 where date_trunc('month', dt) ='2020-07-01' GROUP BY dt order by 1, 2 limit 3;
SELECT dt,sum(num) FROM test_mv1 GROUP BY dt order by 1, 2 limit 3;
drop materialized view default_catalog.db_d5502bb945c9450b9baf225ddeed87e6.test_mv1;
CREATE MATERIALIZED VIEW test_mv1 
PARTITION BY date_trunc('day', dt)
REFRESH DEFERRED MANUAL 
PROPERTIES ("transparent_mv_rewrite_mode" = "true")
AS  select * from (
SELECT dt, sum(num) as num FROM mv_hive_d5502bb945c9450b9baf225ddeed87e6.mv_hive_db_d5502bb945c9450b9baf225ddeed87e6.t1 GROUP BY dt 
UNION ALL
SELECT  str2date(dt, '%Y-%m-%d'), sum(num) as num FROM mv_hive_d5502bb945c9450b9baf225ddeed87e6.mv_hive_db_d5502bb945c9450b9baf225ddeed87e6.t2 GROUP BY dt) t order by 1, 2;
REFRESH MATERIALIZED VIEW test_mv1 WITH SYNC MODE;
INSERT INTO mv_hive_d5502bb945c9450b9baf225ddeed87e6.mv_hive_db_d5502bb945c9450b9baf225ddeed87e6.t2 VALUES (3, "2020-06-18");
[FUNCTION]: print_hit_materialized_view("SELECT dt, num FROM test_mv1 order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt, num FROM test_mv1 where dt='2020-06-15' order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt, num FROM test_mv1 where dt!='2020-06-15' order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt, num FROM test_mv1 where dt>='2020-06-15' order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt, num FROM test_mv1 where dt>='2020-06-15' and num > 10 order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt, num FROM test_mv1 where dt>='2020-06-15' and 1 < num < 10 order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 where dt='2020-06-15' GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 where dt !='2020-06-15' GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 where dt>='2020-06-15' GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 where dt>'2020-06-15' GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
[FUNCTION]: print_hit_materialized_view("SELECT dt,sum(num) FROM test_mv1 where dt>'2020-06-15' and dt < '2020-07-22' GROUP BY dt order by 1, 2 limit 3;", "test_mv1")
?[1;32m******************** [FINISH] test_transparent_mv_hive ******************** ?[0m

Check failure on line 1 in TestSQLCases

github-actions / SQL-Tester Report (Release ubuntu)

TestSQLCases.test_index_and_filter_on_or_predicate

Element counts were not equal:
First has 1, Second has 0:  'E: (1064, "Getting syntax error at line 8, column 0. Detail message: Unexpected input \'function\', the most similar input is {\'UNINSTALL\', \'UNLOCK\', \'STOP\', \'SYNC\', \'GRANT\', \'(\', \';\'}.")'
First has 0, Second has 1:  '0' : sql result not match:
- [SQL]: select count(1) from t1 where c_int_1_seq < 1;
- [exp]: ['E: (1064, "Getting syntax error at line 8, column 0. Detail message: Unexpected input \'function\', the most similar input is {\'UNINSTALL\', \'UNLOCK\', \'STOP\', \'SYNC\', \'GRANT\', \'(\', \';\'}.")']
- [act]: ['0']
---

Raw output


            [Stacktrace]: 
Traceback (most recent call last):
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 60, in testPartExecutor
    yield
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 676, in run
    self._callTestMethod(testMethod)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 633, in _callTestMethod
    method()
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/nose/case.py", line 170, in runTest
    self.test(*self.arg)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/parameterized/parameterized.py", line 620, in standalone_func
    return func(*(a + p.args), **p.kwargs, **kw)
  File "/home/runner/_work/starrocks/starrocks/test/lib/sql_annotation.py", line 48, in wrapper
    raise e
  File "/home/runner/_work/starrocks/starrocks/test/lib/sql_annotation.py", line 43, in wrapper
    res = func(*args, **kwargs)
  File "/home/runner/_work/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 "/home/runner/_work/starrocks/starrocks/test/lib/sr_sql_lib.py", line 1480, in check
    tools.assert_count_equal(
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 1272, in assertCountEqual
    self.fail(msg)
  File "/root/.pyenv/versions/3.8.19/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:  'E: (1064, "Getting syntax error at line 8, column 0. Detail message: Unexpected input \'function\', the most similar input is {\'UNINSTALL\', \'UNLOCK\', \'STOP\', \'SYNC\', \'GRANT\', \'(\', \';\'}.")'
First has 0, Second has 1:  '0' : sql result not match:
- [SQL]: select count(1) from t1 where c_int_1_seq < 1;
- [exp]: ['E: (1064, "Getting syntax error at line 8, column 0. Detail message: Unexpected input \'function\', the most similar input is {\'UNINSTALL\', \'UNLOCK\', \'STOP\', \'SYNC\', \'GRANT\', \'(\', \';\'}.")']
- [act]: ['0']
---

[Standard Output]: 
?[1;32m------------------------------------------------------------ ?[0m
?[1;32m[case name]: test_index_and_filter_on_or_predicate ?[0m
?[1;32m[case file]: sql/test_scan/test_pushdown_or_predicate/R/test_index_and_filter_on_or_predicate ?[0m
?[1;32m------------------------------------------------------------ ?[0m
[SQL]: CREATE DATABASE test_db_a9853207b94a44a0a211fd686b48a19a;
[SQL]: USE test_db_a9853207b94a44a0a211fd686b48a19a;
	 → case db: ['test_db_a9853207b94a44a0a211fd686b48a19a']
	 → case resource: []
set scan_or_to_union_limit = 1;
set enable_profile = true;
set enable_async_profile=false;
[FUNCTION]: update_be_config("enable_index_segment_level_zonemap_filter", "false")
post http://172.21.245.63:8038/api/update_config?enable_index_segment_level_zonemap_filter=false
post http://172.21.245.64:8038/api/update_config?enable_index_segment_level_zonemap_filter=false
post http://172.21.245.65:8038/api/update_config?enable_index_segment_level_zonemap_filter=false
[FUNCTION]: update_be_config("enable_index_page_level_zonemap_filter", "false")
post http://172.21.245.63:8038/api/update_config?enable_index_page_level_zonemap_filter=false
post http://172.21.245.64:8038/api/update_config?enable_index_page_level_zonemap_filter=false
post http://172.21.245.65:8038/api/update_config?enable_index_page_level_zonemap_filter=false
[FUNCTION]: update_be_config("enable_index_bloom_filter", "false")
post http://172.21.245.63:8038/api/update_config?enable_index_bloom_filter=false
post http://172.21.245.64:8038/api/update_config?enable_index_bloom_filter=false
post http://172.21.245.65:8038/api/update_config?enable_index_bloom_filter=false
[FUNCTION]: update_be_config("enable_index_bitmap_filter", "false")
post http://172.21.245.63:8038/api/update_config?enable_index_bitmap_filter=false
post http://172.21.245.64:8038/api/update_config?enable_index_bitmap_filter=false
post http://172.21.245.65:8038/api/update_config?enable_index_bitmap_filter=false
CREATE TABLE __row_util_base (
  k1 bigint NULL
) ENGINE=OLAP
DUPLICATE KEY(`k1`)
DISTRIBUTED BY HASH(`k1`) BUCKETS 32
PROPERTIES (
    "replication_num" = "1"
);
insert into __row_util_base select generate_series from TABLE(generate_series(0, 10000 - 1));
insert into __row_util_base select * from __row_util_base; -- 20000
insert into __row_util_base select * from __row_util_base; -- 40000
insert into __row_util_base select * from __row_util_base; -- 80000
insert into __row_util_base select * from __row_util_base; -- 160000
insert into __row_util_base select * from __row_util_base; -- 320000
insert into __row_util_base select * from __row_util_base; -- 640000
insert into __row_util_base select * from __row_util_base; -- 1280000

CREATE TABLE __row_util (
  idx bigint NULL
) ENGINE=OLAP
DUPLICATE KEY(`idx`)
DISTRIBUTED BY HASH(`idx`) BUCKETS 32
PROPERTIES (
    "replication_num" = "1"
);
insert into __row_util select row_number() over() as idx from __row_util_base;
CREATE TABLE t1 (
  k1 bigint NULL,
  c_int_1_seq bigint NULL,
  c_int_2_seq bigint NULL,

  c_str_1_seq String NULL,
  c_str_2_seq String NULL,

  c_str_3_low1 String NULL,
  c_str_4_low2 String NULL,

  c_str_5_low_non_null1 String NOT NULL,
  c_str_6_low_non_null2 String NOT NULL,

  c_str_7_seq_non_null1 String NOT NULL,
  c_str_8_seq_non_null2 String NOT NULL,

  c_date_1_seq date NULL,
  c_date_2_seq date NULL,
  c_datetime_1_seq datetime NULL,
  c_datetime_2_seq datetime NULL,

  INDEX c_int_1_seq_bitmap_index (c_int_1_seq) USING BITMAP,
  INDEX c_str_1_seq_bitmap_index (c_str_1_seq) USING BITMAP,
  INDEX c_str_3_low1_bitmap_index (c_str_3_low1) USING BITMAP,
  INDEX c_str_5_low_non_null1_bitmap_index (c_str_5_low_non_null1) USING BITMAP,
  INDEX c_str_7_seq_non_null1_bitmap_index (c_str_7_seq_non_null1) USING BITMAP,
  INDEX c_date_1_seq_bitmap_index (c_date_1_seq) USING BITMAP,
  INDEX c_datetime_1_seq_bitmap_index (c_datetime_1_seq) USING BITMAP

) ENGINE=OLAP
DUPLICATE KEY(`k1`)
DISTRIBUTED BY HASH(`k1`) BUCKETS 32
PROPERTIES (
    "replication_num" = "1",
    "bloom_filter_columns" = "c_int_1_seq,c_str_1_seq,c_str_3_low1,c_str_5_low_non_null1,c_str_7_seq_non_null1,c_date_1_seq,c_datetime_1_seq"
);
insert into t1
select 
    idx,
    idx + 1280000,
    idx + 1280000*2,

    concat('abc1-', idx),
    concat('abc2-', idx),
    case when idx % 3 = 0 then 'a1' when idx % 3 = 1 then 'b1' else 'c1' end,
    case when idx < 1280000/4 then 'a2' when idx < 1280000/4*2 then 'b2' when idx < 1280000/4*3 then 'c2' else 'd2' end,

    case when idx % 3 = 0 then 'a1' when idx % 3 = 1 then 'b1' else 'c1' end,
    case when idx < 1280000/4 then 'a2' when idx < 1280000/4*2 then 'b2' when idx < 1280000/4*3 then 'c2' else 'd2' end,
    concat('abc1-', idx),
    concat('abc2-', idx),

    cast(date_sub('2023-11-02', interval cast(idx % 100 as int) day) as date),
    cast(date_sub('2023-11-02', interval cast(idx % 1000 as int) day) as date),
    
    date_sub('2023-11-02', interval cast(idx % 100 as int) second),
    date_sub('2023-11-02', interval cast(idx % 1000 as int) second)
from __row_util ;
insert into t1 (k1, c_str_5_low_non_null1, c_str_6_low_non_null2, c_str_7_seq_non_null1, c_str_8_seq_non_null2) select null, '<null>', '<null>', '<null>', '<null>';
insert into t1 (k1, c_str_5_low_non_null1, c_str_6_low_non_null2, c_str_7_seq_non_null1, c_str_8_seq_non_null2) select null, '<null>', '<null>', '<null>', '<null>';
create view __profile(idx, k, v) as 
select 1, 2, 3;
[FUNCTION]: update_be_config("enable_index_segment_level_zonemap_filter", "true")
post http://172.21.245.63:8038/api/update_config?enable_index_segment_level_zonemap_filter=true
post http://172.21.245.64:8038/api/update_config?enable_index_segment_level_zonemap_filter=true
post http://172.21.245.65:8038/api/update_config?enable_index_segment_level_zonemap_filter=true
select count(1) from t1 where c_int_1_seq < 1;
?[1;32m******************** [FINISH] test_index_and_filter_on_or_predicate ******************** ?[0m

Check failure on line 1 in TestSQLCases

github-actions / SQL-Tester Report (Release ubuntu)

TestSQLCases.test_mutable_bucket

"E: (1064, 'Getting analyzing error. Detail me[36 chars]1.')" != "E: (5064, 'Getting analyzing error. Detail me[36 chars]1.')"
- E: (1064, 'Getting analyzing error. Detail message: Illegal mutable bucket num: -1.')
?     ^
+ E: (5064, 'Getting analyzing error. Detail message: Illegal mutable bucket num: -1.')
?     ^

Raw output


            [Stacktrace]: 
Traceback (most recent call last):
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 60, in testPartExecutor
    yield
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 676, in run
    self._callTestMethod(testMethod)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 633, in _callTestMethod
    method()
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/nose/case.py", line 170, in runTest
    self.test(*self.arg)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/parameterized/parameterized.py", line 620, in standalone_func
    return func(*(a + p.args), **p.kwargs, **kw)
  File "/home/runner/_work/starrocks/starrocks/test/lib/sql_annotation.py", line 48, in wrapper
    raise e
  File "/home/runner/_work/starrocks/starrocks/test/lib/sql_annotation.py", line 43, in wrapper
    res = func(*args, **kwargs)
  File "/home/runner/_work/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 "/home/runner/_work/starrocks/starrocks/test/lib/sr_sql_lib.py", line 1467, in check
    tools.assert_equal(act, exp)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 912, in assertEqual
    assertion_func(first, second, msg=msg)
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 1292, in assertMultiLineEqual
    self.fail(self._formatMessage(msg, standardMsg))
  File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 753, in fail
    raise self.failureException(msg)
AssertionError: "E: (1064, 'Getting analyzing error. Detail me[36 chars]1.')" != "E: (5064, 'Getting analyzing error. Detail me[36 chars]1.')"
- E: (1064, 'Getting analyzing error. Detail message: Illegal mutable bucket num: -1.')
?     ^
+ E: (5064, 'Getting analyzing error. Detail message: Illegal mutable bucket num: -1.')
?     ^


[Standard Output]: 
?[1;32m------------------------------------------------------------ ?[0m
?[1;32m[case name]: test_mutable_bucket ?[0m
?[1;32m[case file]: sql/test_automatic_bucket/R/test_automatic_partition ?[0m
?[1;32m------------------------------------------------------------ ?[0m
	 → case db: ['ggg']
	 → case resource: []
create database ggg;
use ggg;
create table t(k date, v int) PARTITION BY DATE_TRUNC('DAY', `k`)
PROPERTIES (
"replication_num" = "1",
"bucket_size" = "1",
"mutable_bucket_num" = "2"
);
show create table t;
select count(*) from information_schema.be_tablets t1, information_schema.tables_config t2 where TABLE_NAME='t' and t1.TABLE_ID=t2.TABLE_ID and TABLE_SCHEMA='ggg';
insert into t values('2021-01-01', 1);
select count(*) from information_schema.be_tablets t1, information_schema.tables_config t2 where TABLE_NAME='t' and t1.TABLE_ID=t2.TABLE_ID and TABLE_SCHEMA='ggg';
alter table t set('mutable_bucket_num'='3');
show create table t;
insert into t values('2021-01-01', 1);
select count(*) from information_schema.be_tablets t1, information_schema.tables_config t2 where TABLE_NAME='t' and t1.TABLE_ID=t2.TABLE_ID and TABLE_SCHEMA='ggg';
select * from t;
alter table t set('mutable_bucket_num'='-1');
?[1;32m******************** [FINISH] test_mutable_bucket ******************** ?[0m

View more details on GitHub Actions