shutyaev

Untitled

Apr 22nd, 2015
317
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.94 KB | None | 0 0
  1. CREATE KEYSPACE cache WITH replication = {'class': 'SimpleStrategy', 'replication_factor': '3'} AND durable_writes = true;
  2.  
  3. CREATE TABLE cache.physicalversiondata (
  4. key text PRIMARY KEY,
  5. created timestamp,
  6. createdby text,
  7. data blob,
  8. dataformat text,
  9. datasource text,
  10. modified timestamp,
  11. modifiedby text,
  12. uid text,
  13. versionnotes text,
  14. versionnumber int
  15. ) WITH bloom_filter_fp_chance = 0.01
  16. AND caching = '{"keys":"ALL", "rows_per_partition":"NONE"}'
  17. AND comment = ''
  18. AND compaction = {'min_threshold': '4', 'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy', 'max_threshold': '32'}
  19. AND compression = {'sstable_compression': 'org.apache.cassandra.io.compress.LZ4Compressor'}
  20. AND dclocal_read_repair_chance = 0.1
  21. AND default_time_to_live = 0
  22. AND gc_grace_seconds = 259200
  23. AND max_index_interval = 2048
  24. AND memtable_flush_period_in_ms = 0
  25. AND min_index_interval = 128
  26. AND read_repair_chance = 0.0
  27. AND speculative_retry = '99.0PERCENTILE';
  28.  
  29. CREATE TABLE cache.physicalentitydata (
  30. uid text PRIMARY KEY,
  31. created timestamp,
  32. createdby text,
  33. entitytype text,
  34. modified timestamp,
  35. modifiedby text,
  36. status text,
  37. updatepolicy text,
  38. versionscount int
  39. ) WITH bloom_filter_fp_chance = 0.01
  40. AND caching = '{"keys":"ALL", "rows_per_partition":"NONE"}'
  41. AND comment = ''
  42. AND compaction = {'min_threshold': '4', 'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy', 'max_threshold': '32'}
  43. AND compression = {'sstable_compression': 'org.apache.cassandra.io.compress.LZ4Compressor'}
  44. AND dclocal_read_repair_chance = 0.1
  45. AND default_time_to_live = 0
  46. AND gc_grace_seconds = 259200
  47. AND max_index_interval = 2048
  48. AND memtable_flush_period_in_ms = 0
  49. AND min_index_interval = 128
  50. AND read_repair_chance = 0.0
  51. AND speculative_retry = '99.0PERCENTILE';
Advertisement
Add Comment
Please, Sign In to add comment