THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
...
Note | ||
---|---|---|
| ||
In Hive 0.12.0 and earlier releases, the index name is case-sensitive for CREATE INDEX and DROP INDEX statements. However However, ALTER INDEX requires an index name that was created with lowercase letters (see HIVE-2752). This This bug will be fixed in a future release by making index names case-insensitive for all HiveQL statements; in the meantime, the best practice is to use lowercase letters for all index names. |
...
No Format |
---|
DROP INDEX IF EXISTS table09_index ON table09; |
Rebuild index on a partition:
No Format |
---|
ALTER INDEX table10_index ON table10 PARTITION (columnX='valueQ', columnY='valueR') REBUILD; |