I have a keyspace killrvideo. I have 3 tables named "addProduct", "productDetails", "buyProduct". Now when I insert or update any one of the tables, I needed it to be copied to the related tables also. My choice is to use batch statement (With caution). I can execute it in CLI but unable to execute it in python. So how do I create batch statements in python? What libraries should I import for that other than cassandra-driver? Note: I'm running a single node cluster on docker compose with rf=1 and SimpleStrategy.
DataStax Academy FAQ
DataStax Academy migrated to a new learning management system (LMS) in July 2020. We are also moving to a new Cassandra Certification process so there are changes to exam bookings, voucher system and issuing of certificates.
Check out the Academy FAQ pages for answers to your questions:
- Haven't heard back about exams or vouchers? [NEW August 7]
- When can I book an exam? [NEW August 10]
- How do I qualify for an exam voucher? [NEW August 10]
- How long are the coupons valid for? [NEW August 10]
- Why can't I see my old exam result or certificate? [UPDATED August 10]
- What happened to my previous exam voucher? [UPDATED August 10]
- Why is my previous course progress not shown on the new Academy?
What libraries should I import to create Cassandra batch statements in python ?
To run BATCH queries, you need to import BatchQuery:
from cassandra.cqlengine.query import BatchQuery
and create a BatchQuery instance, for example:
b = BatchQuery()
For details and examples, see Batch Queries in the Python driver. cheers!
Hi Erick,
I'm so sorry that I'm not able to understand the code given in the link https://docs.datastax.com/en/developer/python-driver/3.24/cqlengine/batches/ in a section "Batch Query genral use pattern".
If possible could you kindly clarify with a simple code to insert a record using batch :)
That would be very helpful:)
5 People are following this question.
