title: How to define keyspaces for a timeseries data in Cassandra?
body: <p>There are 100s of data points, each data point has its own seperate table with schema and queries as mentioned below:</p>
  <h2>Current Schema in SQLite</h2>
  <ul>
  <li>Table Name: Name of Data Point e.g. Tempearature</li>
  <li>Column-1: Name: Timestamp Type: TEXT (yyyy-MM-dd HH:mm:ss.ttt format) PRIMARY KEY</li>
  <li>Column-2: Name: Value Type: FLOAT</li>
  <li>Column-3: Name: Quality Type: TEXT (&quot;GOOD&quot;, &quot;BAD&quot;)</li>
  </ul>
  <h2>Queries for SQLite</h2>
  <ul>
  <li>SELECT * FROM <em>data-point-name</em>;</li>
  <li>SELECT * FROM <em>data-point-name</em> WHERE Timestamp BETWEEN <em>timesamp-1</em> AND <em>timestamp-2</em>;</li>
  <li>INSERT INTO <em>data-point-name</em> (Timestamp, Value, Quality) VALUES (&quot;2016-01-01 00:00:05.254&quot;, 123.25454, &quot;GOOD&quot;); (this is an example)</li>
  </ul>
  <p>Currently I have SQLite db where I have a table per data-point with above schema, essentially I have 100s of tables. This way reads/writes are not disturbing queries running on different data-points.</p>
  <p>How to translate this schema to be used in Cassandra?</p>