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&