Advertisement
Guest User

Untitled

a guest
Sep 21st, 2017
54
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.44 KB | None | 0 0
  1. >>>'000000020000000000000003' < '000000010000000000000005'
  2. False
  3.  
  4. >>>'000000020000000000000003' < '000000010000000000000005'
  5. False
  6.  
  7. CREATE TABLE sl (
  8. name text,
  9. data blob,
  10. PRIMARY KEY (name)
  11. ) WITH
  12. bloom_filter_fp_chance=0.010000 AND
  13. caching='KEYS_ONLY' AND
  14. comment='' AND
  15. dclocal_read_repair_chance=0.000000 AND
  16. gc_grace_seconds=864000 AND
  17. index_interval=128 AND
  18. read_repair_chance=0.100000 AND
  19. replicate_on_write='true' AND
  20. populate_io_cache_on_flush='false' AND
  21. default_time_to_live=0 AND
  22. speculative_retry='99.0PERCENTILE' AND
  23. memtable_flush_period_in_ms=0 AND
  24. compaction={'class': 'SizeTieredCompactionStrategy'} AND
  25. compression={'sstable_compression': 'LZ4Compressor'};
  26.  
  27. CREATE TABLE sl (
  28. name text,
  29. data blob,
  30. PRIMARY KEY (name)
  31. ) WITH
  32. bloom_filter_fp_chance=0.010000 AND
  33. caching='KEYS_ONLY' AND
  34. comment='' AND
  35. dclocal_read_repair_chance=0.000000 AND
  36. gc_grace_seconds=864000 AND
  37. index_interval=128 AND
  38. read_repair_chance=0.100000 AND
  39. replicate_on_write='true' AND
  40. populate_io_cache_on_flush='false' AND
  41. default_time_to_live=0 AND
  42. speculative_retry='99.0PERCENTILE' AND
  43. memtable_flush_period_in_ms=0 AND
  44. compaction={'class': 'SizeTieredCompactionStrategy'} AND
  45. compression={'sstable_compression': 'LZ4Compressor'};
  46.  
  47. CREATE TABLE sl (
  48. type text,
  49. name text,
  50. data blob,
  51. PRIMARY KEY (type, name)
  52. )
  53.  
  54. select * from sl where type='sometype' AND name < '000000010000000000000005';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement