blob: a32f25f21cc05d81bb755749ad90da127c54906f [file] [log] [blame]
--! qt:dataset:src
create table nzhang_test1 stored as sequencefile as select 'key1' as key, 'value
1
http://asdf' value from src limit 1;
select * from nzhang_test1;
select count(*) from nzhang_test1;
explain vectorization detail
select * from nzhang_test1 where key='key1';
select * from nzhang_test1 where key='key1';
set hive.query.result.fileformat=SequenceFile;
select * from nzhang_test1;
select count(*) from nzhang_test1;
explain vectorization detail
select * from nzhang_test1 where key='key1';
select * from nzhang_test1 where key='key1';