kudu java_Kudu Java API 条件查询

org.apache.kudu

kudu-client

1.9.0

test

org.apache.kudu

kudu-spark2_2.11

1.7.0

package src.main.sample;

import org.apache.kudu.ColumnSchema;

import org.apache.kudu.Schema;

import org.apache.kudu.client.*;

import java.util.ArrayList;

import java.util.List;

public class SelectKuduData2

{

//select * from rawdata.event_wos_p1 where user_id = -1024924858009673815;

private static String tableName = "event_wos_p1";

//private static KuduClient client = new KuduClient.KuduClientBuilder("IP,IP,IP").defaultAdminOperationTimeoutMs(60000).build();

// 获取需要查询数据的列

private static List projectColumns = new ArrayList();

private static KuduTable table;

private static KuduScanner.KuduScannerBuilder builder;

private static KuduScanner scanner;

private static KuduPredicate predicate;

public static void main(String[] args) throws KuduException

{

try

{

projectColumns.add("user_id"); //字段名

projectColumns.add("day");

table = client.openTable(tableName);

// 简单的读取 newScannerBuilder(查询表) setProjectedColumnNames(指定输出列) build()开始扫描

// KuduScanner scanner = client.newScannerBuilder(table).setProjectedColumnNames(projectColumns).build();

builder = client.newScannerBuilder(table).setProjectedColumnNames(projectColumns);

/**

* 设置搜索的条件

* 如果不设置，则全表扫描

*/

//select * from 表名 where user_id = xxx;

long userID = 123456789;

//比较方法ComparisonOp：GREATER、GREATER_EQUAL、EQUAL、LESS、LESS_EQUAL

predicate = predicate.newComparisonPredicate(table.getSchema().getColumn("user_id"),

KuduPredicate.ComparisonOp.EQUAL, userID);

builder.addPredicate(predicate);

// 开始扫描

scanner = builder.build();

while (scanner.hasMoreRows())

{

RowResultIterator results = scanner.nextRows();

// 每次从tablet中获取的数据的行数

int numRows = results.getNumRows();

System.out.println("numRows count is : " numRows);

while (results.hasNext()) {

RowResult result = results.next();

long user_id = result.getLong(0);

int day = result.getInt(1);

System.out.println("user_id is : " user_id " === day: " day );

}

System.out.println("--------------------------------------");

}

}

catch (Exception e)

{

e.printStackTrace();

}

finally

{

scanner.close();

client.close();

}

}

}来源：http://www.icode9.com/content-1-194801.html