Are multiple inserts supported through the REST API?

Question

question

wmalik asked May 4, '21 Erick Ramirez answered May 5, '21

Are multiple inserts supported through the REST API?

I want to send multiple records to insert in a table in single REST API call to Cassandra. Does datastax api service allow this? If yes, please share sample request JSON

stargate

10 |1000

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

DataStax Enterprise is powered by the best distribution of Apache Cassandra ™

Apache, Apache Cassandra, Cassandra, Apache Tomcat, Tomcat, Apache Lucene, Lucene, Apache Solr, Apache Hadoop, Hadoop, 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.

Privacy Policy Terms of Use

Answer 1 · 2021-05-05T07:14:51Z

Erick Ramirez answered May 5, '21

Inserting multiple records is not supported with the REST API because it will overload the coordinator and is inefficient as far as throughput goes. The same mechanism is not recommended with the native CQL protocol since it achieves the opposite of the outcome you're after.

We recommend making multiple requests for each insert operation to maximise throughput and performance of the cluster. Cheers!

Share

10 |1000

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

question