I'm running a 3 node cluster, each with 4 cores and 16gb memory.
When creating the following table (by copying and pasting into cqlsh) each line is pasted in one at a time, and the time between each line being pasted in seems to grow exponentially, especially once the counter columns were reached.
While I left the create table to run memory usage crept up to 70%, and CPU usage went up to 107%.
I have attached a screenshot of what cqlsh looked like after ~20 minutes.
I tried the query again but in 1 line (as below) and it executed instantly.