@Before public void setupLocal() { //setupClient(); Cluster cluster = getOrCreateCluster("MyCluster", "127.0.0.1:9170"); keyspace = createKeyspace("Keyspace1", cluster); Mutator<String> mutator = HFactory.createMutator(keyspace, StringSerializer.get()); mutator.addInsertion("zznate", "Standard1", HFactory.createStringColumn("email", "nate@datastax.com")); mutator.addInsertion("zznate", "Standard1", HFactory.createColumn("int", 1, StringSerializer.get(), IntegerSerializer.get())); mutator.addInsertion("zznate", "Standard1", HFactory.createColumn("long", 1L, StringSerializer.get(), LongSerializer.get())); timeUUID = TimeUUIDUtils.getTimeUUID(System.currentTimeMillis()); mutator.addInsertion("zznate", "Standard1", HFactory.createColumn("uuid", timeUUID, StringSerializer.get(), UUIDSerializer.get())); mutator.execute(); }
public static void main(String[] args) throws Exception { Cluster cluster = HFactory.getOrCreateCluster("TestCluster", "localhost:9160"); Keyspace keyspaceOperator = HFactory.createKeyspace("Keyspace1", cluster); try { Mutator<String> mutator = HFactory.createMutator(keyspaceOperator, StringSerializer.get()); mutator.insert("jsmith", "Standard1", HFactory.createStringColumn("first", "John")); ColumnQuery<String, String, String> columnQuery = HFactory.createStringColumnQuery(keyspaceOperator); columnQuery.setColumnFamily("Standard1").setKey("jsmith").setName("first"); QueryResult<HColumn<String, String>> result = columnQuery.execute(); System.out.println("Read HColumn from cassandra: " + result.get()); System.out.println("Verify on CLI with: get Keyspace1.Standard1['jsmith'] "); } catch (HectorException e) { e.printStackTrace(); } cluster.getConnectionManager().shutdown(); }
private void persistMetaInformation(String table, String key) { Mutator<String> mutator; if (startBatchCommit.get()) { mutator = mutatorThreadLocal.get(); } else { mutator = HFactory.createMutator(keySpace, stringSerializer); } String date = formatter.format(new Date()); long currentTime = System.nanoTime(); String dateTime = date + ":" + Long.toString(currentTime); mutator.addInsertion(PersistencyConstants.ROW_INDEX, table, HFactory.createStringColumn(key, dateTime)); mutator.addInsertion(PersistencyConstants.TIMESTAMP_INDEX, table, HFactory.createStringColumn(dateTime, key)); if (!startBatchCommit.get()) { mutator.execute(); } }
mutator.addInsertion("fake_key_" + i, "Standard1", HFactory.createStringColumn("fake_column_0", "fake_value_0_" + i)) .addInsertion("fake_key_" + i, "Standard1", HFactory.createStringColumn("fake_column_1", "fake_value_1_" + i)) .addInsertion("fake_key_" + i, "Standard1", HFactory.createStringColumn("fake_column_2", "fake_value_2_" + i));
@Override public QueryResult<?> execute() { Mutator<String> mutator = HFactory.createMutator(keyspace, stringSerializer); mutator.addInsertion("CA Burlingame", "StateCity", HFactory.createColumn(650L, "37.57x122.34",longSerializer,stringSerializer)); mutator.addInsertion("650", "AreaCode", HFactory.createStringColumn("Burlingame__650", "37.57x122.34")); mutator.addInsertion("650222", "Npanxx", HFactory.createStringColumn("lat", "37.57")); mutator.addInsertion("650222", "Npanxx", HFactory.createStringColumn("lng", "122.34")); mutator.addInsertion("650222", "Npanxx", HFactory.createStringColumn("city", "Burlingame")); mutator.addInsertion("650222", "Npanxx", HFactory.createStringColumn("state", "CA")); MutationResult mr = mutator.execute(); return null; }
@Override public void persistData(String cfName, String rowKey, Map<String, String> columns) throws StoreException { if (!isTableExists(cfName)) { throw new StoreException("The column family '" + cfName + "' does not exist.."); } Mutator<String> mutator; if (startBatchCommit.get()) { mutator = mutatorThreadLocal.get(); } else { mutator = HFactory.createMutator(keySpace, stringSerializer); } for (Map.Entry<String, String> column : columns.entrySet()) { mutator.addInsertion(rowKey, cfName, HFactory.createStringColumn(column.getKey(), column.getValue())); } persistMetaInformation(cfName, rowKey); if (!startBatchCommit.get()) { mutator.execute(); } }
key = String.format(KEY_FORMAT, rows+startKey); for (int j2 = 0; j2 < commandArgs.columnCount; j2++) { mutator.addInsertion(key, commandArgs.workingColumnFamily, HFactory.createStringColumn(String.format(COLUMN_NAME_FORMAT, j2), String.format(COLUMN_VAL_FORMAT, j2, RandomStringUtils.random(colWidth)))); if ( j2 > 0 && j2 % commandArgs.batchSize == 0 ) {
@Test public void testTruncateColumnFamily() throws Exception { ColumnFamilyDefinition cfDef = HFactory.createColumnFamilyDefinition("Keyspace1", "TruncateableCf"); cassandraCluster.addColumnFamily(cfDef); Keyspace workingKeyspace = HFactory.createKeyspace("Keyspace1", cassandraCluster); Mutator<String> mutator = HFactory.createMutator(workingKeyspace, StringSerializer.get()); mutator.insert("mykey", "TruncateableCf", HFactory.createStringColumn("mycolname", "myval")); ColumnQuery<String,String,String> q = HFactory.createColumnQuery(workingKeyspace, StringSerializer.get(), StringSerializer.get(), StringSerializer.get()); q.setKey("mykey").setName("mycolname").setColumnFamily("TruncateableCf"); assertEquals("myval",q.execute().get().getValue()); cassandraCluster.truncate("Keyspace1", "TruncateableCf"); assertNull(q.execute().get()); }
@Override public Void call() throws Exception { log.debug("Starting VerifyLastInsertCommand"); String key = "test"; sliceQuery.setColumnFamily(commandArgs.workingColumnFamily); log.info("StartKey: {} for thread {}", key, Thread.currentThread().getId()); String colValue; for (int col = 0; col < commandArgs.columnCount; col++) { colValue = String.format(COLUMN_VAL_FORMAT, col); mutator.addInsertion(key, commandArgs.workingColumnFamily, HFactory.createStringColumn(String.format(COLUMN_NAME_FORMAT, col), colValue)); executeMutator(col); // Let's verify sliceQuery.setKey(key); sliceQuery.setRange(null, null, true, 1); QueryResult<ColumnSlice<String,String>> result = sliceQuery.execute(); String actualValue = result.get().getColumns().get(0).getValue(); if (!actualValue.equals(colValue)) { log.error("Column values don't match. Expected: " + colValue + " - Actual: " + actualValue); break; } } commandRunner.doneSignal.countDown(); log.debug("VerifyLastInsertCommand complete"); return null; }
public Integer call() throws Exception { int count = 0; NpanxxLine npanxxLine; Mutator<String> mutator = HFactory.createMutator(tutorialKeyspace, StringSerializer.get()); for (String row : lines) { // parse npanxxLine = new NpanxxLine(row); // String key = npanxxLine.getNpa()+npanxxLine.getNxx(); mutator.addInsertion(key, "Npanxx", HFactory.createStringColumn("city", npanxxLine.getCity())); mutator.addInsertion(key, "Npanxx", HFactory.createStringColumn("lat", Double.toString(npanxxLine.getLat()))); mutator.addInsertion(key, "Npanxx", HFactory.createStringColumn("lng", Double.toString(npanxxLine.getLng()))); mutator.addInsertion(key, "Npanxx", HFactory.createStringColumn("state", npanxxLine.getState())); if ( count % 250 == 0 ) { mutator.execute(); mutator.discardPendingMutations(); } count++; } mutator.execute(); log.info("found count {}", count); return Integer.valueOf(count); }
@Test public void testToggleMultiget() { Mutator<String> mutator = HFactory.createMutator(keyspace, StringSerializer.get()); mutator.addInsertion("patricioe", "Standard1", HFactory.createStringColumn("email", "patricioe@datastax.com")); mutator.addInsertion("patricioe", "Standard1", HFactory.createColumn("int", 2, StringSerializer.get(), IntegerSerializer.get())); mutator.addInsertion("patricioe", "Standard1", HFactory.createColumn("long", 2L, StringSerializer.get(), LongSerializer.get())); timeUUID = TimeUUIDUtils.getTimeUUID(System.currentTimeMillis()); mutator.addInsertion("patricioe", "Standard1", HFactory.createColumn("uuid", timeUUID, StringSerializer.get(), UUIDSerializer.get())); mutator.execute(); HColumnFamilyImpl<String, String> columnFamily = new HColumnFamilyImpl<String,String>(keyspace, "Standard1",StringSerializer.get(), StringSerializer.get()); columnFamily.addKey("zznate").addKey("patricioe").setCount(10); assertEquals("nate@datastax.com",columnFamily.getString("email")); assertTrue(columnFamily.hasNext()); columnFamily.next(); assertEquals("patricioe@datastax.com",columnFamily.getString("email")); assertFalse(columnFamily.hasNext()); try { columnFamily.next(); fail(); } catch (NoSuchElementException nsee) { assertNotNull(nsee); } } }
mutator.addInsertion("fake_key_" + i, "Standard1", HFactory.createStringColumn("fake_column_0", "fake_value_0_" + i)) .addInsertion("fake_key_" + i, "Standard1", HFactory.createStringColumn("fake_column_1", "fake_value_1_" + i)) .addInsertion("fake_key_" + i, "Standard1", HFactory.createStringColumn("fake_column_2", "fake_value_2_" + i));
mutator.addInsertion("fake_key_" + i, "Standard1", HFactory.createStringColumn("fake_column_0", "fake_value_0_" + i)) .addInsertion("fake_key_" + i, "Standard1", HFactory.createStringColumn("fake_column_1", "fake_value_1_" + i)) .addInsertion("fake_key_" + i, "Standard1", HFactory.createStringColumn("fake_column_2", "fake_value_2_" + i));
mutator.addInsertion("fake_key_" + i, "Standard1", HFactory.createStringColumn("fake_column_0", "fake_value_0_" + i)) .addInsertion("fake_key_" + i, "Standard1", HFactory.createStringColumn("fake_column_1", "fake_value_1_" + i)) .addInsertion("fake_key_" + i, "Standard1", HFactory.createStringColumn("fake_column_2", "fake_value_2_" + i));
public static void main(String[] args) throws Exception { Cluster cluster = HFactory.getOrCreateCluster("TestCluster", "localhost:9160"); Keyspace keyspaceOperator = HFactory.createKeyspace("Keyspace1", cluster); try { Mutator<String> mutator = HFactory.createMutator(keyspaceOperator, stringSerializer); mutator.insert("billing", "Super1", HFactory.createSuperColumn("jsmith", Arrays.asList(HFactory.createStringColumn("first", "John")), stringSerializer, stringSerializer, stringSerializer)); SuperColumnQuery<String, String, String, String> superColumnQuery = HFactory.createSuperColumnQuery(keyspaceOperator, stringSerializer, stringSerializer, stringSerializer, stringSerializer); superColumnQuery.setColumnFamily("Super1").setKey("billing").setSuperName("jsmith"); QueryResult<HSuperColumn<String, String, String>> result = superColumnQuery.execute(); System.out.println("Read HSuperColumn from cassandra: " + result.get()); System.out.println("Verify on CLI with: get Keyspace1.Super1['billing']['jsmith'] "); } catch (HectorException e) { e.printStackTrace(); } cluster.getConnectionManager().shutdown(); } }
mutator.addInsertion("fake_key_" + i, "Indexed1", HFactory.createStringColumn("fake_column_0", "fake_value_0_" + i)) .addInsertion("fake_key_" + i, "Indexed1", HFactory.createStringColumn("fake_column_1", "fake_value_1_" + i)) .addInsertion("fake_key_" + i, "Indexed1", HFactory.createStringColumn("fake_column_2", "fake_value_2_" + i)) .addInsertion("fake_key_" + i, "Indexed1", HFactory.createColumn("birthdate",new Long(1974+(i%2)),stringSerializer,LongSerializer.get())) .addInsertion("fake_key_" + i, "Indexed1", HFactory.createColumn("birthmonth",new Long(i%12),stringSerializer,LongSerializer.get()));
mutator.addInsertion("fake_key_" + i, "Standard1", HFactory.createStringColumn("fake_column_0", "fake_value_0_" + i)) .addInsertion("fake_key_" + i, "Standard1", HFactory.createStringColumn("fake_column_1", "fake_value_1_" + i)) .addInsertion("fake_key_" + i, "Standard1", HFactory.createStringColumn("fake_column_2", "fake_value_2_" + i));