<dependencies>
        <dependency>
            <groupId>org.apache.kylin</groupId>
            <artifactId>kylin-jdbc</artifactId>
            <version>2.5.1</version>
        </dependency>
    </dependencies>

package com.xzw.kylin;
 
import java.sql.*;
 
/**
 * @author: xzw
 * @create_date: 2021/5/11 10:21
 * @desc:
 * @modifier:
 * @modified_date:
 * @desc:
 */
public class TestJDBC {
    public static void main(String[] args) throws ClassNotFoundException, SQLException {
        //1、定義連接串
        String driverClass = "org.apache.kylin.jdbc.Driver";
        String url = "jdbc:kylin://master:7070/emp_dept";
        String user = "ADMIN";
        String password = "KYLIN";
 
        //2、加載驅(qū)動
        Class.forName(driverClass);
 
        //3、獲取連接
        Connection conn = DriverManager.getConnection(url, user, password);
 
        //4、SQL語句
        String sql = "select dept.dept_name,sum(emp.sal) from emp join dept on emp.dept_no = dept.dept_no group by " +
                "dept.dept_name";
 
        //5、預編譯SQL
        PreparedStatement ps = conn.prepareStatement(sql);
 
        //6、執(zhí)行SQL
        ResultSet rs = ps.executeQuery();
 
        //7、遍歷，打印結(jié)果
        while (rs.next()) {
            System.out.println(rs.getString(1) + "\t" + rs.getString(2));
        }
 
        //8、關(guān)閉連接
        conn.close();
 
    }
}

[root@master software]# tar -zxvf zeppelin-0.8.0-bin-all.tgz -C ../modules/

[root@master zeppelin-0.8.0-bin-all]# bin/zeppelin-daemon.sh start