This morning I have
nodetool ring -h localhost
Address DC RackStatus State LoadOwns
Token
113427455640312821154458202477256070485
10.34.158.33us-east 1c Up Normal 5.78 MB
33.33% 0
10.38.175.131 us-east 1c Up
No the clients are fixed However sometimes the queries can be huge like this.
To summarize I will have the following in my TODO list to rectify this:
Try reducing the batch commit size.
Please add some more checks here
Thanks,
Dushyant
From: Ben Coverston [mailto:ben.covers...@datastax.com]
ya had created with UTF8Type before.. It gave the same error.
On executing help assume command it is giving 'utf8' as a type.
so can i use comparator='utf8' or not??
Please reply
On Mon, Mar 26, 2012 at 9:17 PM, R. Verlangen ro...@us2.nl wrote:
You should use the full type names, e.g.
Not sure about that, what version of Cassandra are you using? Maybe someone
else here knows how to solve this..
2012/3/27 puneet loya puneetl...@gmail.com
ya had created with UTF8Type before.. It gave the same error.
On executing help assume command it is giving 'utf8' as a type.
so can i
That's true, but it does not sound like a real problem to me.. Maybe
someone else can shed some light upon this.
2012/3/27 samal samalgo...@gmail.com
On Tue, Mar 27, 2012 at 1:47 AM, R. Verlangen ro...@us2.nl wrote:
but any schema change will break it
How do you mean? You don't have to
Thank you Maki, wasn't aware of that.
2012/3/27 Maki Watanabe watanabe.m...@gmail.com
auto_bootstrap has been removed from cassandra.yaml and always enabled
since 1.0.
fyi.
maki
2012/3/26 R. Verlangen ro...@us2.nl:
Yes, you can add nodes to a running cluster. It's very simple:
YEAH! agree, it only matter for time bucket data.
On Tue, Mar 27, 2012 at 12:31 PM, R. Verlangen ro...@us2.nl wrote:
That's true, but it does not sound like a real problem to me.. Maybe
someone else can shed some light upon this.
2012/3/27 samal samalgo...@gmail.com
On Tue, Mar 27, 2012
Thanks, I will wait and see as data accumulates.
Thanks,
*Tamar Fraenkel *
Senior Software Engineer, TOK Media
[image: Inline image 1]
ta...@tok-media.com
Tel: +972 2 6409736
Mob: +972 54 8356490
Fax: +972 2 5612956
On Tue, Mar 27, 2012 at 9:00 AM, R. Verlangen ro...@us2.nl wrote:
I m using cassandra 1.0.8..
Please reply
On Tue, Mar 27, 2012 at 12:28 PM, R. Verlangen ro...@us2.nl wrote:
Not sure about that, what version of Cassandra are you using? Maybe
someone else here knows how to solve this..
2012/3/27 puneet loya puneetl...@gmail.com
ya had created with
without the ability to do disjoint column slices, i would probably use 5
different rows.
userId:itemType - activityId
then it's a multiget slice of 10 items from each of your 5 rows.
On 26/03/2012 22:16, Ertio Lew wrote:
I need to store activities by each user, on 5 items types. I always
why don't you show us the command you're actually trying to run?
On 27/03/2012 08:52, puneet loya wrote:
I m using cassandra 1.0.8..
Please reply
On Tue, Mar 27, 2012 at 12:28 PM, R. Verlangen ro...@us2.nl
mailto:ro...@us2.nl wrote:
Not sure about that, what version of Cassandra are
multiget would require Order Preserving Partitioner, and this can lead to
unbalanced ring and hot spots.
Maybe you can use secondary index on itemtype - is must have small
cardinality:
http://pkghosh.wordpress.com/2011/03/02/cassandra-secondary-index-patterns/
On Tue, Mar 27, 2012 at 10:10 AM,
You can just get a slice range with as start userId: and no end.
2012/3/27 Maciej Miklas mac.mik...@googlemail.com
multiget would require Order Preserving Partitioner, and this can lead to
unbalanced ring and hot spots.
Maybe you can use secondary index on itemtype - is must have small
Any pointers on what I should be looking for in our application that would
be stopping the deletion of tombstones?
Thanks,
Ross
On 26 March 2012 16:27, Viktor Jevdokimov viktor.jevdoki...@adform.comwrote:
Upon read from S1 S6 rows are merged, T3 timestamp wins.
T1 will be deleted upon S1
Dne 27.3.2012 11:13, Ross Black napsal(a):
Any pointers on what I should be looking for in our application that
would be stopping the deletion of tombstones?
do not delete already deleted rows. On read cassandra returns deleted
rows as empty in range slices.
@R. Verlangen:
You are suggesting to keep a single row for all activities read all the
columns from the row then filter, right!?
If done that way (instead of keeping it in 5 rows) then I would need to
retrieve 100s-200s of columns from single row rather than just 50 columns
if I keep in 5
The Cassandra team is pleased to announce the release of the second beta for
the future Apache Cassandra 1.1.
Note 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
1.1 and to get wider testing
Hi All,
Thanks a lot for the release.
I just upgraded my 1.1-beta1 to 1.1-beta2, and I get the following error :
INFO 10:56:17,089 Opening
/app/cassandra/data/data/system/LocationInfo/system-LocationInfo-hc-18
(74 bytes)
INFO 10:56:17,092 Opening
create column family student
with column_type = 'AsciiType'
and column_metadata =
[{
column_name : name,
validation_class : 'AsciiType
}];
On Tue, Mar 27, 2012 at 1:48 PM, Guy Incognito dnd1...@gmail.com wrote:
why don't you show us the command you're actually trying to run?
On
Can u give an example of create column family with counter column in it.
Please reply
Regards,
Puneet Loya
create keyspace DEMO
with placement_strategy =
'org.apache.cassandra.locator.NetworkTopologyStrategy'
and strategy_options=[{datacenter1:1}];
try it n check if it executes
On Tue, Mar 27, 2012 at 3:35 AM, Frank Hsueh frank.hs...@gmail.com wrote:
create keyspace via cassandra cli
*create column family MyCounterColumnFamily with
default_validation_class=CounterColumnType and
key_validation_class=UTF8Type and comparator=UTF8Type;*
There you go! Keys must be utf8, as well as the column names. Of course you
can change those validators.
Cheers!
2012/3/27 puneet loya
create column family users
(uuid PRIMARY KEY
firstname text,
lastname text,
email text,
address text,
zip int,
state text);
Is dis above statement correct?
I m getting an error Syntax error at position 27: missing EOF at '('
Do reply
Can u suggest the most stable version of cassandra??
thanxx a ton :) :)
the counter column family works synonymous as 'auto increment' in other
databases rite?
I mean we have a column of type integer which increments with every insert.
Am i goin the rite way??
please reply :)
On Tue, Mar 27, 2012 at 5:50 PM, R. Verlangen ro...@us2.nl wrote:
Actually, there was a few changes to the on-disk format of schema
between beta1 and beta2 so upgrade is not supported between those two
beta versions.
Sorry for any inconvenience.
--
Sylvain
On Tue, Mar 27, 2012 at 12:57 PM, Benoit Perroud ben...@noisette.ch wrote:
Hi All,
Thanks a lot for
how to use cql??
Rite now i m running dis file cassandra-cli.bat
i connect localhost/9160;
den i went into use pun; //its a keyspace
using the create statement
create COLUMNFAMILY users
(KY uuid PRIMARY KEY*,*
firstname text,
lastname text,
email text,
address text,
zip int,
state
I want to import files from excel to cassandra? Is it possible??
Any tool that can help??
Whats the best way??
Plz reply :)
You should use a connection pool without retries to prevent a single
increment of +1 have a result of e.g. +3.
2012/3/27 Rishabh Agrawal rishabh.agra...@impetus.co.in
You can even define how much increment you want. But let me just warn
you, as far my knowledge, it has consistency issues.
wen i m using a counter column.. i m nt able to add columns of other type
to the column family.. is it so or it is just synactical error??
[default@CMDCv99] create column family status
... with comparator = AsciiType
... and column_metadata =
... [{
...
Thanks for the quick feedback.
I will drop the schema then.
Benoit.
Le 27 mars 2012 14:50, Sylvain Lebresne sylv...@datastax.com a écrit :
Actually, there was a few changes to the on-disk format of schema
between beta1 and beta2 so upgrade is not supported between those two
beta versions.
Hi Carlo,
Can you post steps to reproduce over on
https://issues.apache.org/jira/browse/CASSANDRA-3819 ? We have tried
and failed to cause this problem.
On Thu, Jan 26, 2012 at 6:24 AM, Carlo Pires carlopi...@gmail.com wrote:
I found out this is related to schema change. Happens *every time* I
Counter columns are special, they must be in a column family to themselves.
On 03/27/2012 09:32 AM, puneet loya wrote:
wen i m using a counter column.. i m nt able to add columns of other
type to the column family.. is it so or it is just synactical error??
[default@CMDCv99] create column
now i want to have a field incrementing with every row insertion. how do i
do it in cassandra??
On Tue, Mar 27, 2012 at 7:34 PM, Dave Brosius dbros...@mebigfatguy.comwrote:
Counter columns are special, they must be in a column family to
themselves.
On 03/27/2012 09:32 AM, puneet loya wrote:
How do i use the cqlsh comand line utility??
I m using cassandra 1.0.8.. Does cqlsh command line utility comes with the
download of cassandra 1.0.8 or we have to do it separately.
Suggest a way to go further
plz reply :)
multiget does not require OPP.
On 27/03/2012 09:51, Maciej Miklas wrote:
multiget would require Order Preserving Partitioner, and this can lead
to unbalanced ring and hot spots.
Maybe you can use secondary index on itemtype - is must have small
cardinality:
You can write your own script to parse the excel file (export as csv) and
import it with batch inserts.
Should be pretty easy if you have experience with those techniques.
2012/3/27 puneet loya puneetl...@gmail.com
I want to import files from excel to cassandra? Is it possible??
Any tool
Haven't received any reply. Resend...
Feng Qu
From: Feng Qu mail...@gmail.com
To: Cassandra User Group user@cassandra.apache.org
Sent: Wednesday, February 22, 2012 1:49 PM
Subject: nodetool ring runs very slow
We noticed that nodetool ring sometimes
Hi Jonathan, similar problem happens again and there is only one GC running at
that time per system.log.
This is one node of a 6-node 0.8.6 ring. Heap size on this host is 16GB.
[fengqu@slcdbx1035 cassandra]$ date; time cnt ring
Tue Mar 27 09:24:20 GMT+7 2012
Address
DC
Rack
Hello.
I'm developing a system that will require me to store large (=4MB) columns in
Cassandra. Right now I'm storing 1 column per row, in a single CF. The machines
I have at my disposal are 32GB RAM machines with 10 SATA drives each. I would
prefer to have a larger number of smaller nodes,
I was given one other suggestion (which may have been suggested earlier in
this thread, but is clearer to me with an example). The suggestion was to
use composite columns and have the first part of the key name be skill
and the second part be the specific skill and then store a null value. I
If you have the disck space you can just copy all the data files from the
snapshot onto the dev node, renaming any with conflicting names. Then bring up
the dev node and it should see the data. you can then compact to merge and
drop all the duplicate data.
You can also use the sstable loader
(Radim: I'm assuming you mean do not delete already deleted columns as
Ross doesn't delete his rows.)
Just to be clear about Ross' situation: he continually inserts columns and
later deletes columns from the same set of rows. As long as he *doesn't* *keep
deleting already-deleted columns*
You can find it in the bin directory of the binary distribution.
maki
2012/3/27 puneet loya puneetl...@gmail.com:
How do i use the cqlsh comand line utility??
I m using cassandra 1.0.8.. Does cqlsh command line utility comes with the
download of cassandra 1.0.8 or we have to do it
i know cqlsh is in the bin directory .. how to run it on Windows? it is not
a batch file that can be run directly?
Should we use python to execute it??
plz show a way :)
Reply
On Wed, Mar 28, 2012 at 8:34 AM, Maki Watanabe watanabe.m...@gmail.comwrote:
You can find it in the bin directory of
cqlsh is a python script.
You need python, and cql driver for python.
maki
2012/3/28 puneet loya puneetl...@gmail.com:
i know cqlsh is in the bin directory .. how to run it on Windows? it is not
a batch file that can be run directly?
Should we use python to execute it??
plz show a way :)
If you are running on windows the msi installer for datastax community
edition will install everything you need and add appropriate entries
to your start menu for running the cql shell or the normal cli shell.
You can get the installer here: http://www.datastax.com/download/community
That might
46 matches
Mail list logo