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
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
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.
What is the syntax for the "greater than" operator on Date types in Gremlin?
Is there a limit to adding multiple vertices and edges in a single graph traversal?
Why is groupCount() returning inconsistent results for vertices?
Is our approach the right way to do more traversals on one vertex?
How do we perform edge search in DSE 6.8 of properties stored from IN vertex to edge?
DataStax Enterprise is powered by the best distribution of Apache Cassandra ™
© 2023 DataStax, Titan, and TitanDB are registered trademarks of DataStax, Inc. and its subsidiaries in the United States and/or other countries.
Apache, Apache Cassandra, Cassandra, Apache Tomcat, Tomcat, Apache Lucene, Lucene, Apache Solr, Apache Hadoop, Hadoop, Apache Spark, Spark, Apache TinkerPop, TinkerPop, Apache Kafka and Kafka are either registered trademarks or trademarks of the Apache Software Foundation or its subsidiaries in Canada, the United States and/or other countries.
Privacy Policy Terms of Use