Re: update manually rows in cassandra

2019-03-14 Thread Rahul Singh 
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
> *
>
>
>
>  [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.
>

RE: update manually rows in cassandra

2019-03-13 Thread Sundaramoorthy, Natarajan 
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<mailto:natarajan_sundaramoor...@optum.com>

 [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
_
[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
w: www.dmnbigdata.com<http://www.dmnbigdata.com/>
E: dmng...@dmnbigdata.com<mailto:dmng...@dmnbigdata.com>
Private E: dmng...@gmail.com<mailto:dmng...@gmail.com>
A: Charlotte,NC,28273, USA






On Wed, Mar 13, 2019 at 4:04 PM Sundaramoorthy, Natarajan 
mailto: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.

Re: update manually rows in cassandra

2019-03-13 Thread Dieudonné Madishon NGAYA 
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]

      


*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.
>

update manually rows in cassandra

2019-03-13 Thread Sundaramoorthy, Natarajan 

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.