Versions Compared

Old Version 6

changes.mady.by.user Lefty Leverenz

Saved on

compared with

New Version 7

changes.mady.by.user Lefty Leverenz

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: add ALTER INDEX with PARTITION clause

...

Note
titleCase sensitivity

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;