hiveserver2 java thrift api 接口使用事例

最新推荐文章于 2024-10-31 06:00:00 发布

Kevin-tao

最新推荐文章于 2024-10-31 06:00:00 发布

阅读量5.5k

点赞数 1

CC 4.0 BY-SA版权

分类专栏： Hive

本文链接：https://blog.youkuaiyun.com/taoxinwan/article/details/38404313

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

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

首先定义接口

/**
 * 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