How to add NOT NULL constraint for column in Cassandra?

Question

I'm creating a table in Cassandra key space, i want to add NOT NULL constraint for one column in table. I've googled for that but didn't find any answer. Does Cassandra supports all functions supported by Relational Databases?

Answer 1

Why do you want to add that constraint? This would defeat the purpose of the "new" storage engine where you can dynamically add columns to tables. However, back to your question you can specify WITH COMPACT ENGINE when creating the table. That will effectively force you to insert a value in all the columns of the table.

BTW, Cassandra is a very different beast. It is not a relational database, you should look carefully at your requirements before everything else.