Re: Can't connect to Cassandra server

2015-07-27 Thread Chamila Wijayarathna
ache.org > *Cc:* Erick Ramirez > > *Subject:* Re: Can't connect to Cassandra server > > > > What is the output you are getting if you are issuing nodetool status > command ... > > > > On 23 July 2015 at 11:30, Chamila Wijayarathna > wrote: > > Hi Peer, >

Re: Can't connect to Cassandra server

2015-07-23 Thread Chamila Wijayarathna
IZE="4G" > > And set > > MAX_HEAP_SIZE="16G" > > > > 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 Wijayar

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. https://gist.githubusercontent.com/cdwijayarathna/5e7e69c62ac09b45490b/raw/f7

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 Ca

Re: Can't connect to Cassandra server

2015-07-19 Thread Chamila Wijayarathna
ul 19, 2015 at 4:52 PM, Peer, Oded 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@ca

Re: Can't connect to Cassandra server

2015-07-19 Thread Chamila Wijayarathna
anks, > 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 wrote: >> &g

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

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 connect

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

2015-02-10 Thread Chamila Wijayarathna
see the API docs > 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, >&

Accesing Cassandra Database which uses 'PasswordAuthenticator' in Java

2015-02-10 Thread Chamila Wijayarathna
Hello all, I changed the authenticator value of my Cassandra database to 'PasswordAuthenticator' in cassandra.yaml file. Previously I used following code to connect to the database using java. public void connect(String node) { cluster = Cluster.builder() .addContactPoint(nod

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

2015-01-03 Thread Chamila Wijayarathna
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

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': error(11

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

Re: Understanding what is key and partition key

2014-12-16 Thread Chamila Wijayarathna
Phone: +46 708 84 18 32 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? >&g

Re: Understanding what is key and partition key

2014-12-16 Thread Chamila Wijayarathna
y > have clustering 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 Wijayarath

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 va

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

Re: Cassandra Database using too much space

2014-12-14 Thread Chamila Wijayarathna
ach row once after the full corpus has > been read? > > Also, what is the corpus size – total word instances, both for the full > corpus and for the subset containing your 1.5 million words? > > -- Jack Krupansky > > *From:* Chamila Wijayarathna > *Sent:* Sunday, Dece

Re: Cassandra Database using too much space

2014-12-14 Thread Chamila Wijayarathna
is the cost of scale. >With even relational 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 t

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 https://gist.github.com/cdwijayarathna/6491

Re: Get column family size

2014-12-11 Thread Chamila Wijayarathna
why, but a "Select count(*) from table;" query is inefficient 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 th

Re: Get column family size

2014-12-11 Thread Chamila Wijayarathna
t error, which is unclear 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 pa

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={}, last_host=127

Re: java.lang.AssertionError in cqlsh

2014-12-11 Thread Chamila Wijayarathna
a - ASF JIRA > <https://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. >>

Re: java.lang.AssertionError in cqlsh

2014-12-11 Thread Chamila Wijayarathna
Thompson < 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, >

Re: java.lang.AssertionError in cqlsh

2014-12-11 Thread Chamila Wijayarathna
rong. > > On Thu, 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 ( >> i

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: Cassandra sort using updatable query

2014-11-13 Thread Chamila Wijayarathna
as the cluster increases in size. Ideally you could > bucket frequencies. If that feels like too much work (it's starting to for > me), this may be better suited to something like solr, elastic search, or > DSE (cassandra + solr). > > Does that help? > > Jon > >

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 freq

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 t

./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 cqlshlib.tfa