使用Http方式访问ClickHouse demo

最新推荐文章于 2024-08-23 14:58:22 发布

奋斗的二哈

最新推荐文章于 2024-08-23 14:58:22 发布

阅读量3.7k

点赞数 2

分类专栏： Java 文章标签： clickhouse ck http

本文链接：https://blog.csdn.net/kqZhu/article/details/107943935

版权

本文通过一个详细的示例，展示了如何在Java环境中利用Http方式连接并查询ClickHouse数据库。从引入Maven依赖开始，逐步讲解配置类CkConfig、客户端CkClient的创建，直至在Demo和CkConnectTest中实现具体查询操作，获取过去24小时内每小时的数据。

摘要由CSDN通过智能技术生成

1、引入maven依赖

	<!-- OKHttp3依赖 -->
        <dependency>
            <groupId>com.squareup.okhttp3</groupId>
            <artifactId>okhttp</artifactId>
            <version>3.8.1</version>
        </dependency>

2、CkConfig.java

import lombok.Data;
import org.springframework.stereotype.Component;

/**
 * Created By ZhuKeqian on 2020/8/11
 */

@Component
@Data
public class CkConfig {
	// 在这里我写成固定值
    private String url = "http://******";
    private String cluster = "your_cluster_name";
    private String database = "default";
    private String user = "user_name";
    private String password = "ck_password";

}

3、CkClient.java

import com.alibaba.fastjson.JSONObject;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;
import java.util.concurrent.TimeUnit;
import lombok.extern.slf4j.Slf4j;
import okhttp3.MediaType;
import okhttp3.OkHttpClient;
import okhttp3.Request;
import okhttp3.RequestBody;
import okhttp3.Response;
import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;

/**
 * Created By ZhuKeqian on 2020/8/11
 */

@Slf4j
@Component
public class CkClient {

    @Autowired
    CkConfig ckConfig;

    private static OkHttpClient client = null;


    public static OkHttpClient getClient() {
        if (client == null) {
            client = new OkHttpClient.Builder()
                    .readTimeout(60, TimeUnit.SECONDS)
                    .connectTimeout(1, TimeUnit.SECONDS).build();
        }
        return client;
    }

    private stati