You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by Alessandro Benedetti <al...@sourcesense.com> on 2011/09/29 15:37:48 UTC

Indexing geohash in solrj - Multivalued spatial search

Hi all,
I have already read the topics in the mailing list that are regarding
spatial search, but I haven't found an answer ...
I have to index a multivalued field of type : "geohash" via solrj.
Now I build a string with the lat and lon comma separated ( like
 54.569468,67.58494 ) and index it in the geohash field.
The indexing process seems to work , but when I try a spatial search, Solr
returns me an exception with fieldcache on multivalued field.

I'm using Lucid Work enterprise 1.8 , and , as I know , it should be
integrated with this patch (
https://issues.apache.org/jira/browse/SOLR-2155?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12994256#comment-12994256
).

Am I indexing wrong? Am I missing something?
The type of my spatial field is geohash ...

Cheers

-- 
-------------------------------
Alessandro Benedetti

Sourcesense - making sense of Open Source: http://www.sourcesense.com

Re: Indexing geohash in solrj - Multivalued spatial search

Posted by "Smiley, David W." <ds...@mitre.org>.
On Sep 30, 2011, at 4:14 AM, Alessandro Benedetti wrote:

> Ok this is a good news !
> I will integrate the jar and test the feature :)
> Only one question regarding the indexing process in solrj.
> We could index the location data in format : lat,lon in the geohash field?
> Or we must encode lan & lon in the geohash string and then index the encoded
> string?

This is a common point of confusion stemming from the fact that there is another field named LatLonType. If LatLonType was the only field that accepted a latitude,longitude pair then there would be no confusion but the GeoHashField accepts this too.  "geohash" is a name reflecting its internal workings. You don't need to know a thing about geohashes.

BTW I think LWE 1.8 is Solr 1.4 based, and I highly doubt my plugin, which should work in Solr 3x, would work in Solr 1.4. Consider upgrading to LWE 2.0 or using plain Solr.

~ David Smiley
Author: http://www.packtpub.com/solr-1-4-enterprise-search-server/





Re: Indexing geohash in solrj - Multivalued spatial search

Posted by Alessandro Benedetti <be...@gmail.com>.
Ok this is a good news !
I will integrate the jar and test the feature :)
Only one question regarding the indexing process in solrj.
We could index the location data in format : lat,lon in the geohash field?
Or we must encode lan & lon in the geohash string and then index the encoded
string?

Thank you

2011/9/29 Smiley, David W. <ds...@mitre.org>

>
> On Sep 29, 2011, at 5:10 PM, Alessandro Benedetti wrote:
>
> > Sorry David, probably I misunderstood your reply, what do you mean?
> >
> > I'm using Lucid Work Enterprise 1.8, and, as I know , it includes
> geohashes
> > patch.
>
> Solr 3x, trunk, and I suspect Lucid Works Enterprise 2.0 (doubtful 1.8))
> supports this:
> <fieldtype name="geohash" class="solr.GeoHashField"/>
> That is not "the patch" -- SOLR-2155, that is the standard built-in geo
> support in Solr 3x.
>
> The SOLR-2155 patch is a superset (i.e. extends) that field, adding more
> capability.  Are you telling me LWE includes SOLR-2155? Can you point to
> proof of that please?  If it did, then you wouldn't be getting that
> FieldCache error due to multi-value since SOLR-2155 definitely supports
> multi-value.
>
> You may have luck putting my SOLR-2155 compiled plugin jar in LWE 1.8
> according to the instructions I provide; I don't know.
>
> > I have to index a multivalued location field and I have to make location
> > queries on it!
> > So I figured to use the geohash type ...
> > Any hint about indexing and searching on a multivalued geohash field?
> >
> >
> > 2011/9/29 Smiley, David W. <ds...@mitre.org>
> >
> >> Hi Alessandro.
> >>
> >> I can't think of any good reason anyone would use the geohash field type
> >> that is a part of Solr today. If you are shocked I would say that, keep
> in
> >> mind the work I've done with geohashes is an extension of what's in
> Solr,
> >> it's not what's in Solr today. Recently I ported SOLR-2155 to Solr 3x,
> and
> >> in a way that does NOT require that you patch Solr. I attached it to the
> >> issue just now.
> >>
> >> ~ David Smiley
> >>
> >> On Sep 29, 2011, at 9:37 AM, Alessandro Benedetti wrote:
> >>
> >>> Hi all,
> >>> I have already read the topics in the mailing list that are regarding
> >>> spatial search, but I haven't found an answer ...
> >>> I have to index a multivalued field of type : "geohash" via solrj.
> >>> Now I build a string with the lat and lon comma separated ( like
> >>> 54.569468,67.58494 ) and index it in the geohash field.
> >>> The indexing process seems to work , but when I try a spatial search,
> >> Solr
> >>> returns me an exception with fieldcache on multivalued field.
> >>>
> >>> I'm using Lucid Work enterprise 1.8 , and , as I know , it should be
> >>> integrated with this patch (
> >>>
> >>
> https://issues.apache.org/jira/browse/SOLR-2155?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12994256#comment-12994256
> >>> ).
> >>>
> >>> Am I indexing wrong? Am I missing something?
> >>> The type of my spatial field is geohash ...
> >>>
> >>> Cheers
> >>>
> >>> --
> >>> -------------------------------
> >>> Alessandro Benedetti
> >>>
> >>> Sourcesense - making sense of Open Source: http://www.sourcesense.com
> >>
> >>
> >
> >
> > --
> > --------------------------
> >
> > Benedetti Alessandro
> > Personal Page: http://tigerbolt.altervista.org
> >
> > "Tyger, tyger burning bright
> > In the forests of the night,
> > What immortal hand or eye
> > Could frame thy fearful symmetry?"
> >
> > William Blake - Songs of Experience -1794 England
>
>


-- 
--------------------------

Benedetti Alessandro
Personal Page: http://tigerbolt.altervista.org

"Tyger, tyger burning bright
In the forests of the night,
What immortal hand or eye
Could frame thy fearful symmetry?"

William Blake - Songs of Experience -1794 England

Re: Indexing geohash in solrj - Multivalued spatial search

Posted by "Smiley, David W." <ds...@mitre.org>.
On Sep 29, 2011, at 5:10 PM, Alessandro Benedetti wrote:

> Sorry David, probably I misunderstood your reply, what do you mean?
> 
> I'm using Lucid Work Enterprise 1.8, and, as I know , it includes geohashes
> patch.

Solr 3x, trunk, and I suspect Lucid Works Enterprise 2.0 (doubtful 1.8)) supports this:
<fieldtype name="geohash" class="solr.GeoHashField"/>
That is not "the patch" -- SOLR-2155, that is the standard built-in geo support in Solr 3x.

The SOLR-2155 patch is a superset (i.e. extends) that field, adding more capability.  Are you telling me LWE includes SOLR-2155? Can you point to proof of that please?  If it did, then you wouldn't be getting that FieldCache error due to multi-value since SOLR-2155 definitely supports multi-value.

You may have luck putting my SOLR-2155 compiled plugin jar in LWE 1.8 according to the instructions I provide; I don't know.

> I have to index a multivalued location field and I have to make location
> queries on it!
> So I figured to use the geohash type ...
> Any hint about indexing and searching on a multivalued geohash field?
> 
> 
> 2011/9/29 Smiley, David W. <ds...@mitre.org>
> 
>> Hi Alessandro.
>> 
>> I can't think of any good reason anyone would use the geohash field type
>> that is a part of Solr today. If you are shocked I would say that, keep in
>> mind the work I've done with geohashes is an extension of what's in Solr,
>> it's not what's in Solr today. Recently I ported SOLR-2155 to Solr 3x, and
>> in a way that does NOT require that you patch Solr. I attached it to the
>> issue just now.
>> 
>> ~ David Smiley
>> 
>> On Sep 29, 2011, at 9:37 AM, Alessandro Benedetti wrote:
>> 
>>> Hi all,
>>> I have already read the topics in the mailing list that are regarding
>>> spatial search, but I haven't found an answer ...
>>> I have to index a multivalued field of type : "geohash" via solrj.
>>> Now I build a string with the lat and lon comma separated ( like
>>> 54.569468,67.58494 ) and index it in the geohash field.
>>> The indexing process seems to work , but when I try a spatial search,
>> Solr
>>> returns me an exception with fieldcache on multivalued field.
>>> 
>>> I'm using Lucid Work enterprise 1.8 , and , as I know , it should be
>>> integrated with this patch (
>>> 
>> https://issues.apache.org/jira/browse/SOLR-2155?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12994256#comment-12994256
>>> ).
>>> 
>>> Am I indexing wrong? Am I missing something?
>>> The type of my spatial field is geohash ...
>>> 
>>> Cheers
>>> 
>>> --
>>> -------------------------------
>>> Alessandro Benedetti
>>> 
>>> Sourcesense - making sense of Open Source: http://www.sourcesense.com
>> 
>> 
> 
> 
> -- 
> --------------------------
> 
> Benedetti Alessandro
> Personal Page: http://tigerbolt.altervista.org
> 
> "Tyger, tyger burning bright
> In the forests of the night,
> What immortal hand or eye
> Could frame thy fearful symmetry?"
> 
> William Blake - Songs of Experience -1794 England


Re: Indexing geohash in solrj - Multivalued spatial search

Posted by Alessandro Benedetti <be...@gmail.com>.
Sorry David, probably I misunderstood your reply, what do you mean?

I'm using Lucid Work Enterprise 1.8, and, as I know , it includes geohashes
patch.
I have to index a multivalued location field and I have to make location
queries on it!
So I figured to use the geohash type ...
Any hint about indexing and searching on a multivalued geohash field?


2011/9/29 Smiley, David W. <ds...@mitre.org>

> Hi Alessandro.
>
> I can't think of any good reason anyone would use the geohash field type
> that is a part of Solr today. If you are shocked I would say that, keep in
> mind the work I've done with geohashes is an extension of what's in Solr,
> it's not what's in Solr today. Recently I ported SOLR-2155 to Solr 3x, and
> in a way that does NOT require that you patch Solr. I attached it to the
> issue just now.
>
> ~ David Smiley
>
> On Sep 29, 2011, at 9:37 AM, Alessandro Benedetti wrote:
>
> > Hi all,
> > I have already read the topics in the mailing list that are regarding
> > spatial search, but I haven't found an answer ...
> > I have to index a multivalued field of type : "geohash" via solrj.
> > Now I build a string with the lat and lon comma separated ( like
> > 54.569468,67.58494 ) and index it in the geohash field.
> > The indexing process seems to work , but when I try a spatial search,
> Solr
> > returns me an exception with fieldcache on multivalued field.
> >
> > I'm using Lucid Work enterprise 1.8 , and , as I know , it should be
> > integrated with this patch (
> >
> https://issues.apache.org/jira/browse/SOLR-2155?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12994256#comment-12994256
> > ).
> >
> > Am I indexing wrong? Am I missing something?
> > The type of my spatial field is geohash ...
> >
> > Cheers
> >
> > --
> > -------------------------------
> > Alessandro Benedetti
> >
> > Sourcesense - making sense of Open Source: http://www.sourcesense.com
>
>


-- 
--------------------------

Benedetti Alessandro
Personal Page: http://tigerbolt.altervista.org

"Tyger, tyger burning bright
In the forests of the night,
What immortal hand or eye
Could frame thy fearful symmetry?"

William Blake - Songs of Experience -1794 England

Re: Indexing geohash in solrj - Multivalued spatial search

Posted by "Smiley, David W." <ds...@mitre.org>.
Hi Alessandro.

I can't think of any good reason anyone would use the geohash field type that is a part of Solr today. If you are shocked I would say that, keep in mind the work I've done with geohashes is an extension of what's in Solr, it's not what's in Solr today. Recently I ported SOLR-2155 to Solr 3x, and in a way that does NOT require that you patch Solr. I attached it to the issue just now.

~ David Smiley

On Sep 29, 2011, at 9:37 AM, Alessandro Benedetti wrote:

> Hi all,
> I have already read the topics in the mailing list that are regarding
> spatial search, but I haven't found an answer ...
> I have to index a multivalued field of type : "geohash" via solrj.
> Now I build a string with the lat and lon comma separated ( like
> 54.569468,67.58494 ) and index it in the geohash field.
> The indexing process seems to work , but when I try a spatial search, Solr
> returns me an exception with fieldcache on multivalued field.
> 
> I'm using Lucid Work enterprise 1.8 , and , as I know , it should be
> integrated with this patch (
> https://issues.apache.org/jira/browse/SOLR-2155?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12994256#comment-12994256
> ).
> 
> Am I indexing wrong? Am I missing something?
> The type of my spatial field is geohash ...
> 
> Cheers
> 
> -- 
> -------------------------------
> Alessandro Benedetti
> 
> Sourcesense - making sense of Open Source: http://www.sourcesense.com