Re: Joining Fields in and Index
Hi, I made a MappingUpdateRequestHandler which lets you map country codes to full country names with a config file. See https://issues.apache.org/jira/browse/SOLR-2151 -- Jan Høydahl, search solution architect Cominvent AS - www.cominvent.com On 3. des. 2010, at 00.03, Adam Estrada wrote: > Hi, > > I was hoping to do it directly in the index but it was more out of curiosity > than anything. I can certainly map it in the DAO but again...I was hoping to > learn if it was possible in the index. > > Thanks for the feedback! > > Adam > > On Dec 2, 2010, at 5:48 PM, Savvas-Andreas Moysidis wrote: > >> Hi, >> >> If you are able to do a full re-index then you could index the full names >> and not the codes. When you later facet on the Country field you'll get the >> actual name rather than the code. >> If you are not able to re-index then probably this conversion could be added >> at your application layer prior to displaying your results.(e.g. in your DAO >> object) >> >> On 2 December 2010 22:05, Adam Estrada wrote: >> >>> All, >>> >>> I have an index that has a field with country codes in it. I have 7 million >>> or so documents in the index and when displaying facets the country codes >>> don't mean a whole lot to me. Is there any way to add a field with the full >>> country names then join the codes in there accordingly? I suppose I can do >>> this before updating the records in the index but before I do that I would >>> like to know if there is a way to do this sort of join. >>> >>> Example: US -> United States >>> >>> Thanks, >>> Adam >
Re: Joining Fields in and Index
Hi, I was hoping to do it directly in the index but it was more out of curiosity than anything. I can certainly map it in the DAO but again...I was hoping to learn if it was possible in the index. Thanks for the feedback! Adam On Dec 2, 2010, at 5:48 PM, Savvas-Andreas Moysidis wrote: > Hi, > > If you are able to do a full re-index then you could index the full names > and not the codes. When you later facet on the Country field you'll get the > actual name rather than the code. > If you are not able to re-index then probably this conversion could be added > at your application layer prior to displaying your results.(e.g. in your DAO > object) > > On 2 December 2010 22:05, Adam Estrada wrote: > >> All, >> >> I have an index that has a field with country codes in it. I have 7 million >> or so documents in the index and when displaying facets the country codes >> don't mean a whole lot to me. Is there any way to add a field with the full >> country names then join the codes in there accordingly? I suppose I can do >> this before updating the records in the index but before I do that I would >> like to know if there is a way to do this sort of join. >> >> Example: US -> United States >> >> Thanks, >> Adam
Re: Joining Fields in and Index
Hi, If you are able to do a full re-index then you could index the full names and not the codes. When you later facet on the Country field you'll get the actual name rather than the code. If you are not able to re-index then probably this conversion could be added at your application layer prior to displaying your results.(e.g. in your DAO object) On 2 December 2010 22:05, Adam Estrada wrote: > All, > > I have an index that has a field with country codes in it. I have 7 million > or so documents in the index and when displaying facets the country codes > don't mean a whole lot to me. Is there any way to add a field with the full > country names then join the codes in there accordingly? I suppose I can do > this before updating the records in the index but before I do that I would > like to know if there is a way to do this sort of join. > > Example: US -> United States > > Thanks, > Adam