Java Thrift Hive

最新推荐文章于 2024-08-01 04:30:03 发布

桂成林

最新推荐文章于 2024-08-01 04:30:03 发布

阅读量1.9k

点赞数 1

分类专栏： Java

本文为博主原创文章，未经博主允许不得转载。

本文链接：https://blog.csdn.net/guichenglin/article/details/52808033

版权

Java 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

import java.util.List;

import org.apache.hadoop.hive.service.HiveClient;
import org.apache.hadoop.hive.service.HiveServerException;
import org.apache.thrift.TException;
import org.apache.thrift.protocol.TBinaryProtocol;
import org.apache.thrift.protocol.TProtocol;
import org.apache.thrift.transport.TSocket;
import org.apache.thrift.transport.TTransport;
import org.apache.thrift.transport.TTransportException;


public class thrift_hive_java {
    private static String HOST = "127.0.0.1";
    private static int PORT = 10000;


    public static void main(String[] args)
    {   
        TTransport transport  = new TSocket(HOST, PORT);
        TProtocol protocol = new TBinaryProtocol(transport);
        HiveClient client = new HiveClient(protocol);
        try {
            long time1 = System.currentTimeMillis();
            transport.open();
            client.execute("select  a, b, c  from tb where a='' and b=''  limit 10");


            List<String> list = client.fetchAll();
            long time2 = System.currentTimeMillis();

            String str = ""; 
            for(int i = 0; i < list.size(); i++)
            {   
                str = list.get(i);
                System.out.println(str);
            }   
            System.out.println("use time : " + (time2 - time1) + " ms." );


        } catch (TTransportException e) {
            e.printStackTrace();
        } catch (HiveServerException e) {
            e.printStackTrace();
        } catch (TException e) {
            e.printStackTrace();
        }   

        try {
            client.shutdown();
        } catch (TException e) {
            e.printStackTrace();
        }   
        transport.close();
    }   
}

javac -Djava.ext.dirs=/usr/bin/hive/lib:. *.java -d ./output/

cd output

java -Djava.ext.dirs=/usr/bin/hive/lib:. thrift_hive_java

1364366310 30054373 12560280
1364366313 30054371 12560280
1364366314 30054372 12560280
1364366315 30054374 12560280
1364366316 30054368 12560280
1387914554 30054375 12560280
1387914554 30054375 12560280
1387914569 30054375 12560280
1387914569 30054375 12560280
1387914582 30054375 12560280
use time : 26592 ms.