Hi Renzo
ca you post here the explain of
select *
from CommerceLocation
where state = true
and [description, title, keyword] LUCENE "text"
and latitude is not null
and longitude is not null
and [latitude, longitude, $spatial] NEAR
[-12.100518317393732,-77.03370729064943,{'maxDistance' : 5000}]
2016-04-26 19:49 GMT+02:00 Renzo Ludeña <[email protected]>:
> hi i am using 2.1.15 and orientdb in a query I am using fulltext lucene
> lucene and geospatial but does not work when using 2 index, searching the
> internet I found that use intersect but does not work there any way to use
>
> query:
>
> select *
> from CommerceLocation
> where state = true
> and [description, title, keyword] LUCENE "text"
> and latitude is not null
> and longitude is not null
> and [latitude, longitude, $spatial] NEAR
> [-12.100518317393732,-77.03370729064943,{'maxDistance' : 5000}]
>
>
> query 2:
> select expand ($ 1)
> let $ 2 = (select * from $ distance dist Thing as where [lat, lon, $
> space] NEAR [53.95763, -1.08271, { "maxDistance": 20}]),
> $ 3 = (select * from $ score Thing where [name, description] LUCENE
> "(name: cafe)"),
> $ 1 = Intersect ($ 2, $ 3)
>
> --
>
> ---
> You received this message because you are subscribed to the Google Groups
> "OrientDB" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> For more options, visit https://groups.google.com/d/optout.
>
--
---
You received this message because you are subscribed to the Google Groups
"OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
