HDInsight: Jiving about Hadoop and Hive with CAT

Tomorrow I will be talking about Hive as part of Pragmatic Work’s Women in Technology (WIT) month of webcasts. I am proud to be part of this lineup with all these stellar WITs! I encourage my fellow WITs to get more involved in your data community and if you don’t already do so start tweeting,Continue reading “HDInsight: Jiving about Hadoop and Hive with CAT”

PASS BAC PREVIEW SERIES: SQL Professionals and the World of Self-service BI and Big Data

Are you excited about the upcoming PASS Business Analytics Conference? You should be! This conference will offer a wide range of sessions about Microsoft’s End to End Business Intelligence (including Self-Service BI), Analytics, Big Data, Architecture, Reporting, Information Delivery, Data Management, and Visualization solutions. Whether you are an implementer, a planner, or a decision makerContinue reading “PASS BAC PREVIEW SERIES: SQL Professionals and the World of Self-service BI and Big Data”

HDInsight: Hive Internal and External Tables Intro

Small Bites of Big Data Cindy Gross, SQLCAT PM HDInsight is Microsoft’s distribution, in partnership with Hortonworks, of Hadoop. Hive is the component of the Hadoop ecosystem that imposes structure on Hadoop data in a way that makes it usable from BI tools that expect rows and columns with defined data types. Hive tables canContinue reading “HDInsight: Hive Internal and External Tables Intro”

Hurricane Sandy Mash-Up: Hive, SQL Server, PowerPivot, Power View

Small Bites of Big Data Authors: Cindy Gross Microsoft SQLCAT PM, Ed Katibah Microsoft SQLCAT PM Tech Reviewers: Bob Beauchemin Developer Skills Partner at SQLSkills, Jeannine Nelson-Takaki Microsoft Technical Writer, John Sirmon Microsoft SQLCAT PM, Lara Rubbelke Microsoft Technical Architect, Murshed Zaman Microsoft SQLCAT PM For my #SQLPASS Summit 2012 talk SQLCAT: Big Data –Continue reading “Hurricane Sandy Mash-Up: Hive, SQL Server, PowerPivot, Power View”

Big Data – All Abuzz About Hive at #SQLPASS Summit 2012

Big Data – All Abuzz About Hive Small Bites of Big Data Cindy Gross, SQLCAT PM I hope to see you at the #SQLPASS Summit 2012 this week! There are many reasons people come to the PASS Summit – SQL friends, SQL family, networking, great content in 190 sessions, the SQL clinic, the product team,Continue reading “Big Data – All Abuzz About Hive at #SQLPASS Summit 2012”

Load SQL Server BCP Data to Hive

Load SQL Server BCP Data to Hive Small Bites of Big Data Cindy Gross, SQLCAT PM As you start learning more about Hadoop you may want to take a look at how the same data and queries work for SQL Server and for Hadoop. There are various ways to do this. For now I’ll showContinue reading “Load SQL Server BCP Data to Hive”

What’s all the Buzz about Hadoop and Hive?

What’s all the Buzz about Hadoop and Hive? Why it Matters for SQL Server Peeps Small Bites of Big Data Cindy Gross, SQLCAT PM On September 20, 2012 we have another 24 Hours of PASS event! This PASS Summit Preview will give you a taste of what is coming at this year’s PASS Summit. ThereContinue reading “What’s all the Buzz about Hadoop and Hive?”

How to Install the PowerShell Cmdlets for Apache™ Hadoop™-based Services for Windows

How to Install the PowerShell Cmdlets for Apache™ Hadoop™-based Services for Windows Small Bites of Big Data Cindy Gross, SQLCAT PM UPDATED JUNE 2013 – The very early version of PowerShell cmdlets I discussed below have been replaced – see Managing Your HDInsight Cluster with PowerShell http://blogs.msdn.com/b/carlnol/archive/2013/06/07/managing-your-hdinsight-cluster-with-powershell.aspx We have a cool new addition to Microsoft’s Apache™Continue reading “How to Install the PowerShell Cmdlets for Apache™ Hadoop™-based Services for Windows”

Hadoop Hive Error: Could not connect client socket, timed_out

Small Bites of Big Data Cindy Gross, SQLCAT PM With the Hadoop on Azure CTP, when you create a Hadoop cluster it expires after a few days to free up the resources for other CTP users. Therefore each time I do a demo or test I am likely to create a new Hadoop cluster. ThereContinue reading “Hadoop Hive Error: Could not connect client socket, timed_out”

Load Data from the Azure DataMarket to Hadoop on Azure – Small Bites of Big Data

Load Data from the Azure DataMarket to Hadoop on Azure Small Bites of Big Data Cindy Gross, SQLCAT PM UPDATED Jun 2013: HadoopOnAzure CTP has been replaced by HDInsight Preview which has a different interface and different functionality. Getting Started with Windows Azure HDInsight Service http://www.windowsazure.com/en-us/manage/services/hdinsight/get-started-hdinsight/  The first step in analyzing data is acquiring thatContinue reading “Load Data from the Azure DataMarket to Hadoop on Azure – Small Bites of Big Data”