Hi,
I created a very simple CRUD operation using Cassandra CQL C-sharp driver.
If somebody is interested, please try it out and feedback / comments are
welcome.
https://github.com/muralidharand/cassandra-CQL-csharp-driver-sample
--
Thanks,
Murali
> Can he not specify all 256 tokens in the YAML of the new cluster
> and then copy sstables?
> I know it is a bit ugly but should work.
You can pass a comma separated list of tokens to the -Dcassandra.replace_token
JVM param.
AFAIK it's not possible to provide the list in the yaml
It's available on the Thrift API call describe_keyspaces()
https://github.com/apache/cassandra/blob/trunk/interface/cassandra.thrift#L730
Cheers
-
Aaron Morton
Cassandra Consultant
New Zealand
@aaronmorton
http://www.thelastpickle.com
On 11/07/2013, at 7:04 AM, Robert Coli wro
> But when I run the same query with consistency level as Quorum, it is taking
> ~2.3 seconds. It feels as if querying of the nodes are in sequence.
No.
As Sankalp says look for GC issues. If none then take a look at how much data
you are pulling back, and tell us what sort of query you are
My bet is that you're hitting
https://issues.apache.org/jira/browse/CASSANDRA-5677.
--
Sylvain
On Fri, Jul 12, 2013 at 8:17 AM, Paul Ingalls wrote:
> I'm running into a problem trying to read data from a column family that
> includes a number of collections.
>
> Cluster details:
> 4 nodes runn
> We are starting to think we are going to try to run a side by side cassandra
> instance in production while we map/reduce from one cassandra into the new
> instance.
What do you mean by "side-by-side" ?
> Can I assume a cassandra instance will not only bind to the new ports when I
> change
That sounds sane to me. Couple of caveats:
* Remember that Expiring Columns turn into Tombstones and can only be purged
after TTL and gc_grace.
* Tombstones will only be purged if all fragments of a row are in the
SStable(s) being compacted.
Cheers
-
Aaron Morton
Cassandra C
> The “ALLOW FILTERING” clause also has no effect.
You only need that when the WHERE clause contains predicates for columns that
are not part of the primary key.
> CREATE INDEX ON conv_msgdata_by_participant_cql(msgReadFlag);
On general this is a bad idea in Cassandra (also in a relational DB IM
thanks aaron, the second point I had not considered, and it could explain
why the sstables don't always disapear completely, sometimes a small file
(but megabytes instead of gigabytes) is left behind.
T#
On Fri, Jul 12, 2013 at 10:25 AM, aaron morton wrote:
> That sounds sane to me. Couple of c
Hi experts,
How to extract meta-data of a table or a keyspace using CQL 3.0?
--
Thanks,
Murali
The "raw" answer is that you should query the system tables. The schema is
stored in the 3 following tables: System.schema_keyspaces,
System.schema_columnfamilies and System.schema_columns. Unfortunately, the
information stored in there is, for different reasons, not in a form that
makes
a lot of s
there's a keyspace called system which has a few tables that contain the
metadata. for example schema_keyspaces that contain keyspace metadata, and
schema_columnfamilies that contain table metadata. there are more, just
fire up cqlsh and do a describe keyspace in the system keyspace to find
them.
with some very little work (less then 10 KB of code) is possible to have
online sstable splitter and exported this functionality over JMX.
Earlier, everything was working fine but now i am getting this strange
error.
Initially i was working via tarball installation and did install a
Cassandra rpm package.
Since then, i am getting
"Error: Main method not found in class
org.apache.cassandra.service.CassandraDaemon, please define the ma
The Cassandra team is pleased to announce the release of the first beta for
the future Apache Cassandra 2.0.0.
Let me first stress that this is beta software and as such is *not* ready
for
production use.
The goal of this release is to give a preview of what will become Cassandra
2.0 and to get w
Heh, oops, yes, We have 12 nodes and are trying to run 2 instances of cassandra
on those 12 nodes. So far, in QA this appears to be working. I like
clustername change idea as a just in case so I will definitely be doing that
one.
Thanks,
Dean
From: aaron morton mailto:aa...@thelastpickle.com>
Hi All,
Can anyone explain the compression ratio?
Is it the "compressed data / original" or "original/ compressed" ? Or
something else.
thanks a lot.
Best Regards,
Cem
A basic question and it seems that I have a gap in my understanding.
I have a simple table in Cassandra with multiple column families. I add new
columns to each of these column families on the fly. When I view (using the
'DESCRIBE table' command) the schema of a particular column family, I see
onl
Not sure if it's the best/intended behavior, but you should see it go back
to 100% if you run: nodetool -h 127.0.0.1 -p 8080 ring .
I think the rationale for showing 33% is that different keyspaces might
have different RFs, so it's unclear what to show for ownership. However, if
you include the ke
it's compressed/original.
https://github.com/apache/cassandra/blob/cassandra-1.1.11/src/java/org/apache/cassandra/io/sstable/SSTableMetadata.java#L124
On Fri, Jul 12, 2013 at 10:02 AM, cem wrote:
> Hi All,
>
> Can anyone explain the compression ratio?
>
> Is it the "compressed data / original" o
Thank you very much!
On Fri, Jul 12, 2013 at 5:59 PM, Yuki Morishita wrote:
> it's compressed/original.
>
>
> https://github.com/apache/cassandra/blob/cassandra-1.1.11/src/java/org/apache/cassandra/io/sstable/SSTableMetadata.java#L124
>
> On Fri, Jul 12, 2013 at 10:02 AM, cem wrote:
> > Hi All
More than the DC, I think you will be bound by number of replicas. I dont
know how it will work in case of 10-20 replication factor specially for
range queries.
On Thu, Jul 11, 2013 at 7:14 PM, Blair Zajac wrote:
> In this C* Summit 2013 talk titled "A Deep Dive Into How Cassandra
> Resolves I
Je suis absent(e) du bureau jusqu'au 07/08/2013
Remarque : ceci est une réponse automatique à votre message "Compression
ratio" envoyé le 12/07/2013 17:02:11.
C'est la seule notification que vous recevrez pendant l'absence de cette
personne.
Yes, there's going to be a lot of replicas in total, but the replication factor
will be 3 in each DC. Will it still be an issue?
Blair
On Jul 12, 2013, at 10:58 AM, sankalp kohli wrote:
> More than the DC, I think you will be bound by number of replicas. I dont
> know how it will work in ca
Yep, that was it. I built from the cassandra 1.2 branch and no more timeouts.
Thanks for getting that fix into 1.2!
Paul
On Jul 12, 2013, at 1:20 AM, Sylvain Lebresne wrote:
> My bet is that you're hitting
> https://issues.apache.org/jira/browse/CASSANDRA-5677.
>
> --
> Sylvain
>
>
>
Having a real issue where at the completion of large compactions, it will
evict hot sstables from the kernel page cache causing huge read latency
while it is backfilled.
https://dl.dropboxusercontent.com/s/149h7ssru0dapkg/Screen%20Shot%202013-07-12%20at%201.46.19%20PM.png
Blue line - page cache
G
On Thu, Jul 11, 2013 at 9:43 PM, Takenori Sato wrote:
> I made the repository public. Now you can checkout from here.
>
> https://github.com/cloudian/support-tools
>
> checksstablegarbage is the tool.
>
> Enjoy, and any feedback is welcome.
>
Thanks very much, useful tool!
Out of curiousity, wh
If you're creating dynamic columns via Thrift interface, they will not be
reflected in the CQL3 schema. I would recommend not mixing paradigms like
that, either stick with CQL3 or Thrift / cassandra-cli. With compact
storage creates column families which can be interacted with meaningfully
via Th
Dear Cassandra experts,
I have an HP Proliant ML350 G8 server, and I want to put virtual
servers on it. I would like to put the maximum number of nodes
for a Cassandra + Hadoop cluster. I was wondering - what is the
minimum RAM and memory per node I that I need to have Cassandra + Hadoop
before th
Thanks Eric for the explanation.
Regards,
Shahab
On Fri, Jul 12, 2013 at 11:13 AM, Shahab Yunus wrote:
> A basic question and it seems that I have a gap in my understanding.
>
> I have a simple table in Cassandra with multiple column families. I add
> new columns to each of these column familie
its possible to change num_tokens on node with data?
i changed it and restarted node but it still has same amount in nodetool
status.
It's light. Without -v option, you can even run it against just a SSTable
file without needing the whole Cassandra installation.
- Takenori
On Sat, Jul 13, 2013 at 6:18 AM, Robert Coli wrote:
> On Thu, Jul 11, 2013 at 9:43 PM, Takenori Sato wrote:
>
>> I made the repository public. Now you ca
Hello Rob,
Thanks for the pointer. I have a couple of queries:
>How does this project compare to the KairosDb project on github ( For one
>I see that Rhombus supports multi column query which is cool whereas
>kairos time series DB/OpenTSDB do not seem to have such a feature -
>although we can use
33 matches
Mail list logo
