,
Pierre Fersing
De : Dmitry Konstantinov
Date : jeudi, 22 février 2024 à 20:39
À : user@cassandra.apache.org
Objet : Re: Cassandra 4.1 compaction thread no longer low priority (cpu nice)
Hi all,
I was not participating in the changes but I analyzed the question some time
ago from another side
open a bug for re-adding this feature / submit a PR ?
Regards,
Pierre Fersing
Cassandra is not very good at massive read/bulk read if you need to
retrieve and compute a large amount of data on multiple machines using
something like spark or hadoop (or you'll need to hack and process the
sstable directly, something which is not "natively" supported, you'll have
to hack your w
Hi,
So since, I upgraded to 2.2-rc2 I get the CASSANDRA-9643 warning :
WARN o.a.c.i.s.f.b.BigTableWriter - Compacting large partition bytes
Some of my partitions may have ~20 millions of rows, while others may have
only a few hundreds of rows. It may grow up to 300 millions of rows per
par
Hi,
3.x beta release date ?
2015-06-11 16:21 GMT+02:00 Jonathan Ellis :
> 3.1 is EOL as soon as 3.3 (the next bug fix release) comes out.
>
> On Thu, Jun 11, 2015 at 4:10 AM, Stefan Podkowinski <
> stefan.podkowin...@1und1.de> wrote:
>
>> > We are also extending our backwards compatibility polic
Hi,
I m streaming a big sstable using bulk loader of sstableloader but it's
very slow (3 Mbytes/sec) :
Summary statistics:
Connections per host: : 1
Total files transferred: : 1
Total bytes transferred: : 10357947484
Total duration (ms): : 3280229
Average
Hi,
Does anyone know if there is a more complete and up to date documentation about the sstable files
structure (data, index, stats etc.) than this one : http://wiki.apache.org/cassandra/ArchitectureSSTable
I'm looking for a full specification, with schema of the structure if possible.
Thanks
Hi Romain,
There is a stronger parallel with switft in the openstack world. But the
more evident parallel is with riak-cs for riak.
Cheers,
- pyr
On Thu, Mar 27, 2014 at 10:08 AM, Romain HARDOUIN wrote:
> It looks like MagnetoDB for CloudStack.
> Nice Clojure project.
>
>
&
Hi,
If you're already using cassandra for storing your data, you might be
interested in http://pithos.io which provides s3 compatibility. The
underlying schema splits files in several blocks, themselves being split in
chunks.
I'm looking forward to all your comments on the schema, code and of cou
x27;m planning to
submit for performing such task. If you are patient enough, you will be able to
get it in a few days. This requires cql 3 btw.
- Pierre
-Original Message-
From: "Kevin Burton"
Sent: 11/03/2013 15:25
To: "user@cassandra.apache.org"
Subject: Importin
I found this talk to be a good starting point to dive into the code:
http://blip.tv/datastax/cassandra-internals-5491363
On Wed, Jan 23, 2013 at 2:33 AM, Manu Zhang wrote:
> On Wed 23 Jan 2013 01:10:58 AM CST, Radek Gruchalski wrote:
>
>> Thank you. I found this but was hoping that there's anyt
l, it's v1 - there are still 0x7E more versions to get it better.
- Pierre
From: Theo Hultberg [mailto:t...@iconara.net]
Sent: Saturday, January 19, 2013 6:33 PM
To: user@cassandra.apache.org
Subject: Re: CQL3 Frame Length
Hi,
Another reason for keeping the frame length in the header is that new
Hello,
Executing a query using an invalid CL with binary protocol leads to an
invalid response streamId (always 0).
I've created following issue then:
https://issues.apache.org/jira/browse/CASSANDRA-5164
Thanks,
- Pierre
(127.0.0.1) restore back the tokens column.
Not sure it's the expected behavior. Found nothing in Jira, so I've created
https://issues.apache.org/jira/browse/CASSANDRA-5121
Thanks,
- Pierre
+
| 1 | ert | 693f5800-8acb-11e3-82e0-3f484de45426 |
+---+-+--+
| 1 | opl | d4815800-2d8d-11e0-82e0-3f484de45426 |
+---+-+--+
Looks like there is something weird happening when creating the table.
- Pierre
-Origin
You can use an approach with two CFs
The first one would be
ExpiredCF
| -- File = Key
|-- Reversed(TimeUUID) (representing) last change
In this CF, each entry is expired (after a day, an hour, whatever)
EventualCF
|-- File = Key
|-- String
Storing a file update for a key 'K' at a time
OK, so great news, it is now possible to do in CQL with the following
syntax, as per CASSANDRA-4179
CREATE TABLE foo (
host text,
service text,
metric int,
PRIMARY KEY ((host,service)));
(note the double parentheses).
This will effectively create a CF whose row key is a composite type.
only ONE internal column / cell, the shipname
> * the internal column / cell "shipname" is a composite of the *value* of
> time_seen. e.g.
>
> Hope that helps.
>
>
> -
> Aaron Morton
> Freelance Cassandra Developer
> New Zealand
>
>
Is there still a way to have composite row keys ?
There are times when you want to partition wide rows by a tuple instead of
pushing the composites into column names.
Lists could do the trick but would not allow multiple types and aren't
allowed as primary keys anyhow.
At some point I remember se
there are some bugs hanging around, so feel free to fill
issues/improvements at http://code.google.com/p/cassandra-sharp/issues/list.
Hope you will enjoy it !
- 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
BUG 18:08:23,357 request complete
DEBUG 18:08:23,357 Responding: ERROR SYNTAX_ERROR: line 1:89 mismatched
input 'replication_factor' expecting set null
But nothing seems to work as expected.
Could someone point me how to create a keyspace under CQL 3 using binary
protocol (don't know if binary protocol changes things on this anyway) ?
Thanks a lot,
- Pierre
notified of mutations (ie: not query). Some peoples on this ML are involved in
this, maybe they could help on this.
Cheers,
- Pierre
-Original Message-
From: Oliver Plohmann
Date: Sun, 12 Aug 2012 21:24:43
To:
Reply-To: user@cassandra.apache.org
Subject: Loading data on-demand in Cassandra
On Sat, Jul 28, 2012 at 10:46 PM, Ertio Lew wrote:
> Is it possible to set Replication Factor on per column family basis so that
> I can avoid replicating large text data or other not-so-important data in
> CFs with low RF?
>
> I use hector API.
Replication factor is keyspace bound, not CF bound.
writes:
>> restoring a counter column family. I have two questions related to
>> this:
>>
>> a) how does that setting affect C* in a non-restoring start?
renew_counter_id regenerates a new "NodeId" for the cassandra VM which
is used to keep track of the counter shards the node holds. If you
writes:
> De : Pierre-Yves Ritschard [mailto:p...@spootnik.org]
>> Snapshot and restores are great for point in time recovery. There's no
>> particular side-effect if you're willing to accept the downtime.
>
> Are you sure? The system KS has no book-keeping abo
writes:
> One of the scenarios I have to have in account for a small Cassandra
> cluster (N=4) is
> restoring the data back in time. I will have full backups for 15 days, and
> it's possible
> that I will need to restore, let's say, the data from 10 days ago (don't ask,
> I'm not
> going in
initely still wouldn't be
"experimenting" with this old version in 2012.
=Rob
--
=Robert Coli
AIM>ALK - rc...@palominodb.com
YAHOO - rcoli.palominob
SKYPE - rcoli_palominodb
- Pierre
on etc when I get it up again.
I apologize if this was asked before, but I did not see a clear guide
for achieving something like this.
Can someone please help?
Thank you
- Pierre
Hi,
It's normal.
Keys to replicas are determined with a hash (md5) when using the random
partitionner (which you are using I guess).
You probably want to switch to the order preserving partionner or tweak your
data model in order to rely on 2nd index for such filtering.
- P
Your datacenter is 'datacenter1' not 'DC1'.
- Pierre
-Original Message-
From: Cyril Auburtin
Date: Sat, 26 May 2012 16:51:38
To:
Reply-To: user@cassandra.apache.org
Subject: Re: NetworkTopologyStrategy with 1 node
Here is what happen with 2 cassandra nodes
This looks like CASSANDRA-4201 where map() was failing with oom under 32
bits jvm.
Jonathan provided a patch for that. You can apply it on top of 1.1.
- Pierre
From: cyril auburtin [mailto:cyril.aubur...@gmail.com]
Sent: mardi 8 mai 2012 08:56
To: user@cassandra.apache.org
Subject: Re
create column family Post with comparator=UTF8Type and
colum_metadata=[{column_name : user, validation_class : UTF8Type}] and
comment='bla';
- Pierre
From: cyril auburtin [mailto:cyril.aubur...@gmail.com]
Sent: dimanche 6 mai 2012 13:10
To: user@cassandra.apache.org
Subject: [
_in_mb.
You will probably need to change the caching properties on CF with ALL or
ROWS_ONLY if you want to enable rows caching. Something like this:
create column family Application with caching='ALL';
By default, only keys are cached.
- Pierre
From: cyril auburtin [mailto:cyril.au
Hi,
I bet you are using cql commands in cassandra-cli.
If you are using cli, use instead:
create keyspace Excelsior with placement_strategy='SimpleStrategy' and
strategy_options = [{replication_factor:1}]
From: cyril auburtin [mailto:cyril.aubur...@gmail.com]
Sent: Sunday, May 06,
Sure, here it is : CASSANDRA-4210.
- Pierre
-Original Message-
From: Sylvain Lebresne [mailto:sylv...@datastax.com]
Sent: mercredi 2 mai 2012 09:53
To: user@cassandra.apache.org
Subject: Re: execute_prepared_cql_query and variable range filter parameter
Pierre: do you mind opening an
y in (?, ?)” [è select * from Town where key in
('Paris', 'London')].
In that case, I must prepare the statement again, losing the benefit of prepare.
Maybe there is another way to avoid preparing again ?
Thanks,
- Pierre
From: paul cannon [mailto:
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
ean, if several values are required for '?' then I have to rewrite the
query using several jokers.
My problem is that this defeats statement preparation (using
prepare_cql_query).
Maybe there is a way to bind an array of values to a single command joker ?
Thanks !
- Pierre
just executing the 3 commands
through the cli after the node started makes it crash (and running out of
memory).
I can upgrade my JVM but this one was OK with 0.8 and 1.0.
- Pierre
map0(Native Method)
... 7 more
INFO 09:31:57,116 Stop listening to thrift clients
INFO 09:31:57,117 Waiting for messaging service to quiesce
INFO 09:31:57,136 MessagingService shutting down server thread.
Is this a known issue ?
Thanks,
- Pierre
Another tentative : try using TFramedTransport with an instance of TSocket
directly.
- Pierre
-Original Message-
From: puneet loya
Date: Tue, 10 Apr 2012 11:06:22
To:
Reply-To: user@cassandra.apache.org
Subject: Re: cassandra and .net
hi,
sorry i posted the port as 7000. I m
hello,
9160 is probably the port to use if you use the default config.
- Pierre
On Apr 10, 2012, at 7:26 AM, puneet loya wrote:
> using System;
> using System.Collections.Generic;
> using System.Linq;
> using System.Text;
> using Thrift.Collections;
> using Thrift
.
- Pierre
Hi,
I need to attach a virtual DC to an existing cluster. My existing
cluster uses the Ec2Snitch as endpoint_snitch in cassandra.yaml.
Since both my clusters will live in the same AZ in AWS, it seems as
though my best bet is to switch to a property file snitch to divide.
A couple of questions:
*
The FAQ page on ubuntu has valid pointers:
http://wiki.apache.org/cassandra/FAQ#ubuntu_hangs
On Tue, Feb 21, 2012 at 9:10 PM, Aditya Gupta wrote:
> @Edward: That's nice to know, but I also heard that there are some bugs in
> some recent Ubuntu version that bubble up with Cassandra specifically, s
sorry for not doing my homework properly:
http://wiki.apache.org/cassandra/FAQ#ubuntu_hangs
On Fri, Feb 17, 2012 at 2:00 PM, Pierre-Yves Ritschard
wrote:
> Hi,
>
> I've experienced several node lock-ups on EC2 instances. I'm running
> with the following set-up:
>
> h
Hi,
I've experienced several node lock-ups on EC2 instances. I'm running
with the following set-up:
heap-new: 800M
max-heap: 8G
instance type: m2.xlarge
java is
java version "1.6.0_26"
Java(TM) SE Runtime Environment (build 1.6.0_26-b03)
Java HotSpot(TM) 64-Bit Server VM (build 20.1-b02, mixed m
In this case, you have one query predicate that operates on a much
lower range (years) you could use it as the row key and issue a
multigetslicequery where you set all row keys and specify the slice
you're interested in (here: 2001 2002 2003, then >= "A", < "D")
On Fri, Feb 17, 2012 at 11:46 AM,
Can you elaborate on the composite types instabilities ? is this
specific to hector as the radim's posts suggests ?
These one liner answers are quite stressful :)
On Thu, Jan 26, 2012 at 1:28 PM, Carlo Pires wrote:
> If you need to use composite types and create/drop column families on the
> fly
I was under the impression that Opscenter was only compatible with the DataStax
version of Cassandra.
I'll give that a shot :)
Thank you.
On 2011-12-23, at 6:49 PM, Jeremy Hanna wrote:
> One way to get a good bird's eye view of the cluster would be to install
> DataStax Opscenter - the commu
I just imported a lot of data in a 9 node Cassandra cluster and before I create
a new ColumnFamily with even more data, I'd like to be able to determine how
full my cluster currently is (in terms of memory usage). I'm not too sure what
I need to look at. I don't want to import another 20-30GB of
A couple of nodes per month, but with peaks.
I will test the nodetool move based scenario then.
Cheers,
- pyr
On Wed, Dec 21, 2011 at 10:10 PM, aaron morton wrote:
> How often is "relatively often" ?
>
> * having a fixed amount of nodes with initial tokens and letting new
> ones auto bootstr
0.8.8 has been released last week:
http://cassandra.apache.org/download/
https://svn.apache.org/repos/asf/cassandra/tags/cassandra-0.8.8/CHANGES.txt
Cheers,
- Pierre
-Original Message-
From: Maxim Potekhin [mailto:potek...@bnl.gov]
Sent: vendredi 9 décembre 2011 22:37
To: user
Thanks.
Anyone else to share his production version and some feedbacks ?
- Pierre
-Original Message-
From: Jahangir Mohammed
Date: Tue, 6 Dec 2011 17:36:37
To:
Reply-To: user@cassandra.apache.org
Subject: Re: cassandra most stable version ?
We are running 0.8.7. No big issues so
what version are you running in production ? What kinds of problems do
you encounter if any ?
Thanks,
- Pierre
Hello,
Is this bug serious enough for 1.0.6 to come out shortly or not?
Thank you,
PBR
On Thu, Dec 1, 2011 at 6:05 PM, Zhong Li wrote:
> After upgrade to 1.0.5 RangeSlice got timeout. Ticket
> https://issues.apache.org/jira/browse/CASSANDRA-3551
>
> On Dec 1, 2011, at 5:43 PM, Evgeniy Ryabits
I do not want to use HBase because Cassandra is way far easier to deploy and
it is working pretty well - and for the 99% of our apps the model fits
perfectly. The other 1% has a workaround by ordering writes. I assume the
trade off anyway :)
Don't miss the point: I love Cassandra and the way it wo
>>- support for atomic operations or batches (if QUORUM fails, data should
not be visible with ONE)
>zookeeper is solving that.
Yeah, I can use HBase too.
I might have screwed up a little bit since I didn't talk about isolation;
let's reformulate: support for read committed (using DB terminolog
I missed
something.
- Pierre
-Original Message-
From: Jonathan Ellis [mailto:jbel...@gmail.com]
Sent: mercredi 2 novembre 2011 00:00
To: user
Subject: Second Cassandra users survey
Hi all,
Two years ago I asked for Cassandra use cases and feature requests.
[1] The results [2] have been
Thanks for the answer.
- Pierre
-Original Message-
From: Yi Yang
Date: Thu, 20 Oct 2011 04:20:25
To: ;
Subject: Re: SimpleAuthenticator / SimpleAuthorization missing
See:
https://issues.apache.org/jira/browse/CASSANDRA-2922
On Thu, Oct 20, 2011 at 4:08 AM, Pierre Chalamet wrote
Hello,
SimpleAuthenticator & SimpleAuthorization just disappear in release 1.0.0...
Will this stay like this or is it a release bug ?
Thanks,
- Pierre
Unfortunately there's no way to do this in Cassandra right now, except
by using another row as index, like you're doing right now.
Of course you could also store by source_id.date and have a batch job
iterate over all sources to compute the top 100. It would not be real
time any more though.
-
I will look at that to understand the behavior of ONE with NTS.
Thanks.
- Pierre
-Original Message-
From: aaron morton
Date: Fri, 16 Sep 2011 10:11:30
To:
Reply-To: user@cassandra.apache.org
Subject: Re: Get CL ONE / NTS
> What I’m missing is a clear behavior for CL.ONE. I’m uns
've
landed in ReadCallback.java but error handling is out of my reach for the
moment.
Thanks,
- Pierre
From: aaron morton [mailto:aa...@thelastpickle.com]
Sent: Thursday, September 15, 2011 12:27 AM
To: user@cassandra.apache.org
Subject: Re: Get CL ONE / NTS
Are you advising CL.ONE
inclined to use
CL.ONE for read if possible.
Thanks,
- Pierre
-Original Message-
From: aaron morton [mailto:aa...@thelastpickle.com]
Sent: Wednesday, September 14, 2011 11:48 PM
To: user@cassandra.apache.org; pie...@chalamet.net
Subject: Re: Get CL ONE / NTS
Your current approach to Consis
l servers tell they do not
have the data ?
It seems to depend on RR as in 3/
Are the answers right ?
- Pierre
-Original Message-
From: Pierre Chalamet [mailto:pie...@chalamet.net]
Sent: Wednesday, September 14, 2011 3:33 PM
To: user@cassandra.apache.org
Subject: Get CL ONE / NTS
Hello,
the
data ?
Thanks a lot,
- Pierre
wse/CASSANDRA-2549 is open to fix this
>
> On Tue, Apr 26, 2011 at 9:41 AM, Pierre-Yves Ritschard
> wrote:
> >
> > On ven., 2011-04-22 at 16:49 -0500, Eric Evans wrote:
> >> I am pleased to announce the release of Apache Cassandra 0.8.0 beta1.
> >>
> >
>
Thanks Jonathan,
Should I repackage myself or do you think updated Debian packages will
be made available shortly ?
Regards,
- pyr
On mar., 2011-04-26 at 11:47 -0500, Jonathan Ellis wrote:
> https://issues.apache.org/jira/browse/CASSANDRA-2549 is open to fix this
>
On ven., 2011-04-22 at 16:49 -0500, Eric Evans wrote:
> I am pleased to announce the release of Apache Cassandra 0.8.0 beta1.
>
Hi,
First of all thanks for this release, here are a few annoyances I
spotted while trying it out the published debian packages:
The cassandra-env.sh is ran by /bin/
Am 14.04.2010 15:22, schrieb Ted Zlatanov:
On Wed, 14 Apr 2010 15:02:29 +0200 "Jean-Pierre Bergamin"
wrote:
JB> The metrics are stored together with a timestamp. The queries we want to
JB> perform are:
JB> * The last value of a specific metric of a device
JB> * Th
Hello everyone
We are currently evaluating a new DB system (replacing MySQL) to store
massive amounts of time-series data. The data are various metrics from
various network and IT devices and systems. Metrics i.e. could be CPU usage
of the server "xy" in percent, memory usage of server "xy" in MB,
73 matches
Mail list logo
