nk it’s possible to generate test code to validate the workload?
>
>
>
> *--*
>
> *Jacques-Henri Berthemet*
>
>
>
> *From:* michael.m...@gmail.com [mailto:michael.m...@gmail.com] *On Behalf
> Of *Michael Mior
> *Sent:* mardi 9 mai 2017 17:30
> *To:* user
> *Subject:* NoSE: Au
generate test code to validate the workload?
--
Jacques-Henri Berthemet
From: michael.m...@gmail.com [mailto:michael.m...@gmail.com] On Behalf Of
Michael Mior
Sent: mardi 9 mai 2017 17:30
To: user
Subject: NoSE: Automated schema design for Cassandra
Hi all,
I wanted to share a tool I've
Hi all,
I wanted to share a tool I've been working on that tries to help automate
the schema design process for Cassandra. The short description is that you
provide information on the kind of data you want to store and the queries
and updates you want to issue, and NoSE will perform a cost-
On Wed, Oct 26, 2011 at 7:35 PM, Ben Gambley wrote:
> Our requirement is to store per user, many unique results (which is
> basically an attempt at some questions ..) so I had thought of having the
> userid as the row key and the result id as columns.
>
> The keys for the result ids are maintaine
On Wed, Oct 26, 2011 at 9:35 PM, Ben Gambley wrote:
>
> Hi Everyone
>
> I have a question with regards read performance and schema design if
> someone could help please.
>
>
> Our requirement is to store per user, many unique results (which is
> basically an attempt at
Hi Everyone
I have a question with regards read performance and schema design if someone
could help please.
Our requirement is to store per user, many unique results (which is basically
an attempt at some questions ..) so I had thought of having the userid as the
row key and the result id
Thanks Tyler!
On Thu, Feb 3, 2011 at 12:06 PM, Tyler Hobbs wrote:
> On Wed, Feb 2, 2011 at 3:27 PM, Aditya Narayan wrote:
>>
>> Can I have some more feedback about my schema perhaps somewhat more
>> criticisive/harsh ?
>
> It sounds reasonable to me.
>
> Since you're writing/reading all of the
On Wed, Feb 2, 2011 at 3:27 PM, Aditya Narayan wrote:
> Can I have some more feedback about my schema perhaps somewhat more
> criticisive/harsh ?
>
It sounds reasonable to me.
Since you're writing/reading all of the subcolumns at the same time, I would
opt for a standard column with the tags se
for a user, for
>>>>>> a
>>>>>> day, that would only contain sub column names with the tags you're
>>>>>> looking
>>>>>> for? Then based upon the column names returned, you'd look-up the
>>>>>> remi
t; That seems like a solid schema to me.
>>>>>
>>>>> Bill-
>>>>>
>>>>> On 02/02/2011 09:37 AM, Aditya Narayan wrote:
>>>>>>
>>>>>> Actually, I am trying to use Cassandra to display to users on my
>>>
as the supercolumn names and the subcolumns
inside that supercolumns could contain the list of tags associated
with particular reminder. All tags set at once during first write. The
no of tags(subcolumns) will be around 8 maximum.
Any comments, suggestions and feedback on the schema design are
requested..
; presented to the user in a chronological order like a news feed.
>>>> Each reminder has got certain tags associated with it(so that, at
>>>> times, user may also choose to see the reminders filtered by tags in
>>>> chronological order).
>>>>
n names and the subcolumns
inside that supercolumns could contain the list of tags associated
with particular reminder. All tags set at once during first write. The
no of tags(subcolumns) will be around 8 maximum.
Any comments, suggestions and feedback on the schema design are
requested..
T
he supercolumn names and the subcolumns
>> inside that supercolumns could contain the list of tags associated
>> with particular reminder. All tags set at once during first write. The
>> no of tags(subcolumns) will be around 8 maximum.
>>
>> Any comments, suggestions and
ce during first write. The
no of tags(subcolumns) will be around 8 maximum.
Any comments, suggestions and feedback on the schema design are requested..
Thanks
Aditya Narayan
On Wed, Feb 2, 2011 at 7:49 PM, Aditya Narayan wrote:
Hey all,
I need to store supercolumns each with around 8 subcolumn
of tags associated
with particular reminder. All tags set at once during first write. The
no of tags(subcolumns) will be around 8 maximum.
Any comments, suggestions and feedback on the schema design are requested..
Thanks
Aditya Narayan
On Wed, Feb 2, 2011 at 7:49 PM, Aditya Narayan wrote:
>
Hey all,
I need to store supercolumns each with around 8 subcolumns;
All the data for a supercolumn is written at once and all subcolumns
need to be retrieved together. The data in each subcolumn is not big,
it just contains keys to other rows.
Would it be preferred to have a supercolumn family o
r a host in a single row is not a good choice. 2
>> reason:
>> 1, too few keys, so your data will not distributing well.
>> 2, data under a key will always increase. So Cassandra have to do more
>> SSTable compaction.
>>
>> -邮件原件-
>> 发件人: Wil
t;
> -邮件原件-
> 发件人: William R Speirs [mailto:bill.spe...@gmail.com]
> 发送时间: 2011年1月27日 9:15
> 收件人: user@cassandra.apache.org
> 主题: Re: Schema Design
>
> It makes sense that the single row for a system (with a growing number of
> columns) will reside on a single mac
.@gmail.com]
发送时间: 2011年1月27日 9:15
收件人: user@cassandra.apache.org
主题: Re: Schema Design
It makes sense that the single row for a system (with a growing number of
columns) will reside on a single machine.
With that in mind, here is my updated schema:
- A single column family for all the mess
Ah, sweet... thanks for the link!
Bill-
On 01/26/2011 08:20 PM, buddhasystem wrote:
Bill, it's all explained here:
http://wiki.apache.org/cassandra/MemtableThresholds#JVM_Heap_Size,the
Watch the number of CFs and the memtable sizes.
In my experience, this all matters.
Bill, it's all explained here:
http://wiki.apache.org/cassandra/MemtableThresholds#JVM_Heap_Size,the
Watch the number of CFs and the memtable sizes.
In my experience, this all matters.
--
View this message in context:
http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/S
ich you means you'll definitely not be able to
distribute your load very well.
From: Bill Speirs [bill.spe...@gmail.com]
Sent: Wednesday, January 26, 2011 1:23 PM
To: user@cassandra.apache.org
Subject: Re: Schema Design
I like this approach, but I have 2 q
very well.
From: Bill Speirs [bill.spe...@gmail.com]
Sent: Wednesday, January 26, 2011 1:23 PM
To: user@cassandra.apache.org
Subject: Re: Schema Design
I like this approach, but I have 2 questions:
1) what is the implications of continually adding columns t
065146.n2.nabble.com/Schema-Design-tp5964167p5964326.html
Sent from the cassandra-u...@incubator.apache.org mailing list archive at
Nabble.com.
here are memory considerations.
> >
> > Cheers
> >
> > Maxim
> >
> > --
> > View this message in context:
> http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Schema-Design-tp5964167p5964227.html
> > Sent from the cassandra-u...@incubator.apache.org mailing list archive
> at Nabble.com.
> >
>
My cli knowledge sucks so far, so I'll leave that to othersI'm doing
most of my reading/writing through a thrift client (hector/java based)
As for the implications, as of the latest version of Cassandra there is not
theoretical limit to the number of columns that a particular row can hold.
O
s of using OPP.
>
> Whether to shard data as per system depends on how many you have. If more
> than a few, don't do that, there are memory considerations.
>
> Cheers
>
> Maxim
>
> --
> View this message in context:
> http://cassandra-user-incubator-apa
I like this approach, but I have 2 questions:
1) what is the implications of continually adding columns to a single
row? I'm unsure how Cassandra is able to grow. I realize you can have
a virtually infinite number of columns, but what are the implications
of growing the number of columns over time
ator-apache-org.3065146.n2.nabble.com/Schema-Design-tp5964167p5964227.html
Sent from the cassandra-u...@incubator.apache.org mailing list archive at
Nabble.com.
I would say in that case you might want to try a single column family
where the key to the column is the system name.
Then, you could name your columns as the timestamp. Then when retrieving
information from the data store you can can, in your slice request, specify
your start column as X and
I'm looking to use Cassandra to store log messages from various
systems. A log message only has a message (UTF8Type) and a data/time.
My thought is to create a column family for each system. The row key
will be a TimeUUIDType. Each row will have 7 columns: year, month,
day, hour, minute, second, an
indexed
>> currently may suck here, whenever a small no (10-20 ) of subcolumns
>> need to be retreived from a large list of subcolumns of a supercolumn
>> like MyPostsIdKeysList.
>>
>> On Fri, Jan 7, 2011 at 9:58 PM, Raj wrote:
>>> My question is in context of a
like MyPostsIdKeysList.
>
> On Fri, Jan 7, 2011 at 9:58 PM, Raj wrote:
>> My question is in context of a social network schema design
>>
>> I am thinking of following schema for storing a user's data that is
>> required as he logs in & is led to his homepage:-
context of a social network schema design
>
> I am thinking of following schema for storing a user's data that is
> required as he logs in & is led to his homepage:-
> (I aimed at a schema design such that through a single row read query
> all the data that would be require
My question is in context of a social network schema design
I am thinking of following schema for storing a user's data that is
required as he logs in & is led to his homepage:-
(I aimed at a schema design such that through a single row read query
all the data that would be required to p
the main idea is "denormalize your data into multiple CFs at write
time so that each CF lets you answer a query from a single row."
http://www.rackspacecloud.com/blog/2010/05/12/cassandra-by-example/ is
a good place to start.
On Tue, Jun 22, 2010 at 3:43 PM, Craig Faulkner
wrote:
> I'm having a
I'm having a little block in converting an existing SQL Server schema that we
have into Cassandra Keyspace(s). The whole key-value thing has just not
clicked yet. Do any of you know of any good examples that are more complex
than the example in the readme file?
We are looking to report on web
38 matches
Mail list logo