I hope someone can clear my confusion about the difference between a line and a section in Kassandra. I thought the row would be a set of columns (as in SQL DB), as indicated in the scheme, distributed between the nodes by the partition keys and ordered by the clustering key in each partition.
But then I came across this lesson: https://academy.datastax.com/demos/getting-started-time-series-data-modeling
In the "Temporary inline template 1" section, it indicates:
Since each column is dynamic, our row will grow as needed to accommodate data.
Why will the line grow? I see the section growing, but why the row? The picture in this example also makes no sense to me - I believe that a section is a collection of rows, each of which has columns (WeatherStation | event), where WeatherStationID will be the same duplicate value for each row in the section.
I also tried to take a look at this tutorial: http://www.slideshare.net/yukim/cql3-in-depth , slide 15.
My reading is that it shows a single section with two lines. It seems to me that no matter how much new data you insert, the partition will grow, but not the row (of course, the "alter table" does not work)?
source
share