Hive查询结果封装和查询日志回调

本文章主要是解决之前在写数据中平台的时候遇到的俩个问题，一是封装查询后的结果集为前端展示数据，二是携带查询日志。当然结果集和日志可根据需求决定是否返回和返回方式，比如websocket。

下面做测试流程介绍

 

pom依赖

<dependency>
            <groupId>org.apache.hive</groupId>
            <artifactId>hive-jdbc</artifactId>
            <version>3.1.2</version>
            <exclusions>
                <exclusion>
                    <groupId>org.glassfish</groupId>
                    <artifactId>javax.el</artifactId>
                </exclusion>
            </exclusions>
        </dependency>

 

 包结构

下面依次把代码贴上

package hive.model;

import java.io.Serializable;
import java.util.ArrayList;
import java.util.List;


public class CommandResult implements Serializable {

    protected boolean succeeded = true;
    protected String msg;
    protected List<String> colNm = new ArrayList<>();
    protected List<List<Object>> data = new ArrayList<>();

    public CommandResult() {
    }

    public CommandResult(String msg) {
        this.msg = msg;
    }

    public CommandResult(boolean succeeded, String msg) {
        this.succeeded = succeeded;
        this.msg = msg;
    }

    public boolean isSucceeded() {
        return succeeded;
    }

    public void setSucceeded(boolean succeeded) {
        this.succeeded = succeeded;
    }

    public String getMsg() {
        return msg;
    }

    public void setMsg(String msg) {
        this.msg = msg;
    }

    public static CommandResult error(String msg) {
        CommandResult commandResult = new CommandResult(msg);
        commandResult.setSucceeded(false);
        return commandResult;
    }

    public static CommandResult success(String msg) {
        CommandResult commandResult = new