You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Krisztian Kasa (Jira)" <ji...@apache.org> on 2022/01/26 11:52:00 UTC
[jira] [Created] (HIVE-25899) Materialized view registry does not clean dropped views
Krisztian Kasa created HIVE-25899:
-------------------------------------
Summary: Materialized view registry does not clean dropped views
Key: HIVE-25899
URL: https://issues.apache.org/jira/browse/HIVE-25899
Project: Hive
Issue Type: Bug
Components: Materialized views
Reporter: Krisztian Kasa
Assignee: Krisztian Kasa
CBO plans of materialized views which are enabled for query rewrite are cached in HS2 (MaterializedViewsCache)
Dropping a materialized views should remove the entry from the cache however the entry keys are not removed.
Cache state after running a whole PTest split:
{code}
this = {HiveMaterializedViewsRegistry@20858}
materializedViewsCache = {MaterializedViewsCache@20913}
materializedViews = {ConcurrentHashMap@67654} size = 3
"default" -> {ConcurrentHashMap@28568} size = 8
key = "default"
value = {ConcurrentHashMap@28568} size = 8
"cluster_mv_2" -> {HiveRelOptMaterialization@67786}
"cluster_mv_1" -> {HiveRelOptMaterialization@67788}
"cluster_mv_4" -> {HiveRelOptMaterialization@67790}
"cluster_mv_3" -> {HiveRelOptMaterialization@67792}
"cmv_mat_view_n10" -> {HiveRelOptMaterialization@67794}
"distribute_mv_1" -> {HiveRelOptMaterialization@67796}
"distribute_mv_3" -> {HiveRelOptMaterialization@67798}
"distribute_mv_2" -> {HiveRelOptMaterialization@67800}
"db2" -> {ConcurrentHashMap@67772} size = 2
key = "db2"
value = {ConcurrentHashMap@67772} size = 2
"cmv_mat_view_n7" -> {HiveRelOptMaterialization@67806}
"cmv_mat_view2_n2" -> {HiveRelOptMaterialization@67808}
"count_distinct" -> {ConcurrentHashMap@67774} size = 0
key = "count_distinct"
value = {ConcurrentHashMap@67774} size = 0
sqlToMaterializedView = {ConcurrentHashMap@20915} size = 36
"SELECT `cmv_basetable_n100`.`a`, `cmv_basetable_2_n100`.`c`\n FROM `default`.`cmv_basetable_n100` JOIN `default`.`cmv_basetable_2_n100` ON (`cmv_basetable_n100`.`a` = `cmv_basetable_2_n100`.`a`)\n WHERE `cmv_basetable_2_n100`.`c` > 10.0\n GROUP BY `cmv_basetable_n100`.`a`, `cmv_basetable_2_n100`.`c`" -> {ArrayList@67694} size = 0
key = "SELECT `cmv_basetable_n100`.`a`, `cmv_basetable_2_n100`.`c`\n FROM `default`.`cmv_basetable_n100` JOIN `default`.`cmv_basetable_2_n100` ON (`cmv_basetable_n100`.`a` = `cmv_basetable_2_n100`.`a`)\n WHERE `cmv_basetable_2_n100`.`c` > 10.0\n GROUP BY `cmv_basetable_n100`.`a`, `cmv_basetable_2_n100`.`c`"
value = {ArrayList@67694} size = 0
"select `emps_parquet_n3`.`empid`, `emps_parquet_n3`.`deptno` from `default`.`emps_parquet_n3` group by `emps_parquet_n3`.`empid`, `emps_parquet_n3`.`deptno`" -> {ArrayList@67696} size = 0
key = "select `emps_parquet_n3`.`empid`, `emps_parquet_n3`.`deptno` from `default`.`emps_parquet_n3` group by `emps_parquet_n3`.`empid`, `emps_parquet_n3`.`deptno`"
value = {ArrayList@67696} size = 0
"select `cmv_basetable_n7`.`a`, `cmv_basetable_n7`.`c` from `db1`.`cmv_basetable_n7` where `cmv_basetable_n7`.`a` = 3" -> {ArrayList@67698} size = 1
key = "select `cmv_basetable_n7`.`a`, `cmv_basetable_n7`.`c` from `db1`.`cmv_basetable_n7` where `cmv_basetable_n7`.`a` = 3"
value = {ArrayList@67698} size = 1
"SELECT `value`, `key`, `partkey` FROM (SELECT `src_txn`.`key` + 100 as `partkey`, `src_txn`.`value`, `src_txn`.`key` FROM `default`.`src_txn`, `default`.`src_txn_2`\nWHERE `src_txn`.`key` = `src_txn_2`.`key`\n AND `src_txn`.`key` > 200 AND `src_txn`.`key` < 250) `cluster_mv_3`" -> {ArrayList@67700} size = 1
key = "SELECT `value`, `key`, `partkey` FROM (SELECT `src_txn`.`key` + 100 as `partkey`, `src_txn`.`value`, `src_txn`.`key` FROM `default`.`src_txn`, `default`.`src_txn_2`\nWHERE `src_txn`.`key` = `src_txn_2`.`key`\n AND `src_txn`.`key` > 200 AND `src_txn`.`key` < 250) `cluster_mv_3`"
value = {ArrayList@67700} size = 1
"SELECT `cmv_basetable_n6`.`a`, `cmv_basetable_2_n3`.`c`\n FROM `default`.`cmv_basetable_n6` JOIN `default`.`cmv_basetable_2_n3` ON (`cmv_basetable_n6`.`a` = `cmv_basetable_2_n3`.`a`)\n WHERE `cmv_basetable_2_n3`.`c` > 10.0" -> {ArrayList@67702} size = 0
key = "SELECT `cmv_basetable_n6`.`a`, `cmv_basetable_2_n3`.`c`\n FROM `default`.`cmv_basetable_n6` JOIN `default`.`cmv_basetable_2_n3` ON (`cmv_basetable_n6`.`a` = `cmv_basetable_2_n3`.`a`)\n WHERE `cmv_basetable_2_n3`.`c` > 10.0"
value = {ArrayList@67702} size = 0
"SELECT `src_txn`.`key`, `src_txn`.`value` FROM `default`.`src_txn` where `src_txn`.`key` > 200 and `src_txn`.`key` < 250" -> {ArrayList@67704} size = 1
key = "SELECT `src_txn`.`key`, `src_txn`.`value` FROM `default`.`src_txn` where `src_txn`.`key` > 200 and `src_txn`.`key` < 250"
value = {ArrayList@67704} size = 1
"select `cmv_basetable_n9`.`a`, `cmv_basetable_2_n4`.`c`\n from `default`.`cmv_basetable_n9` join `default`.`cmv_basetable_2_n4` on (`cmv_basetable_n9`.`a` = `cmv_basetable_2_n4`.`a`)\n where `cmv_basetable_2_n4`.`c` > 10.0\n group by `cmv_basetable_n9`.`a`, `cmv_basetable_2_n4`.`c`" -> {ArrayList@67706} size = 0
key = "select `cmv_basetable_n9`.`a`, `cmv_basetable_2_n4`.`c`\n from `default`.`cmv_basetable_n9` join `default`.`cmv_basetable_2_n4` on (`cmv_basetable_n9`.`a` = `cmv_basetable_2_n4`.`a`)\n where `cmv_basetable_2_n4`.`c` > 10.0\n group by `cmv_basetable_n9`.`a`, `cmv_basetable_2_n4`.`c`"
value = {ArrayList@67706} size = 0
"select `emps_parquet_n3`.`empid`, `emps_parquet_n3`.`deptno`, `emps_parquet_n3`.`name`, `emps_parquet_n3`.`salary`, `emps_parquet_n3`.`commission` from `default`.`emps_parquet_n3` where `emps_parquet_n3`.`empid` < 150" -> {ArrayList@67708} size = 0
key = "select `emps_parquet_n3`.`empid`, `emps_parquet_n3`.`deptno`, `emps_parquet_n3`.`name`, `emps_parquet_n3`.`salary`, `emps_parquet_n3`.`commission` from `default`.`emps_parquet_n3` where `emps_parquet_n3`.`empid` < 150"
value = {ArrayList@67708} size = 0
"select `t1`.`a`, sum(`t1`.`b`), count(`t1`.`b`), avg(`t1`.`b`), count(*) from `default`.`t1`\njoin `default`.`t2` on (`t1`.`a` = `t2`.`a`)\ngroup by `t1`.`a`" -> {ArrayList@67710} size = 0
key = "select `t1`.`a`, sum(`t1`.`b`), count(`t1`.`b`), avg(`t1`.`b`), count(*) from `default`.`t1`\njoin `default`.`t2` on (`t1`.`a` = `t2`.`a`)\ngroup by `t1`.`a`"
value = {ArrayList@67710} size = 0
"select `cmv_basetable_n10`.`a`, `cmv_basetable_n10`.`b`, `cmv_basetable_n10`.`c` from `default`.`cmv_basetable_n10` where `cmv_basetable_n10`.`a` = 2" -> {ArrayList@67712} size = 1
key = "select `cmv_basetable_n10`.`a`, `cmv_basetable_n10`.`b`, `cmv_basetable_n10`.`c` from `default`.`cmv_basetable_n10` where `cmv_basetable_n10`.`a` = 2"
value = {ArrayList@67712} size = 1
"select `emps_parquet_n3`.`deptno`, `emps_parquet_n3`.`name`, `emps_parquet_n3`.`salary`, `emps_parquet_n3`.`commission`\nfrom `default`.`emps_parquet_n3`" -> {ArrayList@67714} size = 0
key = "select `emps_parquet_n3`.`deptno`, `emps_parquet_n3`.`name`, `emps_parquet_n3`.`salary`, `emps_parquet_n3`.`commission`\nfrom `default`.`emps_parquet_n3`"
value = {ArrayList@67714} size = 0
"select `cmv_basetable_n9`.`b` from `default`.`cmv_basetable_n9` where `cmv_basetable_n9`.`c` > 10.0 group by `cmv_basetable_n9`.`a`, `cmv_basetable_n9`.`b`, `cmv_basetable_n9`.`c`" -> {ArrayList@67716} size = 0
key = "select `cmv_basetable_n9`.`b` from `default`.`cmv_basetable_n9` where `cmv_basetable_n9`.`c` > 10.0 group by `cmv_basetable_n9`.`a`, `cmv_basetable_n9`.`b`, `cmv_basetable_n9`.`c`"
value = {ArrayList@67716} size = 0
"select `emps_parquet_n3`.`name`, `emps_parquet_n3`.`salary` from `default`.`emps_parquet_n3` where `emps_parquet_n3`.`deptno` = 10 group by `emps_parquet_n3`.`name`, `emps_parquet_n3`.`salary`" -> {ArrayList@67718} size = 0
key = "select `emps_parquet_n3`.`name`, `emps_parquet_n3`.`salary` from `default`.`emps_parquet_n3` where `emps_parquet_n3`.`deptno` = 10 group by `emps_parquet_n3`.`name`, `emps_parquet_n3`.`salary`"
value = {ArrayList@67718} size = 0
"select `cmv_basetable_n9`.`b`, `cmv_basetable_n9`.`c` from `default`.`cmv_basetable_n9` where `cmv_basetable_n9`.`c` > 10.0 group by `cmv_basetable_n9`.`a`, `cmv_basetable_n9`.`b`, `cmv_basetable_n9`.`c`" -> {ArrayList@67720} size = 0
key = "select `cmv_basetable_n9`.`b`, `cmv_basetable_n9`.`c` from `default`.`cmv_basetable_n9` where `cmv_basetable_n9`.`c` > 10.0 group by `cmv_basetable_n9`.`a`, `cmv_basetable_n9`.`b`, `cmv_basetable_n9`.`c`"
value = {ArrayList@67720} size = 0
"SELECT `cmv_basetable_n3`.`a`, `cmv_basetable_2_n1`.`c`\n FROM `default`.`cmv_basetable_n3` JOIN `default`.`cmv_basetable_2_n1` ON (`cmv_basetable_n3`.`a` = `cmv_basetable_2_n1`.`a`)\n WHERE `cmv_basetable_2_n1`.`c` > 10.0\n GROUP BY `cmv_basetable_n3`.`a`, `cmv_basetable_2_n1`.`c`" -> {ArrayList@67722} size = 0
key = "SELECT `cmv_basetable_n3`.`a`, `cmv_basetable_2_n1`.`c`\n FROM `default`.`cmv_basetable_n3` JOIN `default`.`cmv_basetable_2_n1` ON (`cmv_basetable_n3`.`a` = `cmv_basetable_2_n1`.`a`)\n WHERE `cmv_basetable_2_n1`.`c` > 10.0\n GROUP BY `cmv_basetable_n3`.`a`, `cmv_basetable_2_n1`.`c`"
value = {ArrayList@67722} size = 0
"SELECT `t1`.`a`, `t1`.`b`, sum(`t1`.`d`), min(`t1`.`d`), max(`t1`.`d`)\n FROM `default`.`t1`\n WHERE `t1`.`c` > 10.0\n GROUP BY `t1`.`a`, `t1`.`b`" -> {ArrayList@67724} size = 0
key = "SELECT `t1`.`a`, `t1`.`b`, sum(`t1`.`d`), min(`t1`.`d`), max(`t1`.`d`)\n FROM `default`.`t1`\n WHERE `t1`.`c` > 10.0\n GROUP BY `t1`.`a`, `t1`.`b`"
value = {ArrayList@67724} size = 0
"select `t1`.`a`, count(*) from `default`.`t1`\ngroup by `t1`.`a`" -> {ArrayList@67726} size = 0
key = "select `t1`.`a`, count(*) from `default`.`t1`\ngroup by `t1`.`a`"
value = {ArrayList@67726} size = 0
"select `emps_parquet_n3`.`name`, `emps_parquet_n3`.`salary`, count(*) as `c`, sum(`emps_parquet_n3`.`empid`) as `s`\nfrom `default`.`emps_parquet_n3` group by `emps_parquet_n3`.`name`, `emps_parquet_n3`.`salary`" -> {ArrayList@67728} size = 0
key = "select `emps_parquet_n3`.`name`, `emps_parquet_n3`.`salary`, count(*) as `c`, sum(`emps_parquet_n3`.`empid`) as `s`\nfrom `default`.`emps_parquet_n3` group by `emps_parquet_n3`.`name`, `emps_parquet_n3`.`salary`"
value = {ArrayList@67728} size = 0
"SELECT `key`, `value`, `partkey` FROM (SELECT `src_txn`.`key`, `src_txn`.`value`, `src_txn`.`key` + 100 as `partkey` FROM `default`.`src_txn` where `src_txn`.`key` > 200 and `src_txn`.`key` < 250) `cluster_mv_2`" -> {ArrayList@67730} size = 1
key = "SELECT `key`, `value`, `partkey` FROM (SELECT `src_txn`.`key`, `src_txn`.`value`, `src_txn`.`key` + 100 as `partkey` FROM `default`.`src_txn` where `src_txn`.`key` > 200 and `src_txn`.`key` < 250) `cluster_mv_2`"
value = {ArrayList@67730} size = 1
"SELECT `cmv_basetable_n5`.`a`, sum(`cmv_basetable_2_n2`.`d`)\n FROM `default`.`cmv_basetable_n5` JOIN `default`.`cmv_basetable_2_n2` ON (`cmv_basetable_n5`.`a` = `cmv_basetable_2_n2`.`a`)\n WHERE `cmv_basetable_2_n2`.`c` > 10.0\n GROUP BY `cmv_basetable_n5`.`a`" -> {ArrayList@67732} size = 0
key = "SELECT `cmv_basetable_n5`.`a`, sum(`cmv_basetable_2_n2`.`d`)\n FROM `default`.`cmv_basetable_n5` JOIN `default`.`cmv_basetable_2_n2` ON (`cmv_basetable_n5`.`a` = `cmv_basetable_2_n2`.`a`)\n WHERE `cmv_basetable_2_n2`.`c` > 10.0\n GROUP BY `cmv_basetable_n5`.`a`"
value = {ArrayList@67732} size = 0
"select distinct `base`.`c1` `c1`, `base`.`c2` `c2` from `count_distinct`.`base`" -> {ArrayList@67734} size = 0
key = "select distinct `base`.`c1` `c1`, `base`.`c2` `c2` from `count_distinct`.`base`"
value = {ArrayList@67734} size = 0
"select `emps_parquet_n3`.`empid`, `emps_parquet_n3`.`name` from `default`.`emps_parquet_n3` group by `emps_parquet_n3`.`empid`, `emps_parquet_n3`.`name`" -> {ArrayList@67736} size = 0
key = "select `emps_parquet_n3`.`empid`, `emps_parquet_n3`.`name` from `default`.`emps_parquet_n3` group by `emps_parquet_n3`.`empid`, `emps_parquet_n3`.`name`"
value = {ArrayList@67736} size = 0
"select `emps_parquet_n3`.`empid` `deptno` from `default`.`emps_parquet_n3`\njoin `default`.`depts_parquet_n2` using (`deptno`)" -> {ArrayList@67738} size = 0
key = "select `emps_parquet_n3`.`empid` `deptno` from `default`.`emps_parquet_n3`\njoin `default`.`depts_parquet_n2` using (`deptno`)"
value = {ArrayList@67738} size = 0
"SELECT `value`, `key`, `tes"t`, `te*#"s"t`, `partkey` FROM (SELECT `src_txn`.`key` + 100 as `partkey`, `src_txn`.`value`, `src_txn`.`key`, `src_txn`.`key`+1 as `tes"t`, `src_txn`.`key`+2 as `te*#"s"t` FROM `default`.`src_txn` where `src_txn`.`key` > 200 and `src_txn`.`key` < 250) `cluster_mv_4`" -> {ArrayList@67740} size = 1
key = "SELECT `value`, `key`, `tes"t`, `te*#"s"t`, `partkey` FROM (SELECT `src_txn`.`key` + 100 as `partkey`, `src_txn`.`value`, `src_txn`.`key`, `src_txn`.`key`+1 as `tes"t`, `src_txn`.`key`+2 as `te*#"s"t` FROM `default`.`src_txn` where `src_txn`.`key` > 200 and `src_txn`.`key` < 250) `cluster_mv_4`"
value = {ArrayList@67740} size = 1
"SELECT `cmv_basetable_n5`.`a`, `cmv_basetable_2_n2`.`c`, sum(`cmv_basetable_2_n2`.`d`)\n FROM `default`.`cmv_basetable_n5` JOIN `default`.`cmv_basetable_2_n2` ON (`cmv_basetable_n5`.`a` = `cmv_basetable_2_n2`.`a`)\n WHERE `cmv_basetable_2_n2`.`c` > 10.0\n GROUP BY `cmv_basetable_n5`.`a`, `cmv_basetable_2_n2`.`c`" -> {ArrayList@67742} size = 0
key = "SELECT `cmv_basetable_n5`.`a`, `cmv_basetable_2_n2`.`c`, sum(`cmv_basetable_2_n2`.`d`)\n FROM `default`.`cmv_basetable_n5` JOIN `default`.`cmv_basetable_2_n2` ON (`cmv_basetable_n5`.`a` = `cmv_basetable_2_n2`.`a`)\n WHERE `cmv_basetable_2_n2`.`c` > 10.0\n GROUP BY `cmv_basetable_n5`.`a`, `cmv_basetable_2_n2`.`c`"
value = {ArrayList@67742} size = 0
"SELECT `cmv_basetable`.`a`, `cmv_basetable_2`.`c`\n FROM `default`.`cmv_basetable` JOIN `default`.`cmv_basetable_2` ON (`cmv_basetable`.`a` = `cmv_basetable_2`.`a`)\n WHERE `cmv_basetable_2`.`c` > 10.0\n GROUP BY `cmv_basetable`.`a`, `cmv_basetable_2`.`c`" -> {ArrayList@67744} size = 0
key = "SELECT `cmv_basetable`.`a`, `cmv_basetable_2`.`c`\n FROM `default`.`cmv_basetable` JOIN `default`.`cmv_basetable_2` ON (`cmv_basetable`.`a` = `cmv_basetable_2`.`a`)\n WHERE `cmv_basetable_2`.`c` > 10.0\n GROUP BY `cmv_basetable`.`a`, `cmv_basetable_2`.`c`"
value = {ArrayList@67744} size = 0
"select `emps_parquet_n3`.`empid`, `emps_parquet_n3`.`deptno`, `emps_parquet_n3`.`name`, `emps_parquet_n3`.`salary`, `emps_parquet_n3`.`commission` from `default`.`emps_parquet_n3` where `emps_parquet_n3`.`empid` < 200" -> {ArrayList@67746} size = 0
key = "select `emps_parquet_n3`.`empid`, `emps_parquet_n3`.`deptno`, `emps_parquet_n3`.`name`, `emps_parquet_n3`.`salary`, `emps_parquet_n3`.`commission` from `default`.`emps_parquet_n3` where `emps_parquet_n3`.`empid` < 200"
value = {ArrayList@67746} size = 0
"select `cmv_basetable_n7`.`a`, `cmv_basetable_n7`.`b`, `cmv_basetable_n7`.`c` from `db1`.`cmv_basetable_n7` where `cmv_basetable_n7`.`a` = 2" -> {ArrayList@67748} size = 1
key = "select `cmv_basetable_n7`.`a`, `cmv_basetable_n7`.`b`, `cmv_basetable_n7`.`c` from `db1`.`cmv_basetable_n7` where `cmv_basetable_n7`.`a` = 2"
value = {ArrayList@67748} size = 1
"select `cmv_basetable_n9`.`a`, `cmv_basetable_n9`.`b` from `default`.`cmv_basetable_n9` group by `cmv_basetable_n9`.`a`, `cmv_basetable_n9`.`b`" -> {ArrayList@67750} size = 0
key = "select `cmv_basetable_n9`.`a`, `cmv_basetable_n9`.`b` from `default`.`cmv_basetable_n9` group by `cmv_basetable_n9`.`a`, `cmv_basetable_n9`.`b`"
value = {ArrayList@67750} size = 0
"select `emps_parquet_n3`.`name`, `emps_parquet_n3`.`salary` from `default`.`emps_parquet_n3` group by `emps_parquet_n3`.`name`, `emps_parquet_n3`.`salary`" -> {ArrayList@67752} size = 0
key = "select `emps_parquet_n3`.`name`, `emps_parquet_n3`.`salary` from `default`.`emps_parquet_n3` group by `emps_parquet_n3`.`name`, `emps_parquet_n3`.`salary`"
value = {ArrayList@67752} size = 0
"SELECT `value`, `key`, `partkey` FROM (SELECT `src_txn`.`value`, `src_txn`.`key`, `src_txn`.`key` + 100 as `partkey` FROM `default`.`src_txn` where `src_txn`.`key` > 200 and `src_txn`.`key` < 250) `cluster_mv_1`" -> {ArrayList@67754} size = 1
key = "SELECT `value`, `key`, `partkey` FROM (SELECT `src_txn`.`value`, `src_txn`.`key`, `src_txn`.`key` + 100 as `partkey` FROM `default`.`src_txn` where `src_txn`.`key` > 200 and `src_txn`.`key` < 250) `cluster_mv_1`"
value = {ArrayList@67754} size = 1
"SELECT `src_txn`.`value`, `src_txn`.`key` FROM `default`.`src_txn`, `default`.`src_txn_2`\nWHERE `src_txn`.`key` = `src_txn_2`.`key`\n AND `src_txn`.`key` > 200 AND `src_txn`.`key` < 250" -> {ArrayList@67756} size = 1
key = "SELECT `src_txn`.`value`, `src_txn`.`key` FROM `default`.`src_txn`, `default`.`src_txn_2`\nWHERE `src_txn`.`key` = `src_txn_2`.`key`\n AND `src_txn`.`key` > 200 AND `src_txn`.`key` < 250"
value = {ArrayList@67756} size = 1
"SELECT `id`, `name`, `year` FROM (select `tmv`.`id`, `tmv`.`name`, `tmv`.`year` from `db1`.`testmvtable` `tmv` where `tmv`.`year` >= 2018) `testmv`" -> {ArrayList@67758} size = 0
key = "SELECT `id`, `name`, `year` FROM (select `tmv`.`id`, `tmv`.`name`, `tmv`.`year` from `db1`.`testmvtable` `tmv` where `tmv`.`year` >= 2018) `testmv`"
value = {ArrayList@67758} size = 0
"SELECT `src_txn`.`value`, `src_txn`.`key` FROM `default`.`src_txn` where `src_txn`.`key` > 200 and `src_txn`.`key` < 250" -> {ArrayList@67760} size = 2
key = "SELECT `src_txn`.`value`, `src_txn`.`key` FROM `default`.`src_txn` where `src_txn`.`key` > 200 and `src_txn`.`key` < 250"
value = {ArrayList@67760} size = 2
"select `cmv_basetable_n9`.`a`, `cmv_basetable_n9`.`b`, `cmv_basetable_n9`.`c` from `default`.`cmv_basetable_n9` where `cmv_basetable_n9`.`c` > 10.0 group by `cmv_basetable_n9`.`a`, `cmv_basetable_n9`.`b`, `cmv_basetable_n9`.`c`" -> {ArrayList@67762} size = 0
key = "select `cmv_basetable_n9`.`a`, `cmv_basetable_n9`.`b`, `cmv_basetable_n9`.`c` from `default`.`cmv_basetable_n9` where `cmv_basetable_n9`.`c` > 10.0 group by `cmv_basetable_n9`.`a`, `cmv_basetable_n9`.`b`, `cmv_basetable_n9`.`c`"
value = {ArrayList@67762} size = 0
"select `t1`.`a`, sum(`t1`.`b`), count(*) from `default`.`t1`\njoin `default`.`t2` on (`t1`.`a` = `t2`.`a`)\ngroup by `t1`.`a`" -> {ArrayList@67764} size = 0
key = "select `t1`.`a`, sum(`t1`.`b`), count(*) from `default`.`t1`\njoin `default`.`t2` on (`t1`.`a` = `t2`.`a`)\ngroup by `t1`.`a`"
value = {ArrayList@67764} size = 0
initialized = {AtomicBoolean@67652} "true"
{code}
Notice the entries like
{code}
key = "select `t1`.`a`, sum(`t1`.`b`), count(*) from `default`.`t1`\njoin `default`.`t2` on (`t1`.`a` = `t2`.`a`)\ngroup by `t1`.`a`"
value = {ArrayList@67764} size = 0
{code}
--
This message was sent by Atlassian Jira
(v8.20.1#820001)