| set hive.cbo.enable = false; |
| |
| CREATE DATABASE IF NOT EXISTS cdh_82023_repro_db; |
| |
| CREATE TABLE IF NOT EXISTS `cdh_82023_repro_db`.`data` ( |
| `text` string |
| ); |
| |
| CREATE VIEW IF NOT EXISTS `cdh_82023_repro_db`.`background` AS |
| SELECT |
| * |
| FROM |
| `cdh_82023_repro_db`.`data` `xouter` |
| WHERE |
| `xouter`.`text` NOT IN ( |
| SELECT |
| UPPER(`xinner`.`text`) |
| FROM |
| `cdh_82023_repro_db`.`data` `xinner` |
| GROUP BY |
| UPPER(`xinner`.`text`) |
| ); |
| |
| SELECT * FROM `cdh_82023_repro_db`.`background`; |
| |
| CREATE VIEW IF NOT EXISTS `cdh_82023_repro_db`.`foreground`AS |
| SELECT |
| * |
| FROM |
| `cdh_82023_repro_db`.`background`; |
| |
| SELECT * FROM `cdh_82023_repro_db`.`foreground`; |
| |
| DROP DATABASE IF EXISTS `cdh_82023_repro_db` CASCADE; |