You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Goutham reddy <go...@gmail.com> on 2019/02/28 00:06:25 UTC
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
RE: Insert constant value for all the rows for a given column
Posted by Kenneth Brotman <ke...@yahoo.com.INVALID>.
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:kenbrotman@yahoo.com]
Sent: Wednesday, February 27, 2019 4:08 PM
To: 'user@cassandra.apache.org'
Subject: RE: Insert constant value for all the rows for a given column
Sounds like what’s called a “static column”.
From: Goutham reddy [mailto:goutham.chirutha@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 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
Re: Insert constant value for all the rows for a given column
Posted by Patrick Goliwas <pg...@gmail.com>.
Unsubscribe please
Sent via mobile
Call/Text: (612) 281-0702
On Feb 27, 2019, at 6:25 PM, Kenneth Brotman <ke...@yahoo.com.invalid> wrote:
How about using a default value on the column?
From: Kenneth Brotman [mailto:kenbrotman@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.chirutha@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 <ke...@yahoo.com.invalid> wrote:
Sounds like what’s called a “static column”.
From: Goutham reddy [mailto:goutham.chirutha@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 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
RE: Insert constant value for all the rows for a given column
Posted by Kenneth Brotman <ke...@yahoo.com.INVALID>.
I meant to say, what about using Presto?
From: Kenneth Brotman [mailto:kenbrotman@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 [mailto:goutham.chirutha@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 <ke...@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.chirutha@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 <ku...@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 <ke...@yahoo.com.invalid> wrote:
How about using a default value on the column?
From: Kenneth Brotman [mailto:kenbrotman@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.chirutha@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 <ke...@yahoo.com.invalid> wrote:
Sounds like what’s called a “static column”.
From: Goutham reddy [mailto:goutham.chirutha@gmail.com]
Sent: Wednesday, February 27, 2019 4:06 PM
To: user@cassandraapache.org <ma...@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
RE: Insert constant value for all the rows for a given column
Posted by Kenneth Brotman <ke...@yahoo.com.INVALID>.
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.chirutha@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 <ke...@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:kenbrotman@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.chirutha@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 <ke...@yahoo.com.invalid> wrote:
Who are Presto?
From: Goutham reddy [mailto:goutham.chirutha@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 <ke...@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.chirutha@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 <ku...@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 <ke...@yahoo.com.invalid> wrote:
How about using a default value on the column?
From: Kenneth Brotman [mailto:kenbrotman@yahoo.comINVALID <ma...@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.chirutha@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 <ke...@yahoo.com.invalid> wrote:
Sounds like what’s called a “static column”.
From: Goutham reddy [mailto:goutham.chirutha@gmail.com]
Sent: Wednesday, February 27, 2019 4:06 PM
To: user@cassandraapache.org <ma...@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
Re: Insert constant value for all the rows for a given column
Posted by Goutham reddy <go...@gmail.com>.
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
<ke...@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:kenbrotman@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.chirutha@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
> <ke...@yahoo.com.invalid> wrote:
>
> Who are Presto?
>
>
>
> *From:* Goutham reddy [mailto:goutham.chirutha@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
> <ke...@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.chirutha@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 <ku...@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
> <ke...@yahoo.com.invalid> wrote:
>
> How about using a default value on the column?
>
>
>
> *From:* Kenneth Brotman [mailto:kenbrotman@yahoo.comINVALID
> <ke...@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.chirutha@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
> <ke...@yahoo.com.invalid> wrote:
>
> Sounds like what’s called a “static column”.
>
>
>
> *From:* Goutham reddy [mailto:goutham.chirutha@gmail.com]
>
> *Sent:* Wednesday, February 27, 2019 4:06 PM
> *To:* user@cassandraapache.org <us...@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
RE: Insert constant value for all the rows for a given column
Posted by Kenneth Brotman <ke...@yahoo.com.INVALID>.
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:kenbrotman@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.chirutha@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 <ke...@yahoo.com.invalid> wrote:
Who are Presto?
From: Goutham reddy [mailto:goutham.chirutha@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 <ke...@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.chirutha@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 <ku...@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 <ke...@yahoo.com.invalid> wrote:
How about using a default value on the column?
From: Kenneth Brotman [mailto:kenbrotman@yahoo.comINVALID <ma...@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.chirutha@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 <ke...@yahoo.com.invalid> wrote:
Sounds like what’s called a “static column”.
From: Goutham reddy [mailto:goutham.chirutha@gmail.com]
Sent: Wednesday, February 27, 2019 4:06 PM
To: user@cassandraapache.org <ma...@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
RE: Insert constant value for all the rows for a given column
Posted by Kenneth Brotman <ke...@yahoo.com.INVALID>.
Yup
From: Goutham reddy [mailto:goutham.chirutha@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 <ke...@yahoo.com.invalid> wrote:
Who are Presto?
From: Goutham reddy [mailto:goutham.chirutha@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 <ke...@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.chirutha@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 <ku...@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 <ke...@yahoo.com.invalid> wrote:
How about using a default value on the column?
From: Kenneth Brotman [mailto:kenbrotman@yahoo.comINVALID <ma...@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.chirutha@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 <ke...@yahoo.com.invalid> wrote:
Sounds like what’s called a “static column”.
From: Goutham reddy [mailto:goutham.chirutha@gmail.com]
Sent: Wednesday, February 27, 2019 4:06 PM
To: user@cassandraapache.org <ma...@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
Re: Insert constant value for all the rows for a given column
Posted by Goutham reddy <go...@gmail.com>.
Are you taking about SQL engine Presto ;)
On Wed, Feb 27, 2019 at 4:59 PM Kenneth Brotman
<ke...@yahoo.com.invalid> wrote:
> Who are Presto?
>
>
>
> *From:* Goutham reddy [mailto:goutham.chirutha@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
> <ke...@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.chirutha@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 <ku...@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
> <ke...@yahoo.com.invalid> wrote:
>
> How about using a default value on the column?
>
>
>
> *From:* Kenneth Brotman [mailto:kenbrotman@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.chirutha@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
> <ke...@yahoo.com.invalid> wrote:
>
> Sounds like what’s called a “static column”.
>
>
>
> *From:* Goutham reddy [mailto:goutham.chirutha@gmail.com]
>
> *Sent:* Wednesday, February 27, 2019 4:06 PM
> *To:* user@cassandraapache.org <us...@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
RE: Insert constant value for all the rows for a given column
Posted by Kenneth Brotman <ke...@yahoo.com.INVALID>.
Who are Presto?
From: Goutham reddy [mailto:goutham.chirutha@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 <ke...@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.chirutha@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 <ku...@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 <ke...@yahoo.com.invalid> wrote:
How about using a default value on the column?
From: Kenneth Brotman [mailto:kenbrotman@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.chirutha@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 <ke...@yahoo.com.invalid> wrote:
Sounds like what’s called a “static column”.
From: Goutham reddy [mailto:goutham.chirutha@gmail.com]
Sent: Wednesday, February 27, 2019 4:06 PM
To: user@cassandraapache.org <ma...@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
Re: Insert constant value for all the rows for a given column
Posted by Goutham reddy <go...@gmail.com>.
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
<ke...@yahoo.com.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.chirutha@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 <ku...@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
> <ke...@yahoo.com.invalid> wrote:
>
> How about using a default value on the column?
>
>
>
> *From:* Kenneth Brotman [mailto:kenbrotman@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.chirutha@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
> <ke...@yahoo.com.invalid> wrote:
>
> Sounds like what’s called a “static column”.
>
>
>
> *From:* Goutham reddy [mailto:goutham.chirutha@gmail.com]
>
> *Sent:* Wednesday, February 27, 2019 4:06 PM
> *To:* user@cassandraapache.org <us...@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
RE: Insert constant value for all the rows for a given column
Posted by Kenneth Brotman <ke...@yahoo.com.INVALID>.
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.chirutha@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 <ku...@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 <ke...@yahoo.com.invalid> wrote:
How about using a default value on the column?
From: Kenneth Brotman [mailto:kenbrotman@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.chirutha@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 <ke...@yahoo.com.invalid> wrote:
Sounds like what’s called a “static column”.
From: Goutham reddy [mailto:goutham.chirutha@gmail.com]
Sent: Wednesday, February 27, 2019 4:06 PM
To: user@cassandraapache.org <ma...@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
Re: Insert constant value for all the rows for a given column
Posted by Goutham reddy <go...@gmail.com>.
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 <ku...@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
> <ke...@yahoo.com.invalid> wrote:
>
>> How about using a default value on the column?
>>
>>
>>
>> *From:* Kenneth Brotman [mailto:kenbrotman@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.chirutha@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
>> <ke...@yahoo.com.invalid> wrote:
>>
>> Sounds like what’s called a “static column”.
>>
>>
>>
>> *From:* Goutham reddy [mailto:goutham.chirutha@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 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
>>
>>
Re: Insert constant value for all the rows for a given column
Posted by kumar bharath <ku...@gmail.com>.
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
<ke...@yahoo.com.invalid> wrote:
> How about using a default value on the column?
>
>
>
> *From:* Kenneth Brotman [mailto:kenbrotman@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.chirutha@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
> <ke...@yahoo.com.invalid> wrote:
>
> Sounds like what’s called a “static column”.
>
>
>
> *From:* Goutham reddy [mailto:goutham.chirutha@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 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
>
>
RE: Insert constant value for all the rows for a given column
Posted by Kenneth Brotman <ke...@yahoo.com.INVALID>.
How about using a default value on the column?
From: Kenneth Brotman [mailto:kenbrotman@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.chirutha@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 <ke...@yahoo.com.invalid> wrote:
Sounds like what’s called a “static column”.
From: Goutham reddy [mailto:goutham.chirutha@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 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
RE: Insert constant value for all the rows for a given column
Posted by Kenneth Brotman <ke...@yahoo.com.INVALID>.
Good point.
From: Goutham reddy [mailto:goutham.chirutha@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 <ke...@yahoo.com.invalid> wrote:
Sounds like what’s called a “static column”.
From: Goutham reddy [mailto:goutham.chirutha@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 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
Re: Insert constant value for all the rows for a given column
Posted by Goutham reddy <go...@gmail.com>.
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
<ke...@yahoo.com.invalid> wrote:
> Sounds like what’s called a “static column”.
>
>
>
> *From:* Goutham reddy [mailto:goutham.chirutha@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 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
>
RE: Insert constant value for all the rows for a given column
Posted by Kenneth Brotman <ke...@yahoo.com.INVALID>.
Sounds like what’s called a “static column”.
From: Goutham reddy [mailto:goutham.chirutha@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 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