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

[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 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  
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  
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  
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  
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  
wrote:

How about using a default value on the column?

 

From: Kenneth Brotman [mailto:kenbrotman@yahoo.comINVALID 
 ] 
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  
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  
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

[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 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
>  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
>  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 
> 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
>  wrote:
>
> How about using a default value on the column?
>
>
>
> *From:* Kenneth Brotman [mailto:kenbrotman@yahoo.comINVALID
> ]
> *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
>  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 
> *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

[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: '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  
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  
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  
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  
wrote:

How about using a default value on the column?

 

From: Kenneth Brotman [mailto:kenbrotman@yahoo.comINVALID 
 ] 
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  
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  
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

[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 [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  
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  
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  
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: 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  
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  
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

[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 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 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  
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  
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  
wrote:

How about using a default value on the column?

 

From: Kenneth Brotman [mailto:kenbrotman@yahoo.comINVALID 
 ] 
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  
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  
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

[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 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
>  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 
> 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
>  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:* 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
>  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 
> *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

[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 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 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  
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  
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: 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  
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  
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

[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 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 
> 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
>  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:* 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
>  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 
> *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

[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

 

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  
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  
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: 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  
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  
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

[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, 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:* 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
>>  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:* 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

[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:* 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
>  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:* 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

[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: 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  
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: 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

[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 [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  
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: 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

[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 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 [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 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

[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 [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 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

[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 for all the rows for a given column

 

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 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

[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 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