Bringing together the Apache Cassandra experts from the community and DataStax.

Want to learn? Have a question? Want to share your expertise? You are in the right place!

Not sure where to begin? Getting Started

 

question

swami03 avatar image
swami03 asked ·

Gremlin queries always return 10 records in Studio and application

Gremlin queries are returning 10 records both in Datastax studio 6.8.4 version and as well as through the spring boot application using java driver version 4.6.1.

is there a configuration setting to remove the limit ?or limitation on our version of software?

graphstudiogremlin
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

1 Answer

bettina.swynnerton avatar image
bettina.swynnerton answered ·

Hi @swami03,

are you using Search with this Graph installation?

If so, the limit of 10 records might come from the default settings in solr paging. Check in your dse.yaml what the setting is for: cql_solr_query_paging

For use with DSE Graph, set it to cql_solr_query_paging: driver

Please note that you would need to make the change on every node, and a restart of each node is required after the change before you see effects of this changed setting.

Let us know how you get on.

7 comments Share
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

Hi Bettina,

Thank you for quick response. Here is my setting.

1. While fetching data using Gremlin queries on DataStax Studio connecting to DSE Graph schema (6.8.0) - returns 10 records.

2. While fetching data using Gremlin queries from Spring boot application using driver 4.6.1 - returns 10 records.

3. I will validate the settings mentioned above and keep you posted.

Thank you.

0 Likes 0 · ·

I have no luck with the settings. I am not sure if this is with free DSE version.

0 Likes 0 · ·

Hi @swami03,

what changes did you make? Did you restart all your DSE nodes after making the changes?

0 Likes 0 · ·
Show more comments

Yes, we restarted all DSE nodes. Currently we are running on a single Node.

0 Likes 0 · ·

Hi @swami03,

please post the Gremlin query which is returning the 10 results.

Please also confirm that this setting is set in the dse.yaml, and not commented out:

cql_solr_query_paging: driver

Thanks!

0 Likes 0 · ·

Hi Bettina,

any flat searches like below returns 10 records in DSE studio as well as through Java code.

name column - set

code column - Varchar

g.V().hasLabel('Location').has('code', regex('.*')).has('name',contains('GEORGE/ALBERT'))

0 Likes 0 · ·