--! qt:dataset:alltypesorc | |
set hive.vectorized.execution.enabled=false; | |
create materialized view dmv_mat_view disable rewrite as select cint, cstring1 from alltypesorc where cint < 0; | |
show table extended like dmv_mat_view; | |
drop materialized view dmv_mat_view; | |
show table extended like dmv_mat_view; |