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 coming from. This seems straightforward. I must be missing some aspect to it still. From: Goutham reddy [mailto:goutham.chiru...@gmail.com] Sent: Wednesday, February 27, 2019 5:19 PM To: user@cassandra.apache.org Subject: Re: Insert constant value for all the rows for a given column 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 <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 [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 <mailto: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