Cassandra is inserting null values in skipped column
<p>Anybody please help me understand why Cassandra is inserting null values in columns that was skipped? Isn't it supposed to skip the column? It should not insert any value (not even null) if I skip the column entirely while inserting data? I am bit confused because as per the following tutorial, data is stored by row key with the columns (the diagram in column family), if it is true then I should not get null for the column. </p>

<p>Or the whole concept I learned about the Cassandra column family is wrong?</p>

<p><a href="http://www.tutorialspoint.com/cassandra/cassandra_data_model.htm" rel="nofollow">http://www.tutorialspoint.com/cassandra/cassandra_data_model.htm</a></p>

<p><strong>Here is the CQL script</strong></p>

<pre><code>create keyspace test WITH replication =  {'class': 'SimpleStrategy',   'replication_factor': '1'};
create table users (firstname text,lastname text,age int, gender ascii, primary key(firstname))
insert into users(firstname,age,gender,lastname) values("Michael",30,"male","smith");
</code></pre>

<p>Here, I am skipping a column, but when I run select query, it shows null for that column. Why Cassandra is filling up null in that column?</p>

<pre><code>insert into users(firstname,age,gender) values('Jane',23,'female');

select * from users;
</code></pre>