Re: insert into ... select statement

you can use cassandra trigger xiaobo 于2019年4月23日周二 下午1:23写道： > Hi, > > Can we use the result from a select statement to insert into another table > directlly like other RDBMS in cassandra? > > Thanks. > -- you are the apple of my eye !

insert into ... select statement

Hi, Can we use the result from a select statement to insert into another table directlly like other RDBMS in cassandra? Thanks.

Re: Cassandra upsert ordering issue for list type fields

Hi shaurya, Thanks for the response! I am using cassandra 3.11.4, but I have observed the same nature on Cassandra 3.0.15 as well. I think by cqlsh command you mean the updare statements. I gather the update statements mentioned by me were rather rudimentary (for explanation purposes) but for that

Can we set the precision of decimal column

Hi, We usually use decaimal data type for money, can we set decimal columns with a specific precision? Thanks.

Re: Unpair cassandra datacenters

Hi Kunal, The simple solution for this case would be as follows, 1. Run *Full repair.* 2. Add firewall to block network on port 7000(,7001 if ssl enabled) between two datacenter nodes. 3. Check the status of cassandra cluster from both data centers, each DC must show down node status of another D

Re: Unpair cassandra datacenters

HI Marc, Appreciate your prompt response. Yes we are starting datacenter B from scratch. We tried using cluster name change on side B and it works but our requirement says we can not change cluster name because during our product's major or patch release, the scripts expect cluster name to be the

Re: Unpair cassandra datacenters

Hi Kunal, Did you edit the cassandra.yaml file in each data center to remove the seed nodes? On which ever data center is starting from scratch (I think it's B in your case), you may want to also change the cluster name. Best, *Marc Selwan | *DataStax *| *PM, Server Team *|* *(925) 413-7079* *|*

Unpair cassandra datacenters

Hi Friends, I need small help in unpairing two datacenters. We have 2 datacenters (say A and B ) with 3 nodes in each datacenter. We want to remove one whole data center (B) (3 nodes) from the other one (B). basically, want to unpair both datacenter and want to use them both individually. We are t

Re: Cassandra upsert ordering issue for list type fields

Which version of Cassandra are you using? https://docs.datastax.com/en/cql/3.3/cql/cql_using/useInsertList.html and many other relevant pages do not mention any thing of the CQLSH command mentioned by you above. -- Shaurya On Mon, Apr 22, 2019 at 6:51 PM Naman Gupta wrote: > I am facing issue w

Cassandra upsert ordering issue for list type fields

I am facing issue with cassandra ordering in the tables for column types of list. Suppose I have a table as follows... FirstName: of string LastName: of string now if were to Issue update (FirstName,LastName) add values ("Leonardo","DiCaprio") update (FirstName,LastName) add values ("Brad","