And also, here is the info re attributes and indices created:
info class Person
Class................: Person
Super class..........: V
Default cluster......: person (id=11)
Supported cluster ids: [11]
Cluster selection....: round-robin
PROPERTIES
-------------------------------+-------------+-------------------------------+-----------+----------+----------+-----------+-----------+----------+
NAME | TYPE | LINKED TYPE/CLASS
| MANDATORY | READONLY | NOT NULL | MIN | MAX | COLLATE |
-------------------------------+-------------+-------------------------------+-----------+----------+----------+-----------+-----------+----------+
career_title_disp | STRING | null
| false | false | false | | | default |
edu | EMBEDDEDLIST| STRING
| false | false | false | | | default |
personid | LONG | null
| false | false | false | | | default |
-------------------------------+-------------+-------------------------------+-----------+----------+----------+-----------+-----------+----------+
INDEXES (4 altogether)
-------------------------------+----------------+
NAME | PROPERTIES |
-------------------------------+----------------+
Personid | personid |
PersonEducation | edu |
CareerTitle | career_title_disp|
Person.personid | personid |
-------------------------------+----------------+
I can do something like the following:
select * from Person where @rid in (select rid from index:CareerTitle
where key like "Deputy*")
but I cannot get any results from:
select * from Person where CareerTitle LUCENE "Deputy*"
On Tuesday, April 21, 2015 at 5:20:05 PM UTC-4, sck2015 wrote:
>
> Hi all, has anyone seen this behavior before, I am creating a lucene index
> and I don't see a match even though the index appears to have been
> successfully created (I am using version 2.0.7)
>
>
> orientdb {db=newSmallDB}> create index Personid on Person(personid)
> FULLTEXT ENGINE LUCENE
>
>
> Creating index...
> Created index successfully with 1000 entries in 0.411000 sec(s).
>
>
> Index created successfully
> orientdb {db=newSmallDB}> select from index:Personid
>
>
>
> 0 item(s) found. Query executed in 0.0 sec(s).
>
>
> OR, trying to select keys:
>
> orientdb {db=newSmallDB}> select key from index:Personid
>
>
> 0 item(s) found. Query executed in 0.0 sec(s).
>
> Does anyone know why this may be happening? Ty, Sonu (same is whether
> underlying type is string, embeddedlist string, long)
>
--
---
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 orient-database+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
