1.使用impala执行
2.jdbc连接
代码
import java.sql.*;
public class TestKylin {public static void main(String[] args) throws Exception {
//Kylin_JDBC 驱动
String KYLIN_DRIVER = "org.apache.kylin.jdbc.Driver";//Kylin_URL
String KYLIN_URL = "jdbc:kylin://mini2:7070/demo_project";//Kylin的用户名
String KYLIN_USER = "ADMIN";//Kylin的密码
String KYLIN_PASSWD = "KYLIN";//添加驱动信息
Class.forName(KYLIN_DRIVER);//获取连接
Connection connection = DriverManager.getConnection(KYLIN_URL, KYLIN_USER, KYLIN_PASSWD);//预编译SQL
PreparedStatement ps = connection.prepareStatement("SELECT sum(salary) FROM employee");//执行查询
ResultSet resultSet = ps.executeQuery();//遍历打印
while (resultSet.next()) {
System.out.println(resultSet.getInt(1));
}
}
}
<dependency> <groupId>org.apache.kylin</groupId> <artifactId>kylin-jdbc</artifactId> <version>2.5.1</version> </dependency>