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