You've been working at your job as a SQL programmer for quite a while now. You've become proficient in Oracle or SQL Server or Teradata, etc. You've coded oodles of SQL and things are running smoothly. Life's pretty sweet!Then, your boss walks into your cubicle and announces your entire department is moving to Hadoop…and you have one month to convert everything over! Your jaw drops! The contents of your intestines instantly liquefy! Isn't a hadoop an animal only spotted on the plains of the Serengeti? You go into a blind panic! PANIC, I say!! PANIC!!!But, don't worry, that's where this book comes in. My department went through the same thing a few years back and in order to save you time and frustration, I've written down what we learned so you don't have to go through the same panic – PANIC, I say!! PANIC!!! – as we did.This book is the author's notes that will, hopefully, teach you how to work with Impala SQL, HPL/SQL, Linux, Hadoop commands, and more. With that said, this book won't teach you how to become an Hadoop Administrator; that's not its focus.By the end of the book, you should be able to transfer all (or most) of your tables from your legacy database into Hadoop as well as set up automated scripts/processes to keep these tables updated. You should then be able to quickly move your entire programming team over to Hadoop without too much trouble…I can't do anything about their endless complainin', though!So, what are you waiting for? You only have a bloody month! QUICK! START READING!!PART I - Getting StartedChapter 1 – Quick Start GuideChapter 2 – Hadoop Administrator E-MailChapter 3 – Recommended Windows Client SoftwareChapter 4 – A Teensy-Weensy Chat about HadoopChapter 5 – Creating Your Very Own Hadoop PlaygroundPART II - Querying the Hadoop DatabaseChapter 6 – Introduction to SQLChapter 7 – Querying the Hadoop Database (Hue and SQL Clients)Chapter 8 – The One About ImpalaSQLChapter 9 – ImpalaSQL Functions ParadeChapter 10 – Voyage of the Damned (Dates & Times – ImpalaSQL Edition)Chapter 11 – Regular Expressions in ImpalaSQLChapter 12 – SQL Analytic (Windowing) Functions in ImpalaSQLChapter 13 – Extensions to the GROUP BY Clause in ImpalaSQLChapter 14 – The One About HiveQLChapter 15 – Complex Data Types in HiveQL and ImpalaSQLChapter 16 – SQL Performance ImprovementsPART III - Working with the Linux Operating SystemChapter 17 – PuTTY and the Linux Edge Node ServerChapter 18 – Introduction to the Linux Operating SystemChapter 19 – Introduction to the vi EditorChapter 20 – Working with Linux ScriptsChapter 21 – Running ImpalaSQL from the Linux Command LinePART IV - Working with HadoopChapter 22 – Hadoop Commands from Linux (hadoop/hdfs)Chapter 23 – Working with Managed and External TablesChapter 24 – The Impala Queries WebpagesPART V - HPL/SQL Procedural LanguageChapter 25 – Introduction to HPL/SQLChapter 26 – HPL/SQL SyntaxChapter 27 – HPL/SQL and Chatting with a DatabaseChapter 28 – Handling HPL/SQL ExceptionsPART VI - Updating Your DatabaseChapter 29 – Database Import/Export Using sqoopChapter 30 – Loading Data using LOAD DATA to Load DataChapter 31 – Scheduling Jobs Using crontabChapter 32 – Updating Your Hadoop Tables with makePART VII - Advanced Topics IChapter 33 – Accessing the Hive MetaStoreChapter 34 – Working with Impala Request PoolsChapter 35 – Making a Backup Copy of a Linux DirectoryChapter 36 – Using ssh and scp from Linux and WindowsChapter 37 – The Linux /etc/skel DirectoryChapter 38 – The parquet-tools and parquet-cli UtilitiesPART VIII - Advanced Topics IIChapter 39 – Quick Start Guide to Java ProgrammingChapter 40 – Creating User-Defined Functions (UDFs) for ImpalaSQL

Hadoop SQL in a Blind Panic! PDF Download
Hadoop SQL in a Blind Panic! KINDLE
Hadoop SQL in a Blind Panic! EBOOK
Hadoop SQL in a Blind Panic! EPUB
Hadoop SQL in a Blind Panic! Free
Hadoop SQL in a Blind Panic! Read Online
Hadoop SQL in a Blind Panic! Free Online

Items