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:

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 t

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

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-Fil

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

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

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

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-l

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 j

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,

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: [

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

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 th

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

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 colum

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 speci

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?

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"

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 li

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;

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

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 cumberso

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:fals

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 t