|NO.Z.00006|——————————|BigDataEnd|——|Hadoop&OLAP_Kudu.V06|——|kudu.v06|常用API|更改表数据|删除指定行|

一、KuDuApi常用操作:更改数据
### --- 编程代码实现:更改表数据:和插入数据类似

package com.yanqi.kudu.api;

import org.apache.kudu.client.*;

public class updateDemo {
    public static void main(String[] args) {
        KuduClient client = new KuduClient.KuduClientBuilder("hadoop01").build();
        try {
            KuduTable stuTable = client.openTable("student");
            KuduSession kuduSession = client.newSession();
            kuduSession.setFlushMode(SessionConfiguration.FlushMode.MANUAL_FLUSH);
            Update update = stuTable.newUpdate();
            PartialRow row = update.getRow();
            row.addInt("id",1);
            row.addString("name","xiaoming");
            kuduSession.apply(update);

            kuduSession.close();

        } catch (KuduException e) {
            e.printStackTrace();
        } finally {
            try {
                client.close();
            } catch (KuduException e) {
                e.printStackTrace();
            }
        }
    }
}
### --- 编译打印:更改之前状态

~~~     编译打印之后状态
二、KuDuApi常用操作:删除指定行
### --- 编程代码实现:删除指定行:通过封装类Delete
### --- 编译打印

package com.yanqi.kudu.api;

import org.apache.kudu.client.*;

public class deleteDemo {
    public static void main(String[] args) {
        KuduClient client = new KuduClient.KuduClientBuilder("hadoop01").build();
        try {
            KuduTable stuTable = client.openTable("student");
            KuduSession kuduSession = client.newSession();
            kuduSession.setFlushMode(SessionConfiguration.FlushMode.MANUAL_FLUSH);

            Delete delete = stuTable.newDelete();
            PartialRow row = delete.getRow();
            row.addInt("id",1);

            kuduSession.flush();
            kuduSession.apply(delete);

            kuduSession.close();

        } catch (KuduException e) {
            e.printStackTrace();
        } finally {
            try {
                client.close();
            } catch (KuduException e) {
                e.printStackTrace();
            }
        }
    }
}

 
 
 
 
 
 
 
 
 

Walter Savage Landor:strove with none,for none was worth my strife.Nature I loved and, next to Nature, Art:I warm'd both hands before the fire of life.It sinks, and I am ready to depart
                                                                                                                                                   ——W.S.Landor

 

 

posted on 2022-04-14 14:24  yanqi_vip  阅读(39)  评论(0)    收藏  举报

导航