CQL supports JSON in and out from the Cassandra table, but if your JSON in the table is a string, then you need to update it as a string.
https://docs.datastax.com/en/cql/3.3/cql/cql_using/useInsertJSON.html https://docs.datastax.com/en/cql/3.3/cql/cql_using/useQueryJSON.html What's the schema of the table? On Wed, Mar 13, 2019 at 5:09 PM Sundaramoorthy, Natarajan < natarajan_sundaramoor...@optum.com> wrote: > Update json data with the correct value from file. Thanks > > > > > > *Natarajan Sundaramoorthy* > > PaaS Engineering and Automation > > Desk - 763-744-1854 > > Email - *natarajan_sundaramoor...@optum.com > <natarajan_sundaramoor...@optum.com>* > > > > [image: cid:image001.jpg@01D03C99.02523830] > > > > > > > > *From:* Dieudonné Madishon NGAYA [mailto:dmng...@gmail.com] > *Sent:* Wednesday, March 13, 2019 3:44 PM > *To:* user@cassandra.apache.org > *Subject:* Re: update manually rows in cassandra > > > > Hi , > > In your case, do you want to insert json file data into cassandra ? > > > > Best regards > > _____________________________________________________________ > > > [image: > https://www.facebook.com/DMN-BigData-371074727032197/?modal=admin_todo_tour] > <https://www.facebook.com/DMN-BigData-371074727032197/?modal=admin_todo_tour> > <https://twitter.com/dmnbigdata> <https://www.instagram.com/> > <https://www.linkedin.com/in/dngaya/> > > *Dieudonne Madishon NGAYA* > Datastax, Cassandra Architect > *P: *7048580065 > *w: *www.dmnbigdata.com > *E: *dmng...@dmnbigdata.com > *Private E: *dmng...@gmail.com > *A: *Charlotte,NC,28273, USA > > > > > > > > On Wed, Mar 13, 2019 at 4:04 PM Sundaramoorthy, Natarajan < > natarajan_sundaramoor...@optum.com> wrote: > > > > *Something got goofed up in database. Data is in json format. We have data > in some file have to match the data in file and update the database. Can > you please tell how to do it? New to cassandra. Thanks * > > > > > This e-mail, including attachments, may include confidential and/or > proprietary information, and may be used only by the person or entity > to which it is addressed. If the reader of this e-mail is not the intended > recipient or his or her authorized agent, the reader is hereby notified > that any dissemination, distribution or copying of this e-mail is > prohibited. If you have received this e-mail in error, please notify the > sender by replying to this message and delete this e-mail immediately. > > > This e-mail, including attachments, may include confidential and/or > proprietary information, and may be used only by the person or entity > to which it is addressed. If the reader of this e-mail is not the intended > recipient or his or her authorized agent, the reader is hereby notified > that any dissemination, distribution or copying of this e-mail is > prohibited. If you have received this e-mail in error, please notify the > sender by replying to this message and delete this e-mail immediately. >