Search code examples
database-designcassandrahector

Is it possible to create a columnfamily which contains normal column as well as super column?

I am looking for a column family in which i can add both super columns and normal columns like in the example below

keyspace1{
      :rowid1 AND its associated column field
      :rowid2 with a Super Column 
}

is it possible? if yes plz suggest Thanks in Advance

Solution

  • The answer to the question is no it's not possible. You can't mix standard and super columns in a single column family. It's better if you avoid super column as it is being deprecated over time.

    However I did recently see an article on the Cassandra user group identifying some advantages of super column families.