coalesce

Return a value based on the first traversal that has an element.

Synopsis

coalesce(traversal,traversal\_1, ...)

Description

The coalesce() step evaluates the provided traversals in order and returns the first traversal that emits at least one element.

Examples

Create a list of each person and their mean average of stars given for recipe reviews, using coalesce() to either print the mean or print a constant zero value if no reviews are found:

"g.V().hasLabel('person').as('person','starCount').
  select('person','starCount').
    by('name').
    by(coalesce(outE('reviewed').values('stars'),constant(0)).mean()).
  order().by(select('starCount'), decr)"

Was this helpful?

Give Feedback

How can we improve the documentation?

© 2024 DataStax | Privacy policy | Terms of use

Apache, Apache Cassandra, Cassandra, Apache Tomcat, Tomcat, Apache Lucene, Apache Solr, Apache Hadoop, Hadoop, Apache Pulsar, Pulsar, 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. Kubernetes is the registered trademark of the Linux Foundation.

General Inquiries: +1 (650) 389-6000, info@datastax.com