Guest User

Untitled

a guest
Mar 22nd, 2018
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.88 KB | None | 0 0
  1. CREATE TABLE metrics.my_test (
  2. metric_name text,
  3. metric_week text,
  4. metric_time timestamp,
  5. tags map<text, text>,
  6. value double,
  7. PRIMARY KEY ((metric_name, metric_week), metric_time)
  8. ) WITH CLUSTERING ORDER BY (metric_time DESC)
  9. AND compaction = {'class': 'org.apache.cassandra.db.compaction.TimeWindowCompactionStrategy', 'compaction_window_size': '1', 'compaction_window_unit': 'MINUTES'}
  10. AND default_time_to_live = 7776000
  11. AND gc_grace_seconds = 60;
  12.  
  13. # for f in *Data.db; do ls -l $f && java -jar /root/sstable-tools-3.11.0-alpha11.jar describe $f | grep timestamp; done
  14. -rw-r--r-- 1 cassandra cassandra 1431 Mar 22 17:29 mc-10-big-Data.db
  15. Minimum timestamp: 1521739701309280 (03/22/2018 17:28:21)
  16. Maximum timestamp: 1521739777814859 (03/22/2018 17:29:37)
  17. -rw-r--r-- 1 cassandra cassandra 619 Mar 22 17:30 mc-11-big-Data.db
  18. Minimum timestamp: 1521739787241285 (03/22/2018 17:29:47)
  19. Maximum timestamp: 1521739810545148 (03/22/2018 17:30:10)
  20. -rw-r--r-- 1 cassandra cassandra 654 Mar 22 17:20 mc-1-big-Data.db
  21. Minimum timestamp: 1521739189529560 (03/22/2018 17:19:49)
  22. Maximum timestamp: 1521739216248636 (03/22/2018 17:20:16)
  23. -rw-r--r-- 1 cassandra cassandra 1154 Mar 22 17:21 mc-2-big-Data.db
  24. Minimum timestamp: 1521739217033715 (03/22/2018 17:20:17)
  25. Maximum timestamp: 1521739277579629 (03/22/2018 17:21:17)
  26. -rw-r--r-- 1 cassandra cassandra 855 Mar 22 17:22 mc-3-big-Data.db
  27. Minimum timestamp: 1521739283859916 (03/22/2018 17:21:23)
  28. Maximum timestamp: 1521739326037634 (03/22/2018 17:22:06)
  29. -rw-r--r-- 1 cassandra cassandra 1047 Mar 22 17:23 mc-4-big-Data.db
  30. Minimum timestamp: 1521739327868930 (03/22/2018 17:22:07)
  31. Maximum timestamp: 1521739387131847 (03/22/2018 17:23:07)
  32. -rw-r--r-- 1 cassandra cassandra 1288 Mar 22 17:24 mc-5-big-Data.db
  33. Minimum timestamp: 1521739391318240 (03/22/2018 17:23:11)
  34. Maximum timestamp: 1521739459713561 (03/22/2018 17:24:19)
  35. -rw-r--r-- 1 cassandra cassandra 767 Mar 22 17:25 mc-6-big-Data.db
  36. Minimum timestamp: 1521739461284097 (03/22/2018 17:24:21)
  37. Maximum timestamp: 1521739505132186 (03/22/2018 17:25:05)
  38. -rw-r--r-- 1 cassandra cassandra 1216 Mar 22 17:26 mc-7-big-Data.db
  39. Minimum timestamp: 1521739507504019 (03/22/2018 17:25:07)
  40. Maximum timestamp: 1521739583459167 (03/22/2018 17:26:23)
  41. -rw-r--r-- 1 cassandra cassandra 749 Mar 22 17:27 mc-8-big-Data.db
  42. Minimum timestamp: 1521739587644109 (03/22/2018 17:26:27)
  43. Maximum timestamp: 1521739625351120 (03/22/2018 17:27:05)
  44. -rw-r--r-- 1 cassandra cassandra 1259 Mar 22 17:28 mc-9-big-Data.db
  45. Minimum timestamp: 1521739627983733 (03/22/2018 17:27:07)
  46. Maximum timestamp: 1521739698691870 (03/22/2018 17:28:18)
  47.  
  48. # for f in *Data.db; do ls -l $f && java -jar /root/sstable-tools-3.11.0-alpha11.jar describe $f | grep timestamp; done
  49. -rw-r--r-- 1 cassandra cassandra 8677 Mar 22 17:30 mc-12-big-Data.db
  50. Minimum timestamp: 1521739189529561 (03/22/2018 17:19:49)
  51. Maximum timestamp: 1521739810545148 (03/22/2018 17:30:10)
Add Comment
Please, Sign In to add comment