Re: Indexes

2012-10-23 Thread Shreepadma Venugopalan
Forgot to add to the previous email, HIVE-1644 added support to have filters use indexes. Thanks, Shreepadma On Tue, Oct 23, 2012 at 11:48 AM, Shreepadma Venugopalan < shreepa...@cloudera.com> wrote: > Hi Peter, > > Indexing support was added to Hive in 0.7 and in 0.8 the query compiler > was en

Re: Indexes

2012-10-23 Thread Shreepadma Venugopalan
Hi Peter, Indexing support was added to Hive in 0.7 and in 0.8 the query compiler was enhanced to optimized some class of queries (certain group bys and joins) using indexes. Assuming you are using the built in index handler you need to do the following _after_ you have created and rebuilt the ind

Indexes

2012-10-23 Thread Peter Marron
Hi, I'm very much a Hive newbie but I've been looking at HIVE-417 and this page in particular: http://cwiki.apache.org/confluence/display/Hive/IndexDev Using this information I've been able to create an index (using Hive 0.8.1) and when I look at the contents it all looks very promising indeed. H

Re: How to load .xls file

2012-10-23 Thread Nitin Pawar
convert xls to csv files and then load into hive or if your column valus contain "comma" then you may have to use a different column separator. But that means you will need to write some code On Tue, Oct 23, 2012 at 4:45 PM, wrote: > Hi All, > > How can we load .xls format files into Hive in f

How to load .xls file

2012-10-23 Thread yogesh.kumar13
Hi All, How can we load .xls format files into Hive in form of table. Please suggest Thanks & Regards Yogesh Kumar The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, conf