Database Reference
In-Depth Information
You can show indexes for a table using the
SHOW INDEX
command, and
drop one by using
DROP INDEX
:
SHOW INDEX ON customer;
DROP INDEX customerIndex ON TABLE customer;
Summary
This chapter covered the basics of working with Hive. The commands for
creating databases, tables, and views were covered. In addition, the
commands for inserting data into those tables and querying it back out
were reviewed. Some more advanced functionality around partitions and
indexing was also highlighted.
Hive has quite a bit of functionality, and not all the functionality could
be covered here due to space constraints. In particular, administration,
configuration, and extensibility could require a book unto themselves to
cover fully. An excellent reference for this is
Programming Hive
(O'Reilly
Media, Inc., 2012), by Edward Capriolo, Dean Wampler, and Jason
Rutherglen. However, a good overview of setting up data for querying and
implementing some common performance improvements has been
provided.
