Hi John do you have an example of records with coordinates that fails to return with the index?
Thanks 2017-06-14 12:10 GMT+02:00 John <[email protected]>: > > I use Orientdb 2.2 I create a class:TabzIndex with coordinate geospatial > (Opoint) > > > > create class TabzIndex extends V > > create property TabzIndex.xy EMBEDDED Opoint > > > Create property [all other property] > > +----+-------+---------+----+-----+-------+-----------------------+----+-------------------+--------+----+ > |# |@RID |@CLASS |id |idTag|tagName|xy |z |date > |type |z2 | > +----+-------+---------+----+-----+-------+-----------------------+----+-------------------+--------+----+ > |0 |#25:760|TabzIndex|3 |941 |tag941 > |OPoint{coordinates:[2]}|16.0|2009-08-17 01:03:19|Personne|76.0| > > I index xy to make the query faster > > CREATE INDEX Ixy ON TabzIndex (xy) SPATIAL ENGINE LUCENE > > I make a seconde class (*Tabz*) is the same *TabzIndex* with out Index on > *xy* but the same data inside > > When I make a polygone query like > > select count(*) as GeoReturn from TabzIndex where ST_WITHIN(xy,'POLYGON ((0 > 0, 0 40, 40 40,40 0, 0 0))') = true limit 1000000 > > > +----+---------+ > |# |GeoReturn| > +----+---------+ > |0 |11552 | > +----+---------+ > > And (the same query for Tabz) > > select count(*) as GeoReturn from Tabz where ST_WITHIN(xy,'POLYGON ((0 0, 0 > 40, 40 40,40 0, 0 0))') = true limit 1000000 > > +----+---------+ > |# |GeoReturn| > +----+---------+ > |0 |18410 | > +----+---------+ > > The result is different! Why do I loose some data when i use index? What I do > wrong? > > -- > > --- > 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.
