...
Alter Table Storage Properties
Code Block |
---|
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
Drop Index
Code Block |
---|
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.
...