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.
