Re: Grouping by field substring?

2013-09-12 Thread Ken Krugler
Hi Jack,

On Sep 11, 2013, at 5:34pm, Jack Krupansky wrote:

> Do a copyField to another field, with a limit of 8 characters, and then use 
> that other field.

Thanks - I should have included a few more details in my original question.

The issue is that I've got an index with 200M records, of which about 50M have 
a unique value for this prefix (which is 32 characters long)

So adding another indexed field would be significant, which is why I was hoping 
there was a way to do it via grouping/collapsing at query time.

Or is that just not possible?

Thanks,

-- Ken

> -Original Message- From: Ken Krugler
> Sent: Wednesday, September 11, 2013 8:24 PM
> To: solr-user@lucene.apache.org
> Subject: Grouping by field substring?
> 
> Hi all,
> 
> Assuming I want to use the first N characters of a specific field for 
> grouping results, is such a thing possible out-of-the-box?
> 
> If not, then what would the next best option be? E.g. a custom function query?
> 
> Thanks,
> 
> -- Ken
> 
> --
> Ken Krugler
> +1 530-210-6378
> http://www.scaleunlimited.com
> custom big data solutions & training
> Hadoop, Cascading, Cassandra & Solr
> 
> 
> 
> 
> 

--
Ken Krugler
+1 530-210-6378
http://www.scaleunlimited.com
custom big data solutions & training
Hadoop, Cascading, Cassandra & Solr







Re: Grouping by field substring?

2013-09-11 Thread Jack Krupansky
Do a copyField to another field, with a limit of 8 characters, and then use 
that other field.


-- Jack Krupansky

-Original Message- 
From: Ken Krugler

Sent: Wednesday, September 11, 2013 8:24 PM
To: solr-user@lucene.apache.org
Subject: Grouping by field substring?

Hi all,

Assuming I want to use the first N characters of a specific field for 
grouping results, is such a thing possible out-of-the-box?


If not, then what would the next best option be? E.g. a custom function 
query?


Thanks,

-- Ken

--
Ken Krugler
+1 530-210-6378
http://www.scaleunlimited.com
custom big data solutions & training
Hadoop, Cascading, Cassandra & Solr







Grouping by field substring?

2013-09-11 Thread Ken Krugler
Hi all,

Assuming I want to use the first N characters of a specific field for grouping 
results, is such a thing possible out-of-the-box?

If not, then what would the next best option be? E.g. a custom function query?

Thanks,

-- Ken

--
Ken Krugler
+1 530-210-6378
http://www.scaleunlimited.com
custom big data solutions & training
Hadoop, Cascading, Cassandra & Solr