void partitionRead() { // [START partition_read] final BatchReadOnlyTransaction txn = batchClient.batchReadOnlyTransaction(TimestampBound.strong()); List<Partition> partitions = txn.partitionRead( PartitionOptions.getDefaultInstance(), "Singers", KeySet.all(), Arrays.asList("SingerId", "FirstName", "LastName")); for (final Partition p : partitions) { try (ResultSet results = txn.execute(p)) { while (results.next()) { long singerId = results.getLong(0); String firstName = results.getString(1); String lastName = results.getString(2); System.out.println("[" + singerId + "] " + firstName + " " + lastName); } } } // [END partition_read] }
void partitionReadUsingIndex() { // [START partition_read_using_index] final BatchReadOnlyTransaction txn = batchClient.batchReadOnlyTransaction(TimestampBound.strong()); List<Partition> partitions = txn.partitionReadUsingIndex( PartitionOptions.getDefaultInstance(), "Singers", "SingerId", KeySet.all(), Arrays.asList("SingerId", "FirstName", "LastName")); for (Partition p : partitions) { try (ResultSet results = txn.execute(p)) { while (results.next()) { long singerId = results.getLong(0); String firstName = results.getString(1); String lastName = results.getString(2); System.out.println("[" + singerId + "] " + firstName + " " + lastName); } } } // [END partition_read_using_index] } }
private PartitionOptions getRandomPartitionOptions() { int desiredBytesPerBatch = 1 << 30; int maxPartitionCount = 100; PartitionOptions parameters = PartitionOptions.newBuilder() .setPartitionSizeBytes(desiredBytesPerBatch) .setMaxPartitions(maxPartitionCount) .build(); if (RANDOM.nextInt(2) == 1) { parameters = PartitionOptions.getDefaultInstance(); } return parameters; }
@Test public void defaultBuilder() { PartitionOptions parameters = PartitionOptions.getDefaultInstance(); assertThat(parameters.getPartitionSizeBytes()).isEqualTo(0); assertThat(parameters.getMaxPartitions()).isEqualTo(0); // Test serialization. reserializeAndAssert(parameters); }
void partitionQuery() { // [START partition_query] final BatchReadOnlyTransaction txn = batchClient.batchReadOnlyTransaction(TimestampBound.strong()); List<Partition> partitions = txn.partitionQuery( PartitionOptions.getDefaultInstance(), Statement.of("SELECT SingerId, FirstName, LastName FROM Singers")); for (final Partition p : partitions) { try (ResultSet results = txn.execute(p)) { while (results.next()) { long singerId = results.getLong(0); String firstName = results.getString(1); String lastName = results.getString(2); System.out.println("[" + singerId + "] " + firstName + " " + lastName); } } } // [END partition_query] }
@Override public Void run(TransactionContext transaction) throws SpannerException { BatchClient batchClient = env.getTestHelper().getBatchClient(db); BatchReadOnlyTransaction batchTxn = batchClient.batchReadOnlyTransaction(TimestampBound.strong()); batchTxn.partitionReadUsingIndex( PartitionOptions.getDefaultInstance(), "Test", "Index", KeySet.all(), Arrays.asList("Fingerprint")); return null; } });
@Test public void equalAndHashCode() { new EqualsTester() .addEqualityGroup( PartitionOptions.newBuilder() .setPartitionSizeBytes(1 << 30) .setMaxPartitions(100) .build(), PartitionOptions.newBuilder() .setPartitionSizeBytes(1 << 30) .setMaxPartitions(100) .build()) .addEqualityGroup( PartitionOptions.newBuilder().build(), PartitionOptions.getDefaultInstance()) .testEquals(); }
List<Partition> partitions = txn.partitionQuery(PartitionOptions.getDefaultInstance(), Statement.of("SELECT SingerId, FirstName, LastName FROM Singers"));
public static ReadOperation create() { return new AutoValue_ReadOperation.Builder() .setPartitionOptions(PartitionOptions.getDefaultInstance()) .setKeySet(KeySet.all()) .build(); }
public static Partition createFakeReadPartition(ByteString token) { return Partition.createReadPartition( token, PartitionOptions.getDefaultInstance(), "", "", KeySet.all(), Arrays.asList(), Options.fromReadOptions()); } }
public static Partition createFakeQueryPartition(ByteString token) { return Partition.createQueryPartition( token, PartitionOptions.getDefaultInstance(), Statement.of(""), Options.fromQueryOptions()); }