On Thu, Feb 4, 2016 at 2:37 AM, Bhuvan Rawal wrote:
> 1. Using super column family:
>
Super columns have been not-recommended for use for about five years now.
=Rob
wrote:
> Hi All,
>
> There are two ways to achieve this :
> 1. Using super column family:
>
> raman | atul | bhuvan
> ---
> 1234 | 5678 | 2345
>
> OR
> Using single Collection column :
> Phone Number
> ---
> Map
Hi All,
There are two ways to achieve this :
1. Using super column family:
raman | atul | bhuvan
---
1234 | 5678 | 2345
OR
Using single Collection column :
Phone Number
---
Map
I would like to know which approach would be better in the below
I'm trying to select the first x amount of column families within the super
> column family, however, I'm having absolutely no luck, and google searches
> don't seem to bring up much.
>
> I'm using Random Partitioning, and don't particularly wish to chan
On Sun, Aug 26, 2012 at 9:28 PM, Amit Handa wrote:
> Hi,
>
> i basically want to do hands-on on Super Column family concept, making some
> examples using hector api, and manually adding the data.
> I explored hector-example project, but only got very starting level of super
Hi,
i basically want to do hands-on on Super Column family concept, making some
examples using hector api, and manually adding the data.
I explored hector-example project, but only got very starting level of
super column family example.
i am in search of more super column family examples using
to super
> column
> > family.
> > i am using cassandra version 1.1.3
>
> Well, THERE's your problem... ;D
>
> But seriously.. as I understand project intent, super columns will
> ultimately be a weird API wrapper around composite keys. Also, super
> column famil
On Fri, Aug 24, 2012 at 4:33 AM, Amit Handa wrote:
> kindly help in resolving the following problem with respect to super column
> family.
> i am using cassandra version 1.1.3
Well, THERE's your problem... ;D
But seriously.. as I understand project intent, super columns will
u
userid:USER-1
}
}
That is:
- Column family = UserMovies
- Row Key = user1
- Column name = userid
- Column value = USER-1
As you see you have the super column missing in your update sentence.
Given this example
> USER-1(userid) -- MOVIEABCD (movie) -- 9 (rating)
>
I think you d
hi,
kindly help in resolving the following problem with respect to super column
family.
i am using cassandra version 1.1.3
i created two super families namely "UserMovies" and "movieSimilarity" in
cassandra using cassandra-cli:
*create column family movieSimilarity with colum
http://www.datastax.com/dev/blog/introduction-to-composite-columns-part-1
hope this help.
maki
2012/4/12 puneet loya :
> what is composite columns?
>
> super column under it can contain just multiple columns.. will composite
> columns be useful?
>
>
> On Thu, Apr 12, 2
what is composite columns?
super column under it can contain just multiple columns.. will composite
columns be useful?
On Thu, Apr 12, 2012 at 3:50 PM, Paolo Bernardi wrote:
> No.
> Maybe that a super column can contain composite columns but I'm not sure.
>
> Paolo
> On A
No.
Maybe that a super column can contain composite columns but I'm not sure.
Paolo
On Apr 12, 2012 12:15 PM, "puneet loya" wrote:
> Can a super column contain a super column?
>
> I mean is nesting of supercolumns possible?
>
> Regards,
>
> Puneet :)
>
Can a super column contain a super column?
I mean is nesting of supercolumns possible?
Regards,
Puneet :)
/04/2012, at 2:22 AM, Aliou SOW wrote:
> Dear All,
>
> I am new to Cassandra 1.0.8, and I use the tool json2sstable for bulk insert,
> but I still have the error:
>
> java.lang.RuntimeException: Can not write to the Standard columns Super
> Column F
Dear
All,
I am new to Cassandra 1.0.8, and I use the tool json2sstable for bulk
insert, but I still have the error:
java.lang.RuntimeException: Can not write to the Standard columns Super
Column Family.
Has org.apache.cassandra.tools.SSTableImport.importSorted
Dear All,
I am new
to Cassandra 1.0.8, and I use the tool json2sstable for bulk insert, but I
still have the error:
> Is it possible to mix both Standard and Super columns in the same
> Column Family?
No.
> create column family users
>with comparator = UTF8T
>and key_validation_class=UTF8TYpe
>and compression_options = { sstable_compression:SnappyCompressor,
> chunk_length_kb:64}
>and column_m
Is it possible to mix both Standard and Super columns in the same
Column Family? One of our Perl developers seems to have this working,
but I have been using the Java Pelops client and have been unable to
make this happen.
I'm not asking how to do with Pelops as I'll bug those guys if it is
possib
>> I am not sure if this is the right place to ask such question.
It is.
>> I read that it is not safe to use Super Column Family.
They are safe to use, but it's good to avoid them if you can.
>> <>Manager_Employee
>> <>#managerID:employeeID
>>
On 01/06/2012 01:48 PM, investtr wrote:
Please help me understand this.
I am not sure if this is the right place to ask such question.
I read that it is not safe to use Super Column Family.
And the alternative, I found was to use Composite Column Names.
Many managers will have many employees
Please help me understand this.
I am not sure if this is the right place to ask such question.
I read that it is not safe to use Super Column Family.
And the alternative, I found was to use Composite Column Names.
Many managers will have many employees.
*<>Manager_Employee
<&g
erver). Single command is for each row key. To be fully
understood, my question was about retrieving all super columns data of
single row key(single read command).
On Wed, Nov 9, 2011 at 21:04, Konstantin Naryshkin wrote:
> I assume that Reports is the Super column family, the first 1: is the
>
I assume that Reports is the Super column family, the first 1: is the
report id and in the topology is the row key, that the second 1: is
the report line and in the Cassandra topology the super column, and
that "value 1" is the column name. If this is not the case, maybe
explain th
Hi, first of all, let me say thank you for the the amazing product :-)
So, I have a couple of questions about internal physical data layout.
Suppose, I have the following data schema:
Reports:{
1:{
1:{"value1":"some val", "value2":"some val"},
2:{"value1":"some val", "value2":
ng normal columns?
>
> On Tue, Nov 1, 2011 at 7:06 PM, Mike Smith wrote:
> > Hi,
> > I'm having a problem with doing a multiget_slice on a super column family
> > after its first flush. Updates to the column values work properly, but
> > trying to retrieve the upd
Can you file a Jira ticket? And, can you reproduce using normal columns?
On Tue, Nov 1, 2011 at 7:06 PM, Mike Smith wrote:
> Hi,
> I'm having a problem with doing a multiget_slice on a super column family
> after its first flush. Updates to the column values work properly, b
Hi,
I'm having a problem with doing a multiget_slice on a super column family
after its first flush. Updates to the column values work properly, but
trying to retrieve the updated values using a multiget_slice operation fail
to get the updated values. Instead they return the values from b
Which version are you using? In my memory 0.8.3 cannot do it correctly but
> later versions fixed the bug.
>
> 從我的 BlackBerry® 無線裝置
>
> From: Ramesh S
> Date: Thu, 29 Sep 2011 15:23:29 -0500
> To:
> ReplyTo: user@cassandra.apache.org
> Subject: create super column fam
29 Sep 2011 15:23:29 -0500
> *To: *
> *ReplyTo: * user@cassandra.apache.org
> *Subject: *create super column family for
>
> I am trying to create a super column family using Cli command.
> But I am not getting it.
>
> The structure is
>
> <>ProductCategory
&g
Which version are you using? In my memory 0.8.3 cannot do it correctly but
later versions fixed the bug.
從我的 BlackBerry® 無線裝置
-Original Message-
From: Ramesh S
Date: Thu, 29 Sep 2011 15:23:29
To:
Reply-To: user@cassandra.apache.org
Subject: create super column family for
I am
tion_class: UTF8Type}
{column_name: lenght, validation_class: UTF8Type}
{column_name: width, validation_class: UTF8Type}
];
regards,
Ramesh
On Thu, Sep 29, 2011 at 3:23 PM, Ramesh S wrote:
> I am trying to create a super column family using Cli command.
> But I am not getting it.
>
I am trying to create a super column family using Cli command.
But I am not getting it.
The structure is
<>ProductCategory
<>#ProductType
<>#productCatId
+subProdName
+lenght
+width
I tried a lot many ways but I can't find the right way to get this done.
Something
t;
. This works because ; is the character right after : in ASCII. I believe that
UNICODE is ordered similarly to ASCII, though I am not 100% sure on that issue.
- Original Message -
From: "Renato Costa"
To: user@cassandra.apache.org
Sent: Thursday, September 22, 2011 6:35
Hi,
I started do modeling my application over cassandra data model. I will have
to use composite Super columns name, i.e. "username:userid", i know that is
a lot of different ways to deal with this case, but once i have modeled with
composite Super Columns name is there any way to make a sarch ove
to create 500,000 Super Column Families or 500,000 rows in a
> single Super Column Family ?
>
> The former is a somewhat crazy. Cassandra schemas typically have up to a few
> tens of Column Families. Each column family involves a certain amount of
> memory overhead, this is now autom
Are you planning to create 500,000 Super Column Families or 500,000 rows in a
single Super Column Family ?
The former is a somewhat crazy. Cassandra schemas typically have up to a few
tens of Column Families. Each column family involves a certain amount of memory
overhead, this is now
I am wondering about a certain volume situation.
I currently load a Keyspace with a certain amount of SCFs.
Each SCF (Super Column Family) represents an entity.
Each Entity may have up to 6000 values.
I am planning to have 500,000 Entities (SCF) with
6000 Columns (within Super Columns
hat:
>
> Any request for a sub-column deserializes all sub-columns for that super
> column, so you should avoid data models that rely on on large numbers of
> sub-columns.
>
> Is this still true?
>
> Thank you,
> Oleg
>
Hi All,
Cassandra documentation here:
http://www.datastax.com/docs/0.8/data_model/supercolumns
states that:
Any request for a sub-column deserializes all sub-columns for that super
column, so you should avoid data models that rely on on large numbers of
sub-columns.
Is this still true?
Thank
A ColumnPath can contain a super column, so you should be fine inserting a
super column family (in fact I do that). Quoting cassandra.thrift:
struct ColumnPath {
3: required string column_family,
4: optional binary super_column,
5: optional binary column,
}
- Original Message
For batch_insert, I think you could use batch_mutate instead.
For multi_get, I think you could use multiget_slice instead.
Boris
在 ，魏金仙 寫道：
insert(key, column_path, column, consistency_level) can only insert a
standard column.Is batch_mutate the only API to insert a super column?
and also
insert(key, column_path, column, consistency_level) can only insert a standard
column.
Is batch_mutate the only API to insert a super column?
and also can someone tell why batch_insert,multi_get is removed in version
0.7.4?
Recently we released Kundera-2.0.1
One feature which is included in this release is Secondary index support over
Super Column.
I have tried to compile a blog post for the same, which can be found for a
reference at:
http://mevivs.wordpress.com/2011/07/12/cassandra-play-kundera-orm/
-Vivek
Thank you, I will look into that and I will probably wait until there is an
"out of the box" comparator. But it's an excellent new feature !
Regards,
Victor K.
2011/5/5 Eric Evans
> On Thu, 2011-05-05 at 10:49 -0400, Victor Kabdebon wrote:
> > Hello Eric,
> >
> > Compound columns seem to be a v
On Thu, 2011-05-05 at 10:49 -0400, Victor Kabdebon wrote:
> Hello Eric,
>
> Compound columns seem to be a very interesting feature. Do you have any idea
> in which Cassandra version it is going to be introduced : 0.8.X or 0.9.X ?
You can use these today with a custom comparator[1]. There is an o
document. There are operations about column
> > families, but it does not describe how to operate on super column
> > families. Why? Does this mean that super column families would not be
> > supported by CQL in this version? Will it be supported in the future?
>
> No CQL will
On Thu, 2011-05-05 at 18:19 +0800, Guofeng Zhang wrote:
> I read the CQL v1.0 document. There are operations about column
> families, but it does not describe how to operate on super column
> families. Why? Does this mean that super column families would not be
> supported by CQL in
Hi,
I read the CQL v1.0 document. There are operations about column families,
but it does not describe how to operate on super column families. Why? Does
this mean that super column families would not be supported by CQL in this
version? Will it be supported in the future?
Thanks.
Guofeng
; Good afternoon,
>>
>> I'm making my data model from scratch for cassandra, this means i can tune
>> and fine tune it for performance.
>>
>> At this time i'm having problems choosing between a 2 column families or 1
>> super column family. I will il
> uuid1.text and uuid2.text
>
> Hope that helps.
> Aaron
>
> On 30 Mar 2011, at 01:05, T Akhayo wrote:
>
> Good afternoon,
>
> I'm making my data model from scratch for cassandra, this means i can tune
> and fine tune it for performance.
>
> At this time
ans i can tune
> and fine tune it for performance.
>
> At this time i'm having problems choosing between a 2 column families or 1
> super column family. I will illustrate with a example.
>
> Sector, this defines a place, this is one or two properties.
> Entry, a entry t
Good afternoon,
I'm making my data model from scratch for cassandra, this means i can tune
and fine tune it for performance.
At this time i'm having problems choosing between a 2 column families or 1
super column family. I will illustrate with a example.
Sector, this defines a plac
bator-apache-org.3065146.n2.nabble.com/Can-I-count-on-Super-Column-Families-why-planing-3-years-out-tp6057997p6057997.html
Sent from the cassandra-u...@incubator.apache.org mailing list archive at
Nabble.com.
I'm very new to Cassandra, but I'll pitch in my $0.02.
Row look-ups are super fast, why do you think it would be more efficient to
store these two rows "together" in the super column method you describe?
Why would you not just look-up the rows, one after the other?
If I
t that the queries you do less often
will be slower," depending on your workload (e.g. ratio of reads to
writes).
On Fri, Jan 28, 2011 at 12:20 PM, Ertio Lew wrote:
> Hi,
>
> I have two kinds of data that I would like to fit in one super column
> family; I am trying this, for t
Could someone please point me in right direction by commenting on the above
ideas ?
On Fri, Jan 28, 2011 at 11:50 PM, Ertio Lew wrote:
> Hi,
>
> I have two kinds of data that I would like to fit in one super column
> family; I am trying this, for the reasons of implementing fas
Hi,
I have two kinds of data that I would like to fit in one super column
family; I am trying this, for the reasons of implementing fast
database retrievals by combining the data of two rows into just one
row.
First kind of data, in supercolumn family, is named with timeUUIDs as
supercolumn
Curious if anyone has done input from a cassandra super column? Any support
for this currently? Thanks
Hello,
I'm using cassandra 0.7.0-rc2. When I tried to get column contents in a
super column of Super CF like below;
] get myCF['key']['scName'];
the client reply
supercolumn parameter is not optional for super CF user
It seemed to work in cassandra-0.7.0-beta2, if my
On Tue, Dec 7, 2010 at 4:28 PM, Donal Zang wrote:
> Hi,
> I'm using 0.7.0-rc1,and when I use cassandra-cli to create a column family
> with metadata, I got "null",and no column family is created.
> The command I use is:
>
> create keyspace test;
> use test;
> create column family test1 with column
Hi,
I'm using 0.7.0-rc1,and when I use cassandra-cli to create a column
family with metadata, I got "null",and no column family is created.
The command I use is:
/create keyspace test;
use test;
create column family test1 with column_type = 'Super' and comparator =
'LongType' and column_metada
d, the current mapper gets a map of column names to IColumns. The SuperColumn implements the IColumn interface. So you would probably need both the super column name and the subcolumn name to get at it, but you just need to cast the IColumn to a super column and handle it from there.
>>
>&g
.db.SuperColumn.
>
> Have your tried it ?
>
> Aaron
>
>
>
> On 20 Oct 2010, at 04:44, Jeremy Hanna wrote:
>
>> It's relatively straightforward, the current mapper gets a map of column
>> names to IColumns. The SuperColumn implements the IColumn i
n
> names to IColumns. The SuperColumn implements the IColumn interface. So you
> would probably need both the super column name and the subcolumn name to get
> at it, but you just need to cast the IColumn to a super column and handle it
> from there.
>
> On Oct 19, 201
It's relatively straightforward, the current mapper gets a map of column names
to IColumns. The SuperColumn implements the IColumn interface. So you would
probably need both the super column name and the subcolumn name to get at it,
but you just need to cast the IColumn to a super colum
I have a Hadoop installation working with a cluster of 0.7 Beta 2 Nodes, and
got the WordCount example to work using the standard configuration. I have
been inserting data into a Super Column (Sensor) with TimeUUID as the
compare type, it looks like this:
get Sensor['DeviceID:S
As per my knowledge in phpCassa I didnt find any option to remove a
column from the supercolumn, The remove method removes the whole super
column from the key, will check with thrift api.
Through mutation object insert/update happens but removing a column
dosent happen.
Thank you all.
Regards
On Wed, Jul 7, 2010 at 12:16 AM, Jonathan Ellis wrote:
>>
>> insert is insert-or-update. leaving out a column from an update
>> doesn't delete it, you need to use the remove method for that.
>>
>> On Tue, Jul 6, 2010 at 7:41 AM, Moses Dinakaran
>> wr
apache.org
Ämne: Re: Query on delete a column inside a super column
Hi,
Thanks for the reply,
The remove method
$cassandraInstance->remove('cache_pages_key_hash', 'hash_1' )
which will remove the whole key, But I don't want to do that, I need to remove
one column ins
e:
> > Hi All,
> >
> > I have a query related to deleting a column inside a super column
> >
> > The following is my cassandra schema
> >
> > [cache_pages_key_hash] => Array
> >(
> >[hash_1] => Array
insert is insert-or-update. leaving out a column from an update
doesn't delete it, you need to use the remove method for that.
On Tue, Jul 6, 2010 at 7:41 AM, Moses Dinakaran
wrote:
> Hi All,
>
> I have a query related to deleting a column inside a super column
>
> The follo
Hi All,
I have a query related to deleting a column inside a super column
The following is my cassandra schema
[cache_pages_key_hash] => Array
(
[hash_1] => Array
(
[1] => 4c330e95195f9
[2] => 4
Actually I think in the video they said they store each messageID as a
seperate column, that way they can do range queries correct?
so it would be:
aloha: { message1: "2343", message2: "9590002", }
On Thu, Jul 1, 2010 at 6:25 PM, S Ahmed wrote:
> So trying to map how facebook implemented a
So trying to map how facebook implemented a CF of type Super to index
message terms.
Is this json representation correct?
MessageIndex = {
userid1 : {
aloha : { messageIdList:
"234,2343234,23423434,234255,345345,2342,532432"},
clown : { messageIdList: "632, 2342, 23452, 234234, 23423
the TTL (expiring columns) feature in 0.7 is the easiest way to do
this. Until then you'd have to delete them manually.
On Sun, May 23, 2010 at 3:35 AM, Yan Virin wrote:
> Hi
> I want to use cassandra for storing some data which gets irrelevant with
> time. There will be a lot of data and I want
(a) No
(b) you should restrict it to < 2GB of data in 0.6
On Sat, May 22, 2010 at 3:55 AM, huajun qi wrote:
> Can the value of a column under a super column be a super column?
>
> For examples:
>
> sc={
> name:"name",
> value:{
>
;, 'attrB' => 'b1' },
> => { 'id'=>2, 'attrA' => 'a2', 'attrB' => 'b1' }
>...
>}
>
> The number of attributes are quite limited currently (below 20) and
> for now we only plan to have no more than 1000
27;attrB' => 'b1' }
...
}
The number of attributes are quite limited currently (below 20) and
for now we only plan to have no more than 1000 events per minute. So
this should be really a piece of cake for Cassandra. With this little
data using a super column should be n
and
finish is for the standard columns
Thanks for all your help. Appreciated!
Dop
-Original Message-
From: Dop Sun [mailto:su...@dopsun.com]
Sent: Monday, April 12, 2010 9:44 PM
To: user@cassandra.apache.org
Subject: RE: FW: Is there any way to enable the multiple super column names
uper1.
Regards,
Dop
-Original Message-
From: Dop Sun [mailto:su...@dopsun.com]
Sent: Monday, April 12, 2010 9:03 PM
To: user@cassandra.apache.org
Subject: RE: FW: Is there any way to enable the multiple super column names
at a time?
Thanks for your quick reply.
Actually, I tried to lea
Thanks for your quick reply.
Actually, I tried to leave it as null or byte[0], nothing returned, and if I
put right super column value, it returns 3 items actually (in my simple test
case).
I'm using get_range_slices.
I'm calling two times with all other arguments same.
I'm us
certain range of super column
> in a single query?
>
> I have checked the following APIs, but looks they don't work for this:
> get: for a single column
> get_slice: contains column_parent as parameter, means a single CF + SC
> multiget_slice: contains column_parent
I guess I'm putting in the wrong email list. Sorry for this.
My question in short is: whether I can get a certain range of super column
in a single query?
I have checked the following APIs, but looks they don't work for this:
get: for a single column
get_slice: contains column
SCF rows are loaded in their entirety into memory, so the limit
applies in the same way.
On Wed, Apr 7, 2010 at 5:16 PM, Jeremy Davis
wrote:
> Quick question:
> There is an open issue with ColumnFamilies growing too large to fit in
> memory when compacting..
> Does this same limit also apply to S
Quick question:
There is an open issue with ColumnFamilies growing too large to fit in
memory when compacting..
Does this same limit also apply to SCF? As long as each sub CF is
sufficiently small, etc.
-JD
86 matches
Mail list logo
