blob: 09f8cc99644eb6be64266c8a4f4bda94cce3fc0f [file] [log] [blame]
--! qt:dataset:src
create table quoted1 (
`_c1` int,
`int` int,
`col 3` string,
`col``4` string
) stored as textfile;
insert into quoted1 select key, key, value, value from src;
set hive.query.results.cache.enabled=true;
set hive.query.results.cache.nontransactional.tables.enabled=true;
explain
select max(`_c1`), max(`int`), max(`col 3`), max(`col``4`) from quoted1;
select max(`_c1`), max(`int`), max(`col 3`), max(`col``4`) from quoted1;
set test.comment="Cache should be used for this query";
set test.comment;
explain
select max(`_c1`), max(`int`), max(`col 3`), max(`col``4`) from quoted1;
select max(`_c1`), max(`int`), max(`col 3`), max(`col``4`) from quoted1;