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

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

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

2016-02-15 Thread Mich Talebzadeh
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

The index for query in hive 1.2.1 does not work.

2016-02-15 Thread 万修远
Hello, When I use index in hive 1.2.1, I find the index does not work. The details are as follows: 1. After using index, the query speed does not improve. If I use manual use of indexes, the query speed improve obviously, but when switch to automatic use of indexes, the speed makes no