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.


question

bharat.asnani_190772 avatar image
bharat.asnani_190772 asked ·

What is the maximum number of vertices retrieved in a Graph query?

What is the maximum number of records that are retrieved in a graph query?

For eg.

g.V().hasLabel("Acc")

How many vertices data will be retrieved? What is the limit?

dsegraph
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,

I am assuming that you are using DSE Graph 6.8.

Under the hood, the query g.V().hasLabel("Acc") will execute as follows:

SELECT * FROM graphname.Acc

I am not aware of a hard limit with this type of query.

However, there are limits that apply to query execution time, and I would expect that you would run into the default limit for the real-time evaluation timeout with large tables, by default 30 seconds.

The question here is what you want to achieve with reading the entire vertex table. DSEGraphFrames with Spark might be a better alternative for operations where you want to read the entire table.

Would you update your question with more context?

2 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,


Thanks for your response.


In our use case we have a thousands of different vertices which will be retrieved in a single transaction. So, we need to know what is the limit on data returning in a single transaction.


Any help would be appreciated.

0 Likes 0 · ·

Hi @bharat.asnani_190772,

I am not sure I understand your requirement here.

However, as explained in a previous answer:

Cassandra as the underpinning database has no concept for transactions, which means that also Tinkerpop transactions do not provide the kind of ACID guarantee that you are hoping for.


0 Likes 0 · ·