先确认我们的ck服务正常,随便做个查询
来到java项目,先引包
ru.yandex.clickhouse clickhouse-jdbc 0.2.4
jdbc测试
public void clickHouseTest() throws ClassNotFoundException, SQLException {
Class.forName("ru.yandex.clickhouse.ClickHouseDriver");
Connection connection = DriverManager.getConnection("jdbc:clickhouse://*.*.*.*:8123/tutorial", "用户名", "密码");
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery("select count(1) from tutorial.hits_v1");
while (resultSet.next()) {
System.out.println("查询结果为:" + resultSet.getString(1));
}
}
结果



