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”

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”

24HOP/SQLRally – Fitting Microsoft Hadoop Into Your Enterprise BI Strategy

24HOP/SQLRally – Fitting Microsoft Hadoop Into Your Enterprise BI Strategy Small Bites of Big Data Cindy Gross, SQLCAT PM The world of #bigdata and in particular #Hadoop is going mainstream. At 24HOP 2012 I talked about how a SQL Server professional fits into this big data world. Hadoop generally falls into the NOSQL realm. NOSQLContinue reading “24HOP/SQLRally – Fitting Microsoft Hadoop Into Your Enterprise BI Strategy”

Using the Pi Estimator Sample on HadoopOnAzure CTP – Small Bites of Big Data

Using the Pi Estimator Sample on HadoopOnAzure CTP Small Bites of Big Data Cindy Gross, SQLCAT PM UPDATED Jun 2013: HadoopOnAzure CTP has been replaced with HDInsight Preview. See: How to Run the HDInsight Samples http://www.windowsazure.com/en-us/manage/services/hdinsight/howto-run-samples/  Now that you have created your Hadoop on Azure cluster you can run the sample programs to become familiarContinue reading “Using the Pi Estimator Sample on HadoopOnAzure CTP – Small Bites of Big Data”

Open Ports for HadoopOnAzure CTP – Small Bites of Big Data

Open Ports for HadoopOnAzure CTP Small Bites of Big Data Cindy Gross, SQLCAT PM UPDATED Jun 2013: HadoopOnAzure CTP has been replaced by HDInsight Preview. See Troubleshooting ODBC connectivity to HDInsight http://social.msdn.microsoft.com/Forums/en-US/hdinsight/thread/b4ca52ea-f7cf-420c-959d-53e09f801f7d.       Once you have created your Hadoop on Azure cluster you will likely be moving data in and out of the system. That meansContinue reading “Open Ports for HadoopOnAzure CTP – Small Bites of Big Data”