This is the SQL PASS 2012 presentation with David Mariani and myself on how Klout changed the landscape of social media with Hadoop and BI.
Month: November 2012
An easy way to test out Hive Dynamic Partition Insert on HDInsight Azure
One you get your HadoopOnAzure.com cluster up and running, an easy way to test out Hive Dynamic Partition Insert (the ability to load data into multiple partitions without the need to load each partition individually) on HDInsight Azure is to use the HiveSampleTable already included and the scripts below. You can execute the scripst from the Hive Interactive Console or from the Hive CLI. 1) For starters, create a new partitioned table CREATE TABLE hivesampletable_p ( clientid STRING, querytime STRING, market STRING, devicemake STRING, devicemodel STRING, state STRING, querydwelltime STRING, sessionid BIGINT, sessionpagevieworder BIGINT ) PARTITIONED BY (deviceplatform STRING, country…
SQLPASS: Hadoop and BI are better together–we’ll show you how!
This is going to be yet another exciting SQLPASS Summit! Lots of great sessions, focus groups, and craziness – definitely one of the funner times of the job! Over the last few years, I have had the honor to speak at the SQLPASS summits with the various themes surrounding large volume / complex Enterprise Business Intelligence. Last year I had the honor to introduce Hadoop on Azure and Windows during the 2011 PASS Summit Keynote with Ted Kummert. As it was recently announced during this year’s Strata Conference, Hortonworks Powers Microsoft HDInsight. For this year’s PASS Summit, Dave Mariani (@dmariani)…
Denny Lee 