Solr mixed index query not working


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 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.

~




tpr...@...
 

Can you profile your queries ?


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",gt(15)).has("gn","33AABCU2337C1ZW").count() is returning zero .



~


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 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...@...>
 

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.

~