SOLR Config on Dev Center

[kumar bharath]

Hi All,

We are having a 6 node cluster with two data centers(DSE 5.1 Cassandra).One
of the data centers is SOLR enabled.
Do I need to explicitly add the SOLR Search node in  Dev-Center to perform
SOLR Queries.?

Thanks for you response in advance.

Regards,
Bharath Kumar B

Data Inconsistencies - Tables Vs Materialized Views.

[kumar bharath]

Hi All,

I have an use case wherein we created two materialized views on top a
column family in Cassandra. We are facing data  inconsistencies  between
base table and materialized views created on top of it.

Example: Deleted a record in base table about a month ago., Materialized
view are still showing that record.


Thanks,
Bharath Kumar B

Adding New Column with Default Value

[kumar bharath]

Hi ,

Can anyone suggest  a best possible way, how we can add a new column to the
existing table with default value ?

*Column family Size :*  60 Million single partition records.

Thanks,
Bharath Kumar B

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

Fwd: Removing Extra Spaces and Row counts while using Capture Command

[kumar bharath]

Hi All,

I am using Cassandra Capture Command to perform a select query operation to
write data from a column family into JSON format file for further
processing. I am able to do that successfully, but  I am seeing extra
spaces and row count values after every few records.

please suggest a to get rid of these unusual extra spaces and row count
values.

Regards,
Bharath Kumar B

Removing Extra Spaces and Row counts while using Capture Command

[kumar bharath]

Hi All,

I am using Cassandra Capture Command to perform a select query operation to
write data from a column family into JSON format file for further
processing. I am able to do that successfully, but  I am seeing extra
spaces and row count values after every few records. please suggest a to
get rid of these unusual extra spaces and row count values.

Regards,
Bharath Kumar B