title: Saving data in matrix format in Cassandra?
body: <p>I am working with Cassandra and want to store data in matrix format. Currently, I am storing the values using Lists.
  For example: I have created a table "matrix"</p>
  
  <pre><code>CREATE TABLE matrix (row_id int PRIMARY KEY, row_values list&lt;int&gt;);
  </code></pre>
  
  <p>And I entered some values in the table. (Note: the number of rows and columns can vary)</p>
  
  <pre><code>INSERT INTO matrix (row_id, row_values) values (1, [1,2,3,4,5,6,.......]);
  </code></pre>
  
  <p>Now I want to retrieve the 2nd element of the row_values, but with my method I am not able to retrieve the 2nd element of the list, however I can update and delete the element using below query:</p>
  
  <pre><code>UPDATE matrix SET row_values[1] = 50 where row_id =1;
  </code></pre>
  
  <p>Now my question is, whether it is possible to retrieve a specific element from list. If not then is there any other method which I can use to store data in matrix form and retrieve any element from the matrix? </p>