Re: The index for query in hive 1.2.1 does not work.

For more details, see the user@hive discussion January 5 - February 8: "Is Hive Index officially not recommended? " -- Lefty On Mon, Feb 15, 2016

Re: The index for query in hive 1.2.1 does not work.

Hi, "Traditional" Indexes are not currently used in Hive. You can create them but they are not used by the optimizer. You can create storage indexes in Hive using ORC file format that provides three levels of granularity * ORC File itself * Multiple stripes within the ORC f