Re: cqlsh -e output - How to change the default delimiter '|' in the output

2017-08-15 Thread Harikrishnan A
Thank you all Regards,Hari On Tuesday, August 15, 2017 12:55 AM, Erick Ramirez wrote: +1 to Jim and Tobin. cqlsh wasn't designed for what you're trying to achieve. Cheers! On Tue, Aug 15, 2017 at 1:34 AM, Tobin Landricombe wrote: Can't change the delimiter (I'm on cqlsh 5.0.1). Best

Re: cqlsh -e output - How to change the default delimiter '|' in the output

2017-08-14 Thread Harikrishnan A
I have column values with Pipe separator, hence unable to replace this default delimiter from the output. Thanks Hari On Monday, August 14, 2017 12:12 AM, algermissen1971 wrote: On 14.08.2017, at 07:49, Harikrishnan A wrote: Hello, When I execute cqlsh -e "SELECT stat

cqlsh -e output - How to change the default delimiter '|' in the output

2017-08-13 Thread Harikrishnan A
Hello, When I execute cqlsh -e "SELECT statement .."  , it gives the output with a pipe ('|') separator. Is there anyway I can change this default delimiter in the output of cqlsh -e " SELECT statement ..".  Thanks & Regards,Hari

DSE Solr create_core - core not getting created on all sole enabled nodes

2016-11-02 Thread Harikrishnan A
Hello I am getting the below error while trying to create solr core from one of the node. dsetool create_core . generateResources=true; org.apache.solr.client.solrj.impl.HttpSolrServer$RemoteSolrException: Create for core . failed on the following servers [.., ..] Out of the 12 nodes in this solr

Hotspots / Load on Cassandra node

2016-10-25 Thread Harikrishnan A
Hello, When I am issuing nodetool status, I see the load ( in GB) on one of the node is high compare to the other nodes in my ring. I do not see any issues with the Data Modeling, and it looks like the Partition sizes are almost evenly sized and distributed across the nodes.  Repairs are running

Consistency Level (QUORUM vs LOCAL_QUORUM)

2016-03-27 Thread Harikrishnan A
Hello, I have a question regarding consistency Level settings in a multi Data Center Environment.  What is the preferred CL settings in this scenario for an immediate consistency , QUORUM or LOCAL_QUORUM ? If the replication Factor is set to 3  each ( 2 Data Centers) , the QUORUM ( writes/read)

Re: Modeling Master Tables in Cassandra

2016-02-12 Thread Harikrishnan A
VARCHAR STATIC,  phonenr VARCHAR STATIC,  action VARCHAR,  time TIMESTAMP,  PRIMARY KEY(customerid, action, time)). This way, you avoid client side joins. Hope this helps! Carlos Alonso | Software Engineer | @calonso On 12 February 2016 at 09:25, Harikrishnan A wrote: Hello,I have a scenario where I n

Modeling Master Tables in Cassandra

2016-02-12 Thread Harikrishnan A
Hello,I have a scenario where I need to create a customer master table in cassandra which has attributes like customerid, name, email, phonenr .etc ..What is the best way to model such table in cassandra keeping in mind that I will be using customer id to populate customer information from other

Re: Unable to locate Solr Configuration file ( Generated using dsetool )

2016-01-19 Thread Harikrishnan A
size. With more than 500 customers in 45 countries, DataStax is the database technology and transactional backbone of choice for the worlds most innovative companies such as Netflix, Adobe, Intuit, and eBay. On Mon, Jan 18, 2016 at 12:29 PM, Harikrishnan A wrote: Thanks Jack ..So how do I

Re: Unable to locate Solr Configuration file ( Generated using dsetool )

2016-01-18 Thread Harikrishnan A
tax.com/en/datastax_enterprise/4.8/datastax_enterprise/tools/toolsDsetool.html You can also use the dsetool read_resource command to read any of the Solr resource "files". -- Jack Krupansky On Mon, Jan 18, 2016 at 12:47 AM, Harikrishnan A wrote: Hello, I have created a solr core wit

Unable to locate Solr Configuration file ( Generated using dsetool )

2016-01-17 Thread Harikrishnan A
Hello, I have created a solr core with automatic resource generation using the below command> dsetool create_core . generateResources=true reindex=trueHowever I am unable to locate the schema.xml and the solrconfig.xml which got created for this core.What is the default location of these config

Timestamp Query

2015-12-20 Thread Harikrishnan A
Hello, How do I set a timestamp value with specific timezone in cassandra. I understand that it captures the timezone of the co ordinator node while inserting. What about if I want to insert and display the timezone that I preferred nstead of the default co ordinator timezone.  Thanks & Regards,

Re: Triggering Deletion/Updation

2015-11-23 Thread Harikrishnan A
Thanks Jon , Prem .. Regards,Hari From: Jon Haddad To: user@cassandra.apache.org Cc: Harikrishnan A Sent: Sunday, November 22, 2015 10:57 AM Subject: Re: Triggering Deletion/Updation There's no built in way of doing cascading deletes in Cassandra, I really wouldn't recom

Re: Triggering Deletion/Updation

2015-11-22 Thread Harikrishnan A
Trying for second time to get some insights to my below query ...ThanksHari From: Harikrishnan A To: "user@cassandra.apache.org" Sent: Friday, November 20, 2015 2:27 PM Subject: Triggering Deletion/Updation Hello, I have a generic question.  How can I initiate a triggerin

Triggering Deletion/Updation

2015-11-20 Thread Harikrishnan A
Hello, I have a generic question.  How can I initiate a triggering deletion in cassandra? I mean I need to delete few rows/Partition itself from other tables based on a status change in another table.   Thanks & Regards,Hari