RE: Insert constant value for all the rows for a given column

2019-02-27 Thread Kenneth Brotman
Here is the link to Presto: http://prestodb.github.io/ Yes, it’s definitely a distributed SQL query engine for big data. If you are expecting a lot of different values to come in, then you’re only trying to add a value to the existing records? I don’t understand where the data is

Re: Insert constant value for all the rows for a given column

2019-02-27 Thread Goutham reddy
The value is constant as of now but we are expecting lot many different values to come in future. Secondly, is Presto a distributed system ? Thanks and Regards, Goutham. On Wed, Feb 27, 2019 at 5:09 PM Kenneth Brotman wrote: > If you know the value already, why do you need to store it in

RE: Insert constant value for all the rows for a given column

2019-02-27 Thread Kenneth Brotman
If you know the value already, why do you need to store it in every row of a table? Seems like something is wrong. Why do you need to do that, if you can share that information? From: Kenneth Brotman [mailto:kenbrot...@yahoo.com] Sent: Wednesday, February 27, 2019 5:08 PM To:

RE: Insert constant value for all the rows for a given column

2019-02-27 Thread Kenneth Brotman
I meant to say, what about using Presto? From: Kenneth Brotman [mailto:kenbrot...@yahoo.com.INVALID] Sent: Wednesday, February 27, 2019 4:59 PM To: user@cassandra.apache.org Subject: RE: Insert constant value for all the rows for a given column Who are Presto? From: Goutham reddy

RE: Insert constant value for all the rows for a given column

2019-02-27 Thread Kenneth Brotman
Yup From: Goutham reddy [mailto:goutham.chiru...@gmail.com] Sent: Wednesday, February 27, 2019 5:06 PM To: user@cassandra.apache.org Subject: Re: Insert constant value for all the rows for a given column Are you taking about SQL engine Presto ;) On Wed, Feb 27, 2019 at 4:59 PM Kenneth

Re: Insert constant value for all the rows for a given column

2019-02-27 Thread Goutham reddy
Are you taking about SQL engine Presto ;) On Wed, Feb 27, 2019 at 4:59 PM Kenneth Brotman wrote: > Who are Presto? > > > > *From:* Goutham reddy [mailto:goutham.chiru...@gmail.com] > *Sent:* Wednesday, February 27, 2019 4:52 PM > *To:* user@cassandra.apache.org > *Subject:* Re: Insert constant

RE: Insert constant value for all the rows for a given column

2019-02-27 Thread Kenneth Brotman
Who are Presto? From: Goutham reddy [mailto:goutham.chiru...@gmail.com] Sent: Wednesday, February 27, 2019 4:52 PM To: user@cassandra.apache.org Subject: Re: Insert constant value for all the rows for a given column Thanks Kenneth, writing Spark application is our last option and we are

Re: Insert constant value for all the rows for a given column

2019-02-27 Thread Goutham reddy
Thanks Kenneth, writing Spark application is our last option and we are looking out for some hack way to update the column. On Wed, Feb 27, 2019 at 4:48 PM Kenneth Brotman wrote: > Ouch! I was sure I saw it in some material I studied but no. It looks > like you have to provide the value

RE: Insert constant value for all the rows for a given column

2019-02-27 Thread Kenneth Brotman
Ouch! I was sure I saw it in some material I studied but no. It looks like you have to provide the value before Cassandra, maybe through your application or something in the stream before Cassandra, or add it after Cassandra or use something like Spark to process it. Kenneth Brotman

Re: Insert constant value for all the rows for a given column

2019-02-27 Thread Goutham reddy
True Bharath, there is no option to add a default value in Cassandra for a column. Regards Goutham Reddy On Wed, Feb 27, 2019 at 4:31 PM kumar bharath wrote: > Kenneth, > > I didn't see any such option for adding a default value on a column. > > Thanks, > Bharath Kumar B > > On Wed, Feb 27,

Re: Insert constant value for all the rows for a given column

2019-02-27 Thread kumar bharath
Kenneth, I didn't see any such option for adding a default value on a column. Thanks, Bharath Kumar B On Wed, Feb 27, 2019 at 4:25 PM Kenneth Brotman wrote: > How about using a default value on the column? > > > > *From:* Kenneth Brotman [mailto:kenbrot...@yahoo.com.INVALID] > *Sent:*

Re: Insert constant value for all the rows for a given column

2019-02-27 Thread Patrick Goliwas
Unsubscribe please Sent via mobile Call/Text: (612) 281-0702 On Feb 27, 2019, at 6:25 PM, Kenneth Brotman wrote: How about using a default value on the column? From: Kenneth Brotman [mailto:kenbrot...@yahoo.com.INVALID] Sent: Wednesday, February 27, 2019 4:23 PM To:

RE: Insert constant value for all the rows for a given column

2019-02-27 Thread Kenneth Brotman
How about using a default value on the column? From: Kenneth Brotman [mailto:kenbrot...@yahoo.com.INVALID] Sent: Wednesday, February 27, 2019 4:23 PM To: user@cassandra.apache.org Subject: RE: Insert constant value for all the rows for a given column Good point. From: Goutham reddy

RE: Insert constant value for all the rows for a given column

2019-02-27 Thread Kenneth Brotman
Good point. From: Goutham reddy [mailto:goutham.chiru...@gmail.com] Sent: Wednesday, February 27, 2019 4:11 PM To: user@cassandra.apache.org Subject: Re: Insert constant value for all the rows for a given column Kenneth, I believe "static column" applies for one partition key. Correct me

Re: Insert constant value for all the rows for a given column

2019-02-27 Thread Goutham reddy
Kenneth, I believe "static column" applies for one partition key. Correct me if my understanding is wrong. Regards Goutham Reddy On Wed, Feb 27, 2019 at 4:08 PM Kenneth Brotman wrote: > Sounds like what’s called a “static column”. > > > > *From:* Goutham reddy

RE: Insert constant value for all the rows for a given column

2019-02-27 Thread Kenneth Brotman
Here’s a DataStax article called Sharing a static column: https://docs.datastax.com/en/cql/3.3/cql/cql_using/refStaticCol.html From: Kenneth Brotman [mailto:kenbrot...@yahoo.com] Sent: Wednesday, February 27, 2019 4:08 PM To: 'user@cassandra.apache.org' Subject: RE: Insert constant value

RE: Insert constant value for all the rows for a given column

2019-02-27 Thread Kenneth Brotman
Sounds like what’s called a “static column”. From: Goutham reddy [mailto:goutham.chiru...@gmail.com] Sent: Wednesday, February 27, 2019 4:06 PM To: user@cassandra.apache.org Subject: Insert constant value for all the rows for a given column Hi, We have a requirement to add constant value