Re: Can't connect to Cassandra server

2015-07-27 Thread Chamila Wijayarathna
server What is the output you are getting if you are issuing nodetool status command ... On 23 July 2015 at 11:30, Chamila Wijayarathna cdwijayarat...@gmail.com wrote: Hi Peer, I changed cassandra-env.sh and following are the parameters I used,' MAX_HEAP_SIZE=8G HEAP_NEWSIZE=1600M

Re: Can't connect to Cassandra server

2015-07-23 Thread Chamila Wijayarathna
You should uncomment the HEAP_NEWSIZE setting as well. I would leave it with the default setting 800M until you are certain it needs to be changed. *From:* Chamila Wijayarathna [mailto:cdwijayarat...@gmail.com] *Sent:* Tuesday, July 21, 2015 9:21 PM *To:* Erick Ramirez *Cc:* user

Re: Can't connect to Cassandra server

2015-07-21 Thread Chamila Wijayarathna
Hi Erick, In cassandra-env.sh, system_memory_in_mb was set to 2GB, I changed it into 16GB, but I still get the same issue. Following are my complete system.log after changing cassandra-env.sh, and new cassandra-env.sh.

Can't connect to Cassandra server

2015-07-19 Thread Chamila Wijayarathna
Hello all, After starting cassandra, I tried to connect to cassandra from cqlsh and java, but it fails to do so. Following is the error I get while trying to connect to cqlsh. cqlsh -u sinmin -p xx Connection error: ('Unable to connect to any servers', {'127.0.0.1': error(111, Tried

Re: Can't connect to Cassandra server

2015-07-19 Thread Chamila Wijayarathna
/cqlsh.html On Sun, Jul 19, 2015 at 2:00 PM, Chamila Wijayarathna cdwijayarat...@gmail.com wrote: Hello all, After starting cassandra, I tried to connect to cassandra from cqlsh and java, but it fails to do so. Following is the error I get while trying to connect to cqlsh. cqlsh -u sinmin

Re: Can't connect to Cassandra server

2015-07-19 Thread Chamila Wijayarathna
, Umang Shah On Sun, Jul 19, 2015 at 1:52 AM, Chamila Wijayarathna cdwijayarat...@gmail.com wrote: Hi Ajay, I tried that also, but still getting the same result. On Sun, Jul 19, 2015 at 2:08 PM, Ajay ajay.ga...@gmail.com wrote: Try with the correct IP address as below: cqlsh

Re: Can't connect to Cassandra server

2015-07-19 Thread Chamila Wijayarathna
, 2015 at 4:52 PM, Peer, Oded oded.p...@rsa.com wrote: Are you sure your node is up? Do you get a result when running “nodetool –h 192.248.15.219 status”? *From:* Chamila Wijayarathna [mailto:cdwijayarat...@gmail.com] *Sent:* Sunday, July 19, 2015 1:53 PM *To:* user@cassandra.apache.org

Re: Can't connect to Cassandra server

2015-07-19 Thread Chamila Wijayarathna
(/var/log/cassandra/system.log) for errors that prevent your node from starting. *From:* Chamila Wijayarathna [mailto:cdwijayarat...@gmail.com] *Sent:* Sunday, July 19, 2015 2:29 PM *To:* user@cassandra.apache.org *Subject:* Re: Can't connect to Cassandra server Hi, I'm getting

Re: Accesing Cassandra Database which uses 'PasswordAuthenticator' in Java

2015-02-10 Thread Chamila Wijayarathna
http://www.datastax.com/drivers/java/2.0/index.html Cluster.builder has a withCredentials method regards deepak On Tue, Feb 10, 2015 at 12:24 PM, Chamila Wijayarathna cdwijayarat...@gmail.com wrote: Hello all, I changed the authenticator value of my Cassandra database

Can't connect to cassandra node from different host

2015-01-03 Thread Chamila Wijayarathna
Hello all, I have a cassandra node at a machine. When I access cqlsh from the same machne it works properly. But when I tried to connect to it's cqlsh using 192.x.x.x from another machine, I'm getting an error saying Connection error: ('Unable to connect to any servers', {'192.x.x.x':

Re: Can't connect to cassandra node from different host

2015-01-03 Thread Chamila Wijayarathna
. On Sat Jan 03 2015 at 10:03:57 AM Chamila Wijayarathna cdwijayarat...@gmail.com wrote: Hello all, I have a cassandra node at a machine. When I access cqlsh from the same machne it works properly. But when I tried to connect to it's cqlsh using 192.x.x.x from another machine, I'm getting

Understanding what is key and partition key

2014-12-16 Thread Chamila Wijayarathna
Hello all, I have read a lot about Cassandra and I read about key-value pairs, partition keys, clustering keys, etc.. Is key mentioned in key-value pair and partition key refers to same or are they different? CREATE TABLE corpus.bigram_time_category_ordered_frequency ( id bigint, word1

Re: Understanding what is key and partition key

2014-12-16 Thread Chamila Wijayarathna
columns. “The key” should just be a synonym for “primary key”, although sometimes people are loosely speaking about “the partition” (which should be “the partition key”) rather than the CQL “row”. -- Jack Krupansky *From:* Chamila Wijayarathna cdwijayarat...@gmail.com *Sent:* Tuesday

Re: Understanding what is key and partition key

2014-12-16 Thread Chamila Wijayarathna
Web: www.tink.se Facebook Linkedin Twitter On Tue, Dec 16, 2014 at 2:25 PM, Chamila Wijayarathna cdwijayarat...@gmail.com wrote: Hi Jack, So what will be the keys and values of the following CF instance? year | category | frequency | word1| word2 | id

Defining DataSet.json for cassandra-unit testing

2014-12-16 Thread Chamila Wijayarathna
Hello all, I am trying to test my application using cassandra-unit with following schema and data given below. CREATE TABLE corpus.bigram_time_category_ordered_frequency ( id bigint, word1 varchar, word2 varchar, year int, category varchar, frequency int, PRIMARY

Need Help with Cassandra Tombstone

2014-12-15 Thread Chamila Wijayarathna
Hello all, I have a column family where I have to update a field frequency, but it is a clustering key. So I am deleting the existing row and adding a new row again with updated frequency. I want to free the space used for deleted rows as soon as possible, so I decided to change gc_grace_seconds

Cassandra Database using too much space

2014-12-14 Thread Chamila Wijayarathna
Hello all, We are trying to develop a language corpus by using Cassandra as its storage medium. https://gist.github.com/cdwijayarathna/7550176443ad2229fae0 shows the types of information we need to extract from corpus interface. So we designed schema at

Re: Cassandra Database using too much space

2014-12-14 Thread Chamila Wijayarathna
databases in the past I've had to use a similar strategy to speed up lookups (less different query parameters in that case and more queries that would normally require lots of joins). Hope this helps explain tradeoffs and costs. On Sun, Dec 14, 2014 at 6:01 AM, Chamila Wijayarathna

Re: Cassandra Database using too much space

2014-12-14 Thread Chamila Wijayarathna
for the full corpus and for the subset containing your 1.5 million words? -- Jack Krupansky *From:* Chamila Wijayarathna cdwijayarat...@gmail.com *Sent:* Sunday, December 14, 2014 7:01 AM *To:* user@cassandra.apache.org *Subject:* Cassandra Database using too much space Hello all, We

java.lang.AssertionError in cqlsh

2014-12-11 Thread Chamila Wijayarathna
Hello all, I have a column family with following schema. CREATE TABLE corpus.trigram_category_ordered_frequency ( id bigint, word1 varchar, word2 varchar, word3 varchar, category varchar, frequency int, PRIMARY KEY(category,frequency,word1,word2,word3) ); When I run

Re: java.lang.AssertionError in cqlsh

2014-12-11 Thread Chamila Wijayarathna
, Dec 11, 2014 at 7:37 AM, Chamila Wijayarathna cdwijayarat...@gmail.com wrote: Hello all, I have a column family with following schema. CREATE TABLE corpus.trigram_category_ordered_frequency ( id bigint, word1 varchar, word2 varchar, word3 varchar, category varchar

Re: java.lang.AssertionError in cqlsh

2014-12-11 Thread Chamila Wijayarathna
philip.thomp...@datastax.com wrote: The full error should be in that node's system.log file. What version are you running? On Thu, Dec 11, 2014 at 9:42 AM, Chamila Wijayarathna cdwijayarat...@gmail.com wrote: Hi Philip, I ran my queries on cqlsh terminal and it only shows this. Thank

Re: java.lang.AssertionError in cqlsh

2014-12-11 Thread Chamila Wijayarathna
://issues.apache.org/jira/issues/?jql=project+%3D+CASSANDRA On Thu, Dec 11, 2014 at 10:15 AM, Chamila Wijayarathna cdwijayarat...@gmail.com wrote: Hi Philip, I'm using version 2.1.2. Following is the error log at system.log. ( https://gist.github.com/cdwijayarathna/2749f52c52f5c7fd807d

Get column family size

2014-12-11 Thread Chamila Wijayarathna
Hello all, I am trying to get the number of key value pairs. I used following query for this. select count(*) from corpus.word_usage ; This returns number of key value pairs when CF is relatively small. But when I insert more key-velue pairs, I am getting error saying, errors={},

Re: Get column family size

2014-12-11 Thread Chamila Wijayarathna
in 2.1.2, but I believe the error message will be more helpful as of 2.1.3. On Thu, Dec 11, 2014 at 1:52 PM, Chamila Wijayarathna cdwijayarat...@gmail.com wrote: Hello all, I am trying to get the number of key value pairs. I used following query for this. select count(*) from

Re: Get column family size

2014-12-11 Thread Chamila Wijayarathna
in Cassandra for non-trivial datasets. You will need a better way to get the number of partition keys of a CF, which hopefully someone else in the user list can provide, as I have never needed to do that. On Thu, Dec 11, 2014 at 1:59 PM, Chamila Wijayarathna cdwijayarat...@gmail.com wrote: Hi Philip

Re: Cassandra sort using updatable query

2014-11-13 Thread Chamila Wijayarathna
to for me), this may be better suited to something like solr, elastic search, or DSE (cassandra + solr). Does that help? Jon On Wed Nov 12 2014 at 9:01:44 AM Chamila Wijayarathna cdwijayarat...@gmail.com wrote: Hello all, I have a data set with attributes content and year. I want

Cassandra sort using updatable query

2014-11-12 Thread Chamila Wijayarathna
Hello all, I have a data set with attributes content and year. I want to put them in to CF 'words' with attributes ('content','year','frequency'). The CF should support following operations. - Frequency attribute of a column can be updated (i.e. - : can run query like UPDATE words SET

use select with different attributes present in where clause Cassandra

2014-11-05 Thread Chamila Wijayarathna
Hello all, I need to create a Cassandra column family with following attributes. id bigint, content varchar, year int, frequency int, I want to get the content with highest frequency in a given year using this column family. Also when inserting data to table, for given content and year, I need

./cqlsh not working

2014-01-22 Thread Chamila Wijayarathna
Hi all, I downloaded 1.2.13 version and ran ./cqlsh inside bin folder, but it says that bash: ./cqlsh: Permission denied, when I ran it with sudo it says Command not found. When I ran chmod u+x cqlsh and then tried ./cqlsh, now it says that Can't locate transport factory function