分享

Kudu Java API 条件查询

 印度阿三17 2019-05-17
        <!-- https:///artifact/org.apache.kudu/kudu-client -->
        <dependency>
            <groupId>org.apache.kudu</groupId>
            <artifactId>kudu-client</artifactId>
            <version>1.9.0</version>
            <scope>test</scope>
        </dependency>
        <dependency>
            <groupId>org.apache.kudu</groupId>
            <artifactId>kudu-spark2_2.11</artifactId>
            <version>1.7.0</version>
        </dependency>
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<String> projectColumns = new ArrayList<String>();

    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./content-1-194801.html

    本站是提供个人知识管理的网络存储空间,所有内容均由用户发布,不代表本站观点。请注意甄别内容中的联系方式、诱导购买等信息,谨防诈骗。如发现有害或侵权内容,请点击一键举报。
    转藏 分享 献花(0

    0条评论

    发表

    请遵守用户 评论公约

    类似文章 更多