Re: Doubt in Row key range scan

2012-05-28 Thread Luís Ferreira
wal | Developer - Big Data(I&D)| 9731648376 | www.mu-sigma.com > > From: Pierre Chalamet [mailto:pie...@chalamet.net] > Sent: Monday, May 28, 2012 3:31 PM > To: user@cassandra.apache.org > Subject: Re: Doubt in Row key range scan > > Hi, > > It's normal. &g

RE: Doubt in Row key range scan

2012-05-28 Thread Prakrati Agrawal
oubt in Row key range scan 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

Re: Doubt in Row key range scan

2012-05-28 Thread Alain RODRIGUEZ
s to order your data. Alain 2012/5/28 Prakrati Agrawal : > Dear all > > > > I have stored my data into Cassandra database in the format “tickerID_date”. > Now when I specify the row key range like 1_2012/05/24(start) to > 1_2012/05/27(end) it says that the end key md5 value is le

Re: Doubt in Row key range scan

2012-05-28 Thread Pierre Chalamet
ierre -Original Message- From: Prakrati Agrawal Date: Mon, 28 May 2012 04:39:46 To: user@cassandra.apache.org Reply-To: user@cassandra.apache.org Subject: Doubt in Row key range scan Dear all I have stored my data into Cassandra database in the format "tickerID_date". Now when I spec

Doubt in Row key range scan

2012-05-28 Thread Prakrati Agrawal
Dear all I have stored my data into Cassandra database in the format "tickerID_date". Now when I specify the row key range like 1_2012/05/24(start) to 1_2012/05/27(end) it says that the end key md5 value is lesser than start key md5 value. So I changed my start key to 1_2012/05/27 a

Re: Key Range

2011-09-10 Thread Jonathan Ellis
W=Q R=1 is not guaranteed to be consistent, no. you need R=W=Q for that. On Fri, Sep 9, 2011 at 6:59 PM, Alaa Zubaidi wrote: > Hi, > Using 0.7.4, BOP, and RF=3, Write->QUORUM and Read->ONE "NO UPDATES" > How does get_range_slices using Key Range works? Is it possible

Key Range

2011-09-09 Thread Alaa Zubaidi
Hi, Using 0.7.4, BOP, and RF=3, Write->QUORUM and Read->ONE "NO UPDATES" How does get_range_slices using Key Range works? Is it possible to get out of date list of keys? If a key is inserted into 2 Nodes and after that a read with a key range is issued, is it possible to have

Re: Can I retrieve specific key range from a table in RandomPartitioner?

2010-10-01 Thread ilndinesh
I cam through the same problem. I have set the end key same as start key, it worked. (Kinda temp fix...) -- View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Can-I-retrieve-specific-key-range-from-a-table-in-RandomPartitioner-tp5415347p5591681.html

Re: SV: SV: SV: Help with getting Key range with some column limitations

2010-08-21 Thread thelastpickle.com
t them >> >> Från: Jone Lura [mailto:jone.l...@ecc.no] >> Skickat: den 20 augusti 2010 10:37 >> Till: user@cassandra.apache.org >> Ämne: Re: SV: SV: Help with getting Key range with some column limitations >> >> Thanks! Read your blog a few times, but

Re: SV: SV: Help with getting Key range with some column limitations

2010-08-20 Thread Mark
= new SliceRange(); sliceRange.setStart(new byte[] {}); sliceRange.setFinish(new byte[] {}); /J *Från:* Jone Lura [mailto:jone.l...@ecc.no] *Skickat:* den 20 augusti 2010 08:53 *Till:* user@cassandra.apache.org *Ämne:* Re: SV: Help with getting Key range with some column limitations Thanks f

Re: SV: SV: SV: Help with getting Key range with some column limitations

2010-08-20 Thread Jone Lura
ll:* user@cassandra.apache.org *Ämne:* Re: SV: SV: Help with getting Key range with some column limitations Thanks! Read your blog a few times, but it's hard to get rid of sql thinking. So if I create a new standard ColumnFamily with a rowId and geohash a lat/lon into a UTF8Type, I could geohash the bo

SV: SV: SV: Help with getting Key range with some column limitations

2010-08-20 Thread Thorvaldsson Justus
that you probably want to make several and test them Från: Jone Lura [mailto:jone.l...@ecc.no] Skickat: den 20 augusti 2010 10:37 Till: user@cassandra.apache.org Ämne: Re: SV: SV: Help with getting Key range with some column limitations Thanks! Read your blog a few times, but it's hard to

Re: SV: SV: Help with getting Key range with some column limitations

2010-08-20 Thread Jone Lura
e.org *Ämne:* Re: SV: Help with getting Key range with some column limitations Thanks for you suggestions. I tried to iterate them, however I could not get it to work (pretty sure its my code). Im still not to familiar with Cassandra, so could you provide a small example? The key count cou

SV: SV: Help with getting Key range with some column limitations

2010-08-20 Thread Thorvaldsson Justus
w byte[] {}); sliceRange.setFinish(new byte[] {}); /J Från: Jone Lura [mailto:jone.l...@ecc.no] Skickat: den 20 augusti 2010 08:53 Till: user@cassandra.apache.org Ämne: Re: SV: Help with getting Key range with some column limitations Thanks for you suggestions. I tried to iterate them, however I could not get it t

Re: SV: Help with getting Key range with some column limitations

2010-08-19 Thread Jone Lura
iterate through RP because of bugs. But that should be simple enough to 6.4 /Justus *Från:* Jone Lura [mailto:jone.l...@ecc.no] *Skickat:* den 18 augusti 2010 20:32 *Till:* user@cassandra.apache.org *Ämne:* Help with getting Key range with some column limitations Hi, We are trying to implement

Re: Help with getting Key range with some column limitations

2010-08-19 Thread Chen Xinli
ops. (Pelops > not that important for my question) and need suggestions on how to solve a > problem retrieving a key range based on the following. > > > ColumnType="Super" > CompareWith="LongType" > KeysCached="100%&quo

SV: Help with getting Key range with some column limitations

2010-08-18 Thread Thorvaldsson Justus
be needed to iterate through RP because of bugs. But that should be simple enough to 6.4 /Justus Från: Jone Lura [mailto:jone.l...@ecc.no] Skickat: den 18 augusti 2010 20:32 Till: user@cassandra.apache.org Ämne: Help with getting Key range with some column limitations Hi, We are trying to

Help with getting Key range with some column limitations

2010-08-18 Thread Jone Lura
Hi, We are trying to implement Cassandra to replace one of our biggest SQL tables, and so far we got it working. However, for testing I'm using Cassandra 0.6.2, Java and Pelops. (Pelops not that important for my question) and need suggestions on how to solve a problem retrieving a key

Re: Can I retrieve specific key range from a table in RandomPartitioner?

2010-08-12 Thread Aaron Morton
discussion about range slices with RP recently that may be helpful see http://www.mail-archive.com/user@cassandra.apache.org/msg05017.htmlAaronOn 12 Aug, 2010,at 08:50 PM, ChingShen wrote:I have a key range that between 00 and 001000, and my code as below:SlicePredicate predicate = new

Re: Can I retrieve specific key range from a table in RandomPartitioner?

2010-08-12 Thread ChingShen
I have a key range that between 00 and 001000, and my code as below: SlicePredicate predicate = new SlicePredicate(); predicate.setColumn_names(columns); ColumnParent parent = new ColumnParent(columnFamily); KeyRange k = new KeyRange(1000); k.setStart_key(key[0]); k.setEnd_key(key

Can I retrieve specific key range from a table in RandomPartitioner?

2010-08-12 Thread ChingShen
Hi all, Can I retrieve specific key range from a table in RandomPartitioner? Because I always got below exception: Exception in thread "main" InvalidRequestException(why:start key's md5 sorts after end key's md5. this is not allowed; you probably should not specify e