Cassandra的timestamp类型

cqlsh:testspace> CREATE TABLE test_timestamp(id int, date timestamp, PRIMARY KEY(id,date));
cqlsh:testspace> INSERT INTO test_timestamp (id, date ) VALUES ( 1,'2015-05-18 09:00');
cqlsh:testspace> INSERT INTO test_timestamp (id, date ) VALUES ( 4,'2015-05-17 22:48:38');
cqlsh:testspace> INSERT INTO test_timestamp (id, date ) VALUES ( 3,'2015-05-17 21:48:38');
cqlsh:testspace> INSERT INTO test_timestamp (id, date ) VALUES ( 2,'2015-05-17 20:48:38');
cqlsh:testspace> SELECT * FROM test_timestamp 
             ... ;


 id | date
----+--------------------------
  1 | 2015-05-18 09:00:00+0800
  2 | 2015-05-17 20:48:38+0800
  4 | 2015-05-17 22:48:38+0800
  3 | 2015-05-17 21:48:38+0800


(4 rows)

查询语句不限定PRIMARY KEY的话需要用ALLOW FILTERING

cqlsh:testspace> SELECT * FROM test_timestamp WHERE date&