Does drop work in a similar way?
When I drop a CF and add it back with a different schema, it seems to work.
But I notice that in between the drop and adding it back, when the CLI
tells me the CF doesn't exist, the old data is still there.
I've been assuming that this works, but just wanted to m
can i have an example for using TimeUUIDType as comparator in a client
java code.
De : karim abbouh
À : "user@cassandra.apache.org"
Envoyé le : Lundi 27 Juin 2011 17h59
Objet : Re : Re : get_range_slices result
i used TimeUUIDType as type in storage-co
On 27/06/2011 19:19, Sylvain Lebresne wrote:
Let me make that simpler.
Don't ever use replicate_on_write=false (even if you "think" that it is
what you want, there is a good chance it's not).
Obviously, the default is replicate_on_write=true.
I may be wrong. But with 0.8.0, I think the default i
That error is thrown if you send a Deletion with a predicate that has neither
columns or a SliceRange.
Send a Deletion that does not have a predicate.
Cheers
-
Aaron Morton
Freelance Cassandra Developer
@aaronmorton
http://www.thelastpickle.com
On 28 Jun 2011, at 18:11, Donna
Drop CF takes a snapshot of the CF first, and then marks SSTables on disk as
compacted so they will be safely deleted later. Finally it removes the CF from
the meta data.
If you see the SSTables on disk, you should see 0 length .compacted files for
every one of them.
Cheers
First thing is you really should upgrade from 0.6, the current release is 0.8.
Info on time uuid's
http://wiki.apache.org/cassandra/FAQ#working_with_timeuuid_in_java
If you are using a higher level client like Hector or Pelops it will take care
of encoding for you.
Cheers
-
A
On Tue, Jun 28, 2011 at 12:53 PM, Donal Zang wrote:
> On 27/06/2011 19:19, Sylvain Lebresne wrote:
>>
>> Let me make that simpler.
>>
>> Don't ever use replicate_on_write=false (even if you "think" that it is
>> what you want, there is a good chance it's not).
>> Obviously, the default is replicat
On Tue, 2011-06-28 at 11:54 +1200, aaron morton wrote:
> Without exception the timestamp is set by the client, not the server.
> The one exception to the without exception rule is CounterColumnType
> operations.
And CQL...
--
Eric Evans
eev...@rackspace.com
The Cassandra team is pleased to announce the release of Apache Cassandra
version 0.8.1.
Cassandra is a highly scalable second-generation distributed database,
bringing together Dynamo's fully distributed design and Bigtable's
ColumnFamily-based data model. You can read more here:
http://cassand
for example, if I have an application that needs to read off a user browsing
history, and I model the user ID as the key,
and the history data within the row. with current approach, I could model
each visit as a column,
the possible issue is that *possibly* (I'm still doing a lot of profiling on
t
Hey Aaron,
I think you're right, I'm using version 0.7 and indeed the node I'm
trying to move is the only node in that data center - I'll steal some
hardware to add to the ring to confirm.
-Ben
On Sun, Jun 19, 2011 at 4:06 PM, aaron morton wrote:
> I *think* someone had a similar problem once
Hi, yes you are correct, and this is a potential problem.
IMPORTANT: If you need to serialize writes from your application servers,
for example using distributed locking, then before releasing locks you must
sleep for a period equal to the maximum variance between the clocks on your
application se
I found this code
// Start and finish keys, *and* column relations (KEY> foo AND KEY<
bar and name1 = value1).
if (select.isKeyRange()&& (select.getKeyFinish() != null)&&
(select.getColumnRelations().size()> 0))
throw new InvalidRequestException("You cannot comb
Thanks.
On Tue, Jun 28, 2011 at 1:31 PM, Dominic Williams
wrote:
> Hi, yes you are correct, and this is a potential problem.
> IMPORTANT: If you need to serialize writes from your application servers,
> for example using distributed locking, then before releasing locks you must
> sleep for a peri
Hi,
I am having problem accessing data via an index with PHPCassa. I have
var_dump() the results:
array(6) { ["birthdate"]=> int(3546927995491989807) ["email"]=>
string(20) "jnbdzjn...@gmail.com" ["firstname"]=> string(12)
"Jean-Nicolas" ["lastname"]=> string(17) "Boulay Desjardins"
["password"]=
The result of get_indexed_slices() is an Iterator object, not an
array. It doesn't look like you're treating it accordingly.
See the bottom of this section for an example:
http://thobbs.github.com/phpcassa/tutorial.html#indexes
On Tue, Jun 28, 2011 at 2:06 PM, Jean-Nicolas Boulay Desjardins
wro
Actually I am not getting any results from: get_indexed_slices()
It seems my code dies at: $rows =
$column_family->get_indexed_slices($index_clause);
Because everything after that is echo is not shown on the page.
Plus I don't get any errors.
Any ideas?
On Tue, Jun 28, 2011 at 3:23 PM, Tyler H
Hi all,
in most SQL implementations, it's possible to declare parameters in
SQL command text (i.e. "SELECT * FROM T WHERE Id=@myId"). Then the
client application sends this SQL command and parameters values
separately - the server is responsible for the parameters
substitution.
In CQL API (~the "
Yikes! I just read your blog Dominic. Now I'm worried since my app was
going to be mostly cloud-based. But, you didn't mention anything about
sleeping for 'max clock variance' after making the ntp-related config
changes (maybe you haven't had the time to blog it).
I'm curious, do you think
What does the ouput of 'describe keyspace ' show for the
keyspace the CF is in?
On Tue, Jun 28, 2011 at 2:35 PM, Jean-Nicolas Boulay Desjardins
wrote:
> Actually I am not getting any results from: get_indexed_slices()
>
> It seems my code dies at: $rows =
> $column_family->get_indexed_slices($ind
There is no facility to do custom reconciliation for a column. An append style
operation would run into many of the same problems as the Counter type, e.g.
not every node may get an append and there is a chance for lost appends unless
you go to all the trouble Counter's do.
I would go with usi
Sorry, my mistake. The variable name was wrong. Weird, I did not get any errors.
Thanks anyways.
But I do Have a another question. When looking in cassandra-cli I did
"get Users[jnbdz];" and I got:
A long is exactly 8 bytes: 10
And I don't get the data.
Am I missing something?
Thanks in advan
I can see that as my user history grows, the reads time proportionally ( or
faster than linear) grows.
if my business requirements ask me to keep a month's history for each user,
it could become too slow.- I was suspecting that it's actually the
serializing and deserializing that's taking time
Currently these are two different types of query, using a key range is
equivalent to the get_range_slices() API function and column clauses is a
get_indexed_slices() call. So you would be asking for a potentially painful
join between.
Creating a column with the same value as the key sounds reas
see https://issues.apache.org/jira/browse/CASSANDRA-2475
-
Aaron Morton
Freelance Cassandra Developer
@aaronmorton
http://www.thelastpickle.com
On 29 Jun 2011, at 08:45, Michal Augustýn wrote:
> Hi all,
>
> in most SQL implementations, it's possible to declare parameters in
> SQ
Can you provide some more info:
- how big are the rows, e.g. number of columns and column size ?
- how much data are you asking for ?
- what sort of read query are you using ?
- what sort of numbers are you seeing ?
- are you deleting columns or using TTL ?
I would consider issues with the d
I agree with Aaron's suggestion on data model and query here. Since
there is a time component, you can split the row on a fixed duration
for a given user, so the row key would become userId_[timestamp
rounded to day].
This provides you an easy way to roll up the information for the date
ranges you
Hi,
First of all, thank you for releasing v8.0.1 and congrats! the list of fixes
and improvements is impressive.
Is there any ETA for Debian package? Is there a (standard) way to build it
from sources?
Thank you,
Oleg
0.8.1 should be up--I've already installed it. Here's directions:
http://wiki.apache.org/cassandra/DebianPackaging
On Tue, Jun 28, 2011 at 8:24 PM, Oleg Tsvinev wrote:
> Hi,
>
> First of all, thank you for releasing v8.0.1 and congrats! the list of
> fixes and improvements is impressive.
> Is th
Thank you Dan! But I only see 0.8.0 there :(
On Tue, Jun 28, 2011 at 5:35 PM, Dan Kuebrich wrote:
> 0.8.1 should be up--I've already installed it. Here's directions:
> http://wiki.apache.org/cassandra/DebianPackaging
>
>
> On Tue, Jun 28, 2011 at 8:24 PM, Oleg Tsvinev wrote:
>
>> Hi,
>>
>> First
Try running apt-get update (as opposed to upgrade) to pull down the
latest listings from the repo.
On Tue, Jun 28, 2011 at 8:40 PM, Oleg Tsvinev wrote:
> Thank you Dan! But I only see 0.8.0 there :(
>
>
> On Tue, Jun 28, 2011 at 5:35 PM, Dan Kuebrich wrote:
>
>> 0.8.1 should be up--I've alrea
Nope, only see 0.8.0. I updated sources in Synaptic Package manager, which
does the same as apt-get update.
On Tue, Jun 28, 2011 at 5:44 PM, Dan Kuebrich wrote:
> Try running apt-get update (as opposed to upgrade) to pull down the
> latest listings from the repo.
>
>
> On Tue, Jun 28, 2011 at
aaron morton wrote:
>
>> Not sure what the intended purpose is, but we've mostly used it as an
>> emergency disk-capacity-increase option
>
> Thats what I've used it for.
>
> Cheers
>
How does compaction work in terms of utilizing multiple data dirs? Also, is
there a reference on wiki somew
The output of 'describe keyspace' would be useful for figuring this
out, at well.
On Tue, Jun 28, 2011 at 5:10 PM, Jean-Nicolas Boulay Desjardins
wrote:
> Sorry, my mistake. The variable name was wrong. Weird, I did not get any
> errors.
>
> Thanks anyways.
>
> But I do Have a another question.
0.8.1 has been added to the 08x distribution, but not unstable.
See:
http://www.apache.org/dist/cassandra/debian/dists/unstable/main/binary-amd64/Packages
vs
http://www.apache.org/dist/cassandra/debian/dists/08x/main/binary-amd64/Packages
Change your apt sources to use 08x instead of unstable.
Yes, I figured that out. Thank you for your help!
On Tue, Jun 28, 2011 at 8:31 PM, Kyle Ambroff wrote:
> 0.8.1 has been added to the 08x distribution, but not unstable.
>
> See:
>
> http://www.apache.org/dist/cassandra/debian/dists/unstable/main/binary-amd64/Packages
>
> vs
>
>
> http://www.apac
btw I use only one box now just because I'm running it on dev junit test,
not that it's going to be that way in production
On Tue, Jun 28, 2011 at 10:06 PM, Yang wrote:
> ok, here is the profiling result. I think this is consistent (having been
> trying to recover how to effectively use your
On 6/27/2011 3:39 PM, David Strauss wrote:
On Mon, 2011-06-27 at 15:06 -0600, AJ wrote:
Would anyone care to talk about their experiences with using Solandra
along side another application that uses Cassandra (also on the same
node)? I'm curious about any resource contention issues or
compatibi
38 matches
Mail list logo
