set hive.cbo.enable=true;
set hive.support.quoted.identifiers=standard;

-- 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;

describe formatted "s/c";

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;

set hive.support.quoted.identifiers=column;