I will take a look this select from V where type LUCENE "down"
of course shouldn't work the the inheritance is top-down I have the use case however i will check it shortly Thanks 2014-05-05 15:03 GMT+02:00 Carlo Pradissitto <[email protected]>: > Hi Enrico, > I need some advice, in order to better understand this module. > > Using the GratefulDeadConcerts database included in the last ODB snapshot, > I created a new class: > orientdb {GratefulDeadConcerts}> create class Songs extend V; > orientdb {GratefulDeadConcerts}> create property Songs.name string > orientdb {GratefulDeadConcerts}> create property Songs.type string > orientdb {GratefulDeadConcerts}> create property Songs.performances string > orientdb {GratefulDeadConcerts}> create property Songs.song_type string > orientdb {GratefulDeadConcerts}> insert into Songs from select from V > where type = 'song'; > Inserted record '584' in 1.464000 sec(s). > > Then, I created a Lucene-based index: > > orientdb {GratefulDeadConcerts}> create index Songs.name on Songs (name) > FULLTEXT ENGINE LUCENE; > > orientdb {GratefulDeadConcerts}> select name from Songs where name LUCENE > "down"; > > ----+-----+------------------------------- > # |@RID |name > ----+-----+------------------------------- > 0 |#-2:1|CANT COME DOWN > 1 |#-2:2|DOWN SO LONG > 2 |#-2:3|WALK DOWN THE STREET > 3 |#-2:4|TO LAY ME DOWN > 4 |#-2:5|GOING DOWN THE ROAD FEELING BAD > 5 |#-2:6|DOWN IN THE BOTTOM > 6 |#-2:7|BEAT IT ON DOWN THE LINE > ----+-----+------------------------------- > > 7 item(s) found. Query executed in 0.032 sec(s). > > This is OK, but if I repeat the search starting from the superclass V: > > orientdb {GratefulDeadConcerts}> select name from V where name LUCENE > "down"; > > ----+------+------------------------------- > # |@RID |name > ----+------+------------------------------- > 0 |#-2:1 |HEY BO DIDDLEY > 1 |#-2:2 |IM A MAN > 2 |#-2:3 |NOT FADE AWAY > 3 |#-2:4 |BERTHA > 4 |#-2:5 |GOING DOWN THE ROAD FEELING BAD > 5 |#-2:6 |MONA > 6 |#-2:7 |Bo_Diddley > 7 |#-2:8 |Garcia > 8 |#-2:9 |Spencer_Davis > 9 |#-2:10|JACK STRAW > 10 |#-2:11|JAM > 11 |#-2:12|CASEY JONES > 12 |#-2:13|DEAL > 13 |#-2:14|TRUCKING > 14 |#-2:15|BABY BLUE > 15 |#-2:16|DRUMS > 16 |#-2:17|STELLA BLUE > 17 |#-2:18|MOUNTAIN JAM > 18 |#-2:19|PROMISED LAND > 19 |#-2:20|BEAT IT ON DOWN THE LINE > ----+------+------------------------------- > LIMIT EXCEEDED: resultset contains more items not displayed (limit=20) > > 20 item(s) found. Query executed in 0.046 sec(s). > > Maybe the module should accept the query only for the class whose property > was indexed. > I suppose that the inheritance is top-down and not bottom-up > Anyway, the result must be correct. > > orientdb {GratefulDeadConcerts}> select from V where type = "down"; > > 0 item(s) found. Query executed in 0.549 sec(s). > > This is OK > > > > orientdb {GratefulDeadConcerts}> select from V where type LUCENE "down"; > > > ----+-----+------+---------+---------+----------+-----------+------------+-------------+-------------+--------------+-------------------------- > # |@RID |type > > |song_type|in_sung_b|out_sung_b|performance|in_written_b|out_written_b|in_followed_b|out_followed_b|name > > ----+-----+------+---------+---------+----------+-----------+------------+-------------+-------------+--------------+-------------------------- > 0 |#9:1 |song |cover |null |#9:8 |5 |null > |#9:7 |[size=4] |[size=5] |HEY BO DIDDLEY > 1 |#9:2 |song |cover |null |#9:9 |1 |null > |#9:9 |[size=2] |[size=2] |IM A MAN > 2 |#9:3 |song |cover |null |#9:50 |531 |null > |#9:27 |[size=65] |[size=84] |NOT FADE AWAY > 3 |#9:4 |song |original |null |#9:8 |394 |null > |#9:93 |[size=76] |[size=53] |BERTHA > 4 |#9:5 |song |cover |null |#9:8 |293 |null > |#9:131 |[size=46] |[size=39] |GOING DOWN THE ROAD FEE... > 5 |#9:6 |song |cover |null |#9:50 |1 |null > |#9:7 |[size=2] |[size=2] |MONA > 6 |#9:7 |artist|null |[size=7] |null |null |[size=9] > |null |null |null |Bo_Diddley > 7 |#9:8 |artist|null |[size=...|null |null |[size=4] > |null |null |null |Garcia > 8 |#9:9 |artist|null |[size=2] |null |null |#9:2 > |null |null |null |Spencer_Davis > 9 |#9:10|song |original |null |#9:50 |473 |null > |#9:93 |[size=99] |[size=79] |JACK STRAW > 10 |#9:11|song |original |null |#9:335 |24 |null > |#9:350 |[size=20] |[size=14] |JAM > 11 |#9:12|song |original |null |#9:8 |312 |null > |#9:93 |[size=33] |[size=47] |CASEY JONES > 12 |#9:13|song |original |null |#9:8 |423 |null > |#9:93 |[size=65] |[size=80] |DEAL > 13 |#9:14|song |original |null |#9:223 |519 |null > |#9:93 |[size=94] |[size=60] |TRUCKING > 14 |#9:15|song |null |null |null |null |null > |null |[size=27] |[size=46] |BABY BLUE > 15 |#9:16|song |original |null |#9:335 |1386 |null > |#9:335 |[size=92] |[size=73] |DRUMS > 16 |#9:17|song |original |null |#9:8 |328 |null > |#9:93 |[size=46] |[size=31] |STELLA BLUE > 17 |#9:18|song |null |null |null |null |null > |null |#11:14 |#11:7007 |MOUNTAIN JAM > 18 |#9:19|song |cover |null |#9:50 |427 |null > |#9:245 |[size=86] |[size=87] |PROMISED LAND > 19 |#9:20|song |cover |null |#9:50 |325 |null > |#9:169 |[size=65] |[size=60] |BEAT IT ON DOWN THE LINE > > ----+-----+------+---------+---------+----------+-----------+------------+-------------+-------------+--------------+-------------------------- > LIMIT EXCEEDED: resultset contains more items not displayed (limit=20) > > 20 item(s) found. Query executed in 0.422 sec(s). > > This is NOT OK > > Thanks > Carlo > > > > Il giorno giovedì 24 aprile 2014 18:14:14 UTC+2, Enrico Risa ha scritto: > >> Hi All, >> >> a new module for OrientDB is available. The first integration OrientDB / >> Lucene is out. >> The integration for now is focused on Full Text Index and Spatial Index. >> >> You can find the Docs here https://github.com/orientechnologies/orientdb- >> lucene/wiki on how >> to install and use the module. >> >> Give it a try, >> contributions are welcome. >> >> Best Regards >> Enrico >> >> >> >> -- > > --- > 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.
