title: How to insert multiple rows in one line of insert at cassandra cql?
body: <p>I have following table called 'devices':</p>
  
  <p>userid | deviceid | devicedata | userdata</p>
  
  <p>All columns are varchars and userid+deviceid is the primary key.</p>
  
  <p>Inserting one row in to table seems working:</p>
  
  <pre><code>INSERT INTO devices (userid, deviceid, devicedata, userdata)
  VALUES ('user7', 'deviceid1', 'devicedata7', 'userdata1');
  </code></pre>
  
  <p>But following doesn't work:</p>
  
  <pre><code>INSERT INTO devices (userid, deviceid, devicedata, userdata) 
  VALUES (('user8', 'deviceid1', 'devicedata8', 'userdata1'), 
          ('user9', 'deviceid1', 'devicedata9', 'userdata1'));
  </code></pre>
  
  <p>I the get following error:</p>
  
  <pre><code>InvalidRequest: Error from server: code=2200 [Invalid query]
    message="Unmatched column names/values"
  </code></pre>
  
  <p>How can I insert multiple rows with one line of INSERT? Is it possible? I know that there is batching option.</p>