| --! qt:dataset:src |
| |
| set hive.vectorized.execution.enabled=false; |
| CREATE TABLE text_tbl (a STRUCT<b:STRUCT<c:INT>>) |
| STORED AS TEXTFILE; |
| |
| -- This inserts one NULL row |
| INSERT OVERWRITE TABLE text_tbl |
| SELECT NULLIF(named_struct("b", named_struct("c", 1)),named_struct("b", named_struct("c", 1))) |
| FROM src LIMIT 1; |
| |
| -- We test that parquet is written with a level 0 definition |
| CREATE TABLE parq_tbl |
| STORED AS PARQUET |
| AS SELECT * FROM text_tbl; |
| |
| SELECT * FROM text_tbl; |
| SELECT * FROM parq_tbl; |
| |
| DROP TABLE text_tbl; |
| DROP TABLE parq_tbl; |