Stack Overflow
Stack Overflow

Questions tagged [super-columns]

23 questions
29
votes
1 answer

Why are super columns in Cassandra no longer favoured?

I have read in the latest release that super columns are not desirable due to "performance issues", but no where is this explained. Then I read articles such as this one that give wonderful indexing patterns using super columns. This leave me with…
IamIC
  • 16,207
  • 18
  • 81
  • 142
9
votes
4 answers

Mapping Cassandra Super Columns

I guess everybody that played with Cassandra already read this article. I trying to create my schema on CassandraCli, but I am having a lot of problems, can someone guide me to the right way? I am trying to create a similar structure like the…
Laubstein
  • 191
  • 2
  • 5
3
votes
1 answer

Create a Cassandra schema for a super column with metadata

I want the following structure in my database with the cassandra -cli for example I have a person with an address and the address contains a zipcode, housenumber etc schematic it looks like this: name: "address", value: { city: {name: "city",…
Rubenski
  • 237
  • 4
  • 9
3
votes
2 answers

Set Super Column Family in Cassandra Cli

I'm using Cassandra 0.8.0. I cannot figure out how to use the Cassandra-Cli to add values to a currently existing SuperColumn. For example: I have added the following to my keyspace create column family authors with comparator = UTF8Type and…
Henry
  • 916
  • 2
  • 11
  • 24
3
votes
1 answer

Hector querySuperColumns returns only partial super columns

I have the following code intending to grab over all the supercolumns for a key and then find a target data. but it turns out that it only return me partial super columns (for example - 100 out of 400). Is there any reason why and how to fix it? …
tom
  • 13,143
  • 18
  • 63
  • 120
2
votes
2 answers

Cassandra and supercolumns

I have next question: is it possible to create column family in cassandra that would look like this below and how to define it's structure: Users = { //CF AlexS : { //row key Address : { //supercolumn state: "NJ", …
Kitamo
  • 87
  • 1
  • 1
  • 12
2
votes
1 answer

Is storing 86k super columns (with 1-10 small columns each) per row a good idea in Cassandra?

tldr: Is ~90,000 super columns with 1 to 10 columns each too many in one row? How about ~1500? Column values are about 6 bytes each. full question: I am researching various data stores for time series data. Column oriented databases such as…
Alan Peabody
  • 3,327
  • 1
  • 18
  • 25
2
votes
1 answer

Cassandra super column structure

I'm new to Cassandra, and I'm not familiar with super columns. Consider this scenario: Suppose we have a some fields of a customer entity like Name Contact_no address and we can store all these values in a normal column. I want to arrange that…
user1662067
  • 19
  • 4
1
vote
1 answer

Create a SubColumn inside a Column Family in Cassandra

I have been trying to see if I can have nested columns in a cassandra column family either super or normal. I have look all over and have not fully seen what I am looking for. I am wanting to do something like this. `[{ firstname: "Me", …
Dan O'Halloran
  • 11
  • 1
1
vote
1 answer

Are there any Ruby clients for Cassandra with counters and supercolumn?

Are there any Ruby clients for Cassandra with support of counters and supercolumns? 1) gem cassandra doesn't support counters 2) gem cassandra-cql doesn't support supercolumns (cql doesn't support them)
Anton
  • 875
  • 8
  • 17
1
vote
1 answer

cassandra supercolumn data from one partition or multiple?

Assume I have a supercolumn family. Also assume I have multiple partitions running on different machine instances. My supercolumn family data looks like the following (for one row) RowKey: 4818d991-9df5-4899-aa07-461f4ed19996 =>…
tom
  • 13,143
  • 18
  • 63
  • 120
1
vote
1 answer

Representing a super column in Cassandra CQL

Currently, I have the following schema for one of my tables: id name ... country - id - name - city - id - name I was looking around the Cassandra documentation, and I cannot find any clear examples or demonstrations as to how I would…
madcrazydrumma
  • 1,727
  • 3
  • 15
  • 34
1
vote
1 answer

Best way to delete a subcolumn of a supercolumn family

I am trying to delete a sub-column of a super column family. I tried the following code but it won't work when the super column family has many super columns, it only returns partial super columns. SuperCfResult superCfResult =…
tom
  • 13,143
  • 18
  • 63
  • 120
1
vote
1 answer

Super-columns in Cassandra

I must do 5M (5 000 000) super-columns, or ~25M (5M * 5) regular composite-key columns. Alternatively I need to use ordered partitioner. What is exact downside of too many super columns? and why I should avoid them, because if i do composite keys,…
Nick
  • 8,479
  • 2
  • 36
  • 64
0
votes
0 answers

Cassandra and column family and super column family

In Cassandra, you have to defined a table's schedule in terms of columns very much like relational DB. The difference is there is no table join and primary key can be composite key. But a column family definition says each row (column family) can…
Kenneth
  • 185
  • 1
  • 1
  • 8
1
2