Re: Strange delay in query

2012-11-11 Thread André Cruz
On Nov 11, 2012, at 12:01 AM, Binh Nguyen wrote: > FYI: Repair does not remove tombstones. To remove tombstones you need to run > compaction. > If you have a lot of data then make sure you run compaction on all nodes > before running repair. We had a big trouble with our system regarding > tom

Re: [BETA RELEASE] Apache Cassandra 1.2.0-beta2 released

2012-11-11 Thread Sylvain Lebresne
Actually, if we're going to be precise, it's -2^63 to 2^63 - 1. Long.MIN_VALUE is not a valid token for technical reasons. Do note that you can still not change partitioner, so the new partitioner is for new cluster. But that does mean that for existing ones you'll have to make sure you do keep Ra

Re: leveled compaction and tombstoned data

2012-11-11 Thread Sylvain Lebresne
On Sat, Nov 10, 2012 at 7:17 PM, Edward Capriolo wrote: > No it does not exist. Rob and I might start a donation page and give > the money to whoever is willing to code it. If someone would write a > tool that would split an sstable into 4 smaller sstables (even an > offline command line tool) S

Re: CREATE COLUMNFAMILY

2012-11-11 Thread Edward Capriolo
If you supply metadata cassandra can use it for several things. 1) It validates data on insertion 2) Helps display the information in human readable formats in tools like the CLI and sstabletojson 3) If you add a built-in secondary index the type information is needed, strings sort differently the

failed to create keyspace 1.2-beta2 bin protocol

2012-11-11 Thread Pierre Chalamet
Hi all, I'm trying to create a keyspace through the CQL Binary Protocol but lamely failed at doing this simple task with 1.2b2/cql3. Various command tried: DEBUG 18:08:23,240 Received: OPTIONS DEBUG 18:08:23,240 Responding: SUPPORTED {CQL_VERSION=[3.0.0], COMPRESSION=[snappy]} DEBUG 1

In REAME.txt : CQL3 instead of CQL2 ?

2012-11-11 Thread Jean-Armel Luce
Hello, I have installed the 1.2 beta2 (download source + compil) The CREATE SCHEMA fails if I do as explained in README.txt : bin/cqlsh --cql3<== --cql3 is the default in 1.2 so it is not needed Connected to Test Cluster at localhost:9160. [cqlsh 2.3.0 | Cassandra 1.2.0-beta2-SNAPSHOT | CQL

RE: failed to create keyspace 1.2-beta2 bin protocol

2012-11-11 Thread Pierre Chalamet
Forget about it, should have read https://github.com/apache/cassandra/blob/trunk/doc/cql3/CQL.textile instead of source snapshot (not merged in 1.2-b2 snapshot ?) - Pierre From: Pierre Chalamet [mailto:pie...@chalamet.net] Sent: Sunday, November 11, 2012 6:11 PM To: user@cassandra.apache.o

Re: Read during digest mismatch

2012-11-11 Thread Jonathan Ellis
Correct. Which is one reason there is a separate setting for cross-datacenter read repair, by the way. On Thu, Nov 8, 2012 at 4:43 PM, sankalp kohli wrote: > Hi, > Lets say I am reading with consistency TWO and my replication is 3. The > read is eligible for global read repair. It will send

RE: CREATE COLUMNFAMILY

2012-11-11 Thread Kevin Burton
Thank you this helps with my understanding. So the goal here is to supply as many name/type pairs as can be reasonably be foreseen when the column family is created? Can the metadata be applied after the fact? If so how? -Original Message- From: Edward Capriolo [mailto:edlinuxg...@gmail.

Re: Hinted Handoff runs every ten minutes

2012-11-11 Thread Jonathan Ellis
How many hint sstables are there? What does sstable2json show? On Thu, Nov 8, 2012 at 3:23 PM, Mike Heffner wrote: > Is there a ticket open for this for 1.1.6? > > We also noticed this after upgrading from 1.1.3 to 1.1.6. Every node runs a > 0 row hinted handoff every 10 minutes. N-1 nodes hint

Re: leveled compaction and tombstoned data

2012-11-11 Thread Radim Kolar
I would be careful with the patch that was referred to above, it hasn't been reviewed, and from a glance it appears that it will cause an infinite compaction loop if you get more than 4 SSTables at max size. it will, you need to setup max sstable size correctly.

RE: Connecting to cassandra.

2012-11-11 Thread Wz1975
For your testing,  I think put your machine's ip should work.  Thanks. -Wei Sent from my Samsung smartphone on AT&T Original message Subject: RE: Connecting to cassandra. From: Kevin Burton To: user@cassandra.apache.org CC: Thank you in the output.log I see the line:  

RE: Connecting to cassandra.

2012-11-11 Thread Kevin Burton
I finally got it to work by putting the putting “127.0.0.1” in the list of seed IPs. Any other address triggered the warning that Cassandra would not be auto-booted since it was listed as a seed machine and the init process never happened. I am not sure of the impact of setting it to this loopba

Re: Connecting to cassandra.

2012-11-11 Thread aaron morton
> warning that Cassandra would not be auto-booted since it was listed as a seed > machine and the init process never happened. The warning is that it wont join the ring and try to request data from other servers in the cluster. If you are testing a single node it's not an issue. > I am not s

Re: CREATE COLUMNFAMILY

2012-11-11 Thread aaron morton
Also most idomatic clients use the information so they can return the appropriate type to you. > Can the metadata be applied > after the fact? If so how? UPDATE COLUMN FAMILY in the CLI will let you change it. Note that we do not update the existing data. This can be a problem if you do somet

Re: Strange delay in query

2012-11-11 Thread aaron morton
If you have a long lived row with a lot of tombstones or overwrites, it's often more efficient to select a known list of columns. There are short circuits in the read path that can avoid older tombstones filled fragments of the row being read. (Obviously this is hard to do if you don't know the

Re: HugeTLB (Hugepage) Support on a Cassandra Cluster

2012-11-11 Thread aaron morton
Past discussion here http://www.mail-archive.com/user@cassandra.apache.org/msg08786.html Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 11/11/2012, at 4:51 PM, Jason Wee wrote: > option -XX:+UseLargePages ? > > > On Sat, Nov 10, 2012 a

RE: CREATE COLUMNFAMILY

2012-11-11 Thread Kevin Burton
What happens when you are mainly concerned about the human readable formats? Say initially you don't supply metadata for a key like foo in the column family, but you get tired of seeing binary data displayed for the values so you update the column family to get a more human readable format by addin

Re: CREATE COLUMNFAMILY

2012-11-11 Thread Jeremiah Jordan
That is fine. You just have to be careful that you haven't already inserted data which would be rejected by the type you update to, as a client will have issues reading that data back. -Jeremiah On Nov 11, 2012, at 4:09 PM, Kevin Burton wrote: > What happens when you are mainly concerned abo

Re: Multiple Clusters Keyspacse to one core cluster

2012-11-11 Thread B. Todd Burruss
with NetworkTopologyStrategy it theoretically should work http://www.datastax.com/docs/1.0/cluster_architecture/replication On Thu, Nov 8, 2012 at 5:11 PM, ws wrote: > If I have multiple clusters can I replicate a keyspace from each of those > cluster to separate cluster? > >

Re: removing SSTABLEs

2012-11-11 Thread Edward Capriolo
If you shutdown c* and remove an sstable (and it associated data, index, bloom filter , and etc) files it is safe. I would delete any saved caches as well. It is safe in the sense that Cassandra will start up with no issues, but you could be missing some data. On Sun, Nov 11, 2012 at 11:09 PM, B.

Re: In REAME.txt : CQL3 instead of CQL2 ?

2012-11-11 Thread Sylvain Lebresne
I've updated the readme, thanks On Sun, Nov 11, 2012 at 6:49 PM, Jean-Armel Luce wrote: > Hello, > > I have installed the 1.2 beta2 (download source + compil) > > The CREATE SCHEMA fails if I do as explained in README.txt : > > bin/cqlsh --cql3<== --cql3 is the default in 1.2 so it is not n

CF metadata syntax for an array

2012-11-11 Thread Kevin Burton
I am sorry if this is an FAQ. But I was wondering what the syntax for describing an array? I have gotten as far as feeling a need to understand a 'super-column' but I fail after that. Once I have the metadata in place to describe an array how do I insert data into the array? Get data from the arra

java.io.IOException: InvalidRequestException(why:Expected 8 or 0 byte long for date (4)) when inserting data to CF with compound key from pig

2012-11-11 Thread Шамим
Hello All, we are using pig (pig-0.10.0) to store some data in CF with compound key. Cassandra version is 1.1.15. Here is the script for creating CF CREATE TABLE clicks_c ( user_id varchar, time timestamp, url varchar, PRIMARY KEY (user_id, time) ) WITH COMPACT STORAGE; Here is descript