Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE entity_data (
- received_date timestamp,
- entity text,
- received_time timestamp,
- node int,
- primary key ((received_date ,entity),received_time));
- received_date | entity | received_time | node_id
- 2014-09-24 00:00:00+0400 | NA | 2014-09-24 18:56:55+0400 | 0 |
- select * from entity_data
- where received_date = '2014-09-24 00:00:00+0400' and entity = 'NA'
- and received_time='2014-09-24 18:56:55+0400';
- (0 rows)
- CREATE TABLE entity_data2 (
- received_date timestamp,
- entity text,
- received_time timeuuid,
- node int,
- PRIMARY KEY ((received_date, entity), received_time));
- INSERT INTO entity_data2 (received_date, entity, received_time , node)
- VALUES ('2014-09-24 00:00:00+0400','NA',now(),0);
- aploetz@cqlsh:stackoverflow> SELECT * FROM entity_data2
- WHERE received_date = '2014-09-24 00:00:00+0400' AND entity = 'NA'
- AND received_time>minTimeuuid('2014-10-08 08:13:53-0500')
- AND received_time<minTimeuuid('2014-10-08 08:13:54-0500');
- received_date | entity | received_time | node
- --------------------------+--------+--------------------------------------+------
- 2014-09-23 15:00:00-0500 | NA | f3b548b0-4eec-11e4-9d05-7991a041665c | 0
- (1 rows)
- aploetz@cqlsh:stackoverflow> SELECT received_date, entity, dateof(received_time), node
- FROM entity_data2 WHERE received_date = '2014-09-24 00:00:00+0400' AND entity = 'NA'
- AND received_time>minTimeuuid('2014-10-08 08:13:53-0500')
- AND received_time<minTimeuuid('2014-10-08 08:13:54-0500');
- received_date | entity | dateof(received_time) | node
- --------------------------+--------+--------------------------+------
- 2014-09-23 15:00:00-0500 | NA | 2014-10-08 08:13:53-0500 | 0
- (1 rows)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement