question

swami03 avatar image
swami03 asked swami03 commented

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
Toggle Comment visibility. Current Visibility: Viewable by all users

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 swami03 commented

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
Toggle Comment visibility. Current Visibility: Viewable by all users

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

swami03 avatar image swami03 commented ·

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 ·
swami03 avatar image swami03 swami03 commented ·

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

0 Likes 0 ·
bettina.swynnerton avatar image bettina.swynnerton ♦♦ swami03 commented ·

Hi @swami03,

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

0 Likes 0 ·
Show more comments
swami03 avatar image swami03 commented ·

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

0 Likes 0 ·
bettina.swynnerton avatar image bettina.swynnerton ♦♦ swami03 commented ·

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 ·
swami03 avatar image swami03 commented ·

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 ·