Ok, I'll stick with 2.0.4 for now then, until 2.1.4 comes out, then I'll give it another run.
On Tuesday, October 6, 2015 at 12:22:14 PM UTC+1, Enrico Risa wrote: > > > It is not really a new implementation it is a bug fix that prevented you > from use lucene operator along > with other conditions. > Also spatial filter + full text did not worked. So we implemented an in > memory check with lucene code in case the index is not used. > > I think this week will be released > > > 2015-10-06 13:12 GMT+02:00 Rui Pereira <sys...@gmail.com <javascript:>>: > >> Ok, when should I expect that to be released? >> >> I was upgrading from 2.0.4 . When was this new memory index >> implementation introduced? >> >> Thanks for your help >> >> On 6 October 2015 at 12:03, Enrico Risa <enric...@gmail.com <javascript:> >> > wrote: >> >>> Hi syshex >>> >>> Yes it is a 2.1.3 issue >>> i've raised an issue. >>> https://github.com/orientechnologies/orientdb-lucene/issues/73 >>> >>> I will fix it for the next hotfix 2.1.4 >>> >>> 2015-10-06 12:03 GMT+02:00 syshex <sys...@gmail.com <javascript:>>: >>> >>>> On 2.0.4 this query returns the expected results : >>>> >>>> SELECT * FROM Cpv WHERE [description] LUCENE "limpeza" >>>> >>>> >>>> >>>> On Tuesday, October 6, 2015 at 10:57:51 AM UTC+1, Enrico Risa wrote: >>>>> >>>>> Maybe there is some issue with inheritance. >>>>> >>>>> I'm checking >>>>> >>>>> 2015-10-06 11:46 GMT+02:00 Rui Pereira <sys...@gmail.com>: >>>>> >>>>>> Hey , >>>>>> >>>>>> Supertable is actually Cpv (same class, I was renaming my >>>>>> outputs). >>>>>> >>>>>> So Cpv (or Supertable) has 4 subclasses , call them Cpv1, Cpv2, Cpv3, >>>>>> Cpv4 . They all extend from Cpv. >>>>>> >>>>>> All data created is of type Cpv1,2,3,4 . The lucene index is >>>>>> created on Cpv in order to find all Cpvs that match a criteria. >>>>>> >>>>>> >>>>>> On 6 October 2015 at 09:51, Enrico Risa <enric...@gmail.com> wrote: >>>>>> >>>>>>> Can you post the schema also? >>>>>>> >>>>>>> Did Supertable extends other classes? >>>>>>> >>>>>>> Di you have also a class Cpv? >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> 2015-10-06 10:42 GMT+02:00 syshex <sys...@gmail.com>: >>>>>>> >>>>>>>> Hi Enrico >>>>>>>> >>>>>>>> Raw from studio for the explain query you requested: >>>>>>>> >>>>>>>> { >>>>>>>> "result": [ >>>>>>>> { >>>>>>>> "@type": "d", >>>>>>>> "@version": 0, >>>>>>>> "limit": -1, >>>>>>>> "luceneIndex": true, >>>>>>>> "fullySortedByIndex": false, >>>>>>>> "Cpv_description_totalHits": 30, >>>>>>>> "evaluated": 30, >>>>>>>> "score": 1, >>>>>>>> "documentAnalyzedCompatibleClass": 30, >>>>>>>> "involvedIndexes": [ >>>>>>>> "Supertable.description" >>>>>>>> ], >>>>>>>> "totalHits": 30, >>>>>>>> "indexIsUsedInOrderBy": false, >>>>>>>> "current": "#25:12", >>>>>>>> "fetchingFromTargetElapsed": 15, >>>>>>>> "documentReads": 30, >>>>>>>> "user": "#5:0", >>>>>>>> "recordReads": 30, >>>>>>>> "elapsed": 18.605516, >>>>>>>> "resultType": "collection", >>>>>>>> "resultSize": 0, >>>>>>>> "@fieldTypes": >>>>>>>> "evaluated=l,score=f,documentAnalyzedCompatibleClass=l,involvedIndexes=e,current=x,fetchingFromTargetElapsed=l,documentReads=l,user=x,recordReads=l,elapsed=f" >>>>>>>> } >>>>>>>> ], >>>>>>>> "notification": "Query executed in 0.034 sec. Returned 1 >>>>>>>> record(s)" >>>>>>>> } >>>>>>>> >>>>>>>> Hope this helps >>>>>>>> Rui >>>>>>>> >>>>>>>> On Monday, October 5, 2015 at 8:28:33 PM UTC+1, Enrico Risa wrote: >>>>>>>>> >>>>>>>>> Hi syshex >>>>>>>>> >>>>>>>>> can you paste here the result of >>>>>>>>> >>>>>>>>> explain SELECT * FROM Supertable WHERE description LUCENE >>>>>>>>> "limpeza*" >>>>>>>>> >>>>>>>>> 2015-10-05 20:07 GMT+02:00 syshex <sys...@gmail.com>: >>>>>>>>> >>>>>>>>>> Hi everyone. >>>>>>>>>> >>>>>>>>>> I've got a table named Supertable with a String field called >>>>>>>>>> description. >>>>>>>>>> >>>>>>>>>> Created a Lucene index on it, like so : >>>>>>>>>> >>>>>>>>>> create index Supertable.description on Supertable (description) >>>>>>>>>> FULLTEXT ENGINE LUCENE >>>>>>>>>> >>>>>>>>>> return from studio was that the index was created, with 1150 >>>>>>>>>> indexed. >>>>>>>>>> >>>>>>>>>> If I query the index directly, like so : >>>>>>>>>> >>>>>>>>>> SELECT * FROM index:Supertable.description WHERE key LUCENE >>>>>>>>>> "limpeza*" >>>>>>>>>> >>>>>>>>>> I get 20 results back, with key = "limpeza*" and the rid of the >>>>>>>>>> corresponding V . >>>>>>>>>> >>>>>>>>>> If I select like this : >>>>>>>>>> >>>>>>>>>> SELECT * FROM Supertable WHERE description LUCENE "limpeza*" >>>>>>>>>> >>>>>>>>>> I get 0 results back. >>>>>>>>>> >>>>>>>>>> Is this a bug or what? >>>>>>>>>> >>>>>>>>>> Thanks for your time >>>>>>>>>> >>>>>>>>>> -- >>>>>>>>>> >>>>>>>>>> --- >>>>>>>>>> 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-databa...@googlegroups.com. >>>>>>>>>> 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 orient-databa...@googlegroups.com. >>>>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>>>> >>>>>>> >>>>>>> -- >>>>>>> >>>>>>> --- >>>>>>> You received this message because you are subscribed to a topic in >>>>>>> the Google Groups "OrientDB" group. >>>>>>> To unsubscribe from this topic, visit >>>>>>> https://groups.google.com/d/topic/orient-database/1geg4BLKREc/unsubscribe >>>>>>> . >>>>>>> To unsubscribe from this group and all its topics, send an email to >>>>>>> orient-databa...@googlegroups.com. >>>>>>> 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 orient-databa...@googlegroups.com. >>>>>> 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 orient-databa...@googlegroups.com <javascript:>. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> -- >>> >>> --- >>> You received this message because you are subscribed to a topic in the >>> Google Groups "OrientDB" group. >>> To unsubscribe from this topic, visit >>> https://groups.google.com/d/topic/orient-database/1geg4BLKREc/unsubscribe >>> . >>> To unsubscribe from this group and all its topics, send an email to >>> orient-databa...@googlegroups.com <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 orient-databa...@googlegroups.com <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 orient-database+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
