date:20140728

Re: Cassandra trigger following the CQL for Cassandra 2.0 tutorial does not work

2014-07-28 Thread Martin Marinov


Anybody got an idea on this matter ?

On 07/24/2014 06:34 PM, Martin Marinov wrote:

Hi,

I posted the question on stackoverflow:
http://stackoverflow.com/questions/24937425/cassandra-trigger-following-the-cql-for-cassandra-2-0-tutorial-does-not-work

On 07/24/2014 06:25 PM, Martin Marinov wrote:


Hi,

I'm following the tutorial at: 
http://www.datastax.com/documentation/cql/3.1/cql/cql_reference/trigger_r.html


I'm using Cassandra 2.0.9 with Oracle Java (java version "1.7.0_60").

I have downloaded the example Java Class from 
https://git-wip-us.apache.org/repos/asf?p=cassandra.git;a=blob_plain;f=examples/triggers/src/org/apache/cassandra/triggers/InvertedIndex.java;hb=HEAD 
into a file named *org.apache.cassandra.triggers.InvertedIndex.jar* .


I then created a jar using:

|jar cvf 
/etc/cassandra/triggers/org.apache.cassandra.triggers.InvertedIndex.jar 
org.apache.cassandra.triggers.InvertedIndex.class
|

I restarted the cassandra service.

The trigger does not exist:

|cqlsh:mykeyspace> CREATE TRIGGER myTrigger ON myTable USING 
'org.apache.cassandra.triggers.InvertedIndex';
Bad Request: Trigger class 'org.apache.cassandra.triggers.InvertedIndex' 
doesn't exist
|

What am I doing wrong ?


--
Best Regards,

Martin Marinov
Securax LTD

NOTICE:  This email and any file transmitted are confidential and/or
legally privileged and intended only for the person(s) directly
addressed.  If you are not the intended recipient, any use, copying,
transmission, distribution, or other forms of dissemination is strictly
prohibited.  If you have received this email in error, please notify the
sender immediately and permanently delete the email and files, if any.



--
Best Regards,

Martin Marinov
Securax LTD

NOTICE:  This email and any file transmitted are confidential and/or
legally privileged and intended only for the person(s) directly
addressed.  If you are not the intended recipient, any use, copying,
transmission, distribution, or other forms of dissemination is strictly
prohibited.  If you have received this email in error, please notify the
sender immediately and permanently delete the email and files, if any.



--
Best Regards,

Martin Marinov
Securax LTD

NOTICE:  This email and any file transmitted are confidential and/or
legally privileged and intended only for the person(s) directly
addressed.  If you are not the intended recipient, any use, copying,
transmission, distribution, or other forms of dissemination is strictly
prohibited.  If you have received this email in error, please notify the
sender immediately and permanently delete the email and files, if any.

Re: Cassandra trigger following the CQL for Cassandra 2.0 tutorial does not work

2014-07-28 Thread DuyHai Doan

Did you put the jar into the /lib folder on the server ? I know it's a
basic question but it's the first idea to come in mind


On Mon, Jul 28, 2014 at 9:36 AM, Martin Marinov 
wrote:

>  Anybody got an idea on this matter ?
>
>
> On 07/24/2014 06:34 PM, Martin Marinov wrote:
>
> Hi,
>
> I posted the question on stackoverflow:
>
> http://stackoverflow.com/questions/24937425/cassandra-trigger-following-the-cql-for-cassandra-2-0-tutorial-does-not-work
>
> On 07/24/2014 06:25 PM, Martin Marinov wrote:
>
>  Hi,
>
> I'm following the tutorial at:
> http://www.datastax.com/documentation/cql/3.1/cql/cql_reference/trigger_r.html
>
> I'm using Cassandra 2.0.9 with Oracle Java (java version "1.7.0_60").
>
> I have downloaded the example Java Class from
> https://git-wip-us.apache.org/repos/asf?p=cassandra.git;a=blob_plain;f=examples/triggers/src/org/apache/cassandra/triggers/InvertedIndex.java;hb=HEAD
> into a file named *org.apache.cassandra.triggers.InvertedIndex.jar* .
>
> I then created a jar using:
>
> jar cvf 
> /etc/cassandra/triggers/org.apache.cassandra.triggers.InvertedIndex.jar 
> org.apache.cassandra.triggers.InvertedIndex.class
>
> I restarted the cassandra service.
>
> The trigger does not exist:
>
> cqlsh:mykeyspace> CREATE TRIGGER myTrigger ON myTable USING 
> 'org.apache.cassandra.triggers.InvertedIndex';
> Bad Request: Trigger class 'org.apache.cassandra.triggers.InvertedIndex' 
> doesn't exist
>
> What am I doing wrong ?
>
>  --
> Best Regards,
>
> Martin Marinov
> Securax LTD
>
> NOTICE:  This email and any file transmitted are confidential and/or
> legally privileged and intended only for the person(s) directly
> addressed.  If you are not the intended recipient, any use, copying,
> transmission, distribution, or other forms of dissemination is strictly
> prohibited.  If you have received this email in error, please notify the
> sender immediately and permanently delete the email and files, if any.
>
>
>
> --
> Best Regards,
>
> Martin Marinov
> Securax LTD
>
> NOTICE:  This email and any file transmitted are confidential and/or
> legally privileged and intended only for the person(s) directly
> addressed.  If you are not the intended recipient, any use, copying,
> transmission, distribution, or other forms of dissemination is strictly
> prohibited.  If you have received this email in error, please notify the
> sender immediately and permanently delete the email and files, if any.
>
>
>
> --
> Best Regards,
>
> Martin Marinov
> Securax LTD
>
> NOTICE:  This email and any file transmitted are confidential and/or
> legally privileged and intended only for the person(s) directly
> addressed.  If you are not the intended recipient, any use, copying,
> transmission, distribution, or other forms of dissemination is strictly
> prohibited.  If you have received this email in error, please notify the
> sender immediately and permanently delete the email and files, if any.
>
>

Re: Cassandra trigger following the CQL for Cassandra 2.0 tutorial does not work

2014-07-28 Thread Martin Marinov


I did:
ls /etc/cassandra/triggers/
InvertedIndex.jar  README.txt


But I'm not sure I'm creating the jar correctly.

I'm running:
jar cvf 
/etc/cassandra/triggers/org.apache.cassandra.triggers.InvertedIndex.jar 
org.apache.cassandra.triggers.InvertedIndex.class


where org.apache.cassandra.triggers.InvertedIndex.class contains the 
java code on this url:

https://git-wip-us.apache.org/repos/asf?p=cassandra.git;a=blob_plain;f=examples/triggers/src/org/apache/cassandra/triggers/InvertedIndex.java;hb=HEAD

Also I tried with the name of the .class file and the .jar file as:
InvertedIndex.jar, InvertedIndex.class
and as
org.apache.cassandra.triggers.InvertedIndex.jar, 
org.apache.cassandra.triggers.InvertedIndex.class



On 07/28/2014 10:43 AM, DuyHai Doan wrote:
Did you put the jar into the /lib folder on the server ? I know it's a 
basic question but it's the first idea to come in mind



On Mon, Jul 28, 2014 at 9:36 AM, Martin Marinov 
mailto:martin.mari...@securax.org>> wrote:


Anybody got an idea on this matter ?


On 07/24/2014 06:34 PM, Martin Marinov wrote:

Hi,

I posted the question on stackoverflow:

http://stackoverflow.com/questions/24937425/cassandra-trigger-following-the-cql-for-cassandra-2-0-tutorial-does-not-work

On 07/24/2014 06:25 PM, Martin Marinov wrote:


Hi,

I'm following the tutorial at:

http://www.datastax.com/documentation/cql/3.1/cql/cql_reference/trigger_r.html

I'm using Cassandra 2.0.9 with Oracle Java (java version
"1.7.0_60").

I have downloaded the example Java Class from

https://git-wip-us.apache.org/repos/asf?p=cassandra.git;a=blob_plain;f=examples/triggers/src/org/apache/cassandra/triggers/InvertedIndex.java;hb=HEAD
into a file named
*org.apache.cassandra.triggers.InvertedIndex.jar* .

I then created a jar using:

|jar cvf 
/etc/cassandra/triggers/org.apache.cassandra.triggers.InvertedIndex.jar 
org.apache.cassandra.triggers.InvertedIndex.class
|

I restarted the cassandra service.

The trigger does not exist:

|cqlsh:mykeyspace> CREATE TRIGGER myTrigger ON myTable USING 
'org.apache.cassandra.triggers.InvertedIndex';
Bad Request: Trigger class 'org.apache.cassandra.triggers.InvertedIndex' 
doesn't exist
|

What am I doing wrong ?


-- 
Best Regards,


Martin Marinov
Securax LTD

NOTICE:  This email and any file transmitted are confidential and/or
legally privileged and intended only for the person(s) directly
addressed.  If you are not the intended recipient, any use, copying,
transmission, distribution, or other forms of dissemination is strictly
prohibited.  If you have received this email in error, please notify the
sender immediately and permanently delete the email and files, if any.



-- 
Best Regards,


Martin Marinov
Securax LTD

NOTICE:  This email and any file transmitted are confidential and/or
legally privileged and intended only for the person(s) directly
addressed.  If you are not the intended recipient, any use, copying,
transmission, distribution, or other forms of dissemination is strictly
prohibited.  If you have received this email in error, please notify the
sender immediately and permanently delete the email and files, if any.



-- 
Best Regards,


Martin Marinov
Securax LTD

NOTICE:  This email and any file transmitted are confidential and/or
legally privileged and intended only for the person(s) directly
addressed.  If you are not the intended recipient, any use, copying,
transmission, distribution, or other forms of dissemination is strictly
prohibited.  If you have received this email in error, please notify the
sender immediately and permanently delete the email and files, if any.





--
Best Regards,

Martin Marinov
Securax LTD

NOTICE:  This email and any file transmitted are confidential and/or
legally privileged and intended only for the person(s) directly
addressed.  If you are not the intended recipient, any use, copying,
transmission, distribution, or other forms of dissemination is strictly
prohibited.  If you have received this email in error, please notify the
sender immediately and permanently delete the email and files, if any.

unable to load data using sstableloader

2014-07-28 Thread Akshay Ballarpure

Hello,
I am unable to load sstable into cassandra using sstable loader, please 
suggest. Thanks.

[root@CSL-simulation conf]# pwd
/root/Akshay/Cassandra/apache-cassandra-2.0.8/conf
[root@CSL-simulation conf]# ls -ltr keyspace/col/
total 32
-rw-r--r-- 1 root root   16 Jul 28 16:55 Test-Data-jb-1-Filter.db
-rw-r--r-- 1 root root  300 Jul 28 16:55 Test-Data-jb-1-Index.db
-rw-r--r-- 1 root root 3470 Jul 28 16:55 Test-Data-jb-1-Data.db
-rw-r--r-- 1 root root8 Jul 28 16:55 Test-Data-jb-1-CRC.db
-rw-r--r-- 1 root root   64 Jul 28 16:55 Test-Data-jb-1-Digest.sha1
-rw-r--r-- 1 root root 4392 Jul 28 16:55 Test-Data-jb-1-Statistics.db
-rw-r--r-- 1 root root   79 Jul 28 16:55 Test-Data-jb-1-TOC.txt


[root@CSL-simulation conf]# ../bin/sstableloader -d localhost 
/root/Akshay/Cassandra/apache-cassandra-2.0.8/conf/keyspace/col/ --debug
Could not retrieve endpoint ranges:
InvalidRequestException(why:No such keyspace: keyspace)
java.lang.RuntimeException: Could not retrieve endpoint ranges:
at 
org.apache.cassandra.tools.BulkLoader$ExternalClient.init(BulkLoader.java:259)
at 
org.apache.cassandra.io.sstable.SSTableLoader.stream(SSTableLoader.java:149)
at org.apache.cassandra.tools.BulkLoader.main(BulkLoader.java:85)
Caused by: InvalidRequestException(why:No such keyspace: keyspace)
at 
org.apache.cassandra.thrift.Cassandra$describe_ring_result$describe_ring_resultStandardScheme.read(Cassandra.java:34055)
at 
org.apache.cassandra.thrift.Cassandra$describe_ring_result$describe_ring_resultStandardScheme.read(Cassandra.java:34022)
at 
org.apache.cassandra.thrift.Cassandra$describe_ring_result.read(Cassandra.java:33964)
at 
org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:78)
at 
org.apache.cassandra.thrift.Cassandra$Client.recv_describe_ring(Cassandra.java:1251)
at 
org.apache.cassandra.thrift.Cassandra$Client.describe_ring(Cassandra.java:1238)
at 
org.apache.cassandra.tools.BulkLoader$ExternalClient.init(BulkLoader.java:235)
... 2 more


Thanks & Regards
Akshay Ghanshyam Ballarpure
Tata Consultancy Services
Cell:- 9985084075
Mailto: akshay.ballarp...@tcs.com
Website: http://www.tcs.com

Experience certainty.   IT Services
Business Solutions
Consulting

=-=-=
Notice: The information contained in this e-mail
message and/or attachments to it may contain 
confidential or privileged information. If you are 
not the intended recipient, any dissemination, use, 
review, distribution, printing or copying of the 
information contained in this e-mail message 
and/or attachments to it are strictly prohibited. If 
you have received this communication in error, 
please notify us by reply e-mail or telephone and 
immediately and permanently delete the message 
and any attachments. Thank you

Re: Cassandra trigger following the CQL for Cassandra 2.0 tutorial does not work

2014-07-28 Thread Michael Dykman

I wonder; your jar creation looks a little off and I suspect your problem
might be the jar format which would lead to the failure to load.  Could you
list the output of
$ unzip -l my.jar?
On Jul 28, 2014 3:49 AM, "Martin Marinov" 
wrote:

>  I did:
> ls /etc/cassandra/triggers/
> InvertedIndex.jar  README.txt
>
>
> But I'm not sure I'm creating the jar correctly.
>
> I'm running:
> jar cvf
> /etc/cassandra/triggers/org.apache.cassandra.triggers.InvertedIndex.jar
> org.apache.cassandra.triggers.InvertedIndex.class
>
> where org.apache.cassandra.triggers.InvertedIndex.class contains the java
> code on this url:
>
> https://git-wip-us.apache.org/repos/asf?p=cassandra.git;a=blob_plain;f=examples/triggers/src/org/apache/cassandra/triggers/InvertedIndex.java;hb=HEAD
>
> Also I tried with the name of the .class file and the .jar file as:
> InvertedIndex.jar, InvertedIndex.class
> and as
> org.apache.cassandra.triggers.InvertedIndex.jar,
> org.apache.cassandra.triggers.InvertedIndex.class
>
>
> On 07/28/2014 10:43 AM, DuyHai Doan wrote:
>
> Did you put the jar into the /lib folder on the server ? I know it's a
> basic question but it's the first idea to come in mind
>
>
> On Mon, Jul 28, 2014 at 9:36 AM, Martin Marinov <
> martin.mari...@securax.org> wrote:
>
>>  Anybody got an idea on this matter ?
>>
>>
>> On 07/24/2014 06:34 PM, Martin Marinov wrote:
>>
>> Hi,
>>
>> I posted the question on stackoverflow:
>>
>> http://stackoverflow.com/questions/24937425/cassandra-trigger-following-the-cql-for-cassandra-2-0-tutorial-does-not-work
>>
>> On 07/24/2014 06:25 PM, Martin Marinov wrote:
>>
>>  Hi,
>>
>> I'm following the tutorial at:
>> http://www.datastax.com/documentation/cql/3.1/cql/cql_reference/trigger_r.html
>>
>> I'm using Cassandra 2.0.9 with Oracle Java (java version "1.7.0_60").
>>
>> I have downloaded the example Java Class from
>> https://git-wip-us.apache.org/repos/asf?p=cassandra.git;a=blob_plain;f=examples/triggers/src/org/apache/cassandra/triggers/InvertedIndex.java;hb=HEAD
>> into a file named *org.apache.cassandra.triggers.InvertedIndex.jar* .
>>
>> I then created a jar using:
>>
>> jar cvf 
>> /etc/cassandra/triggers/org.apache.cassandra.triggers.InvertedIndex.jar 
>> org.apache.cassandra.triggers.InvertedIndex.class
>>
>> I restarted the cassandra service.
>>
>> The trigger does not exist:
>>
>> cqlsh:mykeyspace> CREATE TRIGGER myTrigger ON myTable USING 
>> 'org.apache.cassandra.triggers.InvertedIndex';
>> Bad Request: Trigger class 'org.apache.cassandra.triggers.InvertedIndex' 
>> doesn't exist
>>
>> What am I doing wrong ?
>>
>>  --
>> Best Regards,
>>
>> Martin Marinov
>> Securax LTD
>>
>> NOTICE:  This email and any file transmitted are confidential and/or
>> legally privileged and intended only for the person(s) directly
>> addressed.  If you are not the intended recipient, any use, copying,
>> transmission, distribution, or other forms of dissemination is strictly
>> prohibited.  If you have received this email in error, please notify the
>> sender immediately and permanently delete the email and files, if any.
>>
>>
>>
>> --
>> Best Regards,
>>
>> Martin Marinov
>> Securax LTD
>>
>> NOTICE:  This email and any file transmitted are confidential and/or
>> legally privileged and intended only for the person(s) directly
>> addressed.  If you are not the intended recipient, any use, copying,
>> transmission, distribution, or other forms of dissemination is strictly
>> prohibited.  If you have received this email in error, please notify the
>> sender immediately and permanently delete the email and files, if any.
>>
>>
>>
>> --
>> Best Regards,
>>
>> Martin Marinov
>> Securax LTD
>>
>> NOTICE:  This email and any file transmitted are confidential and/or
>> legally privileged and intended only for the person(s) directly
>> addressed.  If you are not the intended recipient, any use, copying,
>> transmission, distribution, or other forms of dissemination is strictly
>> prohibited.  If you have received this email in error, please notify the
>> sender immediately and permanently delete the email and files, if any.
>>
>>
>
>
> --
> Best Regards,
>
> Martin Marinov
> Securax LTD
>
> NOTICE:  This email and any file transmitted are confidential and/or
> legally privileged and intended only for the person(s) directly
> addressed.  If you are not the intended recipient, any use, copying,
> transmission, distribution, or other forms of dissemination is strictly
> prohibited.  If you have received this email in error, please notify the
> sender immediately and permanently delete the email and files, if any.
>
>

Re: Cassandra trigger following the CQL for Cassandra 2.0 tutorial does not work

2014-07-28 Thread Martin Marinov


The output is:

unzip /etc/cassandra/triggers/InvertedIndex.jar
Archive:  /etc/cassandra/triggers/InvertedIndex.jar
   creating: META-INF/
  inflating: META-INF/MANIFEST.MF
  inflating: InvertedIndex.java


On 07/28/2014 03:54 PM, Michael Dykman wrote:


I wonder; your jar creation looks a little off and I suspect your 
problem might be the jar format which would lead to the failure to 
load.  Could you list the output of

$ unzip -l my.jar?

On Jul 28, 2014 3:49 AM, "Martin Marinov" > wrote:


I did:
ls /etc/cassandra/triggers/
InvertedIndex.jar  README.txt


But I'm not sure I'm creating the jar correctly.

I'm running:
jar cvf
/etc/cassandra/triggers/org.apache.cassandra.triggers.InvertedIndex.jar
org.apache.cassandra.triggers.InvertedIndex.class

where org.apache.cassandra.triggers.InvertedIndex.class contains
the java code on this url:

https://git-wip-us.apache.org/repos/asf?p=cassandra.git;a=blob_plain;f=examples/triggers/src/org/apache/cassandra/triggers/InvertedIndex.java;hb=HEAD

Also I tried with the name of the .class file and the .jar file as:
InvertedIndex.jar, InvertedIndex.class
and as
org.apache.cassandra.triggers.InvertedIndex.jar,
org.apache.cassandra.triggers.InvertedIndex.class


On 07/28/2014 10:43 AM, DuyHai Doan wrote:

Did you put the jar into the /lib folder on the server ? I know
it's a basic question but it's the first idea to come in mind


On Mon, Jul 28, 2014 at 9:36 AM, Martin Marinov
mailto:martin.mari...@securax.org>>
wrote:

Anybody got an idea on this matter ?


On 07/24/2014 06:34 PM, Martin Marinov wrote:

Hi,

I posted the question on stackoverflow:

http://stackoverflow.com/questions/24937425/cassandra-trigger-following-the-cql-for-cassandra-2-0-tutorial-does-not-work

On 07/24/2014 06:25 PM, Martin Marinov wrote:


Hi,

I'm following the tutorial at:

http://www.datastax.com/documentation/cql/3.1/cql/cql_reference/trigger_r.html

I'm using Cassandra 2.0.9 with Oracle Java (java version
"1.7.0_60").

I have downloaded the example Java Class from

https://git-wip-us.apache.org/repos/asf?p=cassandra.git;a=blob_plain;f=examples/triggers/src/org/apache/cassandra/triggers/InvertedIndex.java;hb=HEAD
into a file named
*org.apache.cassandra.triggers.InvertedIndex.jar* .

I then created a jar using:

|jar cvf 
/etc/cassandra/triggers/org.apache.cassandra.triggers.InvertedIndex.jar 
org.apache.cassandra.triggers.InvertedIndex.class
|

I restarted the cassandra service.

The trigger does not exist:

|cqlsh:mykeyspace> CREATE TRIGGER myTrigger ON myTable USING 
'org.apache.cassandra.triggers.InvertedIndex';
Bad Request: Trigger class 
'org.apache.cassandra.triggers.InvertedIndex' doesn't exist
|

What am I doing wrong ?


-- 
Best Regards,


Martin Marinov
Securax LTD

NOTICE:  This email and any file transmitted are confidential and/or
legally privileged and intended only for the person(s) directly
addressed.  If you are not the intended recipient, any use, copying,
transmission, distribution, or other forms of dissemination is strictly
prohibited.  If you have received this email in error, please notify the
sender immediately and permanently delete the email and files, if any.



-- 
Best Regards,


Martin Marinov
Securax LTD

NOTICE:  This email and any file transmitted are confidential and/or
legally privileged and intended only for the person(s) directly
addressed.  If you are not the intended recipient, any use, copying,
transmission, distribution, or other forms of dissemination is strictly
prohibited.  If you have received this email in error, please notify the
sender immediately and permanently delete the email and files, if any.



-- 
Best Regards,


Martin Marinov
Securax LTD

NOTICE:  This email and any file transmitted are confidential and/or
legally privileged and intended only for the person(s) directly
addressed.  If you are not the intended recipient, any use, copying,
transmission, distribution, or other forms of dissemination is strictly
prohibited.  If you have received this email in error, please notify the
sender immediately and permanently delete the email and files, if any.





-- 
Best Regards,


Martin Marinov
Securax LTD

NOTICE:  This email and any file transmitted are confidential and/or
legally privileged and intended only for the person(s) directly
addressed.  If you are not the intended recipient, any use, copying,
transmission, distribution, or other forms of dissemin

Re: Cassandra trigger following the CQL for Cassandra 2.0 tutorial does not work

2014-07-28 Thread Martin Marinov


Correction.
It's:

unzip -l /etc/cassandra/triggers/InvertedIndex.jar
Archive:  /etc/cassandra/triggers/InvertedIndex.jar
  Length  DateTimeName
-  -- -   
0  2014-07-25 10:07   META-INF/
   68  2014-07-25 10:07   META-INF/MANIFEST.MF
 2761  2014-07-25 10:07   InvertedIndex.java
- ---
 2829 3 files



On 07/28/2014 04:02 PM, Martin Marinov wrote:

The output is:

unzip /etc/cassandra/triggers/InvertedIndex.jar
Archive:  /etc/cassandra/triggers/InvertedIndex.jar
   creating: META-INF/
  inflating: META-INF/MANIFEST.MF
  inflating: InvertedIndex.java


On 07/28/2014 03:54 PM, Michael Dykman wrote:


I wonder; your jar creation looks a little off and I suspect your 
problem might be the jar format which would lead to the failure to 
load.  Could you list the output of

$ unzip -l my.jar?

On Jul 28, 2014 3:49 AM, "Martin Marinov" > wrote:


I did:
ls /etc/cassandra/triggers/
InvertedIndex.jar  README.txt


But I'm not sure I'm creating the jar correctly.

I'm running:
jar cvf
/etc/cassandra/triggers/org.apache.cassandra.triggers.InvertedIndex.jar
org.apache.cassandra.triggers.InvertedIndex.class

where org.apache.cassandra.triggers.InvertedIndex.class contains
the java code on this url:

https://git-wip-us.apache.org/repos/asf?p=cassandra.git;a=blob_plain;f=examples/triggers/src/org/apache/cassandra/triggers/InvertedIndex.java;hb=HEAD

Also I tried with the name of the .class file and the .jar file as:
InvertedIndex.jar, InvertedIndex.class
and as
org.apache.cassandra.triggers.InvertedIndex.jar,
org.apache.cassandra.triggers.InvertedIndex.class


On 07/28/2014 10:43 AM, DuyHai Doan wrote:

Did you put the jar into the /lib folder on the server ? I know
it's a basic question but it's the first idea to come in mind


On Mon, Jul 28, 2014 at 9:36 AM, Martin Marinov
mailto:martin.mari...@securax.org>>
wrote:

Anybody got an idea on this matter ?


On 07/24/2014 06:34 PM, Martin Marinov wrote:

Hi,

I posted the question on stackoverflow:

http://stackoverflow.com/questions/24937425/cassandra-trigger-following-the-cql-for-cassandra-2-0-tutorial-does-not-work

On 07/24/2014 06:25 PM, Martin Marinov wrote:


Hi,

I'm following the tutorial at:

http://www.datastax.com/documentation/cql/3.1/cql/cql_reference/trigger_r.html

I'm using Cassandra 2.0.9 with Oracle Java (java version
"1.7.0_60").

I have downloaded the example Java Class from

https://git-wip-us.apache.org/repos/asf?p=cassandra.git;a=blob_plain;f=examples/triggers/src/org/apache/cassandra/triggers/InvertedIndex.java;hb=HEAD
into a file named
*org.apache.cassandra.triggers.InvertedIndex.jar* .

I then created a jar using:

|jar cvf 
/etc/cassandra/triggers/org.apache.cassandra.triggers.InvertedIndex.jar 
org.apache.cassandra.triggers.InvertedIndex.class
|

I restarted the cassandra service.

The trigger does not exist:

|cqlsh:mykeyspace> CREATE TRIGGER myTrigger ON myTable USING 
'org.apache.cassandra.triggers.InvertedIndex';
Bad Request: Trigger class 
'org.apache.cassandra.triggers.InvertedIndex' doesn't exist
|

What am I doing wrong ?


-- 
Best Regards,


Martin Marinov
Securax LTD

NOTICE:  This email and any file transmitted are confidential and/or
legally privileged and intended only for the person(s) directly
addressed.  If you are not the intended recipient, any use, copying,
transmission, distribution, or other forms of dissemination is strictly
prohibited.  If you have received this email in error, please notify the
sender immediately and permanently delete the email and files, if any.



-- 
Best Regards,


Martin Marinov
Securax LTD

NOTICE:  This email and any file transmitted are confidential and/or
legally privileged and intended only for the person(s) directly
addressed.  If you are not the intended recipient, any use, copying,
transmission, distribution, or other forms of dissemination is strictly
prohibited.  If you have received this email in error, please notify the
sender immediately and permanently delete the email and files, if any.



-- 
Best Regards,


Martin Marinov
Securax LTD

NOTICE:  This email and any file transmitted are confidential and/or
legally privileged and intended only for the person(s) directly
addressed.  If you are not the intended recipient, any use, copying,
transmission, distribution, or other forms of dissemination is strictly
prohibited.  If you have received t

Re: Hot, large row

2014-07-28 Thread Keith Wright

I don’t know but my guess is it would be without tombstones.  I did more 
research this weekend (note that my Sunday was largely interrupted by again 
seeing a node go to high load/high CMS for ~3 hours) and came across this 
presentation:  
http://www.slideshare.net/mobile/planetcassandra/8-axel-liljencrantz-23204252

I definitely suggestion you give this a look, very informative.  The important 
take away is that they ran into the same issue as I due to using the same model 
where I am updating to the same row over time with a TTL causing that row to 
fragment across SSTables and once across 4+ tables, compaction can never 
actually remove tombstones.  As I see it, I have the following options and was 
hoping to get some advice:

1.  Modify my write structure to include time within the key.  Currently we 
want to get all of a row but I can likely add month to the time and it would be 
ok for the application to do two reads to get the most recent data (to deal 
with month boundaries).  This will contain the fragmentation to one month.

2.  Following off of item #1, it appears that according to CASSANDRA-5514 that 
if I include time within my query it will not bother going through older 
SSTables and thus reduce the impact of the row fragmentation.  Problem here is 
that likely my data space will still continue to grow over time as tombstones 
will never be removed.

3.  Move from LCS to STCS and run full compactions periodically to cleanup 
tombstones

I appreciate the help!

From: Jack Krupansky mailto:j...@basetechnology.com>>
Reply-To: "user@cassandra.apache.org" 
mailto:user@cassandra.apache.org>>
Date: Friday, July 25, 2014 at 11:15 AM
To: "user@cassandra.apache.org" 
mailto:user@cassandra.apache.org>>
Subject: Re: Hot, large row

Is it the accumulated tombstones on a row that make it act as if “wide”? Does 
cfhistograms count the tombstones or subtract them when reporting on cell-count 
for rows? (I don’t know.)

-- Jack Krupansky

From: Keith Wright
Sent: Friday, July 25, 2014 10:24 AM
To: user@cassandra.apache.org
Cc: Don Jackson
Subject: Re: Hot, large row

Ha, check out who filed that ticket!   Yes I’m aware of it.  My hope is that it 
was mostly addressed in CASSANDRA-6563 so I may upgrade from 2.0.6 to 2.0.9.  
I’m really just surprised that others are not doing similar actions as I and 
thus experiencing similar issues.

To answer DuyHai’s questions:

How many nodes do you have ? And how many distinct user_id roughtly is there ?
- 14 nodes with approximately 250 million distinct user_ids

For GC activity, in general we see low GC pressure in both Par New and CMS (we 
see the occasional CMS spike but its usually under 100 ms).  When we see a node 
locked up in CMS GC, its not that anyone GC takes a long time, its just that 
the consistent nature of them causes the read latency to spike from the usual 
3-5 ms up to 35 ms which causes issues for our application.

Also Jack Krupansky question is interesting. Even though you limit a request to 
5000, if each cell is a big blob or block of text, it mays add up a lot into 
JVM heap …
- The columns values are actually timestamps and thus not variable in length 
and we cap the length of other columns used in the primary key so I find if 
VERY unlikely that this is a cause.

I will look into the paging option with that native client but from the docs it 
appears that its enabled by default, right?

I greatly appreciate all the help!

From: Ken Hancock mailto:ken.hanc...@schange.com>>
Reply-To: "user@cassandra.apache.org" 
mailto:user@cassandra.apache.org>>
Date: Friday, July 25, 2014 at 10:06 AM
To: "user@cassandra.apache.org" 
mailto:user@cassandra.apache.org>>
Cc: Don Jackson mailto:djack...@nanigans.com>>
Subject: Re: Hot, large row

https://issues.apache.org/jira/browse/CASSANDRA-6654

Full GC in cassandra

2014-07-28 Thread Ruchir Jha

Really curious to know what's causing the spike in Columns and
DeletedColums below :


2014-07-28T09:30:27.471-0400: 127335.928: [Full GC 127335.928: [Class
Histogram:
 num #instances #bytes  class name
--
   1: 132626060 6366050880  java.nio.HeapByteBuffer
   2:  28194918 3920045528  [B
   3:  78124737 3749987376
 edu.stanford.ppl.concurrent.SnapTreeMap$Node
*   4:  67650128 2164804096
<2164804096>  org.apache.cassandra.db.Column*
*   5:  16315310  522089920  org.apache.cassandra.db.DeletedColumn*
   6:  6818  392489608  [I
   7:   2844374  273059904
 edu.stanford.ppl.concurrent.CopyOnWriteManager$COWEpoch
   8:   5727000  22908  java.util.TreeMap$Entry
   9:767742  182921376  [J
  10:   2932832  140775936
 edu.stanford.ppl.concurrent.SnapTreeMap$RootHolder
  11:   2844375   9102
 edu.stanford.ppl.concurrent.CopyOnWriteManager$Latch
  12:   4145131   66322096
 java.util.concurrent.atomic.AtomicReference
  13:437874   64072392  [C
  14:   2660844   63860256
 java.util.concurrent.ConcurrentSkipListMap$Node
  15:  4920   62849864  [[B
  16:   1632063   52226016  edu.stanford.ppl.concurrent.SnapTreeMap

Re: Cassandra trigger following the CQL for Cassandra 2.0 tutorial does not work

2014-07-28 Thread Michael Dykman

This is not really a Cassandra problem: it's a basic Java packaging problem.

First of all, the java source file is not what the runtime needs to
see in your jar; it needs the class file which was generated by
compiling it.  That compiled class needs to be in a folder
corresponding to it's package, which I infer is
'org.apache.cassandra.triggers' from your earlier jar creation command
(obviously not the command you used to create the jar you just showed
us the dump of):
  jar cvf 
/etc/cassandra/triggers/org.apache.cassandra.triggers.InvertedIndex.jar
org.apache.cassandra.triggers.InvertedIndex.class

The META-INF looks fine, but that class should be listed as

org/apache/cassandfra/triggers/InvertedIndex.class

When you compile the source, does the compiler NOT put the binary in
an appropriate folder?


On Mon, Jul 28, 2014 at 9:04 AM, Martin Marinov
 wrote:
> Correction.
> It's:
>
> unzip -l /etc/cassandra/triggers/InvertedIndex.jar
> Archive:  /etc/cassandra/triggers/InvertedIndex.jar
>   Length  DateTimeName
> -  -- -   
> 0  2014-07-25 10:07   META-INF/
>68  2014-07-25 10:07   META-INF/MANIFEST.MF
>  2761  2014-07-25 10:07   InvertedIndex.java
> - ---
>  2829 3 files
>
>
>
>
> On 07/28/2014 04:02 PM, Martin Marinov wrote:
>
> The output is:
>
> unzip /etc/cassandra/triggers/InvertedIndex.jar
> Archive:  /etc/cassandra/triggers/InvertedIndex.jar
>creating: META-INF/
>   inflating: META-INF/MANIFEST.MF
>   inflating: InvertedIndex.java
>
>
> On 07/28/2014 03:54 PM, Michael Dykman wrote:
>
> I wonder; your jar creation looks a little off and I suspect your problem
> might be the jar format which would lead to the failure to load.  Could you
> list the output of
> $ unzip -l my.jar?
>
> On Jul 28, 2014 3:49 AM, "Martin Marinov" 
> wrote:
>>
>> I did:
>> ls /etc/cassandra/triggers/
>> InvertedIndex.jar  README.txt
>>
>>
>> But I'm not sure I'm creating the jar correctly.
>>
>> I'm running:
>> jar cvf
>> /etc/cassandra/triggers/org.apache.cassandra.triggers.InvertedIndex.jar
>> org.apache.cassandra.triggers.InvertedIndex.class
>>
>> where org.apache.cassandra.triggers.InvertedIndex.class contains the java
>> code on this url:
>>
>> https://git-wip-us.apache.org/repos/asf?p=cassandra.git;a=blob_plain;f=examples/triggers/src/org/apache/cassandra/triggers/InvertedIndex.java;hb=HEAD
>>
>> Also I tried with the name of the .class file and the .jar file as:
>> InvertedIndex.jar, InvertedIndex.class
>> and as
>> org.apache.cassandra.triggers.InvertedIndex.jar,
>> org.apache.cassandra.triggers.InvertedIndex.class
>>
>>
>> On 07/28/2014 10:43 AM, DuyHai Doan wrote:
>>
>> Did you put the jar into the /lib folder on the server ? I know it's a
>> basic question but it's the first idea to come in mind
>>
>>
>> On Mon, Jul 28, 2014 at 9:36 AM, Martin Marinov
>>  wrote:
>>>
>>> Anybody got an idea on this matter ?
>>>
>>>
>>> On 07/24/2014 06:34 PM, Martin Marinov wrote:
>>>
>>> Hi,
>>>
>>> I posted the question on stackoverflow:
>>>
>>> http://stackoverflow.com/questions/24937425/cassandra-trigger-following-the-cql-for-cassandra-2-0-tutorial-does-not-work
>>>
>>> On 07/24/2014 06:25 PM, Martin Marinov wrote:
>>>
>>> Hi,
>>>
>>> I'm following the tutorial at:
>>> http://www.datastax.com/documentation/cql/3.1/cql/cql_reference/trigger_r.html
>>>
>>> I'm using Cassandra 2.0.9 with Oracle Java (java version "1.7.0_60").
>>>
>>> I have downloaded the example Java Class from
>>> https://git-wip-us.apache.org/repos/asf?p=cassandra.git;a=blob_plain;f=examples/triggers/src/org/apache/cassandra/triggers/InvertedIndex.java;hb=HEAD
>>> into a file named org.apache.cassandra.triggers.InvertedIndex.jar .
>>>
>>> I then created a jar using:
>>>
>>> jar cvf
>>> /etc/cassandra/triggers/org.apache.cassandra.triggers.InvertedIndex.jar
>>> org.apache.cassandra.triggers.InvertedIndex.class
>>>
>>> I restarted the cassandra service.
>>>
>>> The trigger does not exist:
>>>
>>> cqlsh:mykeyspace> CREATE TRIGGER myTrigger ON myTable USING
>>> 'org.apache.cassandra.triggers.InvertedIndex';
>>> Bad Request: Trigger class 'org.apache.cassandra.triggers.InvertedIndex'
>>> doesn't exist
>>>
>>> What am I doing wrong ?
>>>
>>>
>>> --
>>> Best Regards,
>>>
>>> Martin Marinov
>>> Securax LTD
>>>
>>> NOTICE:  This email and any file transmitted are confidential and/or
>>> legally privileged and intended only for the person(s) directly
>>> addressed.  If you are not the intended recipient, any use, copying,
>>> transmission, distribution, or other forms of dissemination is strictly
>>> prohibited.  If you have received this email in error, please notify the
>>> sender immediately and permanently delete the email and files, if any.
>>>
>>>
>>>
>>> --
>>> Best Regards,
>>>
>>> Martin Marinov
>>> Securax LTD
>>>
>>> NOTICE:  This email and any file transmitted are confidential and/or
>>> legally privileged and intended only for the person(s)

Re: Full GC in cassandra

2014-07-28 Thread Mark Reddy

What is your data size and number of columns in Cassandra. Do you do many
deletions?


On Mon, Jul 28, 2014 at 2:53 PM, Ruchir Jha  wrote:

> Really curious to know what's causing the spike in Columns and
> DeletedColums below :
>
>
> 2014-07-28T09:30:27.471-0400: 127335.928: [Full GC 127335.928: [Class
> Histogram:
>  num #instances #bytes  class name
> --
>1: 132626060 6366050880  java.nio.HeapByteBuffer
>2:  28194918 3920045528  [B
>3:  78124737 3749987376
>  edu.stanford.ppl.concurrent.SnapTreeMap$Node
> *   4:  67650128 2164804096
> <2164804096>  org.apache.cassandra.db.Column*
> *   5:  16315310  522089920  org.apache.cassandra.db.DeletedColumn*
>6:  6818  392489608  [I
>7:   2844374  273059904
>  edu.stanford.ppl.concurrent.CopyOnWriteManager$COWEpoch
>8:   5727000  22908  java.util.TreeMap$Entry
>9:767742  182921376  [J
>   10:   2932832  140775936
>  edu.stanford.ppl.concurrent.SnapTreeMap$RootHolder
>   11:   2844375   9102
>  edu.stanford.ppl.concurrent.CopyOnWriteManager$Latch
>   12:   4145131   66322096
>  java.util.concurrent.atomic.AtomicReference
>   13:437874   64072392  [C
>   14:   2660844   63860256
>  java.util.concurrent.ConcurrentSkipListMap$Node
>   15:  4920   62849864  [[B
>   16:   1632063   52226016  edu.stanford.ppl.concurrent.SnapTreeMap
>

Re: Cassandra trigger following the CQL for Cassandra 2.0 tutorial does not work

2014-07-28 Thread Martin Marinov


I'm not compiling it.
I just download it from:
https://git-wip-us.apache.org/repos/asf?p=cassandra.git;a=blob_plain;f=examples/triggers/src/org/apache/cassandra/triggers/InvertedIndex.java;hb=HEAD

Save the downloaded file into a .class file and jar it.

How do I compile it ?

On 07/28/2014 05:11 PM, Michael Dykman wrote:

This is not really a Cassandra problem: it's a basic Java packaging problem.

First of all, the java source file is not what the runtime needs to
see in your jar; it needs the class file which was generated by
compiling it.  That compiled class needs to be in a folder
corresponding to it's package, which I infer is
'org.apache.cassandra.triggers' from your earlier jar creation command
(obviously not the command you used to create the jar you just showed
us the dump of):
   jar cvf 
/etc/cassandra/triggers/org.apache.cassandra.triggers.InvertedIndex.jar
org.apache.cassandra.triggers.InvertedIndex.class

The META-INF looks fine, but that class should be listed as

org/apache/cassandfra/triggers/InvertedIndex.class

When you compile the source, does the compiler NOT put the binary in
an appropriate folder?


On Mon, Jul 28, 2014 at 9:04 AM, Martin Marinov
 wrote:

Correction.
It's:

unzip -l /etc/cassandra/triggers/InvertedIndex.jar
Archive:  /etc/cassandra/triggers/InvertedIndex.jar
   Length  DateTimeName
-  -- -   
 0  2014-07-25 10:07   META-INF/
68  2014-07-25 10:07   META-INF/MANIFEST.MF
  2761  2014-07-25 10:07   InvertedIndex.java
- ---
  2829 3 files




On 07/28/2014 04:02 PM, Martin Marinov wrote:

The output is:

unzip /etc/cassandra/triggers/InvertedIndex.jar
Archive:  /etc/cassandra/triggers/InvertedIndex.jar
creating: META-INF/
   inflating: META-INF/MANIFEST.MF
   inflating: InvertedIndex.java


On 07/28/2014 03:54 PM, Michael Dykman wrote:

I wonder; your jar creation looks a little off and I suspect your problem
might be the jar format which would lead to the failure to load.  Could you
list the output of
$ unzip -l my.jar?

On Jul 28, 2014 3:49 AM, "Martin Marinov" 
wrote:

I did:
ls /etc/cassandra/triggers/
InvertedIndex.jar  README.txt


But I'm not sure I'm creating the jar correctly.

I'm running:
jar cvf
/etc/cassandra/triggers/org.apache.cassandra.triggers.InvertedIndex.jar
org.apache.cassandra.triggers.InvertedIndex.class

where org.apache.cassandra.triggers.InvertedIndex.class contains the java
code on this url:

https://git-wip-us.apache.org/repos/asf?p=cassandra.git;a=blob_plain;f=examples/triggers/src/org/apache/cassandra/triggers/InvertedIndex.java;hb=HEAD

Also I tried with the name of the .class file and the .jar file as:
InvertedIndex.jar, InvertedIndex.class
and as
org.apache.cassandra.triggers.InvertedIndex.jar,
org.apache.cassandra.triggers.InvertedIndex.class


On 07/28/2014 10:43 AM, DuyHai Doan wrote:

Did you put the jar into the /lib folder on the server ? I know it's a
basic question but it's the first idea to come in mind


On Mon, Jul 28, 2014 at 9:36 AM, Martin Marinov
 wrote:

Anybody got an idea on this matter ?


On 07/24/2014 06:34 PM, Martin Marinov wrote:

Hi,

I posted the question on stackoverflow:

http://stackoverflow.com/questions/24937425/cassandra-trigger-following-the-cql-for-cassandra-2-0-tutorial-does-not-work

On 07/24/2014 06:25 PM, Martin Marinov wrote:

Hi,

I'm following the tutorial at:
http://www.datastax.com/documentation/cql/3.1/cql/cql_reference/trigger_r.html

I'm using Cassandra 2.0.9 with Oracle Java (java version "1.7.0_60").

I have downloaded the example Java Class from
https://git-wip-us.apache.org/repos/asf?p=cassandra.git;a=blob_plain;f=examples/triggers/src/org/apache/cassandra/triggers/InvertedIndex.java;hb=HEAD
into a file named org.apache.cassandra.triggers.InvertedIndex.jar .

I then created a jar using:

jar cvf
/etc/cassandra/triggers/org.apache.cassandra.triggers.InvertedIndex.jar
org.apache.cassandra.triggers.InvertedIndex.class

I restarted the cassandra service.

The trigger does not exist:

cqlsh:mykeyspace> CREATE TRIGGER myTrigger ON myTable USING
'org.apache.cassandra.triggers.InvertedIndex';
Bad Request: Trigger class 'org.apache.cassandra.triggers.InvertedIndex'
doesn't exist

What am I doing wrong ?


--
Best Regards,

Martin Marinov
Securax LTD

NOTICE:  This email and any file transmitted are confidential and/or
legally privileged and intended only for the person(s) directly
addressed.  If you are not the intended recipient, any use, copying,
transmission, distribution, or other forms of dissemination is strictly
prohibited.  If you have received this email in error, please notify the
sender immediately and permanently delete the email and files, if any.



--
Best Regards,

Martin Marinov
Securax LTD

NOTICE:  This email and any file transmitted are confidential and/or
legally privileged and intended only for the person(s) directly
addressed.  If you are not the intended

Re: Cassandra trigger following the CQL for Cassandra 2.0 tutorial does not work

2014-07-28 Thread Michael Dykman

How to compile is a much biggest question and probably way off topic
for this list.   I think you need a starter tutorial on building and
packaing java; there is more than one concept at work.

you will need a compiler of the appropriate version. that source has
external dependancies declared in the imports from these packages:
 org.apache.cassandra.io
 org.apache.cassandra.db
 org.slf4j

The rest of the import are internal to Java's standard library.

I think you need to master the art of building and running a jar
before you can reasonably hope to be playing with cassandra triggers.


On Mon, Jul 28, 2014 at 10:15 AM, Martin Marinov
 wrote:
> I'm not compiling it.
> I just download it from:
>
> https://git-wip-us.apache.org/repos/asf?p=cassandra.git;a=blob_plain;f=examples/triggers/src/org/apache/cassandra/triggers/InvertedIndex.java;hb=HEAD
>
> Save the downloaded file into a .class file and jar it.
>
> How do I compile it ?
>
>
> On 07/28/2014 05:11 PM, Michael Dykman wrote:
>>
>> This is not really a Cassandra problem: it's a basic Java packaging
>> problem.
>>
>> First of all, the java source file is not what the runtime needs to
>> see in your jar; it needs the class file which was generated by
>> compiling it.  That compiled class needs to be in a folder
>> corresponding to it's package, which I infer is
>> 'org.apache.cassandra.triggers' from your earlier jar creation command
>> (obviously not the command you used to create the jar you just showed
>> us the dump of):
>>jar cvf
>> /etc/cassandra/triggers/org.apache.cassandra.triggers.InvertedIndex.jar
>> org.apache.cassandra.triggers.InvertedIndex.class
>>
>> The META-INF looks fine, but that class should be listed as
>>
>> org/apache/cassandfra/triggers/InvertedIndex.class
>>
>> When you compile the source, does the compiler NOT put the binary in
>> an appropriate folder?
>>
>>
>> On Mon, Jul 28, 2014 at 9:04 AM, Martin Marinov
>>  wrote:
>>>
>>> Correction.
>>> It's:
>>>
>>> unzip -l /etc/cassandra/triggers/InvertedIndex.jar
>>> Archive:  /etc/cassandra/triggers/InvertedIndex.jar
>>>Length  DateTimeName
>>> -  -- -   
>>>  0  2014-07-25 10:07   META-INF/
>>> 68  2014-07-25 10:07   META-INF/MANIFEST.MF
>>>   2761  2014-07-25 10:07   InvertedIndex.java
>>> - ---
>>>   2829 3 files
>>>
>>>
>>>
>>>
>>> On 07/28/2014 04:02 PM, Martin Marinov wrote:
>>>
>>> The output is:
>>>
>>> unzip /etc/cassandra/triggers/InvertedIndex.jar
>>> Archive:  /etc/cassandra/triggers/InvertedIndex.jar
>>> creating: META-INF/
>>>inflating: META-INF/MANIFEST.MF
>>>inflating: InvertedIndex.java
>>>
>>>
>>> On 07/28/2014 03:54 PM, Michael Dykman wrote:
>>>
>>> I wonder; your jar creation looks a little off and I suspect your problem
>>> might be the jar format which would lead to the failure to load.  Could
>>> you
>>> list the output of
>>> $ unzip -l my.jar?
>>>
>>> On Jul 28, 2014 3:49 AM, "Martin Marinov" 
>>> wrote:

 I did:
 ls /etc/cassandra/triggers/
 InvertedIndex.jar  README.txt


 But I'm not sure I'm creating the jar correctly.

 I'm running:
 jar cvf
 /etc/cassandra/triggers/org.apache.cassandra.triggers.InvertedIndex.jar
 org.apache.cassandra.triggers.InvertedIndex.class

 where org.apache.cassandra.triggers.InvertedIndex.class contains the
 java
 code on this url:


 https://git-wip-us.apache.org/repos/asf?p=cassandra.git;a=blob_plain;f=examples/triggers/src/org/apache/cassandra/triggers/InvertedIndex.java;hb=HEAD

 Also I tried with the name of the .class file and the .jar file as:
 InvertedIndex.jar, InvertedIndex.class
 and as
 org.apache.cassandra.triggers.InvertedIndex.jar,
 org.apache.cassandra.triggers.InvertedIndex.class


 On 07/28/2014 10:43 AM, DuyHai Doan wrote:

 Did you put the jar into the /lib folder on the server ? I know it's a
 basic question but it's the first idea to come in mind


 On Mon, Jul 28, 2014 at 9:36 AM, Martin Marinov
  wrote:
>
> Anybody got an idea on this matter ?
>
>
> On 07/24/2014 06:34 PM, Martin Marinov wrote:
>
> Hi,
>
> I posted the question on stackoverflow:
>
>
> http://stackoverflow.com/questions/24937425/cassandra-trigger-following-the-cql-for-cassandra-2-0-tutorial-does-not-work
>
> On 07/24/2014 06:25 PM, Martin Marinov wrote:
>
> Hi,
>
> I'm following the tutorial at:
>
> http://www.datastax.com/documentation/cql/3.1/cql/cql_reference/trigger_r.html
>
> I'm using Cassandra 2.0.9 with Oracle Java (java version "1.7.0_60").
>
> I have downloaded the example Java Class from
>
> https://git-wip-us.apache.org/repos/asf?p=cassandra.git;a=blob_plain;f=examples/triggers/src/org/apache/cassandra/triggers/InvertedIndex.java;hb=HEAD
> into a file

Re: Full GC in cassandra

2014-07-28 Thread Ruchir Jha

Doing about 5K writes / second. Avg Data Size = 1.6 TB / node. Total Data
Size = 21 TB.

And this is the nodetool cfstats output for one of our busiest column
families:

  SSTable count: 10
Space used (live): 43239294899
Space used (total): 43239419603
SSTable Compression Ratio: 0.2954468408497778
Number of Keys (estimate): 63729152
Memtable Columns Count: 1921620
Memtable Data Size: 257680020
Memtable Switch Count: 9
Read Count: 6167
Read Latency: NaN ms.
Write Count: 770984
Write Latency: 0.098 ms.
Pending Tasks: 0
Bloom Filter False Positives: 370
Bloom Filter False Ratio: 0.0
Bloom Filter Space Used: 80103200
Compacted row minimum size: 180
Compacted row maximum size: 3311
Compacted row mean size: 2631
Average live cells per slice (last five minutes): 73.0
Average tombstones per slice (last five minutes): 13.0

On Mon, Jul 28, 2014 at 10:14 AM, Mark Reddy  wrote:

> What is your data size and number of columns in Cassandra. Do you do many
> deletions?
>
>
> On Mon, Jul 28, 2014 at 2:53 PM, Ruchir Jha  wrote:
>
>> Really curious to know what's causing the spike in Columns and
>> DeletedColums below :
>>
>>
>> 2014-07-28T09:30:27.471-0400: 127335.928: [Full GC 127335.928: [Class
>> Histogram:
>>   num #instances #bytes  class name
>> --
>>1: 132626060 6366050880  java.nio.HeapByteBuffer
>>2:  28194918 3920045528  [B
>>3:  78124737 3749987376
>>  edu.stanford.ppl.concurrent.SnapTreeMap$Node
>> *   4:  67650128 2164804096
>> <2164804096>  org.apache.cassandra.db.Column*
>> *   5:  16315310  522089920
>>  org.apache.cassandra.db.DeletedColumn*
>>6:  6818  392489608  [I
>>7:   2844374  273059904
>>  edu.stanford.ppl.concurrent.CopyOnWriteManager$COWEpoch
>>8:   5727000  22908  java.util.TreeMap$Entry
>>9:767742  182921376  [J
>>   10:   2932832  140775936
>>  edu.stanford.ppl.concurrent.SnapTreeMap$RootHolder
>>   11:   2844375   9102
>>  edu.stanford.ppl.concurrent.CopyOnWriteManager$Latch
>>   12:   4145131   66322096
>>  java.util.concurrent.atomic.AtomicReference
>>   13:437874   64072392  [C
>>   14:   2660844   63860256
>>  java.util.concurrent.ConcurrentSkipListMap$Node
>>   15:  4920   62849864  [[B
>>   16:   1632063   52226016
>>  edu.stanford.ppl.concurrent.SnapTreeMap
>>
>
>

Re: Full GC in cassandra

2014-07-28 Thread Ruchir Jha

Also we do subsequent updates (atleat 4) for each piece of data that we
write.


On Mon, Jul 28, 2014 at 10:36 AM, Ruchir Jha  wrote:

> Doing about 5K writes / second. Avg Data Size = 1.6 TB / node. Total Data
> Size = 21 TB.
>
> And this is the nodetool cfstats output for one of our busiest column
> families:
>
>   SSTable count: 10
> Space used (live): 43239294899
> Space used (total): 43239419603
> SSTable Compression Ratio: 0.2954468408497778
> Number of Keys (estimate): 63729152
> Memtable Columns Count: 1921620
> Memtable Data Size: 257680020
> Memtable Switch Count: 9
> Read Count: 6167
> Read Latency: NaN ms.
> Write Count: 770984
> Write Latency: 0.098 ms.
> Pending Tasks: 0
> Bloom Filter False Positives: 370
> Bloom Filter False Ratio: 0.0
> Bloom Filter Space Used: 80103200
> Compacted row minimum size: 180
> Compacted row maximum size: 3311
> Compacted row mean size: 2631
> Average live cells per slice (last five minutes): 73.0
> Average tombstones per slice (last five minutes): 13.0
>
>
>
> On Mon, Jul 28, 2014 at 10:14 AM, Mark Reddy 
> wrote:
>
>> What is your data size and number of columns in Cassandra. Do you do many
>> deletions?
>>
>>
>> On Mon, Jul 28, 2014 at 2:53 PM, Ruchir Jha  wrote:
>>
>>> Really curious to know what's causing the spike in Columns and
>>> DeletedColums below :
>>>
>>>
>>> 2014-07-28T09:30:27.471-0400: 127335.928: [Full GC 127335.928: [Class
>>> Histogram:
>>>   num #instances #bytes  class name
>>> --
>>>1: 132626060 6366050880  java.nio.HeapByteBuffer
>>>2:  28194918 3920045528  [B
>>>3:  78124737 3749987376
>>>  edu.stanford.ppl.concurrent.SnapTreeMap$Node
>>> *   4:  67650128 2164804096
>>> <2164804096>  org.apache.cassandra.db.Column*
>>> *   5:  16315310  522089920
>>>  org.apache.cassandra.db.DeletedColumn*
>>>6:  6818  392489608  [I
>>>7:   2844374  273059904
>>>  edu.stanford.ppl.concurrent.CopyOnWriteManager$COWEpoch
>>>8:   5727000  22908  java.util.TreeMap$Entry
>>>9:767742  182921376  [J
>>>   10:   2932832  140775936
>>>  edu.stanford.ppl.concurrent.SnapTreeMap$RootHolder
>>>   11:   2844375   9102
>>>  edu.stanford.ppl.concurrent.CopyOnWriteManager$Latch
>>>   12:   4145131   66322096
>>>  java.util.concurrent.atomic.AtomicReference
>>>   13:437874   64072392  [C
>>>   14:   2660844   63860256
>>>  java.util.concurrent.ConcurrentSkipListMap$Node
>>>   15:  4920   62849864  [[B
>>>   16:   1632063   52226016
>>>  edu.stanford.ppl.concurrent.SnapTreeMap
>>>
>>
>>
>

Re: Cassandra trigger following the CQL for Cassandra 2.0 tutorial does not work

2014-07-28 Thread Jack Krupansky

To be clear, Cassandra triggers require that you be a skilled and confident 
Java developer. If you aren't fluent in Java and the Java development 
process, triggers are not a great place to start learning Java.


That said, maybe the doc does need to be a little more clear about some of 
the specifics.


-- Jack Krupansky

-Original Message- 
From: Michael Dykman

Sent: Monday, July 28, 2014 10:35 AM
To: Cassandra Users
Subject: Re: Cassandra trigger following the CQL for Cassandra 2.0 tutorial 
does not work


How to compile is a much biggest question and probably way off topic
for this list.   I think you need a starter tutorial on building and
packaing java; there is more than one concept at work.

you will need a compiler of the appropriate version. that source has
external dependancies declared in the imports from these packages:
org.apache.cassandra.io
org.apache.cassandra.db
org.slf4j

The rest of the import are internal to Java's standard library.

I think you need to master the art of building and running a jar
before you can reasonably hope to be playing with cassandra triggers.


On Mon, Jul 28, 2014 at 10:15 AM, Martin Marinov
 wrote:

I'm not compiling it.
I just download it from:

https://git-wip-us.apache.org/repos/asf?p=cassandra.git;a=blob_plain;f=examples/triggers/src/org/apache/cassandra/triggers/InvertedIndex.java;hb=HEAD

Save the downloaded file into a .class file and jar it.

How do I compile it ?


On 07/28/2014 05:11 PM, Michael Dykman wrote:


This is not really a Cassandra problem: it's a basic Java packaging
problem.

First of all, the java source file is not what the runtime needs to
see in your jar; it needs the class file which was generated by
compiling it.  That compiled class needs to be in a folder
corresponding to it's package, which I infer is
'org.apache.cassandra.triggers' from your earlier jar creation command
(obviously not the command you used to create the jar you just showed
us the dump of):
   jar cvf
/etc/cassandra/triggers/org.apache.cassandra.triggers.InvertedIndex.jar
org.apache.cassandra.triggers.InvertedIndex.class

The META-INF looks fine, but that class should be listed as

org/apache/cassandfra/triggers/InvertedIndex.class

When you compile the source, does the compiler NOT put the binary in
an appropriate folder?


On Mon, Jul 28, 2014 at 9:04 AM, Martin Marinov
 wrote:


Correction.
It's:

unzip -l /etc/cassandra/triggers/InvertedIndex.jar
Archive:  /etc/cassandra/triggers/InvertedIndex.jar
   Length  DateTimeName
-  -- -   
 0  2014-07-25 10:07   META-INF/
68  2014-07-25 10:07   META-INF/MANIFEST.MF
  2761  2014-07-25 10:07   InvertedIndex.java
- ---
  2829 3 files




On 07/28/2014 04:02 PM, Martin Marinov wrote:

The output is:

unzip /etc/cassandra/triggers/InvertedIndex.jar
Archive:  /etc/cassandra/triggers/InvertedIndex.jar
creating: META-INF/
   inflating: META-INF/MANIFEST.MF
   inflating: InvertedIndex.java


On 07/28/2014 03:54 PM, Michael Dykman wrote:

I wonder; your jar creation looks a little off and I suspect your 
problem

might be the jar format which would lead to the failure to load.  Could
you
list the output of
$ unzip -l my.jar?

On Jul 28, 2014 3:49 AM, "Martin Marinov" 
wrote:


I did:
ls /etc/cassandra/triggers/
InvertedIndex.jar  README.txt


But I'm not sure I'm creating the jar correctly.

I'm running:
jar cvf
/etc/cassandra/triggers/org.apache.cassandra.triggers.InvertedIndex.jar
org.apache.cassandra.triggers.InvertedIndex.class

where org.apache.cassandra.triggers.InvertedIndex.class contains the
java
code on this url:


https://git-wip-us.apache.org/repos/asf?p=cassandra.git;a=blob_plain;f=examples/triggers/src/org/apache/cassandra/triggers/InvertedIndex.java;hb=HEAD

Also I tried with the name of the .class file and the .jar file as:
InvertedIndex.jar, InvertedIndex.class
and as
org.apache.cassandra.triggers.InvertedIndex.jar,
org.apache.cassandra.triggers.InvertedIndex.class


On 07/28/2014 10:43 AM, DuyHai Doan wrote:

Did you put the jar into the /lib folder on the server ? I know it's a
basic question but it's the first idea to come in mind


On Mon, Jul 28, 2014 at 9:36 AM, Martin Marinov
 wrote:


Anybody got an idea on this matter ?


On 07/24/2014 06:34 PM, Martin Marinov wrote:

Hi,

I posted the question on stackoverflow:


http://stackoverflow.com/questions/24937425/cassandra-trigger-following-the-cql-for-cassandra-2-0-tutorial-does-not-work

On 07/24/2014 06:25 PM, Martin Marinov wrote:

Hi,

I'm following the tutorial at:

http://www.datastax.com/documentation/cql/3.1/cql/cql_reference/trigger_r.html

I'm using Cassandra 2.0.9 with Oracle Java (java version "1.7.0_60").

I have downloaded the example Java Class from

https://git-wip-us.apache.org/repos/asf?p=cassandra.git;a=blob_plain;f=examples/triggers/src/org/apache/cassandra/triggers/InvertedIndex.java;hb=HEAD
into a file name

Thrift vs CQL3 performance

2014-07-28 Thread bi kro


Hi every one,

I'm newcomer to Cassandra, so I would like to know about performance 
between Thrift (Hector) vs CQL3, specially about the speed (Thrift based 
on RPC, CQL3 based on binary protocol).


Currently I'm using Cassandra 1.2 , which version CQL3 of 
JavaDriver-Datastax is stable for it?


Thanks very much

Re: Full GC in cassandra

2014-07-28 Thread Keith Wright

What’s your cfhistograms look like?

From: Ruchir Jha mailto:ruchir@gmail.com>>
Reply-To: "user@cassandra.apache.org" 
mailto:user@cassandra.apache.org>>
Date: Monday, July 28, 2014 at 10:43 AM
To: "user@cassandra.apache.org" 
mailto:user@cassandra.apache.org>>
Subject: Re: Full GC in cassandra

Also we do subsequent updates (atleat 4) for each piece of data that we write.

On Mon, Jul 28, 2014 at 10:36 AM, Ruchir Jha 
mailto:ruchir@gmail.com>> wrote:
Doing about 5K writes / second. Avg Data Size = 1.6 TB / node. Total Data Size 
= 21 TB.

And this is the nodetool cfstats output for one of our busiest column families:

  SSTable count: 10
Space used (live): 43239294899
Space used (total): 43239419603
SSTable Compression Ratio: 0.2954468408497778
Number of Keys (estimate): 63729152
Memtable Columns Count: 1921620
Memtable Data Size: 257680020
Memtable Switch Count: 9
Read Count: 6167
Read Latency: NaN ms.
Write Count: 770984
Write Latency: 0.098 ms.
Pending Tasks: 0
Bloom Filter False Positives: 370
Bloom Filter False Ratio: 0.0
Bloom Filter Space Used: 80103200
Compacted row minimum size: 180
Compacted row maximum size: 3311
Compacted row mean size: 2631
Average live cells per slice (last five minutes): 73.0
Average tombstones per slice (last five minutes): 13.0

On Mon, Jul 28, 2014 at 10:14 AM, Mark Reddy 
mailto:mark.re...@boxever.com>> wrote:
What is your data size and number of columns in Cassandra. Do you do many 
deletions?

On Mon, Jul 28, 2014 at 2:53 PM, Ruchir Jha 
mailto:ruchir@gmail.com>> wrote:
Really curious to know what's causing the spike in Columns and DeletedColums 
below :

2014-07-28T09:30:27.471-0400: 127335.928: [Full GC 127335.928: [Class Histogram:
 num #instances #bytes  class name
--
   1: 132626060 6366050880  java.nio.HeapByteBuffer
   2:  28194918 3920045528  [B
   3:  78124737 3749987376  edu.stanford.ppl.concurrent.SnapTreeMap$Node
   4:  67650128 2164804096  
org.apache.cassandra.db.Column
   5:  16315310  522089920  org.apache.cassandra.db.DeletedColumn
   6:  6818  392489608  [I
   7:   2844374  273059904  
edu.stanford.ppl.concurrent.CopyOnWriteManager$COWEpoch
   8:   5727000  22908  java.util.TreeMap$Entry
   9:767742  182921376  [J
  10:   2932832  140775936  
edu.stanford.ppl.concurrent.SnapTreeMap$RootHolder
  11:   2844375   9102  
edu.stanford.ppl.concurrent.CopyOnWriteManager$Latch
  12:   4145131   66322096  java.util.concurrent.atomic.AtomicReference
  13:437874   64072392  [C
  14:   2660844   63860256  
java.util.concurrent.ConcurrentSkipListMap$Node
  15:  4920   62849864  [[B
  16:   1632063   52226016  edu.stanford.ppl.concurrent.SnapTreeMap

Re: Full GC in cassandra

2014-07-28 Thread graham sanderson

1) Is that heap dump after full GC?
2) Are you doing a lot of concurrent writes to the same partition
3) Is the system hinting at the time of the spike
4) when you say “spike” do you mean this is unusually high?

On Jul 28, 2014, at 11:07 AM, Keith Wright  wrote:

> What’s your cfhistograms look like?
> 
> From: Ruchir Jha 
> Reply-To: "user@cassandra.apache.org" 
> Date: Monday, July 28, 2014 at 10:43 AM
> To: "user@cassandra.apache.org" 
> Subject: Re: Full GC in cassandra
> 
> Also we do subsequent updates (atleat 4) for each piece of data that we write.
> 
> 
> On Mon, Jul 28, 2014 at 10:36 AM, Ruchir Jha  wrote:
>> Doing about 5K writes / second. Avg Data Size = 1.6 TB / node. Total Data 
>> Size = 21 TB. 
>> 
>> And this is the nodetool cfstats output for one of our busiest column 
>> families:
>> 
>>   SSTable count: 10
>> Space used (live): 43239294899
>> Space used (total): 43239419603
>> SSTable Compression Ratio: 0.2954468408497778
>> Number of Keys (estimate): 63729152
>> Memtable Columns Count: 1921620
>> Memtable Data Size: 257680020
>> Memtable Switch Count: 9
>> Read Count: 6167
>> Read Latency: NaN ms.
>> Write Count: 770984
>> Write Latency: 0.098 ms.
>> Pending Tasks: 0
>> Bloom Filter False Positives: 370
>> Bloom Filter False Ratio: 0.0
>> Bloom Filter Space Used: 80103200
>> Compacted row minimum size: 180
>> Compacted row maximum size: 3311
>> Compacted row mean size: 2631
>> Average live cells per slice (last five minutes): 73.0
>> Average tombstones per slice (last five minutes): 13.0
>> 
>> 
>> 
>> On Mon, Jul 28, 2014 at 10:14 AM, Mark Reddy  wrote:
>>> What is your data size and number of columns in Cassandra. Do you do many 
>>> deletions?
>>> 
>>> 
>>> On Mon, Jul 28, 2014 at 2:53 PM, Ruchir Jha  wrote:
 Really curious to know what's causing the spike in Columns and 
 DeletedColums below :
 
 
 2014-07-28T09:30:27.471-0400: 127335.928: [Full GC 127335.928: [Class 
 Histogram:
  num #instances #bytes  class name
 --
1: 132626060 6366050880  java.nio.HeapByteBuffer
2:  28194918 3920045528  [B
3:  78124737 3749987376  
 edu.stanford.ppl.concurrent.SnapTreeMap$Node
4:  67650128 2164804096  org.apache.cassandra.db.Column
5:  16315310  522089920  org.apache.cassandra.db.DeletedColumn
6:  6818  392489608  [I
7:   2844374  273059904  
 edu.stanford.ppl.concurrent.CopyOnWriteManager$COWEpoch
8:   5727000  22908  java.util.TreeMap$Entry
9:767742  182921376  [J
   10:   2932832  140775936  
 edu.stanford.ppl.concurrent.SnapTreeMap$RootHolder
   11:   2844375   9102  
 edu.stanford.ppl.concurrent.CopyOnWriteManager$Latch
   12:   4145131   66322096  
 java.util.concurrent.atomic.AtomicReference
   13:437874   64072392  [C
   14:   2660844   63860256  
 java.util.concurrent.ConcurrentSkipListMap$Node
   15:  4920   62849864  [[B
   16:   1632063   52226016  edu.stanford.ppl.concurrent.SnapTreeMap
>>> 
>> 
> 



smime.p7s
Description: S/MIME cryptographic signature

cassandra [2.1.0-rc4] does not filter data out when using WHERE clause on cluster column

2014-07-28 Thread Krzysztof Zarzycki

Hi everyone,
I have a weird, invalid situation with my cluster. I have a table on which
I'm running some SELECTs with WHERE clause filtering on cluster columns,
but the rows are not getting filtered out.
Look:
 select * from page_view where website_id = xxx and user_id = 'some_user'
and page_id =0; -- tried also page_id<0 >0

 website_id | user_id   | page_id  | ...
+---+--+
xxx | some_user | 21044533 | ...
...more rows here, none with page_id=0

The filtering on other (partition) columns runs fine. Only the clustering
column is somewhat malfunctioning.

Important is, how I got to this table:
1. I collected data with Cassandra version 2.0.8
2. I snapshotted the data, and removed the main copy from cluster's data.
3. I upgraded cluster to version 2.1.0-rc4
4. I've recreated the schema of tables in new version.
5. I ran sstableloader on the data to load data to new upgraded cluster.
6. I spotted the problem with filtering.
7. I've tried to run nodetool repair, nodetool upgradesstables -a , neither
helped.

Do you have any ideas how to curate my data?
It might be cumbersome, but possible to just copy data out (to e.g. json)
and back in. But anyway, I believe it might be a bug in 2.1.0-rc4. Do you
have at least ideas on how to investigate what the problem is?

Thank you for any help,
-- Krzysztof Zarzycki

Re: unable to load data using sstableloader

2014-07-28 Thread Colin Kuo

Have you created the schema for these data files? I meant the schema should
be created before you load these data file to C*.

Here is the article for introduction of sstableloader that you could refer.
http://www.datastax.com/documentation/cassandra/1.2/cassandra/tools/toolsBulkloader_t.html



On Mon, Jul 28, 2014 at 7:28 PM, Akshay Ballarpure <
akshay.ballarp...@tcs.com> wrote:

>
> Hello,
> I am unable to load sstable into cassandra using sstable loader, please
> suggest. Thanks.
>
> [root@CSL-simulation conf]# pwd
> /root/Akshay/Cassandra/apache-cassandra-2.0.8/conf
> [root@CSL-simulation conf]# ls -ltr keyspace/col/
> total 32
> -rw-r--r-- 1 root root   16 Jul 28 16:55 Test-Data-jb-1-Filter.db
> -rw-r--r-- 1 root root  300 Jul 28 16:55 Test-Data-jb-1-Index.db
> -rw-r--r-- 1 root root 3470 Jul 28 16:55 Test-Data-jb-1-Data.db
> -rw-r--r-- 1 root root8 Jul 28 16:55 Test-Data-jb-1-CRC.db
> -rw-r--r-- 1 root root   64 Jul 28 16:55 Test-Data-jb-1-Digest.sha1
> -rw-r--r-- 1 root root 4392 Jul 28 16:55 Test-Data-jb-1-Statistics.db
> -rw-r--r-- 1 root root   79 Jul 28 16:55 Test-Data-jb-1-TOC.txt
>
>
> [root@CSL-simulation conf]# ../bin/sstableloader -d localhost
> /root/Akshay/Cassandra/apache-cassandra-2.0.8/conf/keyspace/col/ --debug
> Could not retrieve endpoint ranges:
> InvalidRequestException(why:No such keyspace: keyspace)
> java.lang.RuntimeException: Could not retrieve endpoint ranges:
> at
> org.apache.cassandra.tools.BulkLoader$ExternalClient.init(BulkLoader.java:259)
> at
> org.apache.cassandra.io.sstable.SSTableLoader.stream(SSTableLoader.java:149)
> at org.apache.cassandra.tools.BulkLoader.main(BulkLoader.java:85)
> Caused by: InvalidRequestException(why:No such keyspace: keyspace)
> at
> org.apache.cassandra.thrift.Cassandra$describe_ring_result$describe_ring_resultStandardScheme.read(Cassandra.java:34055)
> at
> org.apache.cassandra.thrift.Cassandra$describe_ring_result$describe_ring_resultStandardScheme.read(Cassandra.java:34022)
> at
> org.apache.cassandra.thrift.Cassandra$describe_ring_result.read(Cassandra.java:33964)
> at
> org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:78)
> at
> org.apache.cassandra.thrift.Cassandra$Client.recv_describe_ring(Cassandra.java:1251)
> at
> org.apache.cassandra.thrift.Cassandra$Client.describe_ring(Cassandra.java:1238)
> at
> org.apache.cassandra.tools.BulkLoader$ExternalClient.init(BulkLoader.java:235)
> ... 2 more
>
>
> Thanks & Regards
> Akshay Ghanshyam Ballarpure
> Tata Consultancy Services
> Cell:- 9985084075
> Mailto: akshay.ballarp...@tcs.com
> Website: http://www.tcs.com
> 
> Experience certainty.IT Services
>Business Solutions
>Consulting
> 
>
> =-=-=
> Notice: The information contained in this e-mail
> message and/or attachments to it may contain
> confidential or privileged information. If you are
> not the intended recipient, any dissemination, use,
> review, distribution, printing or copying of the
> information contained in this e-mail message
> and/or attachments to it are strictly prohibited. If
> you have received this communication in error,
> please notify us by reply e-mail or telephone and
> immediately and permanently delete the message
> and any attachments. Thank you
>
>

Re: cassandra [2.1.0-rc4] does not filter data out when using WHERE clause on cluster column

2014-07-28 Thread Robert Coli

On Mon, Jul 28, 2014 at 9:32 AM, Krzysztof Zarzycki 
wrote:

> Hi everyone,
> I have a weird, invalid situation with my cluster. I have a table on which
> I'm running some SELECTs with WHERE clause filtering on cluster columns,
> but the rows are not getting filtered out.
>

> It might be cumbersome, but possible to just copy data out (to e.g. json)
> and back in. But anyway, I believe it might be a bug in 2.1.0-rc4. Do you
> have at least ideas on how to investigate what the problem is?
>

Reports of issues in pre-release versions of Cassandra are probably best
suited for the Apache JIRA, where relevant people can assist you with
investigation.

If you regularly run pre-release versions, cassandra-dev is probably the
list for you! :D

=Rob

Re: any plans for coprocessors?

2014-07-28 Thread Robert Coli

On Fri, Jul 25, 2014 at 6:32 PM, Kevin Burton  wrote:

> Are there any plans to add coprocessors to cassandra?
>
> Embedding logic directly in a cassandra daemon would be nice.
>

https://github.com/zznate/intravert-ug

Edward Capriolo has done a bit of thinking about this as well.. :D

=Rob

Re: Changing IPs of all nodes in a ring

2014-07-28 Thread Robert Coli

On Fri, Jul 25, 2014 at 6:30 PM, Rahul Neelakantan  wrote:

> Do I need to do any move tokens of the new IPs to the old token -1 and the
> removeToken of the old tokens?  I ask this because the old IPs will
> continue to show in gossip info with a status of Normal.
>

If you use auto_bootstrap:false, the old IPs should be removed from gossip,
or no longer matter. However IIRC you are using an ancient version of
Cassandra, so you might see unexpected behavior.

=Rob

Settings for "old" tables to optimize storage space

2014-07-28 Thread Redmumba

After much help from this list, I've moved to a date-based table schema.
Once a date has passed, there will be very little, if any, writing to that
table.  As such, I have a nightly process that goes through a performs a
major compaction to move it down to a single table.

I've tried manipulating the chunk size for compaction, but there's very
little change in the size of the final table.  I'm currently using the LZ4
compressor.  Does anybody have any tips for optimizing the longer term
storage for "old" data?  For example, will one of the other compressors be
better for long-term storage?

Re: Cassandra trigger following the CQL for Cassandra 2.0 tutorial does not work

Re: Cassandra trigger following the CQL for Cassandra 2.0 tutorial does not work

Re: Cassandra trigger following the CQL for Cassandra 2.0 tutorial does not work

unable to load data using sstableloader

Re: Cassandra trigger following the CQL for Cassandra 2.0 tutorial does not work

Re: Cassandra trigger following the CQL for Cassandra 2.0 tutorial does not work

Re: Cassandra trigger following the CQL for Cassandra 2.0 tutorial does not work

Re: Hot, large row

Full GC in cassandra

Re: Cassandra trigger following the CQL for Cassandra 2.0 tutorial does not work

Re: Full GC in cassandra

Re: Cassandra trigger following the CQL for Cassandra 2.0 tutorial does not work

Re: Cassandra trigger following the CQL for Cassandra 2.0 tutorial does not work

Re: Full GC in cassandra

Re: Full GC in cassandra

Re: Cassandra trigger following the CQL for Cassandra 2.0 tutorial does not work

Thrift vs CQL3 performance

Re: Full GC in cassandra

Re: Full GC in cassandra

cassandra [2.1.0-rc4] does not filter data out when using WHERE clause on cluster column

Re: unable to load data using sstableloader

Re: cassandra [2.1.0-rc4] does not filter data out when using WHERE clause on cluster column

Re: any plans for coprocessors?

Re: Changing IPs of all nodes in a ring

Settings for "old" tables to optimize storage space

25 matches

Site Navigation

Mail list logo

Footer information