hello
{
"result": [
{
"@type": "d",
"@version": 0,
"documentReads": 1,
"fullySortedByIndex": false,
"documentAnalyzedCompatibleClass": 1,
"recordReads": 1,
"distance": 0.4249428696025692,
"luceneIndex": true,
"fetchingFromTargetElapsed": 4,
"indexIsUsedInOrderBy": false,
"score": 0.052147128,
"current": "#14:10",
"totalHits": 1,
"_memoryIndex": "description:\n\t'[31 35 30 30 73]':1:
[(24)]\n\t'[31 39 36 30 73]':1: [(65)]\n\t'[61 63 63 69 64 65 6e 74]':1:
[(188)]\n\t'[61 6c 64 75 73]':1: [(84)]\n\t'[61 6c 73 6f]':1:
[(51)]\n\t'[62 65 65 6e]':1: [(15)]\n\t'[62 6f 6f 6b]':1: [(42)]\n\t'[63 65
6e 74 75 72 69 65 73]':1: [(49)]\n\t'[63 6f 6e 74 61 69 6e 69 6e 67]':1:
[(72)]\n\t'[63 6f 6e 74 65 6e 74]':3: [(106),(137),(139)]\n\t'[64 65 66 61
75 6c 74]':1: [(161)]\n\t'[64 65 73 6b 74 6f 70]':2: [(80),(148)]\n\t'[64
69 73 74 72 61 63 74 65 64]':1: [(102)]\n\t'[64 69 73 74 72 69 62 75 74 69
6f 6e]':1: [(130)]\n\t'[64 75 6d 6d 79]':2: [(4),(19)]\n\t'[65 64 69 74 6f
72 73]':1: [(154)]\n\t'[65 6c 65 63 74 72 6f 6e 69 63]':1: [(55)]\n\t'[65
6e 67 6c 69 73 68]':1: [(146)]\n\t'[65 73 73 65 6e 74 69 61 6c 6c 79]':1:
[(58)]\n\t'[65 73 74 61 62 6c 69 73 68 65 64]':1: [(95)]\n\t'[65 76 65
72]':1: [(21)]\n\t'[65 76 6f 6c 76 65 64]':1: [(182)]\n\t'[66 61 63 74]':1:
[(96)]\n\t'[66 69 76 65]':1: [(48)]\n\t'[67 61 6c 6c 65 79]':1:
[(31)]\n\t'[68 61 73]':3: [(14),(44),(124)]\n\t'[68 61 76 65]':1:
[(181)]\n\t'[68 65 72 65]':2: [(138),(140)]\n\t'[68 75 6d 6f 75 72]':1:
[(193)]\n\t'[69 6e 63 6c 75 64 69 6e 67]':1: [(86)]\n\t'[69 6e 64 75 73 74
72 79]':1: [(11)]\n\t'[69 6e 64 75 73 74 72 79 27 73]':1: [(17)]\n\t'[69 6e
66 61 6e 63 79]':1: [(178)]\n\t'[69 6e 6a 65 63 74 65 64]':1:
[(192)]\n\t'[69 70 73 75 6d]':7:
[(1),(13),(74),(90),(120),(158),(169)]\n\t'[69 74 73]':1: [(113)]\n\t'[6c
61 79 6f 75 74]':1: [(114)]\n\t'[6c 65 61 70]':1: [(53)]\n\t'[6c 65 73
73]':1: [(128)]\n\t'[6c 65 74 72 61 73 65 74]':1: [(70)]\n\t'[6c 65 74 74
65 72 73]':1: [(132)]\n\t'[6c 69 6b 65]':3: [(83),(144),(196)]\n\t'[6c 6f
6e 67]':1: [(94)]\n\t'[6c 6f 6f 6b]':1: [(143)]\n\t'[6c 6f 6f 6b 69 6e
67]':1: [(111)]\n\t'[6c 6f 72 65 6d]':7:
[(0),(12),(73),(89),(119),(157),(168)]\n\t'[6d 61 6b 65]':1: [(38)]\n\t'[6d
61 6b 69 6e 67]':1: [(141)]\n\t'[6d 61 6e 79]':2: [(147),(172)]\n\t'[6d 6f
64 65 6c]':1: [(162)]\n\t'[6d 6f 72 65]':2: [(77),(126)]\n\t'[6e 6f 72 6d
61 6c]':1: [(129)]\n\t'[6e 6f 77]':1: [(155)]\n\t'[6f 6e 6c 79]':1:
[(47)]\n\t'[6f 70 70 6f 73 65 64]':1: [(134)]\n\t'[6f 76 65 72]':1:
[(183)]\n\t'[70 61 63 6b 61 67 65 73]':1: [(150)]\n\t'[70 61 67 65]':2:
[(109),(153)]\n\t'[70 61 67 65 6d 61 6b 65 72]':1: [(85)]\n\t'[70 61 73 73
61 67 65 73]':1: [(75)]\n\t'[70 6f 69 6e 74]':1: [(116)]\n\t'[70 6f 70 75
6c 61 72 69 73 65 64]':1: [(62)]\n\t'[70 72 69 6e 74 65 72]':1:
[(28)]\n\t'[70 72 69 6e 74 69 6e 67]':1: [(8)]\n\t'[70 75 62 6c 69 73 68 69
6e 67]':2: [(81),(149)]\n\t'[70 75 72 70 6f 73 65]':1: [(191)]\n\t'[72 65
61 64 61 62 6c 65]':2: [(105),(145)]\n\t'[72 65 61 64 65 72]':1:
[(99)]\n\t'[72 65 63 65 6e 74 6c 79]':1: [(78)]\n\t'[72 65 6c 65 61 73
65]':1: [(68)]\n\t'[72 65 6d 61 69 6e 69 6e 67]':1: [(57)]\n\t'[73 63 72 61
6d 62 6c 65 64]':1: [(35)]\n\t'[73 65 61 72 63 68]':1: [(166)]\n\t'[73 68
65 65 74 73]':1: [(71)]\n\t'[73 69 6d 70 6c 79]':1: [(3)]\n\t'[73 69 6e 63
65]':1: [(22)]\n\t'[73 69 74 65 73]':1: [(174)]\n\t'[73 6f 66 74 77 61 72
65]':1: [(82)]\n\t'[73 6f 6d 65 74 69 6d 65 73]':2: [(186),(189)]\n\t'[73
70 65 63 69 6d 65 6e]':1: [(41)]\n\t'[73 74 61 6e 64 61 72 64]':1:
[(18)]\n\t'[73 74 69 6c 6c]':1: [(175)]\n\t'[73 75 72 76 69 76 65 64]':1:
[(45)]\n\t'[74 65 78 74]':3: [(5),(20),(163)]\n\t'[74 6f 6f 6b]':1:
[(29)]\n\t'[74 79 70 65]':2: [(33),(40)]\n\t'[74 79 70 65 73 65 74 74 69 6e
67]':2: [(10),(56)]\n\t'[75 6e 63 68 61 6e 67 65 64]':1: [(59)]\n\t'[75 6e
63 6f 76 65 72]':1: [(171)]\n\t'[75 6e 6b 6e 6f 77 6e]':1: [(27)]\n\t'[75
73 65]':1: [(156)]\n\t'[75 73 69 6e 67]':2: [(118),(136)]\n\t'[76 61 72 69
6f 75 73]':1: [(179)]\n\t'[76 65 72 73 69 6f 6e 73]':2:
[(87),(180)]\n\t'[77 65 62]':2: [(152),(173)]\n\t'[77 68 65 6e]':2:
[(25),(110)]\n\t'[79 65 61 72 73]':1: [(185)]\n\tterms=97, positions=132,
memory=35.1 KB\nkeyword:\n\t'[64 6f 6c 6f 72]':1: [(2)]\n\t'[69 70 73 75
6e]':1: [(1)]\n\t'[6c 6f 72 65 6d]':1: [(0)]\n\tterms=3, positions=3,
memory=32.9 KB\ntitle:\n\t'[31]':1: [(3)]\n\t'[64 65]':1: [(1)]\n\t'[6e 65
67 6f 63 69 6f]':1: [(0)]\n\t'[70 72 75 65 62 61]':1: [(2)]\n\tterms=4,
positions=4, memory=32.9 KB\n\nfields=3, terms=104, positions=139,
memory=69.7 KB",
"involvedIndexes": [
"Commercelocation.des_tit_key"
],
"limit": -1,
"evaluated": 1,
"spatial": {
"maxDistance": 5000
},
"Commercelocation_des_tit_key_totalHits": 1,
"user": "#5:0",
"elapsed": 8.147328,
"resultType": "collection",
"resultSize": 1,
"@fieldTypes":
"documentReads=l,documentAnalyzedCompatibleClass=l,recordReads=l,distance=d,fetchingFromTargetElapsed=l,score=f,current=x,involvedIndexes=e,evaluated=l,user=x,elapsed=f"
}
],
"notification": "Query executed in 0.065 sec. Returned 1 record(s)"
I made a solution but not if it is the best way
select *, $distance
from
(
select *
from CommerceLocation
where state = true
and [description, title, keyword] LUCENE "text"
and latitude is not null
and longitude is not null
)
where [latitude, longitude, $spatial] NEAR
[-12.102700323271819,-77.03379312133791,{'maxDistance' : 5000}]
order by $distance
--
---
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.
