售 价:¥
温馨提示:数字商品不支持退换货,不提供源文件,不支持导出打印
为你推荐
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
买过这本书的人还买过
读了这本书的人还在读
同类图书排行榜