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 <kenbrot...@yahoo.com.invalid> wrote: > 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:* 'user@cassandra.apache.org' > *Subject:* RE: Insert constant value for all the rows for a given column > > > > 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 Brotman > <kenbrot...@yahoo.com.invalid> 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 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 > <kenbrotman@yahoocom.invalid> 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:goutham.chiru...@gmail.com] > *Sent:* Wednesday, February 27, 2019 4:32 PM > *To:* user@cassandra.apache.org > *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 <kumar.bharathb...@gmail.com> > 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 > <kenbrot...@yahoo.com.invalid> wrote: > > How about using a default value on the column? > > > > *From:* Kenneth Brotman [mailto:kenbrotman@yahoo.comINVALID > <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 [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 if my > understanding is wrong. > > > > Regards > > Goutham Reddy > > > > > > On Wed, Feb 27, 2019 at 4:08 PM Kenneth Brotman > <kenbrot...@yahoo.com.invalid> wrote: > > 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:* u...@cassandraapache.org <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 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 > -- Regards Goutham Reddy
