kudu API scala版系列:
Kudu create table api (scala版)
Kudu insert data api (scala版)
Kudu select data api (scala版)
Kudu updata data api (scala版)
Kudu upsert data api (scala版)
Kudu delete data api (scala版)
kuduClient API 对表执行查询操作
// 创建kudu连接
val kuduClient = new KuduClient.KuduClientBuilder("172.20.85.29:7051").build()
// 设置表名
val tableName = "kudu_test"
// 获得表的连接
val kuduTable = kuduClient.openTable(tableName)
// 设置查询条件
val schema = kuduTable.getSchema()
val name = KuduPredicate.newComparisonPredicate(schema.getColumn("name"), KuduPredicate.ComparisonOp.EQUAL, "Ronnie")
val age = KuduPredicate.newComparisonPredicate(schema.getColumn("age"), KuduPredicate.ComparisonOp.LESS, 22)
val city = KuduPredicate.newComparisonPredicate(schema.getColumn("city"), KuduPredicate.ComparisonOp.EQUAL, "beijing")
// 执行查询操作
val builder = kuduClient.newScannerBuilder(kuduTable)
.setProjectedColumnNames(List("name", "age", "city").asJava)
.addPredicate(name)
.addPredicate(age)
.addPredicate(city).build()
while (builder.hasMoreRows()) {
val results = builder.nextRows()
while (results.hasNext()) {
val result = results.next()
System.out.println(result.getLong("name") + "_" + result.getInt("age") + "_" + result.getString("city"))
}
}
// 关闭kudu连接
kuduClient.close()
欢迎关注我的公众号——数据杨公子。本公众号会分享包括但不限于大数据、数据治理、元数据管理、python 等方面的技术文章,主旨是和大家一起共同成长,用技术来认识我们这个数据的时代。