client.sql("create table test (a string, b int) with (number_of_replicas=0)").actionGet();
ensureGreen();
client.sql("insert into test (a, b) values ('foo', 1)").actionGet();
client.sql("refresh table test").actionGet();
SQLBulkRequest bulkRequest = new SQLBulkRequest(
"update test set a = ? where b = ?",
new Object[][]{new Object[]{"bar", 1}, new Object[]{"baz", 1}});
SQLBulkResponse bulkResponse = client.bulkSql(bulkRequest).actionGet();
assertThat(bulkResponse.results().length, is(2));
for (SQLBulkResponse.Result result : bulkResponse.results()) {