Shulou(Shulou.com)06/01 Report--

This article mainly explains "how hive creates index". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let Xiaobian take you to learn "how to create an index in hive"!

hive index

Indexing is a function that only exists after hive0.7. It is necessary to evaluate the rationality of creating an index, because it also requires disk space to create an index, and maintenance also requires a price.

create index idx_user_phone on table user_phone_with_phone_message (user_phone)as 'org.apache.hadoop.hive.ql.index.compact.CompactIndexHandler'with deferred rebuildIN TABLE idx_user_phone_with_phone_message;idx_user_phone: index nameuser_phone_with_phone_message: original table to indexuser_phone: index fieldidx_user_phone_with_phone_message: indexed table org.apache.hadoop.hive.ql.index.compact.CompactIndexHandler: implementation class needed to create index loads index data alter index idx_user_phone on user_phone_with_phone_message rebuild;idx_user_phone: table after index creation user_phone_with_phone_message: original table to create index View data in index table select * from idx_user_phone_with_phone_message; drop index idx_user_phone on user_phone_with_phone_message; View index show index on user_phone_with_phone_message At this point, I believe everyone has a deeper understanding of "how to create index hive," may wish to actually operate it! Here is the website, more related content can enter the relevant channels for inquiry, pay attention to us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.