Hi,
In DSE 6.8, what tool can I use to check for the underlying cassandra query which is being fired when I use the graph(gremlin query) traversal to search.
The profile() method does not gives complete information.
Thank you
What tool can I use to check the underlying Cassandra query fired by a gremlin traversal?
The gremlin profile() method is probably still the best tool here, but it is incomplete in the sense that it gives the query pattern rather than the exact queries that are launched, the parameters are generally not explicitly displayed.
For example, for the query
g.V().has("person", "person_id", "person1")
the profile gives this pattern
SELECT * FROM friends.person WHERE person_id = ? / Duration: < 1 ms / Count: 1 / Index type: Table: person
but it omits the actual parameter used for "?"
Unless you have very simple queries like this one, many parallel cql queries are launched for a gremlin query, as the cql queries are launched by the various traversers needed to execute the query.
What type of query are you investigating? Perhaps we need to look at this in a different way.
6 People are following this question.
