| set hive.vectorized.execution.enabled=false; |
| set hive.cbo.enable=false; |
| |
| create table orc_test_n0( col1 varchar(15), col2 char(10)) stored as orc; |
| create table text_test( col1 varchar(15), col2 char(10)); |
| |
| insert into orc_test_n0 values ('val1', '1'); |
| insert overwrite table text_test select * from orc_test_n0; |
| |
| explain select * from text_test where col2='1'; |
| select * from text_test where col2='1'; |
| |
| set hive.optimize.index.filter=false; |
| select * from orc_test_n0 where col2='1'; |
| |
| set hive.optimize.index.filter=true; |
| select * from orc_test_n0 where col2='1'; |
| |