title: Composite and non-composite columns in the same ColumnFamily?
body: <p>I am working on my first project with the Cassandra database, and I'm trying to wrap my head around the data modelling. I am attempting to come up with a ColumnFamily definition that allows me to store some data that could be modelled (in C#) like this:</p>
  
  <pre><code>class the_data
  {
      public string prop_1;
      public string prop_2;
      public Dictionary&lt;string, Dictionary&lt;string, List&lt;string&gt;&gt;&gt; other_data;
  }
  </code></pre>
  
  <p>Now, the other_data can have its keys combined to create something like this:</p>
  
  <pre><code>public Dictionary&lt;string, List&lt;string&gt;&gt; other_data;
  </code></pre>
  
  <p>(where the key in this dictionary would be the combination of the two keys in the previous version).</p>
  
  <p>I believe that I could model just this part of the data in Cassandra using a composite column, like so:</p>
  
  <pre><code>CREATE TABLE some_data
  {
      row_key text,
      other_data_outer_key text,
      other_data_inner_key text,
      other_data_value text,
      PRIMARY KEY (row_key, other_data_outer_key, other_data_inner_key)
  };
  </code></pre>
  
  <p>What I don't understand, however (or maybe it isn't possible), is how to have the composite column (because other_data_outer_key and other_data_inner_key become parts of the column name), as well as other columns that are NOT composite columns, nor duplicated for every combination of keys.</p>
  
  <p>I'd like something like this:</p>
  
  <pre><code>CREATE TABLE some_data
  {
      row_key text,                    &lt;--- row key (partition key?)
      prop_1 text,                     &lt;--- just a normal column (one per row) #1
      prop_2 text,                     &lt;--- just a normal column (one per row) #2
      other_data_outer_key text,       &lt;--- composite column name part 1
      other_data_inner_key text,       &lt;--- composite column name part 2
      other_data_value text,           &lt;--- composite column value
      PRIMARY KEY (row_key, other_data_outer_key, other_data_inner_key)
  };
  </code></pre>
  
  <p>Is this possible? How can I accomplish this?</p>