万本电子书0元读

万本电子书0元读

顶部广告

Microsoft SQL Server 2012 with Hadoop电子书

售       价:¥

9人正在读 | 0人评论 9.8

作       者:Debarchan Sarkar

出  版  社:Packt Publishing

出版时间:2013-08-26

字       数:29.0万

所属分类: 进口书 > 外文原版书 > 电脑/网络

温馨提示:数字商品不支持退换货,不提供源文件,不支持导出打印

为你推荐

  • 读书简介
  • 目录
  • 累计评论(0条)
  • 读书简介
  • 目录
  • 累计评论(0条)
This book will be a step-by-step tutorial, which practically teaches working with big data on SQL Server through sample examples in increasing complexity.Microsoft SQL Server 2012 with Hadoop is specifically targeted at readers who want to cross-pollinate their Hadoop skills with SQL Server 2012 business intelligence and data analytics. A basic understanding of traditional RDBMS technologies and query processing techniques is essential.
目录展开

Microsoft SQL Server 2012 with Hadoop

Table of Contents

Microsoft SQL Server 2012 with Hadoop

Credits

About the Author

About the Reviewer

www.PacktPub.com

Support files, eBooks, discount offers and more

Why Subscribe?

Free Access for Packt account holders

Instant Updates on New Packt Books

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Errata

Piracy

Questions

1. Introduction to Big Data and Hadoop

Big Data – what's the big deal?

The Apache Hadoop framework

HDFS

MapReduce

NameNode

Secondary NameNode

DataNode

JobTracker

TaskTracker

Hive

Pig

Flume

Sqoop

Oozie

HBase

Mahout

Summary

2. Using Sqoop – The SQL Server Hadoop Connector

The SQL Server-Hadoop Connector

Installation prerequisites

A Hadoop cluster on Linux

Installing and configuring Sqoop

Setting up the Microsoft JDBC driver

Downloading the SQL Server-Hadoop Connector

Installing the SQL Server-Hadoop Connector

The Sqoop import tool

Importing the tables in Hive

The Sqoop export tool

Data types

Summary

3. Using the Hive ODBC Driver

The Hive ODBC Driver

SQL Server Integration Services (SSIS)

SSIS as an ETL – extract, transform, and load tool

Developing the package

Creating the project

Creating the Data Flow

Creating the source Hive connection

Creating the destination SQL connection

Creating the Hive source component

Creating the SQL destination component

Mapping the columns

Running the package

Summary

4. Creating a Data Model with SQL Server Analysis Services

Configuring the SQL Linked Server to Hive

The Linked Server script

Using OpenQuery

Creating a view

Creating an SSAS data model

Summary

5. Using Microsoft's Self-Service Business Intelligence Tools

PowerPivot enhancements

Power View for Excel

Summary

Index

累计评论(0条) 0个书友正在讨论这本书 发表评论

发表评论

发表评论,分享你的想法吧!

买过这本书的人还买过

读了这本书的人还在读

回顶部