Hive BI analytics: Visual Reporting
来源:互联网 发布:抠图软件 for mac 编辑:程序博客网 时间:2024/05/19 16:50
Hive BI analytics: Visual Reporting
I had earlier written about using Hive as a data source for BI tools using industry proven BI reporting tools and here is a list of the various official announcements from Pentaho, Talend. Microstrategy and Intellicus -
- Pentaho – http://www.pentaho.com/hadoop/, Business Intelligence Player Pentaho Embraces Hadoop
- Intellicus – Intellicus to support Hadoop framework for Large Data
- Talend – Hadoop Support Available from Industry’s Leading Open Source Data Integration Provider . However, Hadoop features will only be in Talend’s Integration Suite and will not, according to a company spokesperson, be available in Talend’s open source core product, Open Studio.
- Microstrategy (with Cloudera) – MicroStrategy Announces Support for Apache Hadoop
- Cloudera is also doing something with Quest team-http://www.theregister.co.uk/2010/06/21/cloudera_and_quest_team_on_oracle_connector/
The topic is close to my heart since I firmly believe that while Hadoop and Hive are true large data analytics tool, their power is currently limited to use by software programmers. The advent of BI tools in Hadoop/Hive world would certainly bring it closer to the real end users – business users.
I am currently not too sure how these BI reporting tools are deciding how much part of the analytics be left in Map reduce and how much in the reporting tool itself- guess it will take time to find the right balance. Chances are that I will find it a bit earlier than others as I am working closely (read here) with Intellicus team to get the changes in Hive JDBC driver for Intellicus’ interoperability with Hive.
February 8, 2010
BI with MapReduce
Have any of you used map reduce in the context of business intelligence?
While collating my thoughts on this Linked-in Hadoop discussion, found out that I needed more visuals to explain it first to myself .
So, here are the many ways in which Hadoop MapReduce does offer an alternative in the big-big BI world-
Scenario 1: Use Hadoop and Hive as interface to BI tools. Pentaho reporting is already supported as of Hive 0.4.0.
Scenario 2: Use Hadoop for intial data polishing, and then dump to a SQL supported column based database near-real BI reporting. Aster data/Vertica /Greenplum sell themselves by advertising MapReduce connectors (or similar) heavily. The cost of SQL supported column based database is the only pain point here (+ the risk on how these actually scale vs what these promise)
Scenario 3: Use Hadoop for intial data polishing, and then dump to a SQL supported column based database near-real BI reporting. In case of Real time reporting, data can further be BI polished from column based databases to a fast regular RDBMS with BI support.
Scenario 4: The free way:)- Use Hadoop for intial data polishing, and then dump to a regular SQL database with BI support. The export from HDFS can be the Un-sqoop way. The onus would more be on the developer to dump only ready-for-report data (lesser) with most of the BI already completed as part of More MR step.
The important fact to note is that there might be additional costs on moving the major chunk of BI data analysis part to programmatic interfaces (SQL or MR).
I am not too much of a database-fallen-in-love type, so do like the way Hive can emerge as a potential BI reporting tool.
- Hive BI analytics: Visual Reporting
- Visual Mining Announces Third Release of Its Eclipse-Based BI Reporting Tool
- SEO工具:Google Analytics AIR Reporting Suite
- hive --Windowing and Analytics Functions
- Visual Studio2010 Reporting开发问题
- Compelling Analytics: SQL Server Reporting Services in Dynamics AX 2009
- Google Analytics Reporting API V4 开发之笔记 star.Hou
- 微软BI专题-Reporting Services报表交互排序探微
- BI 商业智能 SQL Server Reporting Services (SSRS)(转)
- Knowledge Generation Model for Visual Analytics
- SAS Visual Analytics(VA)安装教程
- The State of Visual Analytics Views on what visual analytics is and where it is going
- Hive Analytics Functions row_number rank over partition by
- Visual Studio 2012 does not support BI
- "Big Data"- Reporting Over Hadoop using Hive-Intellicus 5.2
- Mastering the Information Age - Solving Problems with Visual Analytics
- A visual analytics framework for spatio-temporal analysis and modelling
- Knowledge Generation Model for Visual Analytics 第二部分
- android开发实战系列(19)-- 让用户转移到另一个应用程序
- ZOJ 1298 poj 1135 Domino Effect(最短路,dij)
- linux下防御ddos攻击
- Android的AlertDialog详解
- java_command
- Hive BI analytics: Visual Reporting
- Android中一直走马灯效果的TextView
- 4断点和单步执行
- QLayout 动态布局(如何清空布局)
- Hive + Intellicus
- HAProxy负载均衡器的配置与算法
- Hadoop Ecosystem World-Map
- hdu 1085 Holding Bin-Laden Captive!
- Fedora 18 修改主文件夹目录名为英文