You CAN only supply some of the components for a slice.
On Fri, Dec 20, 2013 at 2:13 PM, Josh Dzielak wrote:
> Is there a way to include *multiple* column names in a slice query where
> one only component of the composite column name key needs to match?
>
> For example, if this
Thanks Nate.
I will take a look at extending thrift, seems like this could be useful for
some folks.
On Friday, December 20, 2013 at 12:29 PM, Nate McCall wrote:
> >
> > My questions –
> >
> > 1) Is this supported in the Thrift interface or CQL?
>
> Not directly, no.
>
> > 2) If
>
>
> My questions –
>
> 1) Is this supported in the Thrift interface or CQL?
>
Not directly, no.
> 2) If not, is there clever data modeling or indexing that could accomplish
> this use case? 1 single-row round-trip to get these columns?
>
If this is a query done frequently you could prefix bot
Is there a way to include *multiple* column names in a slice query where one
only component of the composite column name key needs to match?
For example, if this was a single row -
username:0 | username:1 | city:0 | city:1 | other:0|
other:1
In thrift an empty ByteBuffer (in some cases an empty string "") can mean
both start and end
Thus:
start: "", end "" is the entire slice
start: "c", end "" start at c inclusive rest of slice
On Thu, May 30, 2013 at 2:37 PM, Kanwar Sangha wrote:
> Hi – We gave a dynamic CF which has a key and
Hi - We gave a dynamic CF which has a key and multiple columns which get added
dynamically. For example -
Key_1 , Column1, Column2, Column3,...
Key_2 , Column1, Column2, Column3,.
Now I want to get all columns after Column3...how do we query that ? The
ColumnSliceIterator in hector al
@gmail.com> wrote:
>>>>
>>>> > Hello guys.
>>>> > I'm investigating the reasons of performance degradation for my case
>>>> scenario which follows:
>>>> >
>>>> > - I do have a column family which is filled of
I'm investigating the reasons of performance degradation for my case
>>> > scenario which follows:
>>> >
>>> > - I do have a column family which is filled of thousands of columns
>>> > inside a unique row(varies between 10k ~ 200k). And I do have als
have also
>>> thousands of rows, not much more than 15k.
>>> > - This rows are constantly updated. But the write-load is not that
>>> intensive. I estimate it as 100w/sec in the column family.
>>> > - Each column represents a message which is read and p
eading it, the column is marked for deletion in order to keep
> it out from the next query on this row.
>
> Ok, so, I've been figured out that after many insertions plus deletion
> updates, my queries( column slice query ) are taking more time to be
> performed. Even if t
e it as 100w/sec in the column family.
>> > - Each column represents a message which is read and processed by
>> another process. After reading it, the column is marked for deletion in
>> order to keep it out from the next query on this row.
>> >
>> > Ok, so, I&#
>> > - Each column represents a message which is read and processed by
>> another process. After reading it, the column is marked for deletion in
>> order to keep it out from the next query on this row.
>> >
>> > Ok, so, I've been figured out that af
read and processed by another
> process. After reading it, the column is marked for deletion in order to keep
> it out from the next query on this row.
>
> Ok, so, I've been figured out that after many insertions plus deletion
> updates, my queries( column slice query ) are ta
- Each column represents a message which is read and processed by
> another process. After reading it, the column is marked for deletion in
> order to keep it out from the next query on this row.
> >
> > Ok, so, I've been figured out that after many insertions plus deletion
; - Each column represents a message which is read and processed by another
> process. After reading it, the column is marked for deletion in order to keep
> it out from the next query on this row.
>
> Ok, so, I've been figured out that after many insertions plus deletion
>
this row.
Ok, so, I've been figured out that after many insertions plus deletion
updates, my queries( column slice query ) are taking more time to be
performed. Even if there are only few columns, lower than 100.
So it looks like that the longer is the number of columns being deleted,
the lon
> Is there a way to create a slice query that returns all columns where the
> _second_ component is A?
No.
You can only get a contiguous slice of columns.
Cheers
-
Aaron Morton
Freelance Developer
@aaronmorton
http://www.thelastpickle.com
On 16/08/2012, at 7:21 AM, Mik
Hello,
Given a row like this
"key1" => (A:A:C), (A:A:B), (B:A:C), (B:C:D)
Is there a way to create a slice query that returns all columns where the
_second_ component is A? That is, I would like to get back the following
columns by asking for columns where component[0] = * and com
On Tue, Jul 10, 2012 at 2:20 PM, Sunit Randhawa wrote:
> I have tested this extensively and EOC has huge issue in terms of
> usability of CompositeTypes in Cassandra.
>
> As an example: If you have 2 Composite Columns such as A:B:C and A:D:C.
>
> And if you do search on A:B as start and end Compos
I have tested this extensively and EOC has huge issue in terms of
usability of CompositeTypes in Cassandra.
As an example: If you have 2 Composite Columns such as A:B:C and A:D:C.
And if you do search on A:B as start and end Composite Components, it
will return D as well. Because it returns all t
I think in this case that's just Hector's way of setting the EOC byte for a
component. My guess is that the composite isn't being structured correctly
through Hector, as well.
On Tue, Jul 10, 2012 at 4:40 AM, aaron morton wrote:
>
> The first thing that stands out is that (in cassandra) comparis
; with comparator =
>>
>> 'CompositeType(org.apache.cassandra.db.marshal.Int32Type,org.apache.cassandra.db.marshal.UTF8Type,org.apache.cassandra.db.marshal.UTF8Type)'
>>
>> and key_validation_class = UTF8Type
>>
>> and default_validat
orton
>
> wrote:
>
>
> #2 has the Composite Column and #1 does not.
>
>
>
> They are both strings.
>
>
>
> All column names *must* be of the same type. What was your CF definition ?
>
>
>
> Cheers
>
>
>
> -
>
t;
>> All column names *must* be of the same type. What was your CF definition ?
>>
>>
>> Cheers
>>
>>
>> -
>>
>> Aaron Morton
>>
>> Freelance Developer
>>
>> @aaronmorton
>>
>> ht
rton
>
> Freelance Developer
>
> @aaronmorton
>
> http://www.thelastpickle.com
>
>
> On 6/07/2012, at 7:26 AM, Sunit Randhawa wrote:
>
>
> Hello,
>
>
> I have 2 Columns for a 'RowKey' as below:
>
>
> #1 : set CF['RowKey'][
>> Hello,
>>
>> I have 2 Columns for a 'RowKey' as below:
>>
>> #1 : set CF['RowKey']['1000']='A=1,B=2';
>> #2: set CF['RowKey']['1000:C1']='A=2,B=3'';
>>
#1 : set CF['RowKey']['1000']='A=1,B=2';
> #2: set CF['RowKey']['1000:C1']='A=2,B=3'';
>
> #2 has the Composite Column and #1 does not.
>
> Now when I execute the Composite Slice query by 1000 and C1, I do get
> bot
ote:
> Hello,
>
> I have 2 Columns for a 'RowKey' as below:
>
> #1 : set CF['RowKey']['1000']='A=1,B=2';
> #2: set CF['RowKey']['1000:C1']='A=2,B=3'';
>
> #2 has the Composite Column and #1 does no
Hello,
I have 2 Columns for a 'RowKey' as below:
#1 : set CF['RowKey']['1000']='A=1,B=2';
#2: set CF['RowKey']['1000:C1']='A=2,B=3'';
#2 has the Composite Column and #1 does not.
Now when I execute the Composite Slice
Hi there,
We run a 3 node cluster with 0.7.8 with replication factor 3 for all key
spaces.
We store external->internal key mappings in a column family with one row
for each customer. The largest row contains abount 200k columns.
If we import external data we load the whole row and map externa
he.org>"
mailto:user@cassandra.apache.org>>
Date: Thu, 27 Oct 2011 06:34:08 -0400
To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>"
mailto:user@cassandra.apache.org>>
Subject: super sub slice query?
is there such a thing? a query that runs against a SC family
is there such a thing? a query that runs against a SC family and
returns a subset of subcolumns from a set of super-columns?
is there a way to have eg a slice query (or super slice query) only
return the column names, rather than the value as well?
?
-Ursprüngliche Nachricht-
Von: Roland Gude [mailto:roland.g...@yoochoose.com]
Gesendet: Donnerstag, 28. Juli 2011 11:22
An: user@cassandra.apache.org
Betreff: AW: results of index slice query
Created https://issues.apache.org/jira/browse/CASSANDRA-2964
-Ursprüngliche Nachricht-
Von: Jonathan
Created https://issues.apache.org/jira/browse/CASSANDRA-2964
-Ursprüngliche Nachricht-
Von: Jonathan Ellis [mailto:jbel...@gmail.com]
Gesendet: Mittwoch, 27. Juli 2011 17:35
An: user@cassandra.apache.org
Betreff: Re: results of index slice query
Sounds like a Cassandra bug to me.
On
Sounds like a Cassandra bug to me.
On Wed, Jul 27, 2011 at 6:44 AM, Roland Gude wrote:
> Hi,
>
> I was just experiencing that when i do an IndexSliceQuery with the index
> column not in the slicerange the index column will be returned anyways. Is
> this behavior intended or is it a bug (if so – i
Hi,
I was just experiencing that when i do an IndexSliceQuery with the index column
not in the slicerange the index column will be returned anyways. Is this
behavior intended or is it a bug (if so - is it a Cassandra bug or a hector
bug)?
I am using Cassandra 0.7.7 and hector 0.7-26
Greetings,
I checked out #2212 and was able to reproduce the problem.
Thanks for investigating this and putting together a good script to
reproduce!
- Tyler
; -
>>
>>
>> Regards,
>> Shotaro
>>
>>
>>
>>
>> On Fri, Feb 18, 2011 at 5:19 AM, Aaron Morton
>> wrote:
>> > First some terminology, when you say range slice do you mean getting
>> > multiple rows
ortant. The
> comparator and sub comparator as specified in the CF definition control the
> ordering of colums. If possible i would suggest using the random
> partitioner.
> >
> > Could you provide examples of how you are doing the queries using pycassa
> we may be able to help.
; 20031210 is not true
>
> Trying appending the highest value ASCII character to the end of 20031210
>
> Cheers
> Aaron
>
> On 18/02/2011, at 4:35 AM, Shotaro Kamio wrote:
>
>> Hi,
>>
>> We are in trouble with a strange behavior in cassandra 0.7.2 (also
>> ha
ot;.
> Data structure is something like:
> Order[ a_key ][ date + "/" + order_id + "/" (+ suffix) ][attribute] = value
>
> For example,
> Order[ "100" ][ "20031210022059/190209-20031210-4476885-s/" ]
> is a super column.
> Because
/" (+ suffix) ][attribute] = value
For example,
Order[ "100" ][ "20031210022059/190209-20031210-4476885-s/" ]
is a super column.
Because we want to scan them in the latest-first order, range slice
query with reversed order is used. (Partitioner is
ByteOrderedPartitione
I'm not doing schema migration, but I suspect my lack of experience
and understanding of column-based data is clouding the issue. What I
have is 2 pieces of information, let's call them LH and RH and a
single long value representing the link between them, S. The data
needs to be ordered by S, so
On Wed, Mar 24, 2010 at 4:57 AM, Colin Vipurs wrote:
...
> ColumnFamily {
> 'key1' {
> 'SuperColumn1' {
> 'Column1' :
> 'Column2' :
> }
> 'SuperColumn2' {
> 'Column3' :
> }
> }
> 'key2' {
> 'SuperColumn1' {
> 'Column1' :
> }
>
On Wed, Mar 24, 2010 at 4:57 AM, Colin Vipurs wrote:
> Could I get all keys/supercolumns where 'Column1' exists? fyi I'm
> using the Hector Java client for my work.
Not servir-side, no.
-Jonathan
Hi all,
I've just started playing with Cassandra and investigating if it's
useful for us, so please be gentle when I ask silly questions :).
When user super columns is it possible to perform a slice operation to
pull out all SC's/Keys that match a specific/range of column names?
Putting it more c
46 matches
Mail list logo
