Kylin |4.可视化

 Kylin可视化工具

JDBC

新建项目并导入依赖

 

public class TestKylin {

    public static void main(String[] args) throws ClassNotFoundException, SQLException {
        //kylin的JDBC驱动类
        String Kylin_Driver = "org.apache.kylin.jdbc.Driver";
        String Kylin_Url = "jdbc:kylin://hadoop101:7070/HelloWorld";
        String Kylin_User = "ADMIN";
        String Kylin_Password = "KYLIN";
　　
        Class.forName(Kylin_Driver); //①添加驱动信息
        Connection connection = DriverManager.getConnection(Kylin_Url, Kylin_User, Kylin_Password);//②
　　　　　　//③预编译SQL
        PreparedStatement preparedStatement = connection.prepareStatement("select job, count(*), sum(sal) from EMP inner join DEPT ON EMP.DEPTNO = DEPT.DEPTNO group by job");
        ResultSet resultSet = preparedStatement.executeQuery(); //④执行查询
        while (resultSet.next()){ //⑤遍历打印
            String job = resultSet.getString(1);
            int count = resultSet.getInt(2);
            double sum_total = resultSet.getDouble(3);

            System.out.println(job + "\t" + count + "\t" + sum_total);
        }
    }
}

 

可视化工具 Zepplin安装与启动

1）将zeppelin-0.8.0-bin-all.tgz上传至Linux
2）解压zeppelin-0.8.0-bin-all.tgz之/opt/module
[kris@hadoop101 sorfware]$ tar -zxvf zeppelin-0.8.0-bin-all.tgz -C /opt/module/
3）修改名称
[kris@hadoop101 module]$ mv zeppelin-0.8.0-bin-all/ zeppelin
4）启动
[kris@hadoop101 zeppelin]$ bin/zeppelin-daemon.sh start
可登录网页查看，web默认端口号为8080
http://hadoop101:8080

 

 

 

 

 

 key横坐标；

values纵坐标。

%kylin select job, dname, count(*), sum(sal) from EMP inner join DEPT ON EMP.DEPTNO = DEPT.DEPTNO group by job, dname;