set hive.cbo.enable=true;

-- try the query without indexing, with manual indexing, and with automatic indexing
-- SORT_QUERY_RESULTS

DROP TABLE IF EXISTS `s/c`;

CREATE TABLE `s/c` (key STRING COMMENT 'default', value STRING COMMENT 'default') STORED AS TEXTFILE;

LOAD DATA LOCAL INPATH "../../data/files/kv1.txt" INTO TABLE `s/c`;

ANALYZE TABLE `s/c` COMPUTE STATISTICS;

ANALYZE TABLE `s/c` COMPUTE STATISTICS FOR COLUMNS key,value;

SELECT key, value FROM `s/c` WHERE key > 80 AND key < 100;

EXPLAIN SELECT key, value FROM `s/c` WHERE key > 80 AND key < 100;
SELECT key, value FROM `s/c` WHERE key > 80 AND key < 100;