Advertisement
Guest User

Untitled

a guest
Sep 20th, 2017
410
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.76 KB | None | 0 0
  1. CREATE TABLE entity_data (
  2. received_date timestamp,
  3. entity text,
  4. received_time timestamp,
  5. node int,
  6. primary key ((received_date ,entity),received_time));
  7.  
  8. received_date | entity | received_time | node_id
  9. 2014-09-24 00:00:00+0400 | NA | 2014-09-24 18:56:55+0400 | 0 |
  10.  
  11. select * from entity_data
  12. where received_date = '2014-09-24 00:00:00+0400' and entity = 'NA'
  13. and received_time='2014-09-24 18:56:55+0400';
  14. (0 rows)
  15.  
  16. CREATE TABLE entity_data2 (
  17. received_date timestamp,
  18. entity text,
  19. received_time timeuuid,
  20. node int,
  21. PRIMARY KEY ((received_date, entity), received_time));
  22.  
  23. INSERT INTO entity_data2 (received_date, entity, received_time , node)
  24. VALUES ('2014-09-24 00:00:00+0400','NA',now(),0);
  25.  
  26. aploetz@cqlsh:stackoverflow> SELECT * FROM entity_data2
  27. WHERE received_date = '2014-09-24 00:00:00+0400' AND entity = 'NA'
  28. AND received_time>minTimeuuid('2014-10-08 08:13:53-0500')
  29. AND received_time<minTimeuuid('2014-10-08 08:13:54-0500');
  30.  
  31. received_date | entity | received_time | node
  32. --------------------------+--------+--------------------------------------+------
  33. 2014-09-23 15:00:00-0500 | NA | f3b548b0-4eec-11e4-9d05-7991a041665c | 0
  34.  
  35. (1 rows)
  36.  
  37. aploetz@cqlsh:stackoverflow> SELECT received_date, entity, dateof(received_time), node
  38. FROM entity_data2 WHERE received_date = '2014-09-24 00:00:00+0400' AND entity = 'NA'
  39. AND received_time>minTimeuuid('2014-10-08 08:13:53-0500')
  40. AND received_time<minTimeuuid('2014-10-08 08:13:54-0500');
  41.  
  42. received_date | entity | dateof(received_time) | node
  43. --------------------------+--------+--------------------------+------
  44. 2014-09-23 15:00:00-0500 | NA | 2014-10-08 08:13:53-0500 | 0
  45.  
  46. (1 rows)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement