Page History

...

Alter Table Storage Properties

ALTER TABLE table_name CLUSTERED BY (col_name, col_name, ...) [SORTED BY (col_name, ...)] INTO num_buckets BUCKETS

...

CREATE INDEX creates an index on a table using the given list of columns as keys. See http://wiki.apache.org/hadoop/Hive/IndexDev#CREATE_INDEX^{Image Removed}

Drop Index

DROP INDEX [IF EXISTS] index_name ON table_name

...

SHOW TABLES lists all the base tables and views with names matching the given regular expression. Regular expression can contain only '' for any characters characters or '|' for  for a choice. Examples are 'page_view', 'page_v', 'view|page', all which will match 'page_view' table. Matching tables are listed in alphabetical order. It is not an error if there are no matching tables found in metastore.

...