Thank you so much Aaron !!
On Wed, Feb 9, 2011 at 2:11 AM, Aaron Morton wrote:
> Makes sense, use a get_slice() against the second row and pass in the column
> names. Should e fine.
>
> If you run into performance issues look at slice_buffer_size and
> column_index_size in the config.
>
> Aaron
Makes sense, use a get_slice() against the second row and pass in the column
names. Should e fine.
If you run into performance issues look at slice_buffer_size and
column_index_size in the config.
Aaron
On 9/02/2011, at 5:16 AM, Aklin_81 wrote:
> Amongst two rows, where I need to find the c
Amongst two rows, where I need to find the common columns. I will not
have more than 200 columns(in 99% cases) for the 1st row. But the 2nd
row where I need to find these columns may have even around a million
valueless columns.
A point to note is:- These calculations are all done for **writing th
Ah -- ok.
So (I'm also pretty new to Cassandra, but) I believe that your solution
works... just as far as I know you might have to query for those 60-70 columns
individually. If you wanted to optimize, you could create a bloom filter for
the columns in row 2, and first get it, and then only que
I think my question might have been unclear to some of you. So I would
again explain my problem(& solution which I thought of) for the sake
of clarity:-
Consider I have 2 rows. 1st row contains 60-70 columns and 2nd row
contains like in hundreds of thousands columns. Both the columns sets
are al
Thanks Aaron & Shaun,
**
I think my question might have been unclear to some of you. So I would
again explain my problem(& solution which I thought of) for the sake
of clarity:-
Consider I have 2 rows. 1st row contains 60-70 columns and 2nd row
contains like in hundre
In theory, you should be able to do joins by creating an extra column in one
column family, holding the "foreign key" of the matching row in the other
family.
This assumes that the info you are joining on is available in both CFs (is not
some sort of functional transformation).
I have just fo
Is it possible for you to dernormalise and write all the intersection values?
Will depend on how many I guess.
The other alternative is to pull back more data that you need and the
intersection in code in the client.
Hope that helps.
Aaron
On 7/02/2011, at 7:11 AM, Aklin_81 wrote:
> Hi,
>
Hi,
@buddhasystem : yes that's well known solution. But obviously when
mysql couldnt satisfy my needs, I am here. My question is in context
of Cassandra, if it possible to achieve intersection result set of
columns in two rows, by the way I spoke about.
@Edward: yes that I know but how does that
On Sun, Feb 6, 2011 at 10:15 AM, buddhasystem wrote:
>
> Hello,
>
> If the amount of data is _that_ small, you'll have a much easier life with
> MySQL, which supports the "join" procedure -- because that's exactly what
> you want to achieve.
>
>
> asil klin wrote:
>>
>> Hi all,
>>
>> I want to pro
Hello,
If the amount of data is _that_ small, you'll have a much easier life with
MySQL, which supports the "join" procedure -- because that's exactly what
you want to achieve.
asil klin wrote:
>
> Hi all,
>
> I want to procure the intersection of columns set of two rows (from 2
> different c
11 matches
Mail list logo
