Hi,
I have a columnfamily like that:
CREATE COLUMN FAMILY Clients
WITH key_validation_class = 'CompositeType(LexicalUUIDType,UTF8Type)'
AND comparator = LexicalUUIDType
AND column_metadata = [
{column_name: name, validation_class: UTF8Type}
];
My metadata definition i
Hi Aaron,
No, I just avoid truncating for the moment L (I'm adding CQL prepared
statement to Cassandra-Sharp).
It's a bit strange anyway, JVM options are:
set JAVA_OPTS=-ea^
-javaagent:"%CASSANDRA_HOME%\lib\jamm-0.2.5.jar"^
-Xms1G^
-Xmx1G^
-XX:+HeapDumpOnOutOfMemoryError^
-XX:+UseParN
Hi Aaron,
Thank you for your answer, I was beginning to think that my question would
never be answered ;-)
Actually, this is what I was going for, except one thing, instead of
partitioning row per month, I though about partitioning per day, like that
everyday I launch the cleaning tool, and it
On Mon, Apr 30, 2012 at 4:25 PM, Morgan Segalis wrote:
> Hi Aaron,
>
> Thank you for your answer, I was beginning to think that my question would
> never be answered ;-)
>
> Actually, this is what I was going for, except one thing, instead of
> partitioning row per month, I though about partition
Hi Samal,
Thanks for the TTL feature, I wasn't aware of it's existence.
Day's partitioning will be less wider than month partitionning (about 30 times
less give or take ;-) )
Per day it should have something like 100 000 messages stored, most of it would
be retrieved so deleted before the TTL f
On Mon, Apr 30, 2012 at 5:52 PM, Morgan Segalis wrote:
> Hi Samal,
>
> Thanks for the TTL feature, I wasn't aware of it's existence.
>
> Day's partitioning will be less wider than month partitionning (about 30
> times less give or take ;-) )
> Per day it should have something like 100 000 message
Don't use dates or datestamps as the buckets for your row keys, use a unix
timestamp modulo whatever size you want your bucket to be instead.
Timestamps don't involve time zones or any of that nonsense.
So, instead of having keys like "user1uuid_30042012", the second half would
be replaced the cur
Hi,
We have a cassandra cluster in ec2.
If i stop a node and start it - as a result the node ip changes. The
node is recognised as NEW node and is declared as replacing the previous
node with same token.(But this is the same node of course)
In this specific case the node ip before stop/star
Isn't kafka too young for production using purpose ?
Clearly that would fit much better my needs but I can't afford early stage
project not ready for production. Is it ?
Le 30 avr. 2012 à 14:28, samal a écrit :
>
>
> On Mon, Apr 30, 2012 at 5:52 PM, Morgan Segalis wrote:
> Hi Samal,
>
> Th
thanks tyler for reply.
are you saying user1uuid_*{ts%86400}* would lead to unique day bucket
which will be timezone {NZ to US} independent? I will try.
On Mon, Apr 30, 2012 at 8:25 PM, Tyler Hobbs wrote:
> Don't use dates or datestamps as the buckets for your row keys, use a unix
> timestamp
Correct, that's exactly what I'm saying.
On Mon, Apr 30, 2012 at 10:37 AM, samal wrote:
> thanks tyler for reply.
>
> are you saying user1uuid_*{ts%86400}* would lead to unique day bucket
> which will be timezone {NZ to US} independent? I will try.
>
>
> On Mon, Apr 30, 2012 at 8:25 PM, Tyler H
I did it with node.js but it is changing after some interval.
setInterval(function(){
var d =new Date().getTime();
console.log("== ");
console.log("unix => ",d);
i=parseInt(d)
console.log("Divid i/86400=> ",i/86400);
console.log("Modulo i%86400=> ",i%8640
getTime() returns the number of milliseconds since the epoch, not the
number of seconds: http://www.w3schools.com/jsref/jsref_gettime.asp
If you divide that number by 1000, it should work.
On Mon, Apr 30, 2012 at 11:28 AM, samal wrote:
> I did it with node.js but it is changing after some inter
thanks I didn't noticed.
run script for 5 minutes => divide seems to produce result ,modulo is
still changing. If divide is ok will do the trick.
I will run this script on Singapore, East coast server, and New delhi
server whole night today.
==
unix => 133580698
Err, sorry, I should have said ts - (ts % 86400). Integer division does
something similar.
On Mon, Apr 30, 2012 at 12:39 PM, samal wrote:
> thanks I didn't noticed.
> run script for 5 minutes => divide seems to produce result ,modulo is
> still changing. If divide is ok will do the trick.
> I
When you set comparator = LexicalUUIDType, you're saying that column names
are UUIDs. In your column metadata, you need to use a UUID for column_name
if that's what you want.
I suspect that you either don't want LexicalUUIDType for your column names
or you're looking for default_validation_class,
hhmm. I will try both. thanks
On Mon, Apr 30, 2012 at 11:29 PM, Tyler Hobbs wrote:
> Err, sorry, I should have said ts - (ts % 86400). Integer division does
> something similar.
>
>
> On Mon, Apr 30, 2012 at 12:39 PM, samal wrote:
>
>> thanks I didn't noticed.
>> run script for 5 minutes => d
Hi Aaron,
it's still an issue. However it's difficult to reproduce because I'd
need to insert data to Cassandra for day or more which is not
possible.
I think the problem is somehow connected to an IntegerType secondary
index. I had a different problem with CF with two secondary indexes,
the firs
When the server starts it reads the SSTables then applies the Commit Logs.
There is nothing you need to do other than leave the commit logs where they
are.
Cheers
-
Aaron Morton
Freelance Developer
@aaronmorton
http://www.thelastpickle.com
On 30/04/2012, at 6:02 PM, Roshan wr
Try upgrading to the newest JVM first. Can you also say what version you were
using ?
If you still get the problem create a ticket on
https://issues.apache.org/jira/browse/CASSANDRA with the steps to reproduce.
Please include the OS version, RAM size, JVM information,
commit_log_segment_size
Hi all,
Is there a support in Cassandra 1.1 for variable range filter parameter
(sorry I can't find a right name for that):
select * from TestCF where key in (?)
using execute_prepared_cql_query ?
In the query above, it seems I can only bind one value to '?'.
I mean, if several values
JVM is the latest available after all.
Filled CASSANDRA-4201.
Thanks,
- Pierre
From: aaron morton [mailto:aa...@thelastpickle.com]
Sent: lundi 30 avril 2012 22:36
To: user@cassandra.apache.org
Subject: Re: Crash by truncate with cassandra 1.1
Try upgrading to the newest JVM first. Ca
Hi Pierre-
Yes, each ? can only represent one value at a time (although it can take on
a different value for each actual execution of the prepared query). This is
certainly normal for SQL binding libraries. Not sure why you feel that
defeats statement preparation.
p
On Mon, Apr 30, 2012 at 3:45
If I prepare “select * from Town where key in (?)”
I will be able to bind ? to 'Paris' for example [è select * from Town where key
in ('Paris')].
If I want to query for 'Paris' and 'London', the query should be restated to
“select * from Town where key in (?, ?)” [è select * from Town where
Many Thanks Aaron.
According to the datastax restore documentation, they ask to remove the
commitlogs before restoring (Clear all files the
/var/lib/cassandra/commitlog (by default)).
In that case better not to follow this step in a server rash situation.
Thanks
/Roshan
--
View this message
David Strauss davidstrauss.net> writes:
>
> It's not, currently, but I'm happy to answer questions about its architecture.
>
David,
Has your cassandraFS / WebDav software made it into the light of open source?
Does yo integrate into other systems for user info, and simply store data in
Ca
Hello group,
I'm a new Cassandra and Java user so I'm still trying to get my head around a
few things. If you've disabled swap on a machine what is the reason to use
JNA? A second question is doesn't JNA break the Java inherent security
mechanisms by allowing access to direct system calls out
Gossip information about a node can stay in the cluster for up to 3 days. How
long has this been going on for ?
I'm unsure if this is expected behaviour. But it sounds like Gossip is kicking
out the phantom node correctly.
Can you use nodetool gossipinfo on the nodes to capture some artefacts
> Isn't kafka too young for production using purpose ?
The best way to advance the project is to use it and contribute your experience
and time.
btw, checking out kafka is a great idea. There are people around having Fun
Times with Kafka in production
Cheers
-
Aaron Morton
Fre
The schema for the user defined CF's should not matter. The exceptions has to
do with compacting the HintedHandoff CF.
With regard to the failed read, is this happening at CL QUOURM ?
Can you remember if the assertion was raised while the cluster was still under
load ?
Cheers
--
Can you provide a link to that page ?
Cheers
-
Aaron Morton
Freelance Developer
@aaronmorton
http://www.thelastpickle.com
On 1/05/2012, at 10:12 AM, Roshan wrote:
> Many Thanks Aaron.
>
> According to the datastax restore documentation, they ask to remove the
> commitlogs befor
> If you've disabled swap on a machine what is the reason to use JNA?
JNA will still be used to efficiently make hard links for snapshots. It's not
necessary to lock the JVM memory when swap is disabled.
> A second question is doesn't JNA break the Java inherent security mechanisms
> by allowin
On Mon, Apr 30, 2012 at 2:11 PM, Patrik Modesto
wrote:
> I think the problem is somehow connected to an IntegerType secondary
> index.
Could be, but my money is on the supercolumns in the HH data model.
Can you create a jira ticket?
--
Jonathan Ellis
Project Chair, Apache Cassandra
co-founder
On Mon, Apr 30, 2012 at 7:49 PM, Cord MacLeod wrote:
> Hello group,
>
> I'm a new Cassandra and Java user so I'm still trying to get my head around a
> few things. If you've disabled swap on a machine what is the reason to use
> JNA?
Faster snapshots, giving hints to the page cache with fadvis
Incremental snapshots contain only new data, so they are *much* smaller.
On Mon, Apr 30, 2012 at 12:39 AM, Tamar Fraenkel wrote:
> Hi!
> I wonder what are the advantages of doing incremental snapshot over non
> incremental?
> Are the snapshots smaller is size? Are there any other implications?
>
The documentation in the cassandra.yaml file covers this pretty well.
In summary, a snapshot will create a hard link for each file in the data
directory (if JNA is installed and on the classpath).
Turning on incremental backup will create a hard link to every new SSTable
that is flushed out to di
That should work. I don't see anything obviously wrong with your
query, other than the trivial (ascii values need to be quoted).
Assuming that's not the problem, please file a ticket if you have a
failing test case.
On Fri, Apr 20, 2012 at 11:59 PM, Nagaraj J wrote:
> Hi
>
> cql 3 for wide rows
http://www.datastax.com/docs/1.0/operations/backup_restore
--
View this message in context:
http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Cassandra-backup-queston-regarding-commitlogs-tp7508823p7515679.html
Sent from the cassandra-u...@incubator.apache.org mailing list archive
CQL doesn't currently let you filter on columns which aren't part of a
primary key or indexed, so the "and x=2 and z=2" part of your query is not
valid.
p
On Mon, Apr 30, 2012 at 8:54 PM, Jonathan Ellis wrote:
> That should work. I don't see anything obviously wrong with your
> query, other th
No, there isn't right now. But note that there shouldn't be a whole lot of
performance difference between
select * from Town where key in ('Paris', 'London');
and
select * from Town where key = 'Paris';
select * from Town where key = 'London';
..other than round-trip times. Or, I
Thanks for posting the script.
I see that the snapshot is always a full one, and if I understand
correctly, it replaces the old snapshot on S3. Am I right?
*Tamar Fraenkel *
Senior Software Engineer, TOK Media
[image: Inline image 1]
ta...@tok-media.com
Tel: +972 2 6409736
Mob: +972 54 835649
Hi Aaron,
Below is the reposted gossipinfo on a fresh 6 node cluster for which I
stop/started all nodes one by one ~12hours ago,
As you can see gossipinfo reports on 11 nodes, but what bothers me is
why it reports STATUS:NORMAL for all of them
and decides that non existing node is UP just o
42 matches
Mail list logo
