HIVEインデックス作成
参照リンク:https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Indexing#LanguageManualIndexing-ConfigurationParametersforHiveIndexes
Create/build, show, and drop index:
Create then build, show formatted (with column names), and drop index:
Create bitmap index, build, show, and drop:
Create index in a new table:
Create index stored as RCFile:
Create index stored as text file:
Create index with index properties:
Create index with table properties:
Drop index if exists:
Rebuild index on a partition:
インデックスクエリが追加されていません:
索引クエリーを追加するには、次の手順に従います.
1.HIVE索引の公式文法を作成する:
Create/build, show, and drop index:
CREATE INDEX table01_index ON TABLE table01 (column2) AS 'COMPACT';
SHOW INDEX ON table01;
DROP INDEX table01_index ON table01;
Create then build, show formatted (with column names), and drop index:
CREATE INDEX table02_index ON TABLE table02 (column3) AS 'COMPACT' WITH DEFERRED REBUILD;
ALTER INDEX table02_index ON table2 REBUILD;
SHOW FORMATTED INDEX ON table02;
DROP INDEX table02_index ON table02;
Create bitmap index, build, show, and drop:
CREATE INDEX table03_index ON TABLE table03 (column4) AS 'BITMAP' WITH DEFERRED REBUILD;
ALTER INDEX table03_index ON table03 REBUILD;
SHOW FORMATTED INDEX ON table03;
DROP INDEX table03_index ON table03;
Create index in a new table:
CREATE INDEX table04_index ON TABLE table04 (column5) AS 'COMPACT' WITH DEFERRED REBUILD IN TABLE table04_index_table;
Create index stored as RCFile:
CREATE INDEX table05_index ON TABLE table05 (column6) AS 'COMPACT' STORED AS RCFILE;
Create index stored as text file:
CREATE INDEX table06_index ON TABLE table06 (column7) AS 'COMPACT' ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' STORED AS TEXTFILE;
Create index with index properties:
CREATE INDEX table07_index ON TABLE table07 (column8) AS 'COMPACT' IDXPROPERTIES ("prop1"="value1", "prop2"="value2");
Create index with table properties:
CREATE INDEX table08_index ON TABLE table08 (column9) AS 'COMPACT' TBLPROPERTIES ("prop3"="value3", "prop4"="value4");
Drop index if exists:
DROP INDEX IF EXISTS table09_index ON table09;
Rebuild index on a partition:
ALTER INDEX table10_index ON table10 PARTITION (columnX='valueQ', columnY='valueR') REBUILD;
2.HIVEはインデックステストを作成する:
CREATE INDEX index_persona_idCard2 ON TABLE persona (idCard) AS 'COMPACT' WITH DEFERRED REBUILD;
ALTER INDEX index_persona_idCard2 ON persona REBUILD;
3.索引クエリーの前後比較の追加
インデックスクエリが追加されていません:
jdbc:hive2://hadoop01:10015/> select count (*) from test1;
索引クエリーを追加するには、次の手順に従います.
jdbc:hive2://hadoop01:10015/> select count (*) from test1;