hiveserver2 java thrift api 接口使用事例

最新推荐文章于 2024-04-02 08:47:59 发布

原创

最新推荐文章于 2024-04-02 08:47:59 发布 · 5.5k 阅读

3 ·

CC 4.0 BY-SA版权

本文介绍了如何使用Java通过Thrift API连接到HiveServer2进行SQL查询。从定义基本查询接口开始，然后展示工具类和实现类的详细代码，包括建立连接、执行查询、获取日志、检查操作状态、获取结果集和取消查询的步骤。

首先定义接口

/**
 * sql查询的基类
 * @author taoxinwan
 *
 */
public abstract class QueryBase {
    
    protected static final Logger log = Logger.getLogger(QueryBase.class);  
    //ip
    protected static String host;
    //端口
    protected static int port;
    //类型
    protected static int type;
    
    protected static String username;
    protected static String passsword;
    
    /**
     * 初始化上下文信息
     * @param context
     */
    protected void init(Context context){
        host = context.getHost();
        port = context.getPort();
        type = context.getType();
        username = context.getUsername();
        passsword = context.getPasssword();
    }   
    
    public abstract TOperationHandle submitQuery(String command) throws Exception;
    public abstract String getQueryLog(TOperationHandle tOperationHandle) throws Exception;
    public abstract TOperationState getQueryHandleStatus(TOperationHandle tOperationHandle) throws Exception;
    public abstract Map<String, Object> getResultByOperation(TOperationHandle tOperationHandle) throws Exception;
    public abstract void cancelQuery(TOperationHandle tOperationHandle) throws Exception;
    

}

工具类

/**
     * 获取shrift client
     *
     * @param transport
     * @param type
     *            1=hive,2=impala
     * @return
     * @throws TTransportException
     */
    public static TCLIService.Client getClientInstance(TTransport transport, int type) throws TTransportException {

        TCLIService.Client client = null;
        if (1 == type) {// hive
            client = new TCLIServic

最低0.47元/天解锁文章