You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by "Sundaramoorthy, Natarajan" <na...@optum.com> on 2019/03/13 20:04:45 UTC
update manually rows in cassandra
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.
Re: update manually rows in cassandra
Posted by Rahul Singh <ra...@gmail.com>.
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_sundaramoorthy@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_sundaramoorthy@optum.com
> <na...@optum.com>*
>
>
>
> [image: cid:image001.jpg@01D03C99.02523830]
>
>
>
>
>
>
>
> *From:* Dieudonné Madishon NGAYA [mailto:dmngaya@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: *dmngaya@dmnbigdata.com
> *Private E: *dmngaya@gmail.com
> *A: *Charlotte,NC,28273, USA
>
>
>
>
>
>
>
> On Wed, Mar 13, 2019 at 4:04 PM Sundaramoorthy, Natarajan <
> natarajan_sundaramoorthy@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.
>
RE: update manually rows in cassandra
Posted by "Sundaramoorthy, Natarajan" <na...@optum.com>.
Update json data with the correct value from file. Thanks
Natarajan Sundaramoorthy
PaaS Engineering and Automation
Desk - 763-744-1854
Email - natarajan_sundaramoorthy@optum.com<ma...@optum.com>
[cid:image001.jpg@01D03C99.02523830]
From: Dieudonné Madishon NGAYA [mailto:dmngaya@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
_____________________________________________________________
[https://s26.postimg.cc/9rnn6cmjt/logo.png]
[https://www.facebook.com/DMN-BigData-371074727032197/?modal=admin_todo_tour]<https://www.facebook.com/DMN-BigData-371074727032197/?modal=admin_todo_tour> [https://s26.postimg.cc/uvc71fu09/twitter.png] <https://twitter.com/dmnbigdata> [https://s26.postimg.cc/zb3sy6l61/instragram.png] <https://www.instagram.com/> [https://s26.postimg.cc/tgoehxx2h/linkadin.png] <https://www.linkedin.com/in/dngaya/> [https://s26.postimg.cc/3mels5x2h/google.png]
Dieudonne Madishon NGAYA
Datastax, Cassandra Architect
P: 7048580065<tel:7048580065>
w: www.dmnbigdata.com<http://www.dmnbigdata.com/>
E: dmngaya@dmnbigdata.com<ma...@dmnbigdata.com>
Private E: dmngaya@gmail.com<ma...@gmail.com>
A: Charlotte,NC,28273, USA
On Wed, Mar 13, 2019 at 4:04 PM Sundaramoorthy, Natarajan <na...@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.
Re: update manually rows in cassandra
Posted by Dieudonné Madishon NGAYA <dm...@gmail.com>.
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: *dmngaya@dmnbigdata.com
*Private E: *dmngaya@gmail.com
*A: *Charlotte,NC,28273, USA
On Wed, Mar 13, 2019 at 4:04 PM Sundaramoorthy, Natarajan <
natarajan_sundaramoorthy@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.
>