Apache Sqoop Cookbook pdf

所需积分/C币:10 2016-04-10 15:55:31 3.71MB PDF
收藏 收藏

Apache Sqoop Cookbook.pdf 英文版 免积分下载
OREILLY° Learn how to turn Strata data into decisions. Making data Work From startups to the fortune 500 smart companies are betting on data-driven insight seizing the opportunities that are emerging from the convergence of four powerful trends New methods of collecting managing and analyzing data Cloud computing that offers inexpensive storage and flexible on-demand computing power for massive data sets Visualization techniques that turn complex data into images that tell a compelling story Tools that make the r of data available to anyone Get control over big data and turn it into insight with O'Reilly's Strata offerings. Find the inspiration and nformation to create new products or revive existing ones nderstand customer behavior, and get the data edge ○ REILLY Visit oreilly. com/data to learn more Apache Sqoop cookbook Kathleen ting and Jarek Jarcec echo O'REILLY° Beijing· ambridge; Farnham·Kdn: Sebastopol· Tokyo Apache Sqoop Cookbook by Kathleen Ting and Jarek Jarcec Cecho Copyright O 2013 Kathleen Ting and Jarek Jarcec Cecho. All rights reserved Printed in the united states of america Published by o reilly Media, Inc., 1005 Gravenstein Highway North, Sebastopol, CA 95472 OReilly books may be purchased for educational, business, or sales promotional use. Online editions are alsoavailableformosttitles(http://my.safaribooksonline.com).Formoreinformation,contactourcorporate institutionalsalesdepartment800-998-9938orcorporate@oreilly.com Editor Courtney nash Proofreader: Julie Van Keuren Production Editor: Rachel Steely Cover Designer: Randy Comer Copyeditor: BIM Proofreading Services Interior Designer: David Futato July 2013 First edition Revision history for the first Edition 2013-06-28: First release Seehttp:/oreilly.com/catalog/errata.csp?isbn=9781449364625forreleasedetails Nutshell Handbook, the Nutshell Handbook logo, and the O Reilly logo are registered trademarks ofO Reilly Media, Inc. Apache Sqoop Cookbook, the image of a Great White Pelican, and related trade dress are trade marks of o Reilly media, Inc Many of the designations used by manufacturers and sellers to distinguish their products are claimed as trademarks. Where those designations appear in this book, and O reilly Media, Inc, was aware of a trade- mark claim, the designations have been printed in caps or initial caps Apache, Sqoop, Apache Sqoop, and the Apache feather logos are registered trademarks or trademarks of The apache Software Foundation While every precaution has been taken in the preparation of this book, the publisher and authors assume no responsibility for errors or omissions, or for damages resulting from the use of the information contained herein ISBN:978-1-449-36462-5 [LSI Table of contents Foreword Preface 1. Getting Started.......... 1. 1. Downloading and Installing Sqoop 1.2. Installing JDBC Drivers 1.3. Installing Specialized Connectors 1. 4. Starting Sqoop 1.5. Getting Help with Sqoop 2. Importing Data........ 13456901 2. 1. Transferring an Entire Table 2. 2. Specifying a Target Directory 2.3. Importing only a subset of data 13 2.4. Protecting Your Password 13 2.5. Using a File Format Other Than CSv 15 2.6. Compressing Imported Data 16 2. 7. Speeding Up Transfers 2.8. Overriding Type Mapping 18 2.9. Controlling Parallelism 19 2.10. Encoding null values 21 2. 11. Importing All Your Tables 2 3. Incremental Import 25 3. 1. Importing Only New Data 25 3. 2. Incrementally Importing Mutable Data 26 3.3. Preserving the Last Imported value 27 3.4. Storing Passwords in the Metastore 28 3.5. Overriding the arguments to a saved job 29 3.6. Sharing the Metastore Between Sqoop Clients 4. Free-Form Query Import 33 4.1. Importing data from Two Tables 34 4. 2. Using Custom Boundary Queries 35 4.3. Renaming Sqoop Job Instances 37 4.4. Importing Queries with Duplicated Columns 37 5. Export 39 5. 1. Transferring Data from Hadoop 39 5.2. Inserting Data in Batches 5.3. Exporting with All-or-Nothing Semantics 42 5.4. Updating an Existing Data Set 43 5.5. Updating or Inserting at the Same Time 5.6. Using Stored Procedures 45 5.7. Exporting into a Subset of Columns 46 5.8. Encoding the NULL Value Differently 47 5.9. Exporting Corrupted Data 48 6. Hadoop Ecosystem Integration 6. 1. Scheduling sgoop jobs with oozie 51 6. 2. Specifying Commands in Oozie 52 6.3. Using Property parameters in oozie 53 6.4. Installing Dbc Drivers in Oozie 54 6.5. Importing data Directly into Hive 55 6.6. Using Partitioned Hive Table 56 6.7. Replacing Special Delimiters During Hive Import 6.8. USing the Correct NULL String in Hive 6.9. Importing Data into HBase 60 6.10. Importing all rows into HBase 61 6.11. Improving Performance When Importing into HBase 62 7. Specialized connectors 7.1. Overriding Imported boolean Values in PostgreSQL Direct Import 63 7. 2. Importing a Table Stored in Custom Schema in PostgreSQL 7.3. Exporting into PostgreSQL USing pg_ bulkload 65 7.4. Connecting to MySQL 66 7.5. USing Direct MySQL Import into Hive 66 7.6. USing the upsert Feature When Exporting into MySQL 67 7.7. Importing from Oracle 68 7.8. Using ynonyms in orac 7. 9. Faster Transfers with Oracle 70 Table of contents 7.10. Importing into Avro with OraOop 70 7. 11. Choosing the Proper Connector for Oracle 7. 12. Exporting into Teradata 73 7.13. USing the Cloudera Teradata Connector 7. 14. Using Long Column Names in Teradata 74 Table of contentsⅶi

试读 94P Apache Sqoop Cookbook pdf
立即下载 低至0.43元/次 身份认证VIP会员低至7折
\`\`\\17 正好在用sqoop,看看
szfbair113 it is ok, good , go on
  • 签到新秀

  • 分享王者

关注 私信 TA的资源
    Apache Sqoop Cookbook pdf 10积分/C币 立即下载
    Apache Sqoop Cookbook pdf第1页
    Apache Sqoop Cookbook pdf第2页
    Apache Sqoop Cookbook pdf第3页
    Apache Sqoop Cookbook pdf第4页
    Apache Sqoop Cookbook pdf第5页
    Apache Sqoop Cookbook pdf第6页
    Apache Sqoop Cookbook pdf第7页
    Apache Sqoop Cookbook pdf第8页
    Apache Sqoop Cookbook pdf第9页
    Apache Sqoop Cookbook pdf第10页
    Apache Sqoop Cookbook pdf第11页
    Apache Sqoop Cookbook pdf第12页
    Apache Sqoop Cookbook pdf第13页
    Apache Sqoop Cookbook pdf第14页
    Apache Sqoop Cookbook pdf第15页
    Apache Sqoop Cookbook pdf第16页
    Apache Sqoop Cookbook pdf第17页
    Apache Sqoop Cookbook pdf第18页
    Apache Sqoop Cookbook pdf第19页

    试读结束, 可继续读1页

    10积分/C币 立即下载 >