0

I am new to cassandra, is it possible to insert into only few columns in a table and leaving other columns for future filling?

Thanks in advance

Rajesh Kumar
  • 1,270
  • 4
  • 15
  • 31

1 Answers1

2

Yes. The syntax of the CQL INSERT gives you what you'd expect:

INSERT INTO table (col_1, col_5) VALUES (val1, val5)

Alex Popescu
  • 3,982
  • 18
  • 20
  • Do I need to use again insert or update for future filling of all other remaining columns? – Rajesh Kumar Mar 16 '15 at 08:41
  • You can use either. See: http://stackoverflow.com/questions/16532227/difference-between-update-and-insert-in-cassandra, http://www.datastax.com/documentation/cassandra/2.0/cassandra/dml/dml_about_inserts_c.html, http://planetcassandra.org/blog/how-to-do-an-upsert-in-cassandra/ for more details. – Alex Popescu Mar 16 '15 at 20:57