Yup
From: Goutham reddy [mailto:[email protected]] Sent: Wednesday, February 27, 2019 5:06 PM To: [email protected] 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 Brotman <[email protected]> wrote: Who are Presto? From: Goutham reddy [mailto:[email protected]] Sent: Wednesday, February 27, 2019 4:52 PM To: [email protected] 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 looking out for some hack way to update the column. On Wed, Feb 27, 2019 at 4:48 PM Kenneth Brotman <[email protected]> wrote: 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 From: Goutham reddy [mailto:[email protected]] Sent: Wednesday, February 27, 2019 4:32 PM To: [email protected] Subject: Re: Insert constant value for all the rows for a given column 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 <[email protected]> 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, 2019 at 4:25 PM Kenneth Brotman <[email protected]> wrote: How about using a default value on the column? From: Kenneth Brotman [mailto:[email protected] <mailto:[email protected]> ] Sent: Wednesday, February 27, 2019 4:23 PM To: [email protected] Subject: RE: Insert constant value for all the rows for a given column Good point. From: Goutham reddy [mailto:[email protected]] Sent: Wednesday, February 27, 2019 4:11 PM To: [email protected] 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 if my understanding is wrong. Regards Goutham Reddy On Wed, Feb 27, 2019 at 4:08 PM Kenneth Brotman <[email protected]> wrote: Sounds like what’s called a “static column”. From: Goutham reddy [mailto:[email protected]] Sent: Wednesday, February 27, 2019 4:06 PM To: [email protected] <mailto:[email protected]> Subject: Insert constant value for all the rows for a given column Hi, We have a requirement to add constant value to all the rows for a particular column, and we could not find any solution. Can anybody provide standard procedure for the problem. Appreciate your help. Regards Goutham Reddy -- Regards Goutham Reddy -- Regards Goutham Reddy
