Closed wanpengfei-git closed 2 years ago
--java.lang.AssertionError: SELECT * FROM v14 UNION ALL SELECT * FROM v15 UNION ALL SELECT * FROM v16;
-- at sqlancer.common.query.QueryAdapter.checkException(QueryAdapter.java:98)
-- at sqlancer.common.query.QueryAdapter.executeAndGet(QueryAdapter.java:128)
-- at sqlancer.ComparatorHelper.getResultSetFirstColumnAsString(ComparatorHelper.java:54)
-- at sqlancer.ComparatorHelper.getCombinedResultSet(ComparatorHelper.java:138)
-- at sqlancer.starrocks.oracle.tlp.StarRocksTLPViewOracle.checkViewOnSingleUnion(StarRocksTLPViewOracle.java:68)
-- at sqlancer.starrocks.oracle.tlp.StarRocksTLPViewOracle.check(StarRocksTLPViewOracle.java:42)
-- at sqlancer.ProviderAdapter.generateAndTestDatabase(ProviderAdapter.java:55)
-- at sqlancer.Main$DBMSExecutor.run(Main.java:322)
-- at sqlancer.Main$2.run(Main.java:511)
-- at sqlancer.Main$2.runThread(Main.java:489)
-- at sqlancer.Main$2.run(Main.java:479)
-- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
-- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
-- at java.lang.Thread.run(Thread.java:748)
--Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Query exceeded time limit of 300 seconds
-- at sun.reflect.GeneratedConstructorAccessor5.newInstance(Unknown Source)
-- at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
-- at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
-- at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
-- at com.mysql.jdbc.Util.getInstance(Util.java:408)
-- at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)
-- at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
-- at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
-- at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
-- at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
-- at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2497)
-- at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2455)
-- at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1369)
-- at sqlancer.common.query.QueryAdapter.executeAndGet(QueryAdapter.java:118)
-- ... 12 more
---- Time: 2022/05/30 23:50:49
-- Database: v14
-- Database version: 5.1.0
-- seed value: 1653925121885
DROP DATABASE IF EXISTS v14;
CREATE DATABASE v14;
USE v14;
admin set frontend config ("enable_decimal_v3" = "true");
CREATE TABLE t0 (c_0_0 DATE NULL ,c_0_1 BIGINT REPLACE NOT NULL ,c_0_2 DECIMAL(6, 1) MIN NULL ,c_0_3 BOOLEAN REPLACE NOT NULL ,c_0_4 HLL HLL_UNION NOT NULL ,c_0_5 PERCENTILE PERCENTILE_UNION NULL ,c_0_6 BOOLEAN REPLACE NULL ,c_0_7 PERCENTILE PERCENTILE_UNION NOT NULL ,c_0_8 HLL HLL_UNION NULL ,c_0_9 DOUBLE SUM NULL ,c_0_10 DECIMAL(13, 1) REPLACE NOT NULL ,c_0_11 DATE MIN NOT NULL ,c_0_12 FLOAT MIN NULL ,c_0_13 TINYINT MIN NULL ,c_0_14 CHAR(1) REPLACE NOT NULL , INDEX index1_c_0_0(`c_0_0`) USING BITMAP) AGGREGATE KEY (c_0_0) DISTRIBUTED BY HASH (c_0_0) BUCKETS 3 properties("replication_num"="3") ;
CREATE TABLE t1 (c_1_0 LARGEINT NULL ,c_1_1 DATE NOT NULL ,c_1_2 DATETIME NULL ,c_1_3 DECIMAL(10, 2) NOT NULL ,c_1_4 DECIMAL(24, 14) NULL ,c_1_5 CHAR(21) NULL ,c_1_6 VARCHAR(1) NOT NULL ,c_1_7 LARGEINT NOT NULL ,c_1_8 SMALLINT NULL ,c_1_9 SMALLINT NULL ,c_1_10 DATETIME NULL ,c_1_11 DATE NOT NULL ,c_1_12 DECIMAL(27, 8) NULL ,c_1_13 ARRAY<STRING> NOT NULL ,c_1_14 BOOLEAN NULL ,c_1_15 ARRAY<STRING> NULL ,c_1_16 DATETIME NOT NULL ,c_1_17 ARRAY<INT> NOT NULL , INDEX index1_c_1_8(`c_1_8`) USING BITMAP) DUPLICATE KEY (c_1_0,c_1_1,c_1_2,c_1_3,c_1_4,c_1_5,c_1_6,c_1_7,c_1_8,c_1_9) PARTITION BY RANGE(c_1_2) (START ("2010-01-01") END ("2021-12-31") EVERY (INTERVAL 132 day)) DISTRIBUTED BY HASH (c_1_6,c_1_8,c_1_7,c_1_3,c_1_4) BUCKETS 3 properties("replication_num"="3", "bloom_filter_columns"="c_1_7") ;
TRUNCATE TABLE t0;
INSERT INTO t1 VALUES (NULL, '2010-01-19', '2010-01-14 08:00:14', 84084.83, 0.00005514618793, '', '', 24884086, 2, 12, '2010-01-28 08:00:14', '2010-01-27', 67459904733.49972052, ["h", "fT", "", "X8nMa91", "", "LS", "", "", "Y", "", "oAm34iz", "", "UMGuZirK8"], true, ["rW0oMoSsX", "YKt8", "4H", "y", ""], '2010-01-30 08:00:14', [-389908676, 24884086, 913233896]), (NULL, '2010-01-08', '2010-01-23 08:00:14', 356599.44, 0.00004253405637, 'k0MmB', '', -232578455, 11, 1, '2010-01-11 08:00:14', '2009-12-31', 59315267497.33235738, ["M", "1nO", "gjl"], true, ["4NHTtlY", "Sr"], '2010-01-08 08:00:14', [-978067387, -194169345, -1127807000, 1151324986, -1548562823]);
INSERT INTO t0 VALUES ('2010-01-05', -273509299, 7595.9, true, hll_hash(''), percentile_hash('913233896'), false, percentile_hash('306144693'), hll_hash('1'), 0.11085471570090055, 13531068143.3, '2010-01-05', 0.11085471570090055, 0, '');
INSERT INTO t0 VALUES ('2010-01-08', 1151324986, 7184.8, false, hll_hash(''), percentile_hash('-232578455'), true, percentile_hash('1151324986'), hll_hash('f'), 0.6979699395723891, 49950725693.4, '2010-01-14', 0.24143576390979493, 7, ''), (NULL, -110955776, 9877.1, true, hll_hash(''), percentile_hash('-194169345'), false, percentile_hash('-273509299'), hll_hash('auQ9YC'), 0.9554629440771643, 88007400419.7, '2010-01-15', 0.706586263960329, 5, '');
INSERT INTO t1 VALUES (-584444685, '2010-01-07', '2010-01-27 08:00:14', 997564.77, 0.00006785113246, 'SeXxWPQqD', '', -1811795867, NULL, 11, '2010-01-04 08:00:14', '2010-01-15', 45227565106.15242281, ["", "my", "DaANJQa8X"], false, ["U", "kX", "2KWXljHr", "n94RMd", "zRW", "F", "", "h"], '2010-01-28 08:00:14', [1991707373, 1450040376, 1886556730, -516240212, -1811795867]);
INSERT INTO t0 VALUES ('2010-01-25', -416046836, 4308.5, true, hll_hash('W'), percentile_hash('-202756662'), true, percentile_hash('899924620'), hll_hash('Bd'), 0.36761652667033806, 55786201159.5, '2010-01-24', NULL, 5, ''), ('2010-01-14', -1548562823, 5749.1, false, hll_hash('G'), percentile_hash('61746514'), true, percentile_hash('-1811795867'), hll_hash('uVfjQ9PB'), 0.7149424964148393, 9458163708.8, '2010-01-21', 0.4294844711126856, NULL, ''), (NULL, 417933515, 295.6, true, hll_hash(''), percentile_hash('-1100864005'), false, percentile_hash('1544011767'), hll_hash('H'), 0.4695335067596168, 21957750771.2, '2010-01-13', 0.3294601855868845, NULL, '');
INSERT INTO t1 VALUES (1006882437, '2009-12-31', '2010-01-14 08:00:14', 399424.59, 0.00004802035923, 'S', '', -389908676, 10, 5, '2010-01-13 08:00:14', '2010-01-16', 33284021599.03115184, ["", "", "l", "SpyhRtU", "", "", "", "g"], true, ["", "", "oUxPsW", "SEUA", "Et"], '2010-01-03 08:00:14', [-961603077, -2122180062]), (NULL, '2010-01-04', '2010-01-10 08:00:14', 464317.88, 0.00001309181593, '', '', -658571796, 3, 11, '2010-01-10 08:00:14', '2010-01-12', 72733216478.26568271, ["K"], false, ["3v", "", "xc0M", "", "MCB0", "821QHWDQ", "3", "eQdc", "DTH", "wog3I"], '2010-01-28 08:00:14', [411868673, 1195327459, 560912658, -814892451, -1127807000]), (411868673, '2010-01-09', '2010-01-21 08:00:14', 207723.15, 0.00006307250121, 'M8', '', 103385437, 9, 15, '2010-01-12 08:00:14', '2010-01-24', 12614468880.33421436, ["t", "V", "HUdJK9L", "", "bcOm5vk", "h93nu", "29"], true, [], '2010-01-04 08:00:14', [1189431551, -978067387, 1880073830, 1391434926, 1713532567, -892133515]);
INSERT INTO t1 VALUES (NULL, '2010-01-13', NULL, 919727.77, 0.00008026507635, 'kLk60QBL4', '', -826191688, 1, NULL, '2010-01-27 08:00:14', '2010-01-06', 69150577184.15597776, [], false, ["yU4", "G1", "NrtC2", "Uhp", "", "xtR5H", "nq2UeR6", "ZnL", "", "IgB", "92oYFR", "NFHgt7HwK"], '2010-01-18 08:00:14', [-931091421, -294146256, -1742427531, 612205636, -1136444613, -1127807000, 316068570, -516240212, 676065561, -1154854856]);
INSERT INTO t1 VALUES (1198278818, '2010-01-09', '2010-01-19 08:00:14', 364007.08, 0.00007790892226, 'HO', '', -351606648, 7, 14, '2010-01-11 08:00:14', '2010-01-03', 21212146026.09570974, ["F", ""], false, ["6f", "", "", "N", "", "h", "PYd9"], '2010-01-05 08:00:14', [-1154854856, 411868673, 1879030524, 810363705, -1883651114, 364745034, 1391434926, -1612675354]);
INSERT INTO t1 VALUES (-941577156, '2010-01-28', '2010-01-31 08:00:14', 805403.93, 0.00000450262425, 'M0tBL25ST', '', 311996279, NULL, 7, '2010-01-06 08:00:14', '2010-01-01', 80328704950.01991447, ["4kxm"], NULL, ["NWXm3umv", "e", "F73", "x"], '2010-01-19 08:00:14', [1189431551, -892133515, -800828955, 612205636, 1437227976, -800828955, -2005197926, 830335652]), (-1109310390, '2010-01-07', '2010-01-14 08:00:14', 846385.07, 0.00004461672858, '', '', -1604043942, 2, 11, '2009-12-31 08:00:14', '2010-01-25', 19722123981.55155755, ["JLW4f", "", "2"], NULL, ["", "Qf", "kg5", "i7", "7A", "L", "c4X", "O", ""], '2010-01-05 08:00:14', [1713532567, -567732282, 1558719557, -1503010348, -584444685, -956488008, 2050508745, 1553228656, -1, 1703648928, -836877894, -1453378163]);
CREATE MATERIALIZED VIEW v0 AS SELECT t0_2274.c_0_1, t0_2274.c_0_3, t0_2274.c_0_6, t0_2274.c_0_9, t0_2274.c_0_11, t0_2274.c_0_14, MAX(t0_2274.c_0_0) , MIN(t0_2274.c_0_2) , SUM(t0_2274.c_0_10) , MAX(t0_2274.c_0_12) , COUNT(t0_2274.c_0_13) FROM t0 AS t0_2274 GROUP BY t0_2274.c_0_1, t0_2274.c_0_3, t0_2274.c_0_6, t0_2274.c_0_9, t0_2274.c_0_11, t0_2274.c_0_14 ORDER BY t0_2274.c_0_1, t0_2274.c_0_3, t0_2274.c_0_6 DESC, t0_2274.c_0_9 DESC, t0_2274.c_0_11, t0_2274.c_0_14;
CREATE MATERIALIZED VIEW v0 AS SELECT t0_2276.c_0_1, t0_2276.c_0_2, t0_2276.c_0_12, MIN(t0_2276.c_0_0) , MAX(t0_2276.c_0_3) , MAX(t0_2276.c_0_6) , MAX(t0_2276.c_0_9) , SUM(t0_2276.c_0_10) , MAX(t0_2276.c_0_11) , SUM(t0_2276.c_0_13) , MAX(t0_2276.c_0_14) FROM t0 AS t0_2276 GROUP BY t0_2276.c_0_1, t0_2276.c_0_2, t0_2276.c_0_12 ORDER BY t0_2276.c_0_1 DESC, t0_2276.c_0_2 ASC, t0_2276.c_0_12 ASC;
INSERT INTO t0 VALUES ('2009-12-31', 1391434926, 3716.6, true, hll_hash(''), percentile_hash('-1100864005'), true, percentile_hash('411868673'), hll_hash('L8'), 0.4524107114861857, 48104116247.4, '2009-12-31', 0.48189228567898157, 4, ''), ('2010-01-30', -1608645381, 5437.3, true, hll_hash('iEd'), percentile_hash('-1554039870'), true, percentile_hash('2074867487'), hll_hash(''), 0.8931026415764478, 45185490338.1, '2009-12-31', 0.5096277987729163, 3, '');
CREATE VIEW v3 AS WITH with_t_0 as (SELECT t1_2281.c_1_0, t1_2281.c_1_1, t1_2281.c_1_2, t1_2281.c_1_3, t1_2281.c_1_4, t1_2281.c_1_5, t1_2281.c_1_6, t1_2281.c_1_7, t1_2281.c_1_8, t1_2281.c_1_9, t1_2281.c_1_10, t1_2281.c_1_11, t1_2281.c_1_12, t1_2281.c_1_14, t1_2281.c_1_16 FROM t1 AS t1_2281) , with_t_1 as (SELECT t0_2280.c_0_0, t0_2280.c_0_1, t0_2280.c_0_2, t0_2280.c_0_3, t0_2280.c_0_6, t0_2280.c_0_9, t0_2280.c_0_10, t0_2280.c_0_11, t0_2280.c_0_12, t0_2280.c_0_13, t0_2280.c_0_14 FROM t0 AS t0_2280) SELECT t0_2280.c_0_0 FROM t0 AS t0_2280, t1 AS t1_2281, with_t_0 AS with_t_0, with_t_1 AS with_t_1;
CREATE VIEW v0 AS WITH with_t_0 as (SELECT t1_2281.c_1_0, t1_2281.c_1_1, t1_2281.c_1_2, t1_2281.c_1_3, t1_2281.c_1_4, t1_2281.c_1_5, t1_2281.c_1_6, t1_2281.c_1_7, t1_2281.c_1_8, t1_2281.c_1_9, t1_2281.c_1_10, t1_2281.c_1_11, t1_2281.c_1_12, t1_2281.c_1_14, t1_2281.c_1_16 FROM t1 AS t1_2281) , with_t_1 as (SELECT t0_2280.c_0_0, t0_2280.c_0_1, t0_2280.c_0_2, t0_2280.c_0_3, t0_2280.c_0_6, t0_2280.c_0_9, t0_2280.c_0_10, t0_2280.c_0_11, t0_2280.c_0_12, t0_2280.c_0_13, t0_2280.c_0_14 FROM t0 AS t0_2280) SELECT t0_2280.c_0_0 FROM t0 AS t0_2280, t1 AS t1_2281, with_t_0 AS with_t_0, with_t_1 AS with_t_1 WHERE (t1_2281.c_1_6) BETWEEN (t1_2281.c_1_6) AND ('') ;
CREATE VIEW v1 AS WITH with_t_0 as (SELECT t1_2281.c_1_0, t1_2281.c_1_1, t1_2281.c_1_2, t1_2281.c_1_3, t1_2281.c_1_4, t1_2281.c_1_5, t1_2281.c_1_6, t1_2281.c_1_7, t1_2281.c_1_8, t1_2281.c_1_9, t1_2281.c_1_10, t1_2281.c_1_11, t1_2281.c_1_12, t1_2281.c_1_14, t1_2281.c_1_16 FROM t1 AS t1_2281) , with_t_1 as (SELECT t0_2280.c_0_0, t0_2280.c_0_1, t0_2280.c_0_2, t0_2280.c_0_3, t0_2280.c_0_6, t0_2280.c_0_9, t0_2280.c_0_10, t0_2280.c_0_11, t0_2280.c_0_12, t0_2280.c_0_13, t0_2280.c_0_14 FROM t0 AS t0_2280) SELECT t0_2280.c_0_0 FROM t0 AS t0_2280, t1 AS t1_2281, with_t_0 AS with_t_0, with_t_1 AS with_t_1 WHERE (NOT ((t1_2281.c_1_6) BETWEEN (t1_2281.c_1_6) AND ('') ));
CREATE VIEW v2 AS WITH with_t_0 as (SELECT t1_2281.c_1_0, t1_2281.c_1_1, t1_2281.c_1_2, t1_2281.c_1_3, t1_2281.c_1_4, t1_2281.c_1_5, t1_2281.c_1_6, t1_2281.c_1_7, t1_2281.c_1_8, t1_2281.c_1_9, t1_2281.c_1_10, t1_2281.c_1_11, t1_2281.c_1_12, t1_2281.c_1_14, t1_2281.c_1_16 FROM t1 AS t1_2281) , with_t_1 as (SELECT t0_2280.c_0_0, t0_2280.c_0_1, t0_2280.c_0_2, t0_2280.c_0_3, t0_2280.c_0_6, t0_2280.c_0_9, t0_2280.c_0_10, t0_2280.c_0_11, t0_2280.c_0_12, t0_2280.c_0_13, t0_2280.c_0_14 FROM t0 AS t0_2280) SELECT t0_2280.c_0_0 FROM t0 AS t0_2280, t1 AS t1_2281, with_t_0 AS with_t_0, with_t_1 AS with_t_1 WHERE (((t1_2281.c_1_6) BETWEEN (t1_2281.c_1_6) AND ('') ) IS NULL);
CREATE VIEW v4 AS WITH with_t_0 as (SELECT t1_2281.c_1_0, t1_2281.c_1_1, t1_2281.c_1_2, t1_2281.c_1_3, t1_2281.c_1_4, t1_2281.c_1_5, t1_2281.c_1_6, t1_2281.c_1_7, t1_2281.c_1_8, t1_2281.c_1_9, t1_2281.c_1_10, t1_2281.c_1_11, t1_2281.c_1_12, t1_2281.c_1_14, t1_2281.c_1_16 FROM t1 AS t1_2281) , with_t_1 as (SELECT t0_2280.c_0_0, t0_2280.c_0_1, t0_2280.c_0_2, t0_2280.c_0_3, t0_2280.c_0_6, t0_2280.c_0_9, t0_2280.c_0_10, t0_2280.c_0_11, t0_2280.c_0_12, t0_2280.c_0_13, t0_2280.c_0_14 FROM t0 AS t0_2280) SELECT t0_2280.c_0_0 FROM t0 AS t0_2280, t1 AS t1_2281, with_t_0 AS with_t_0, with_t_1 AS with_t_1 WHERE (t1_2281.c_1_6) BETWEEN (t1_2281.c_1_6) AND ('') UNION ALL SELECT t0_2280.c_0_0 FROM t0 AS t0_2280, t1 AS t1_2281, with_t_0 AS with_t_0, with_t_1 AS with_t_1 WHERE (NOT ((t1_2281.c_1_6) BETWEEN (t1_2281.c_1_6) AND ('') )) UNION ALL SELECT t0_2280.c_0_0 FROM t0 AS t0_2280, t1 AS t1_2281, with_t_0 AS with_t_0, with_t_1 AS with_t_1 WHERE (((t1_2281.c_1_6) BETWEEN (t1_2281.c_1_6) AND ('') ) IS NULL);
CREATE VIEW v5 AS SELECT v0_2302.c_0_0 FROM v0 AS v0_2302, v4 AS v4_2306, t1 AS t1_2301, v2 AS v2_2304, v3 AS v3_2305;
CREATE VIEW v6 AS SELECT v0_2302.c_0_0 FROM v0 AS v0_2302, v4 AS v4_2306, t1 AS t1_2301, v2 AS v2_2304, v3 AS v3_2305 WHERE false;
CREATE VIEW v7 AS SELECT v0_2302.c_0_0 FROM v0 AS v0_2302, v4 AS v4_2306, t1 AS t1_2301, v2 AS v2_2304, v3 AS v3_2305 WHERE (NOT (false));
CREATE VIEW v93 AS SELECT v0_2302.c_0_0 FROM v0 AS v0_2302, v4 AS v4_2306, t1 AS t1_2301, v2 AS v2_2304, v3 AS v3_2305 WHERE ((false) IS NULL);
CREATE VIEW v8 AS SELECT v0_2302.c_0_0 FROM v0 AS v0_2302, v4 AS v4_2306, t1 AS t1_2301, v2 AS v2_2304, v3 AS v3_2305 WHERE false UNION ALL SELECT v0_2302.c_0_0 FROM v0 AS v0_2302, v4 AS v4_2306, t1 AS t1_2301, v2 AS v2_2304, v3 AS v3_2305 WHERE (NOT (false)) UNION ALL SELECT v0_2302.c_0_0 FROM v0 AS v0_2302, v4 AS v4_2306, t1 AS t1_2301, v2 AS v2_2304, v3 AS v3_2305 WHERE ((false) IS NULL);
CREATE VIEW v67 AS SELECT subv1.c_0_0 FROM t1 AS t1_2346, v8 AS v8_2355, (SELECT v1_2348.c_0_0 FROM v1 AS v1_2348 WHERE true) subv1 LEFT JOIN (SELECT v3_2350.c_0_0 FROM v3 AS v3_2350 WHERE CASE WHEN (CAST(v3_2350.c_0_0 AS DATE ) ) BETWEEN (v3_2350.c_0_0) AND (v3_2350.c_0_0) THEN CASE WHEN (v3_2350.c_0_0) IN ('1969-12-14') THEN false ELSE true END WHEN true THEN ((('')||((((('')||('')))||(CAST(v3_2350.c_0_0 AS STRING ) ))))) BETWEEN (MD5(GET_JSON_STRING('', '3') ) ) AND ('') END) subv3 ON subv1.c_0_0 = subv3.c_0_0 AND CASE WHEN true THEN subv1.c_0_0 END = subv3.c_0_0;
CREATE VIEW v9 AS SELECT subv1.c_0_0 FROM t1 AS t1_2346, v8 AS v8_2355, (SELECT v1_2348.c_0_0 FROM v1 AS v1_2348 WHERE true) subv1 LEFT JOIN (SELECT v3_2350.c_0_0 FROM v3 AS v3_2350 WHERE CASE WHEN (CAST(v3_2350.c_0_0 AS DATE ) ) BETWEEN (v3_2350.c_0_0) AND (v3_2350.c_0_0) THEN CASE WHEN (v3_2350.c_0_0) IN ('1969-12-14') THEN false ELSE true END WHEN true THEN ((('')||((((('')||('')))||(CAST(v3_2350.c_0_0 AS STRING ) ))))) BETWEEN (MD5(GET_JSON_STRING('', '3') ) ) AND ('') END) subv3 ON subv1.c_0_0 = subv3.c_0_0 AND CASE WHEN true THEN subv1.c_0_0 END = subv3.c_0_0 WHERE false;
CREATE VIEW v10 AS SELECT subv1.c_0_0 FROM t1 AS t1_2346, v8 AS v8_2355, (SELECT v1_2348.c_0_0 FROM v1 AS v1_2348 WHERE true) subv1 LEFT JOIN (SELECT v3_2350.c_0_0 FROM v3 AS v3_2350 WHERE CASE WHEN (CAST(v3_2350.c_0_0 AS DATE ) ) BETWEEN (v3_2350.c_0_0) AND (v3_2350.c_0_0) THEN CASE WHEN (v3_2350.c_0_0) IN ('1969-12-14') THEN false ELSE true END WHEN true THEN ((('')||((((('')||('')))||(CAST(v3_2350.c_0_0 AS STRING ) ))))) BETWEEN (MD5(GET_JSON_STRING('', '3') ) ) AND ('') END) subv3 ON subv1.c_0_0 = subv3.c_0_0 AND CASE WHEN true THEN subv1.c_0_0 END = subv3.c_0_0 WHERE (NOT (false));
CREATE VIEW v11 AS SELECT subv1.c_0_0 FROM t1 AS t1_2346, v8 AS v8_2355, (SELECT v1_2348.c_0_0 FROM v1 AS v1_2348 WHERE true) subv1 LEFT JOIN (SELECT v3_2350.c_0_0 FROM v3 AS v3_2350 WHERE CASE WHEN (CAST(v3_2350.c_0_0 AS DATE ) ) BETWEEN (v3_2350.c_0_0) AND (v3_2350.c_0_0) THEN CASE WHEN (v3_2350.c_0_0) IN ('1969-12-14') THEN false ELSE true END WHEN true THEN ((('')||((((('')||('')))||(CAST(v3_2350.c_0_0 AS STRING ) ))))) BETWEEN (MD5(GET_JSON_STRING('', '3') ) ) AND ('') END) subv3 ON subv1.c_0_0 = subv3.c_0_0 AND CASE WHEN true THEN subv1.c_0_0 END = subv3.c_0_0 WHERE ((false) IS NULL);
CREATE VIEW v12 AS SELECT subv1.c_0_0 FROM t1 AS t1_2346, v8 AS v8_2355, (SELECT v1_2348.c_0_0 FROM v1 AS v1_2348 WHERE true) subv1 LEFT JOIN (SELECT v3_2350.c_0_0 FROM v3 AS v3_2350 WHERE CASE WHEN (CAST(v3_2350.c_0_0 AS DATE ) ) BETWEEN (v3_2350.c_0_0) AND (v3_2350.c_0_0) THEN CASE WHEN (v3_2350.c_0_0) IN ('1969-12-14') THEN false ELSE true END WHEN true THEN ((('')||((((('')||('')))||(CAST(v3_2350.c_0_0 AS STRING ) ))))) BETWEEN (MD5(GET_JSON_STRING('', '3') ) ) AND ('') END) subv3 ON subv1.c_0_0 = subv3.c_0_0 AND CASE WHEN true THEN subv1.c_0_0 END = subv3.c_0_0 WHERE false UNION ALL SELECT subv1.c_0_0 FROM t1 AS t1_2346, v8 AS v8_2355, (SELECT v1_2348.c_0_0 FROM v1 AS v1_2348 WHERE true) subv1 LEFT JOIN (SELECT v3_2350.c_0_0 FROM v3 AS v3_2350 WHERE CASE WHEN (CAST(v3_2350.c_0_0 AS DATE ) ) BETWEEN (v3_2350.c_0_0) AND (v3_2350.c_0_0) THEN CASE WHEN (v3_2350.c_0_0) IN ('1969-12-14') THEN false ELSE true END WHEN true THEN ((('')||((((('')||('')))||(CAST(v3_2350.c_0_0 AS STRING ) ))))) BETWEEN (MD5(GET_JSON_STRING('', '3') ) ) AND ('') END) subv3 ON subv1.c_0_0 = subv3.c_0_0 AND CASE WHEN true THEN subv1.c_0_0 END = subv3.c_0_0 WHERE (NOT (false)) UNION ALL SELECT subv1.c_0_0 FROM t1 AS t1_2346, v8 AS v8_2355, (SELECT v1_2348.c_0_0 FROM v1 AS v1_2348 WHERE true) subv1 LEFT JOIN (SELECT v3_2350.c_0_0 FROM v3 AS v3_2350 WHERE CASE WHEN (CAST(v3_2350.c_0_0 AS DATE ) ) BETWEEN (v3_2350.c_0_0) AND (v3_2350.c_0_0) THEN CASE WHEN (v3_2350.c_0_0) IN ('1969-12-14') THEN false ELSE true END WHEN true THEN ((('')||((((('')||('')))||(CAST(v3_2350.c_0_0 AS STRING ) ))))) BETWEEN (MD5(GET_JSON_STRING('', '3') ) ) AND ('') END) subv3 ON subv1.c_0_0 = subv3.c_0_0 AND CASE WHEN true THEN subv1.c_0_0 END = subv3.c_0_0 WHERE ((false) IS NULL);
CREATE VIEW v13 AS SELECT v8_2429.c_0_0 FROM v8 AS v8_2429;
CREATE VIEW v14 AS SELECT v8_2429.c_0_0 FROM v8 AS v8_2429 WHERE CASE WHEN true THEN ((v8_2429.c_0_0) IS NULL) END;
CREATE VIEW v15 AS SELECT v8_2429.c_0_0 FROM v8 AS v8_2429 WHERE (NOT (CASE WHEN true THEN ((v8_2429.c_0_0) IS NULL) END));
CREATE VIEW v16 AS SELECT v8_2429.c_0_0 FROM v8 AS v8_2429 WHERE ((CASE WHEN true THEN ((v8_2429.c_0_0) IS NULL) END) IS NULL);
mysql> SELECT * FROM v14 UNION ALL SELECT * FROM v15 UNION ALL SELECT * FROM v16;
ERROR 1064 (HY000): Query exceeded time limit of 500 seconds
mysql> SELECT * FROM v14 UNION ALL SELECT * FROM v15 UNION ALL SELECT * FROM v16;
Empty set (0.63 sec)
mysql> SELECT * FROM v14 UNION ALL SELECT * FROM v15 UNION ALL SELECT * FROM v16;
Empty set (0.62 sec)
mysql> SELECT * FROM v14 UNION ALL SELECT * FROM v15 UNION ALL SELECT * FROM v16;
Empty set (0.65 sec)
explain:
mysql> explain SELECT * FROM v14 UNION ALL SELECT * FROM v15 UNION ALL SELECT * FROM v16;
+--------------------------------------------------------------------+
| Explain String |
+--------------------------------------------------------------------+
| PLAN FRAGMENT 0 |
| OUTPUT EXPRS:4927: c_0_0 |
| PARTITION: UNPARTITIONED |
| |
| RESULT SINK |
| |
| 289:EXCHANGE |
| |
| PLAN FRAGMENT 1 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 289 |
| UNPARTITIONED |
| |
| 0:UNION |
| | |
| |----192:EXCHANGE |
| | |
| |----288:EXCHANGE |
| | |
| 96:EXCHANGE |
| |
| PLAN FRAGMENT 2 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 288 |
| RANDOM |
| |
| 287:Project |
| | <slot 4926> : 3865: c_0_0 |
| | |
| 286:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----285:EXCHANGE |
| | |
| 271:Project |
| | <slot 3865> : 3865: c_0_0 |
| | |
| 270:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----269:EXCHANGE |
| | |
| 255:Project |
| | <slot 3865> : 3865: c_0_0 |
| | |
| 254:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----253:EXCHANGE |
| | |
| 251:Project |
| | <slot 3865> : 3865: c_0_0 |
| | |
| 250:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----249:EXCHANGE |
| | |
| 205:Project |
| | <slot 3865> : 3865: c_0_0 |
| | |
| 204:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----203:EXCHANGE |
| | |
| 201:Project |
| | <slot 3865> : 3865: c_0_0 |
| | |
| 200:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----199:EXCHANGE |
| | |
| 197:Project |
| | <slot 3865> : 3865: c_0_0 |
| | |
| 196:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----195:EXCHANGE |
| | |
| 193:OlapScanNode |
| TABLE: t0 |
| PREAGGREGATION: OFF. Reason: Has can not pre-aggregation Join |
| PREDICATES: 3865: c_0_0 IS NULL IS NULL |
| partitions=1/1 |
| rollup: t0 |
| tabletRatio=3/3 |
| tabletList=3818370,3818374,3818378 |
| cardinality=1 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 3 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 285 |
| UNPARTITIONED |
| |
| 284:Project |
| | <slot 4367> : 4367: c_0_3 |
| | |
| 283:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----282:EXCHANGE |
| | |
| 280:Project |
| | <slot 4360> : 4360: c_1_14 |
| | |
| 279:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----278:EXCHANGE |
| | |
| 276:Project |
| | <slot 4316> : 4316: c_0_3 |
| | |
| 275:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----274:EXCHANGE |
| | |
| 272:OlapScanNode |
| TABLE: t0 |
| PREAGGREGATION: OFF. Reason: Has can not pre-aggregation Join |
| partitions=1/1 |
| rollup: t0 |
| tabletRatio=3/3 |
| tabletList=3818370,3818374,3818378 |
| cardinality=8 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 4 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 282 |
| UNPARTITIONED |
| |
| 281:OlapScanNode |
| TABLE: t0 |
| PREAGGREGATION: OFF. Reason: Has can not pre-aggregation Join |
| partitions=1/1 |
| rollup: t0 |
| tabletRatio=3/3 |
| tabletList=3818370,3818374,3818378 |
| cardinality=8 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 5 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 278 |
| UNPARTITIONED |
| |
| 277:OlapScanNode |
| TABLE: t1 |
| PREAGGREGATION: ON |
| partitions=1/34 |
| rollup: t1 |
| tabletRatio=3/3 |
| tabletList=3818153,3818157,3818161 |
| cardinality=9 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 6 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 274 |
| UNPARTITIONED |
| |
| 273:OlapScanNode |
| TABLE: t1 |
| PREAGGREGATION: ON |
| partitions=1/34 |
| rollup: t1 |
| tabletRatio=3/3 |
| tabletList=3818153,3818157,3818161 |
| cardinality=9 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 7 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 269 |
| UNPARTITIONED |
| |
| 268:Project |
| | <slot 4268> : 4268: c_0_3 |
| | |
| 267:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----266:EXCHANGE |
| | |
| 264:Project |
| | <slot 4261> : 4261: c_1_14 |
| | |
| 263:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----262:EXCHANGE |
| | |
| 260:Project |
| | <slot 4217> : 4217: c_0_3 |
| | |
| 259:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----258:EXCHANGE |
| | |
| 256:OlapScanNode |
| TABLE: t0 |
| PREAGGREGATION: OFF. Reason: Has can not pre-aggregation Join |
| partitions=1/1 |
| rollup: t0 |
| tabletRatio=3/3 |
| tabletList=3818370,3818374,3818378 |
| cardinality=8 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 8 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 266 |
| UNPARTITIONED |
| |
| 265:OlapScanNode |
| TABLE: t0 |
| PREAGGREGATION: OFF. Reason: Has can not pre-aggregation Join |
| partitions=1/1 |
| rollup: t0 |
| tabletRatio=3/3 |
| tabletList=3818370,3818374,3818378 |
| cardinality=8 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 9 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 262 |
| UNPARTITIONED |
| |
| 261:OlapScanNode |
| TABLE: t1 |
| PREAGGREGATION: ON |
| partitions=1/34 |
| rollup: t1 |
| tabletRatio=3/3 |
| tabletList=3818153,3818157,3818161 |
| cardinality=9 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 10 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 258 |
| UNPARTITIONED |
| |
| 257:OlapScanNode |
| TABLE: t1 |
| PREAGGREGATION: ON |
| PREDICATES: 4235: c_1_6 <= '' IS NULL |
| partitions=1/34 |
| rollup: t1 |
| tabletRatio=3/3 |
| tabletList=3818153,3818157,3818161 |
| cardinality=1 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 11 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 253 |
| UNPARTITIONED |
| |
| 252:OlapScanNode |
| TABLE: t1 |
| PREAGGREGATION: ON |
| partitions=1/34 |
| rollup: t1 |
| tabletRatio=3/3 |
| tabletList=3818153,3818157,3818161 |
| cardinality=9 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 12 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 249 |
| UNPARTITIONED |
| |
| 206:UNION |
| | |
| |----234:EXCHANGE |
| | |
| |----248:EXCHANGE |
| | |
| 220:EXCHANGE |
| |
| PLAN FRAGMENT 13 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 248 |
| RANDOM |
| |
| 247:Project |
| | <slot 4096> : 4096: c_0_0 |
| | |
| 246:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----245:EXCHANGE |
| | |
| 243:Project |
| | <slot 4096> : 4096: c_0_0 |
| | |
| 242:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----241:EXCHANGE |
| | |
| 239:Project |
| | <slot 4096> : 4096: c_0_0 |
| | |
| 238:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----237:EXCHANGE |
| | |
| 235:OlapScanNode |
| TABLE: t1 |
| PREAGGREGATION: ON |
| partitions=1/34 |
| rollup: t1 |
| tabletRatio=3/3 |
| tabletList=3818153,3818157,3818161 |
| cardinality=9 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 14 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 245 |
| UNPARTITIONED |
| |
| 244:OlapScanNode |
| TABLE: t1 |
| PREAGGREGATION: ON |
| PREDICATES: 4117: c_1_6 <= '' IS NULL |
| partitions=1/34 |
| rollup: t1 |
| tabletRatio=3/3 |
| tabletList=3818153,3818157,3818161 |
| cardinality=1 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 15 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 241 |
| UNPARTITIONED |
| |
| 240:OlapScanNode |
| TABLE: t0 |
| PREAGGREGATION: OFF. Reason: Has can not pre-aggregation Join |
| partitions=1/1 |
| rollup: t0 |
| tabletRatio=3/3 |
| tabletList=3818370,3818374,3818378 |
| cardinality=8 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 16 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 237 |
| UNPARTITIONED |
| |
| 236:OlapScanNode |
| TABLE: t0 |
| PREAGGREGATION: OFF. Reason: Has can not pre-aggregation Join |
| partitions=1/1 |
| rollup: t0 |
| tabletRatio=3/3 |
| tabletList=3818370,3818374,3818378 |
| cardinality=8 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 17 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 234 |
| RANDOM |
| |
| 233:Project |
| | <slot 4030> : 4030: c_0_0 |
| | |
| 232:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----231:EXCHANGE |
| | |
| 229:Project |
| | <slot 4030> : 4030: c_0_0 |
| | |
| 228:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----227:EXCHANGE |
| | |
| 225:Project |
| | <slot 4030> : 4030: c_0_0 |
| | |
| 224:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----223:EXCHANGE |
| | |
| 221:OlapScanNode |
| TABLE: t1 |
| PREAGGREGATION: ON |
| partitions=1/34 |
| rollup: t1 |
| tabletRatio=3/3 |
| tabletList=3818153,3818157,3818161 |
| cardinality=9 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 18 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 231 |
| UNPARTITIONED |
| |
| 230:OlapScanNode |
| TABLE: t1 |
| PREAGGREGATION: ON |
| PREDICATES: 4051: c_1_6 > '' |
| partitions=1/34 |
| rollup: t1 |
| tabletRatio=3/3 |
| tabletList=3818153,3818157,3818161 |
| cardinality=5 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 19 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 227 |
| UNPARTITIONED |
| |
| 226:OlapScanNode |
| TABLE: t0 |
| PREAGGREGATION: OFF. Reason: Has can not pre-aggregation Join |
| partitions=1/1 |
| rollup: t0 |
| tabletRatio=3/3 |
| tabletList=3818370,3818374,3818378 |
| cardinality=8 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 20 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 223 |
| UNPARTITIONED |
| |
| 222:OlapScanNode |
| TABLE: t0 |
| PREAGGREGATION: OFF. Reason: Has can not pre-aggregation Join |
| partitions=1/1 |
| rollup: t0 |
| tabletRatio=3/3 |
| tabletList=3818370,3818374,3818378 |
| cardinality=8 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 21 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 220 |
| RANDOM |
| |
| 219:Project |
| | <slot 3964> : 3964: c_0_0 |
| | |
| 218:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----217:EXCHANGE |
| | |
| 215:Project |
| | <slot 3964> : 3964: c_0_0 |
| | |
| 214:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----213:EXCHANGE |
| | |
| 211:Project |
| | <slot 3964> : 3964: c_0_0 |
| | |
| 210:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----209:EXCHANGE |
| | |
| 207:OlapScanNode |
| TABLE: t1 |
| PREAGGREGATION: ON |
| partitions=1/34 |
| rollup: t1 |
| tabletRatio=3/3 |
| tabletList=3818153,3818157,3818161 |
| cardinality=9 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 22 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 217 |
| UNPARTITIONED |
| |
| 216:OlapScanNode |
| TABLE: t1 |
| PREAGGREGATION: ON |
| PREDICATES: 3985: c_1_6 <= '' |
| partitions=1/34 |
| rollup: t1 |
| tabletRatio=3/3 |
| tabletList=3818153,3818157,3818161 |
| cardinality=5 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 23 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 213 |
| UNPARTITIONED |
| |
| 212:OlapScanNode |
| TABLE: t0 |
| PREAGGREGATION: OFF. Reason: Has can not pre-aggregation Join |
| partitions=1/1 |
| rollup: t0 |
| tabletRatio=3/3 |
| tabletList=3818370,3818374,3818378 |
| cardinality=8 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 24 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 209 |
| UNPARTITIONED |
| |
| 208:OlapScanNode |
| TABLE: t0 |
| PREAGGREGATION: OFF. Reason: Has can not pre-aggregation Join |
| partitions=1/1 |
| rollup: t0 |
| tabletRatio=3/3 |
| tabletList=3818370,3818374,3818378 |
| cardinality=8 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 25 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 203 |
| UNPARTITIONED |
| |
| 202:OlapScanNode |
| TABLE: t0 |
| PREAGGREGATION: OFF. Reason: Has can not pre-aggregation Join |
| partitions=1/1 |
| rollup: t0 |
| tabletRatio=3/3 |
| tabletList=3818370,3818374,3818378 |
| cardinality=8 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 26 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 199 |
| UNPARTITIONED |
| |
| 198:OlapScanNode |
| TABLE: t1 |
| PREAGGREGATION: ON |
| partitions=1/34 |
| rollup: t1 |
| tabletRatio=3/3 |
| tabletList=3818153,3818157,3818161 |
| cardinality=9 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 27 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 195 |
| UNPARTITIONED |
| |
| 194:OlapScanNode |
| TABLE: t1 |
| PREAGGREGATION: ON |
| PREDICATES: 3886: c_1_6 <= '' |
| partitions=1/34 |
| rollup: t1 |
| tabletRatio=3/3 |
| tabletList=3818153,3818157,3818161 |
| cardinality=5 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 28 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 192 |
| RANDOM |
| |
| 191:Project |
| | <slot 3284> : 2223: c_0_0 |
| | |
| 190:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----189:EXCHANGE |
| | |
| 175:Project |
| | <slot 2223> : 2223: c_0_0 |
| | |
| 174:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----173:EXCHANGE |
| | |
| 159:Project |
| | <slot 2223> : 2223: c_0_0 |
| | |
| 158:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----157:EXCHANGE |
| | |
| 155:Project |
| | <slot 2223> : 2223: c_0_0 |
| | |
| 154:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----153:EXCHANGE |
| | |
| 109:Project |
| | <slot 2223> : 2223: c_0_0 |
| | |
| 108:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----107:EXCHANGE |
| | |
| 105:Project |
| | <slot 2223> : 2223: c_0_0 |
| | |
| 104:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----103:EXCHANGE |
| | |
| 101:Project |
| | <slot 2223> : 2223: c_0_0 |
| | |
| 100:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----99:EXCHANGE |
| | |
| 97:OlapScanNode |
| TABLE: t0 |
| PREAGGREGATION: OFF. Reason: Has can not pre-aggregation Join |
| PREDICATES: 2223: c_0_0 IS NOT NULL |
| partitions=1/1 |
| rollup: t0 |
| tabletRatio=3/3 |
| tabletList=3818370,3818374,3818378 |
| cardinality=7 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 29 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 189 |
| UNPARTITIONED |
| |
| 188:Project |
| | <slot 2725> : 2725: c_0_3 |
| | |
| 187:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----186:EXCHANGE |
| | |
| 184:Project |
| | <slot 2718> : 2718: c_1_14 |
| | |
| 183:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----182:EXCHANGE |
| | |
| 180:Project |
| | <slot 2674> : 2674: c_0_3 |
| | |
| 179:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----178:EXCHANGE |
| | |
| 176:OlapScanNode |
| TABLE: t0 |
| PREAGGREGATION: OFF. Reason: Has can not pre-aggregation Join |
| partitions=1/1 |
| rollup: t0 |
| tabletRatio=3/3 |
| tabletList=3818370,3818374,3818378 |
| cardinality=8 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 30 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 186 |
| UNPARTITIONED |
| |
| 185:OlapScanNode |
| TABLE: t0 |
| PREAGGREGATION: OFF. Reason: Has can not pre-aggregation Join |
| partitions=1/1 |
| rollup: t0 |
| tabletRatio=3/3 |
| tabletList=3818370,3818374,3818378 |
| cardinality=8 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 31 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 182 |
| UNPARTITIONED |
| |
| 181:OlapScanNode |
| TABLE: t1 |
| PREAGGREGATION: ON |
| partitions=1/34 |
| rollup: t1 |
| tabletRatio=3/3 |
| tabletList=3818153,3818157,3818161 |
| cardinality=9 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 32 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 178 |
| UNPARTITIONED |
| |
| 177:OlapScanNode |
| TABLE: t1 |
| PREAGGREGATION: ON |
| partitions=1/34 |
| rollup: t1 |
| tabletRatio=3/3 |
| tabletList=3818153,3818157,3818161 |
| cardinality=9 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 33 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 173 |
| UNPARTITIONED |
| |
| 172:Project |
| | <slot 2626> : 2626: c_0_3 |
| | |
| 171:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----170:EXCHANGE |
| | |
| 168:Project |
| | <slot 2619> : 2619: c_1_14 |
| | |
| 167:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----166:EXCHANGE |
| | |
| 164:Project |
| | <slot 2575> : 2575: c_0_3 |
| | |
| 163:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----162:EXCHANGE |
| | |
| 160:OlapScanNode |
| TABLE: t0 |
| PREAGGREGATION: OFF. Reason: Has can not pre-aggregation Join |
| partitions=1/1 |
| rollup: t0 |
| tabletRatio=3/3 |
| tabletList=3818370,3818374,3818378 |
| cardinality=8 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 34 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 170 |
| UNPARTITIONED |
| |
| 169:OlapScanNode |
| TABLE: t0 |
| PREAGGREGATION: OFF. Reason: Has can not pre-aggregation Join |
| partitions=1/1 |
| rollup: t0 |
| tabletRatio=3/3 |
| tabletList=3818370,3818374,3818378 |
| cardinality=8 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 35 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 166 |
| UNPARTITIONED |
| |
| 165:OlapScanNode |
| TABLE: t1 |
| PREAGGREGATION: ON |
| partitions=1/34 |
| rollup: t1 |
| tabletRatio=3/3 |
| tabletList=3818153,3818157,3818161 |
| cardinality=9 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 36 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 162 |
| UNPARTITIONED |
| |
| 161:OlapScanNode |
| TABLE: t1 |
| PREAGGREGATION: ON |
| PREDICATES: 2593: c_1_6 <= '' IS NULL |
| partitions=1/34 |
| rollup: t1 |
| tabletRatio=3/3 |
| tabletList=3818153,3818157,3818161 |
| cardinality=1 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 37 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 157 |
| UNPARTITIONED |
| |
| 156:OlapScanNode |
| TABLE: t1 |
| PREAGGREGATION: ON |
| partitions=1/34 |
| rollup: t1 |
| tabletRatio=3/3 |
| tabletList=3818153,3818157,3818161 |
| cardinality=9 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 38 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 153 |
| UNPARTITIONED |
| |
| 110:UNION |
| | |
| |----138:EXCHANGE |
| | |
| |----152:EXCHANGE |
| | |
| 124:EXCHANGE |
| |
| PLAN FRAGMENT 39 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 152 |
| RANDOM |
| |
| 151:Project |
| | <slot 2454> : 2454: c_0_0 |
| | |
| 150:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----149:EXCHANGE |
| | |
| 147:Project |
| | <slot 2454> : 2454: c_0_0 |
| | |
| 146:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----145:EXCHANGE |
| | |
| 143:Project |
| | <slot 2454> : 2454: c_0_0 |
| | |
| 142:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----141:EXCHANGE |
| | |
| 139:OlapScanNode |
| TABLE: t1 |
| PREAGGREGATION: ON |
| partitions=1/34 |
| rollup: t1 |
| tabletRatio=3/3 |
| tabletList=3818153,3818157,3818161 |
| cardinality=9 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 40 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 149 |
| UNPARTITIONED |
| |
| 148:OlapScanNode |
| TABLE: t1 |
| PREAGGREGATION: ON |
| PREDICATES: 2475: c_1_6 <= '' IS NULL |
| partitions=1/34 |
| rollup: t1 |
| tabletRatio=3/3 |
| tabletList=3818153,3818157,3818161 |
| cardinality=1 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 41 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 145 |
| UNPARTITIONED |
| |
| 144:OlapScanNode |
| TABLE: t0 |
| PREAGGREGATION: OFF. Reason: Has can not pre-aggregation Join |
| partitions=1/1 |
| rollup: t0 |
| tabletRatio=3/3 |
| tabletList=3818370,3818374,3818378 |
| cardinality=8 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 42 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 141 |
| UNPARTITIONED |
| |
| 140:OlapScanNode |
| TABLE: t0 |
| PREAGGREGATION: OFF. Reason: Has can not pre-aggregation Join |
| partitions=1/1 |
| rollup: t0 |
| tabletRatio=3/3 |
| tabletList=3818370,3818374,3818378 |
| cardinality=8 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 43 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 138 |
| RANDOM |
| |
| 137:Project |
| | <slot 2388> : 2388: c_0_0 |
| | |
| 136:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----135:EXCHANGE |
| | |
| 133:Project |
| | <slot 2388> : 2388: c_0_0 |
| | |
| 132:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----131:EXCHANGE |
| | |
| 129:Project |
| | <slot 2388> : 2388: c_0_0 |
| | |
| 128:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----127:EXCHANGE |
| | |
| 125:OlapScanNode |
| TABLE: t1 |
| PREAGGREGATION: ON |
| partitions=1/34 |
| rollup: t1 |
| tabletRatio=3/3 |
| tabletList=3818153,3818157,3818161 |
| cardinality=9 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 44 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 135 |
| UNPARTITIONED |
| |
| 134:OlapScanNode |
| TABLE: t1 |
| PREAGGREGATION: ON |
| PREDICATES: 2409: c_1_6 > '' |
| partitions=1/34 |
| rollup: t1 |
| tabletRatio=3/3 |
| tabletList=3818153,3818157,3818161 |
| cardinality=5 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 45 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 131 |
| UNPARTITIONED |
| |
| 130:OlapScanNode |
| TABLE: t0 |
| PREAGGREGATION: OFF. Reason: Has can not pre-aggregation Join |
| partitions=1/1 |
| rollup: t0 |
| tabletRatio=3/3 |
| tabletList=3818370,3818374,3818378 |
| cardinality=8 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 46 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 127 |
| UNPARTITIONED |
| |
| 126:OlapScanNode |
| TABLE: t0 |
| PREAGGREGATION: OFF. Reason: Has can not pre-aggregation Join |
| partitions=1/1 |
| rollup: t0 |
| tabletRatio=3/3 |
| tabletList=3818370,3818374,3818378 |
| cardinality=8 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 47 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 124 |
| RANDOM |
| |
| 123:Project |
| | <slot 2322> : 2322: c_0_0 |
| | |
| 122:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----121:EXCHANGE |
| | |
| 119:Project |
| | <slot 2322> : 2322: c_0_0 |
| | |
| 118:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----117:EXCHANGE |
| | |
| 115:Project |
| | <slot 2322> : 2322: c_0_0 |
| | |
| 114:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----113:EXCHANGE |
| | |
| 111:OlapScanNode |
| TABLE: t1 |
| PREAGGREGATION: ON |
| partitions=1/34 |
| rollup: t1 |
| tabletRatio=3/3 |
| tabletList=3818153,3818157,3818161 |
| cardinality=9 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 48 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 121 |
| UNPARTITIONED |
| |
| 120:OlapScanNode |
| TABLE: t1 |
| PREAGGREGATION: ON |
| PREDICATES: 2343: c_1_6 <= '' |
| partitions=1/34 |
| rollup: t1 |
| tabletRatio=3/3 |
| tabletList=3818153,3818157,3818161 |
| cardinality=5 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 49 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 117 |
| UNPARTITIONED |
| |
| 116:OlapScanNode |
| TABLE: t0 |
| PREAGGREGATION: OFF. Reason: Has can not pre-aggregation Join |
| partitions=1/1 |
| rollup: t0 |
| tabletRatio=3/3 |
| tabletList=3818370,3818374,3818378 |
| cardinality=8 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 50 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 113 |
| UNPARTITIONED |
| |
| 112:OlapScanNode |
| TABLE: t0 |
| PREAGGREGATION: OFF. Reason: Has can not pre-aggregation Join |
| partitions=1/1 |
| rollup: t0 |
| tabletRatio=3/3 |
| tabletList=3818370,3818374,3818378 |
| cardinality=8 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 51 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 107 |
| UNPARTITIONED |
| |
| 106:OlapScanNode |
| TABLE: t0 |
| PREAGGREGATION: OFF. Reason: Has can not pre-aggregation Join |
| partitions=1/1 |
| rollup: t0 |
| tabletRatio=3/3 |
| tabletList=3818370,3818374,3818378 |
| cardinality=8 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 52 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 103 |
| UNPARTITIONED |
| |
| 102:OlapScanNode |
| TABLE: t1 |
| PREAGGREGATION: ON |
| partitions=1/34 |
| rollup: t1 |
| tabletRatio=3/3 |
| tabletList=3818153,3818157,3818161 |
| cardinality=9 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 53 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 99 |
| UNPARTITIONED |
| |
| 98:OlapScanNode |
| TABLE: t1 |
| PREAGGREGATION: ON |
| PREDICATES: 2244: c_1_6 <= '' |
| partitions=1/34 |
| rollup: t1 |
| tabletRatio=3/3 |
| tabletList=3818153,3818157,3818161 |
| cardinality=5 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 54 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 96 |
| RANDOM |
| |
| 95:Project |
| | <slot 1642> : 581: c_0_0 |
| | |
| 94:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----93:EXCHANGE |
| | |
| 79:Project |
| | <slot 581> : 581: c_0_0 |
| | |
| 78:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----77:EXCHANGE |
| | |
| 63:Project |
| | <slot 581> : 581: c_0_0 |
| | |
| 62:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----61:EXCHANGE |
| | |
| 59:Project |
| | <slot 581> : 581: c_0_0 |
| | |
| 58:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----57:EXCHANGE |
| | |
| 13:Project |
| | <slot 581> : 581: c_0_0 |
| | |
| 12:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----11:EXCHANGE |
| | |
| 9:Project |
| | <slot 581> : 581: c_0_0 |
| | |
| 8:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----7:EXCHANGE |
| | |
| 5:Project |
| | <slot 581> : 581: c_0_0 |
| | |
| 4:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----3:EXCHANGE |
| | |
| 1:OlapScanNode |
| TABLE: t0 |
| PREAGGREGATION: OFF. Reason: Has can not pre-aggregation Join |
| PREDICATES: 581: c_0_0 IS NULL |
| partitions=1/1 |
| rollup: t0 |
| tabletRatio=1/3 |
| tabletList=3818374 |
| cardinality=1 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 55 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 93 |
| UNPARTITIONED |
| |
| 92:Project |
| | <slot 1083> : 1083: c_0_3 |
| | |
| 91:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----90:EXCHANGE |
| | |
| 88:Project |
| | <slot 1076> : 1076: c_1_14 |
| | |
| 87:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----86:EXCHANGE |
| | |
| 84:Project |
| | <slot 1032> : 1032: c_0_3 |
| | |
| 83:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----82:EXCHANGE |
| | |
| 80:OlapScanNode |
| TABLE: t0 |
| PREAGGREGATION: OFF. Reason: Has can not pre-aggregation Join |
| partitions=1/1 |
| rollup: t0 |
| tabletRatio=3/3 |
| tabletList=3818370,3818374,3818378 |
| cardinality=8 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 56 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 90 |
| UNPARTITIONED |
| |
| 89:OlapScanNode |
| TABLE: t0 |
| PREAGGREGATION: OFF. Reason: Has can not pre-aggregation Join |
| partitions=1/1 |
| rollup: t0 |
| tabletRatio=3/3 |
| tabletList=3818370,3818374,3818378 |
| cardinality=8 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 57 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 86 |
| UNPARTITIONED |
| |
| 85:OlapScanNode |
| TABLE: t1 |
| PREAGGREGATION: ON |
| partitions=1/34 |
| rollup: t1 |
| tabletRatio=3/3 |
| tabletList=3818153,3818157,3818161 |
| cardinality=9 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 58 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 82 |
| UNPARTITIONED |
| |
| 81:OlapScanNode |
| TABLE: t1 |
| PREAGGREGATION: ON |
| partitions=1/34 |
| rollup: t1 |
| tabletRatio=3/3 |
| tabletList=3818153,3818157,3818161 |
| cardinality=9 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 59 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 77 |
| UNPARTITIONED |
| |
| 76:Project |
| | <slot 984> : 984: c_0_3 |
| | |
| 75:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----74:EXCHANGE |
| | |
| 72:Project |
| | <slot 977> : 977: c_1_14 |
| | |
| 71:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----70:EXCHANGE |
| | |
| 68:Project |
| | <slot 933> : 933: c_0_3 |
| | |
| 67:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----66:EXCHANGE |
| | |
| 64:OlapScanNode |
| TABLE: t0 |
| PREAGGREGATION: OFF. Reason: Has can not pre-aggregation Join |
| partitions=1/1 |
| rollup: t0 |
| tabletRatio=3/3 |
| tabletList=3818370,3818374,3818378 |
| cardinality=8 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 60 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 74 |
| UNPARTITIONED |
| |
| 73:OlapScanNode |
| TABLE: t0 |
| PREAGGREGATION: OFF. Reason: Has can not pre-aggregation Join |
| partitions=1/1 |
| rollup: t0 |
| tabletRatio=3/3 |
| tabletList=3818370,3818374,3818378 |
| cardinality=8 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 61 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 70 |
| UNPARTITIONED |
| |
| 69:OlapScanNode |
| TABLE: t1 |
| PREAGGREGATION: ON |
| partitions=1/34 |
| rollup: t1 |
| tabletRatio=3/3 |
| tabletList=3818153,3818157,3818161 |
| cardinality=9 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 62 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 66 |
| UNPARTITIONED |
| |
| 65:OlapScanNode |
| TABLE: t1 |
| PREAGGREGATION: ON |
| PREDICATES: 951: c_1_6 <= '' IS NULL |
| partitions=1/34 |
| rollup: t1 |
| tabletRatio=3/3 |
| tabletList=3818153,3818157,3818161 |
| cardinality=1 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 63 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 61 |
| UNPARTITIONED |
| |
| 60:OlapScanNode |
| TABLE: t1 |
| PREAGGREGATION: ON |
| partitions=1/34 |
| rollup: t1 |
| tabletRatio=3/3 |
| tabletList=3818153,3818157,3818161 |
| cardinality=9 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 64 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 57 |
| UNPARTITIONED |
| |
| 14:UNION |
| | |
| |----42:EXCHANGE |
| | |
| |----56:EXCHANGE |
| | |
| 28:EXCHANGE |
| |
| PLAN FRAGMENT 65 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 56 |
| RANDOM |
| |
| 55:Project |
| | <slot 812> : 812: c_0_0 |
| | |
| 54:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----53:EXCHANGE |
| | |
| 51:Project |
| | <slot 812> : 812: c_0_0 |
| | |
| 50:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----49:EXCHANGE |
| | |
| 47:Project |
| | <slot 812> : 812: c_0_0 |
| | |
| 46:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----45:EXCHANGE |
| | |
| 43:OlapScanNode |
| TABLE: t1 |
| PREAGGREGATION: ON |
| partitions=1/34 |
| rollup: t1 |
| tabletRatio=3/3 |
| tabletList=3818153,3818157,3818161 |
| cardinality=9 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 66 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 53 |
| UNPARTITIONED |
| |
| 52:OlapScanNode |
| TABLE: t1 |
| PREAGGREGATION: ON |
| PREDICATES: 833: c_1_6 <= '' IS NULL |
| partitions=1/34 |
| rollup: t1 |
| tabletRatio=3/3 |
| tabletList=3818153,3818157,3818161 |
| cardinality=1 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 67 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 49 |
| UNPARTITIONED |
| |
| 48:OlapScanNode |
| TABLE: t0 |
| PREAGGREGATION: OFF. Reason: Has can not pre-aggregation Join |
| partitions=1/1 |
| rollup: t0 |
| tabletRatio=3/3 |
| tabletList=3818370,3818374,3818378 |
| cardinality=8 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 68 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 45 |
| UNPARTITIONED |
| |
| 44:OlapScanNode |
| TABLE: t0 |
| PREAGGREGATION: OFF. Reason: Has can not pre-aggregation Join |
| partitions=1/1 |
| rollup: t0 |
| tabletRatio=3/3 |
| tabletList=3818370,3818374,3818378 |
| cardinality=8 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 69 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 42 |
| RANDOM |
| |
| 41:Project |
| | <slot 746> : 746: c_0_0 |
| | |
| 40:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----39:EXCHANGE |
| | |
| 37:Project |
| | <slot 746> : 746: c_0_0 |
| | |
| 36:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----35:EXCHANGE |
| | |
| 33:Project |
| | <slot 746> : 746: c_0_0 |
| | |
| 32:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----31:EXCHANGE |
| | |
| 29:OlapScanNode |
| TABLE: t1 |
| PREAGGREGATION: ON |
| partitions=1/34 |
| rollup: t1 |
| tabletRatio=3/3 |
| tabletList=3818153,3818157,3818161 |
| cardinality=9 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 70 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 39 |
| UNPARTITIONED |
| |
| 38:OlapScanNode |
| TABLE: t1 |
| PREAGGREGATION: ON |
| PREDICATES: 767: c_1_6 > '' |
| partitions=1/34 |
| rollup: t1 |
| tabletRatio=3/3 |
| tabletList=3818153,3818157,3818161 |
| cardinality=5 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 71 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 35 |
| UNPARTITIONED |
| |
| 34:OlapScanNode |
| TABLE: t0 |
| PREAGGREGATION: OFF. Reason: Has can not pre-aggregation Join |
| partitions=1/1 |
| rollup: t0 |
| tabletRatio=3/3 |
| tabletList=3818370,3818374,3818378 |
| cardinality=8 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 72 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 31 |
| UNPARTITIONED |
| |
| 30:OlapScanNode |
| TABLE: t0 |
| PREAGGREGATION: OFF. Reason: Has can not pre-aggregation Join |
| partitions=1/1 |
| rollup: t0 |
| tabletRatio=3/3 |
| tabletList=3818370,3818374,3818378 |
| cardinality=8 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 73 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 28 |
| RANDOM |
| |
| 27:Project |
| | <slot 680> : 680: c_0_0 |
| | |
| 26:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----25:EXCHANGE |
| | |
| 23:Project |
| | <slot 680> : 680: c_0_0 |
| | |
| 22:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----21:EXCHANGE |
| | |
| 19:Project |
| | <slot 680> : 680: c_0_0 |
| | |
| 18:CROSS JOIN |
| | cross join: |
| | predicates is NULL. |
| | |
| |----17:EXCHANGE |
| | |
| 15:OlapScanNode |
| TABLE: t1 |
| PREAGGREGATION: ON |
| partitions=1/34 |
| rollup: t1 |
| tabletRatio=3/3 |
| tabletList=3818153,3818157,3818161 |
| cardinality=9 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 74 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 25 |
| UNPARTITIONED |
| |
| 24:OlapScanNode |
| TABLE: t1 |
| PREAGGREGATION: ON |
| PREDICATES: 701: c_1_6 <= '' |
| partitions=1/34 |
| rollup: t1 |
| tabletRatio=3/3 |
| tabletList=3818153,3818157,3818161 |
| cardinality=5 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 75 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 21 |
| UNPARTITIONED |
| |
| 20:OlapScanNode |
| TABLE: t0 |
| PREAGGREGATION: OFF. Reason: Has can not pre-aggregation Join |
| partitions=1/1 |
| rollup: t0 |
| tabletRatio=3/3 |
| tabletList=3818370,3818374,3818378 |
| cardinality=8 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 76 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 17 |
| UNPARTITIONED |
| |
| 16:OlapScanNode |
| TABLE: t0 |
| PREAGGREGATION: OFF. Reason: Has can not pre-aggregation Join |
| partitions=1/1 |
| rollup: t0 |
| tabletRatio=3/3 |
| tabletList=3818370,3818374,3818378 |
| cardinality=8 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 77 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 11 |
| UNPARTITIONED |
| |
| 10:OlapScanNode |
| TABLE: t0 |
| PREAGGREGATION: OFF. Reason: Has can not pre-aggregation Join |
| partitions=1/1 |
| rollup: t0 |
| tabletRatio=3/3 |
| tabletList=3818370,3818374,3818378 |
| cardinality=8 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 78 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 07 |
| UNPARTITIONED |
| |
| 6:OlapScanNode |
| TABLE: t1 |
| PREAGGREGATION: ON |
| partitions=1/34 |
| rollup: t1 |
| tabletRatio=3/3 |
| tabletList=3818153,3818157,3818161 |
| cardinality=9 |
| avgRowSize=1.0 |
| numNodes=0 |
| |
| PLAN FRAGMENT 79 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 03 |
| UNPARTITIONED |
| |
| 2:OlapScanNode |
| TABLE: t1 |
| PREAGGREGATION: ON |
| PREDICATES: 602: c_1_6 <= '' |
| partitions=1/34 |
| rollup: t1 |
| tabletRatio=3/3 |
| tabletList=3818153,3818157,3818161 |
| cardinality=5 |
| avgRowSize=1.0 |
| numNodes=0 |
+--------------------------------------------------------------------+
2108 rows in set (0.16 sec)
Steps to reproduce the behavior (Required)
StarRocks version (Required)
select current_version()