OSDir


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: How to query 100 primary keys at once


Thank you Jeff for the solution.

On Thu, Jul 5, 2018 at 12:01 PM Jeff Jirsa <jjirsa@xxxxxxxxx> wrote:
Either of those solutions are fine, you just need to consider throttling/limiting the number of concurrent queries (either in the application, or on the server side) to avoid timeouts.



On Thu, Jul 5, 2018 at 11:16 AM, Goutham reddy <goutham.chirutha@xxxxxxxxx> wrote:
Hi users,
Querying multiple primary keys can be achieved using IN operator but it cause load only on single node and which inturn causes READ timeout issues. Calling asynchronously each primary key is also not a right choice for big partition key. 
Can anyone suggest me best practice to query it and if Cassandra is not the right fit for these type of queries which NoSQL dB solves this problem. Any help is highly appreciated

Thanks,
Goutham,
T- Mobile.
--
Regards
Goutham Reddy

--
Regards
Goutham Reddy