Date
1 - 4 of 4
Solr mixed index query not working
Ankur Goel <ankur...@...>
Looks there is issue in mixed index query when using solr+ cassandra:
gremlin> g.V().has("vl","tag").has("id",gt(15)).has("gn","33AABCU2337C1ZW").count().profile()
==>Traversal Metrics
Step Count Traversers Time (ms) % Dur
=============================================================================================================
JanusGraphStep([],[vl.eq(tag), id.g... 13.133 98.31
\_condition=(vl = tag AND id > 15 AND gn = 33AABCU2337C1ZW)
\_isFitted=true
\_query=[(vl_s = tag AND id_l > 15 AND gn_s = 33AABCU2337C1ZW)]:VlGnIdMVIndex
\_index= VlGnIdMVIndex
\_orders=[]
\_isOrdered=true
\_index_impl=search
optimization 3.621
CountGlobalStep 1 1 0.225 1.69
>TOTAL - - 13.358 -
gremlin>
i am having mixed index on vl, id, gn:
mgmt.buildIndex("VlGnIdMVIndex", Vertex.class).addKey('vl', Mapping.STRING.asParameter()).addKey('gn', Mapping.STRING.asParameter()).addKey(id).buildMixedIndex("search");
i think query should be following while its coming as highlighted in red:
vl_s:"tag" AND id_l:[15 TO *] AND gn_s:"33AABCU2337C1ZW"
Please suggest.
~
Ankur Goel <ankur...@...>
Strange behaviour when i used below query it started working with solr+cassandra combination:
g.V().has("vl",textPrefix("tag")).has("id",gt(15)).has("gn",eq("33AABCU2337C1ZW")).count()
While g.V().has("vl","tag").has("id"
~
On Thursday, November 9, 2017 at 4:31:39 PM UTC+5:30, Ankur Goel wrote:
Looks there is issue in mixed index query when using solr+ cassandra:gremlin> g.V().has("vl","tag").has("id",gt(15)).has("gn"," 33AABCU2337C1ZW").count(). profile() ==>Traversal MetricsStep Count Traversers Time (ms) % Dur============================================================ ============================== =================== JanusGraphStep([],[vl.eq(tag), id.g... 13.133 98.31\_condition=(vl = tag AND id > 15 AND gn = 33AABCU2337C1ZW)\_isFitted=true\_query=[(vl_s = tag AND id_l > 15 AND gn_s = 33AABCU2337C1ZW)]:VlGnIdMVIndex \_index= VlGnIdMVIndex\_orders=[]\_isOrdered=true\_index_impl=searchoptimization 3.621CountGlobalStep 1 1 0.225 1.69>TOTAL - - 13.358 -gremlin>i am having mixed index on vl, id, gn:mgmt.buildIndex("VlGnIdMVIndex
", Vertex.class).addKey('vl', Mapping.STRING.asParameter()). addKey('gn', Mapping.STRING.asParameter()). addKey(id).buildMixedIndex(" search"); i think query should be following while its coming as highlighted in red:vl_s:"tag" AND id_l:[15 TO *] AND gn_s:"33AABCU2337C1ZW"Please suggest.~
Ankur Goel <ankur...@...>
First post has profile result.
On Thursday, November 9, 2017 at 4:31:39 PM UTC+5:30, Ankur Goel wrote:
Looks there is issue in mixed index query when using solr+ cassandra:gremlin> g.V().has("vl","tag").has("id",gt(15)).has("gn"," 33AABCU2337C1ZW").count(). profile() ==>Traversal MetricsStep Count Traversers Time (ms) % Dur============================================================ ============================== =================== JanusGraphStep([],[vl.eq(tag), id.g... 13.133 98.31\_condition=(vl = tag AND id > 15 AND gn = 33AABCU2337C1ZW)\_isFitted=true\_query=[(vl_s = tag AND id_l > 15 AND gn_s = 33AABCU2337C1ZW)]:VlGnIdMVIndex \_index= VlGnIdMVIndex\_orders=[]\_isOrdered=true\_index_impl=searchoptimization 3.621CountGlobalStep 1 1 0.225 1.69>TOTAL - - 13.358 -gremlin>i am having mixed index on vl, id, gn:mgmt.buildIndex("VlGnIdMVIndex
", Vertex.class).addKey('vl', Mapping.STRING.asParameter()). addKey('gn', Mapping.STRING.asParameter()). addKey(id).buildMixedIndex(" search"); i think query should be following while its coming as highlighted in red:vl_s:"tag" AND id_l:[15 TO *] AND gn_s:"33AABCU2337C1ZW"Please suggest.~