{"id":648070,"date":"2013-03-21T14:18:10","date_gmt":"2013-03-21T18:18:10","guid":{"rendered":"http:\/\/gigaom.com\/?p=622888"},"modified":"2013-03-21T14:18:10","modified_gmt":"2013-03-21T18:18:10","slug":"if-the-future-of-bi-is-hadoop-sql-and-the-cloud-are-the-glue","status":"publish","type":"post","link":"https:\/\/mereja.media\/index\/648070","title":{"rendered":"If the future of BI is Hadoop, SQL and the cloud are the glue"},"content":{"rendered":"

Starting with the well-known quote \u2014 \u201cA good way to predict the future is to invent it\u201d \u2013\u00a0Ravi Murthy, engineering manager at Facebook, kicked off an interesting panel discussion at GigaOM Structure:Data 2013<\/a> Thursday with four industry experts on business intelligence (BI) and Hadoop. Hadoop has a big place in that future, but not by itself. The conclusion? Applications and SQL databases built atop Hadoop are needed for better BI, noted the panel.<\/p>\n

\u201cWhy are so many systems being built in the BI landscape? If Hadoop can deliver the promise, why have all these other solutions?\u201d asked Murthy.<\/p>\n

Ashish Thusoo, co-Founder and CEO at Qubole,<\/a> said that\u00a0putting SQL on top of Hadoop just makes sense. \u201cAs a system, Hadoop is not a low-latency system, opening the need for faster SQL-based systems to query the data. And there\u2019s probably only space for half-dozen of these solutions in the market; not dozens.\u201d<\/p>\n

Agreeing with Thusoo was Tomer Shiran, director, product management at MapR Technologies<\/a>. \u201cWith our open source Apache Drill we\u2019re enabling lots of differing BI use cases allowing companies to do different things with Hadoop. One use case is ability to interactively query and explore data.\u201d Apache Drill is an interactive, low-latency SQL way to get at the data\u00a0reservoir\u00a0in Hadoop.\u00a0Ben Werther, founder and CEO, Platfora<\/a> completely agreed, saying that customers looking for\u00a0much more agile approaches to data exploration\u00a0without\u00a0building more IT work.<\/p>\n

But Hadoop is still an important underlying part of the puzzle.\u00a0Justin Borgman, CEO, Hadapt<\/a> noted that \u201cHadoop scales so cost effectively; it\u2019s a landfill where you can dump everything. That opens up new\u00a0opportunities\u00a0to explore that data including indexing to boost performance and interactivity across a broader data set.\u201d<\/p>\n

When asked for a use case of the benefits, Werther pointed out an unnamed customer. \u201cThey had\u00a050 analysts working against SQL stores in a very siloed fashion. We moved them to a Hadoop-based stack and built a data\u00a0reservoir. Only 5 of the 50 were able to be productive before. Within a week, all 50 became productive.\u201d<\/p>\n

Of course, the cloud is also part of BI\u2019s future, although it\u2019s not without risks. Sure, running Hadoop in the cloud is very elastic so that you can use as many resources as you need in near real-time. But the issues of security and data gravity in particular are worth noting: Generating data in the cloud could make it tough to move out in the future and may require more apps build on this data to also be in the cloud.<\/p>\n

Check out the rest of our Structure:Data 2013 live coverage here<\/a>, and a video embed of the session follows below:<\/p>\n