首页 文章 精选 留言 我的

精选列表

搜索[数据协作平台],共10000篇文章
优秀的个人博客,低调大师

Kylin-web上的数据分析

Kylin Web Interface Supported Browsers Windows: Google Chrome, FireFox Mac: Google Chrome, FireFox, Safari 1. Access & Login Host to access: http://hostname:7070 Login with username/password: ADMIN/KYLIN 2. Sync Hive Table into Kylin Although Kylin will using SQL as query interface and leverage Hive metadata, kylin will not enable user to query all hive tables since it’s a pre-build OLAP (MOLAP) system so far. To enable Table in Kylin, it will be easy to using “Sync” function to sync up tables from Hive. 3. Kylin OLAP Cube Kylin’s OLAP Cubes are pre-calculation datasets from star schema tables, Here’s the web interface for user to explorer, manage all cubes. Go to Model menu, it will list all cubes available in system: To explore more detail about the Cube Form View: SQL View (Hive Query to read data to generate the cube): Access (Grant user/role privileges, grant operation only open to Admin): 4. Write and Execute SQL on web Kylin’s web offer a simple query tool for user to run SQL to explorer existing cube, verify result and explorer the result set using #5’s Pivot analysis and visualization Query Limit Only SELECT query be supported SQL will not be redirect to Hive Go to “Insight” menu: Source Tables: Browser current available tables (same structure and metadata as Hive): New Query: You can write and execute your query and explorer the result. Saved Query (only work after enable LDAP security): Associate with user account, you can get saved query from different browsers even machines. Click “Save” in Result area, it will popup for name and description to save current query: Click “Saved Queries” to browser all your saved queries, you could direct submit it or remove it. Query History: Only keep the current user’s query history in current bowser, it will require cookie enabled and will lost if you clean up bowser’s cache. Click “Query History” tab, you could directly resubmit any of them to execute again. 5. Pivot Analysis and Visualization There’s one simple pivot and visualization analysis tool in Kylin’s web for user to explore their query result: General Information: When the query execute success, it will present a success indictor and also a cube’s name which be hit. Also it will present how long this query be executed in backend engine (not cover network traffic from Kylin server to browser): Query Result: It’s easy to order on one column. Export to CSV File Click “Export” button to save current result as CSV file. Pivot Table: Drag and drop one or more columns into the header, the result will grouping by such column’s value: Visualization: Also, the result set will be easy to show with different charts in “Visualization”: note: line chart only available when there’s at least one dimension with real “Date” data type of column from Hive Table. Bar Chart: Pie Chart: Line Chart

优秀的个人博客,低调大师

用OSS数据卷实现wordpress附件共享

docker容器的兴起,让wordpress的部署变得极为容易,“一分钟部署wordpress”的教程也随处可见。以阿里云容器服务为例,利用一下编排模板,可以一键部署wordpress(详细教程见这里)。 web: image: registry.aliyuncs.com/acs-sample/wordpress:4.3 ports: - '80' environment: WORDPRESS_AUTH_KEY: changeme WORDPRESS_SECURE_AUTH_KEY: changeme WORDPRESS_LOGGED_IN_KEY: changeme WORDPRESS_NONCE_KEY: changeme WORDPRESS_AUTH_SALT: ch

资源下载

更多资源
Mario

Mario

马里奥是站在游戏界顶峰的超人气多面角色。马里奥靠吃蘑菇成长,特征是大鼻子、头戴帽子、身穿背带裤,还留着胡子。与他的双胞胎兄弟路易基一起,长年担任任天堂的招牌角色。

Spring

Spring

Spring框架(Spring Framework)是由Rod Johnson于2002年提出的开源Java企业级应用框架,旨在通过使用JavaBean替代传统EJB实现方式降低企业级编程开发的复杂性。该框架基于简单性、可测试性和松耦合性设计理念,提供核心容器、应用上下文、数据访问集成等模块,支持整合Hibernate、Struts等第三方框架,其适用范围不仅限于服务器端开发,绝大多数Java应用均可从中受益。

Rocky Linux

Rocky Linux

Rocky Linux(中文名:洛基)是由Gregory Kurtzer于2020年12月发起的企业级Linux发行版,作为CentOS稳定版停止维护后与RHEL(Red Hat Enterprise Linux)完全兼容的开源替代方案,由社区拥有并管理,支持x86_64、aarch64等架构。其通过重新编译RHEL源代码提供长期稳定性,采用模块化包装和SELinux安全架构,默认包含GNOME桌面环境及XFS文件系统,支持十年生命周期更新。

Sublime Text

Sublime Text

Sublime Text具有漂亮的用户界面和强大的功能,例如代码缩略图,Python的插件,代码段等。还可自定义键绑定,菜单和工具栏。Sublime Text 的主要功能包括:拼写检查,书签,完整的 Python API , Goto 功能,即时项目切换,多选择,多窗口等等。Sublime Text 是一个跨平台的编辑器,同时支持Windows、Linux、Mac OS X等操作系统。

用户登录
用户注册