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
PLANNED MAINTENANCE
Hello, DataStax Community!
We want to make you aware of a few operational updates which will be carried out on the site. We are working hard to streamline the login process to integrate with other DataStax resources. As such, you will soon be prompted to update your password. Please note that your username will remain the same.
As we work to improve your user experience, please be aware that login to the DataStax Community will be unavailable for a few hours on:
- Wednesday, July 15 16:00 PDT | 19:00 EDT | 20:00 BRT
- Thursday, July 16 00:00 BST | 01:00 CEST | 04:30 IST | 07:00 CST | 09:00 AEST
For more info, check out the FAQ page. Thank you for being a valued member of our community.
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.
