Advertisement
Guest User

Untitled

a guest
Jul 23rd, 2017
51
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.93 KB | None | 0 0
  1. //Create cluster
  2. Cluster cluster = Cluster.builder().addContactPoint(hostNameOrIp)
  3. //Get session
  4. Session session = cluster.connect();
  5. //create keyspace using session
  6. session.execute(String.format("CREATE KEYSPACE IF NOT EXISTS %s WITH REPLICATION = {'class' : 'SimpleStrategy', 'replication_factor': %d}",
  7. QueryBuilder.quote("MY_KS"),
  8. 1)
  9. );
  10.  
  11. String tableQuery = "CREATE TABLE timeline2 (
  12. key varchar,
  13. open float,
  14. high float,
  15. low float,
  16. close float,
  17. volume int,
  18. adjusted float,
  19. dtime timestamp,
  20. PRIMARY KEY (key, dtime)
  21. )";
  22.  
  23. //create columnFamily using session
  24. ResultSet result = session.execute(tableQuery);
  25.  
  26. Map<String, String> accessMap = new HashMap<String, String>();
  27. accessMap.put("username", username);
  28. accessMap.put("password", password);
  29.  
  30. Cluster cluster = HFactory.getOrCreateCluster("TEST_CLUSTER", new CassandraHostConfigurator(cassandraUrl), accessMap);
  31.  
  32. ColumnFamilyDefinition cfDef = HFactory.createColumnFamilyDefinition("MY_KS", ComparatorType.BYTESTYPE);
  33.  
  34. KeyspaceDefinition newKeyspaceDef = HFactory.createKeyspaceDefinition("MY_KS", ThriftKsDef.DEF_STRATEGY_CLASS, 1, Arrays.asList(cfDef));
  35.  
  36. //Add the schema to the cluster.
  37. //"true" as the second param means that Hector will block until all nodes see the change.
  38. cassandraCluster.addKeyspace(newKeyspaceDef, true);
  39.  
  40. Keyspace ksp = HFactory.createKeyspace("MY_KS", cassandraCluster);
  41.  
  42. //This will give a connection to the cluster
  43. Cluster cassandraCluster = connectApacheCassandra();
  44.  
  45. ColumnFamilyDefinition cfDef = HFactory.createColumnFamilyDefinition("TEST_KS", "TEST_CF",
  46. ComparatorType.BYTESTYPE);
  47.  
  48. KeyspaceDefinition newKeyspaceDef = HFactory.createKeyspaceDefinition("TEST_KS", ThriftKsDef.DEF_STRATEGY_CLASS, 1, Arrays.asList(cfDef));
  49.  
  50.  
  51. cassandraCluster.addKeyspace(newKeyspaceDef, true);
  52.  
  53. Keyspace ksp = HFactory.createKeyspace("TEST_KS", cassandraCluster);
  54.  
  55. BasicColumnFamilyDefinition columnFamilyDefinition = new BasicColumnFamilyDefinition(cfDef);
  56.  
  57. cassandraCluster.addKeyspace(newKeyspaceDef, true);
  58.  
  59. Keyspace ksp = HFactory.createKeyspace("TEST_KS", cassandraCluster);
  60.  
  61. BasicColumnFamilyDefinition columnFamilyDefinition = new BasicColumnFamilyDefinition(cfDef);
  62.  
  63. BasicColumnDefinition columnDefinition = new BasicColumnDefinition();
  64. columnDefinition.setName(StringSerializer.get().toByteBuffer("aKey"));
  65. columnDefinition.setIndexName("key_idx1");
  66. columnDefinition.setIndexType(ColumnIndexType.KEYS);
  67. columnDefinition.setValidationClass(ComparatorType.LONGTYPE.getClassName());
  68. columnFamilyDefinition.addColumnDefinition(columnDefinition);
  69.  
  70. columnDefinition = new BasicColumnDefinition();
  71. columnDefinition.setName(StringSerializer.get().toByteBuffer("aTestColumn"));
  72. columnDefinition.setValidationClass(ComparatorType.LONGTYPE.getClassName());
  73. columnFamilyDefinition.addColumnDefinition(columnDefinition);
  74.  
  75. cassandraCluster.updateColumnFamily(new ThriftCfDef(columnFamilyDefinition));
  76.  
  77. CREATE TABLE "TEST_CF" (
  78. key blob,
  79. column1 blob,
  80. "614b6579" bigint,
  81. "6154657374436f6c756d6e" bigint,
  82. value blob,
  83. PRIMARY KEY (key, column1)
  84. ) WITH COMPACT STORAGE AND
  85. bloom_filter_fp_chance=0.010000 AND
  86. caching='KEYS_ONLY' AND
  87. comment='' AND
  88. dclocal_read_repair_chance=0.000000 AND
  89. gc_grace_seconds=864000 AND
  90. index_interval=128 AND
  91. read_repair_chance=1.000000 AND
  92. replicate_on_write='true' AND
  93. populate_io_cache_on_flush='false' AND
  94. default_time_to_live=0 AND
  95. speculative_retry='NONE' AND
  96. memtable_flush_period_in_ms=0 AND
  97. compaction={'class': 'SizeTieredCompactionStrategy'} AND
  98. compression={'sstable_compression': 'LZ4Compressor'};
  99.  
  100. CREATE TABLE TEST_CF (
  101. aKey varchar,
  102. aColumn varchar
  103. PRIMARY KEY (aKey )
  104. )";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement