It makes sense but what kind of index should I create? I thought that LIKE
is not supported by any indices in OrientDB and only LUCENE provides
ability to search by partial names.
Could you write a query how to create corresponding indices?
среда, 18 июня 2014 г., 9:29:31 UTC+3 пользователь Riccardo Tasso написал:
>
> Why are you using Lucene if you don't need full-text features?
>
> I would try with:
>
> SELECT FROM Location WHERE name LIKE 'Lon%' OR
> out('language').name LIKE 'Lon%' LIMIT 20
>
>
> 2014-06-17 13:58 GMT+02:00 Vladimir Ziankevich <[email protected]
> <javascript:>>:
>
>> Ouch, I was mistaken. The second query makes search only throough the
>> aliases. I think that is a correct variant of the second query
>>
>> SELECT EXPAND( $c )
>> LET $a = (select from (traverse * from (select in_language from Alias
>> where name LUCENE 'fr_tord*') while $depth <=2) where @class='Location'
>> order by name_en),
>> $b = ( SELECT FROM Location where name_en LUCENE 'Minsk*' ),
>> $c = UNIONALL( $a, $b )
>>
>> But the main question is still not answered. Is there any way to make
>> similar search without traversing?
>>
>> вторник, 17 июня 2014 г., 13:22:00 UTC+3 пользователь Vladimir Ziankevich
>> написал:
>>
>>> I have the next database schema:
>>>
>>> vertex type Location(properties: id, name)
>>> vertex type Alias(properties: name)
>>> edge type Language(properties: name)
>>>
>>> Each vertex of Location can have multiple edges with Aliases.
>>> For example:
>>> location(1,London) -> edge language(name='english') ->
>>> alias(name='City of London')
>>> -> edge
>>> language(name='french') -> alias(name='Londres')
>>>
>>> There are about 600 000 locations and more than 1 000 000 aliases. I
>>> need to implement fast search of locations through the location names and
>>> aliases for typeahead.
>>> I've applied Lucene indices both to Location.name and Alias.name and
>>> expected to get appropriate locations list running query like:
>>>
>>> select from Location where name LUCENE 'Lon*' or out_language.in.name
>>> LUCENE 'Lon*' limit=20
>>> something like that.
>>>
>>> But it does not work. This query returns all the locations from database.
>>>
>>> I've found another one query that works correctly
>>>
>>> select from
>>> (traverse * from (select in_language from Alias where name LUCENE 'Lon*'
>>> ) while $depth <=2)
>>> where @class='Location'
>>>
>>> but I'm worried about the performance.
>>>
>>> Could someone offer me another variants? Or how to tune this one query.
>>> Thanks in advance.
>>>
>> --
>>
>> ---
>> 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] <javascript:>.
>> 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.
