Dive into the world of SQL on Hadoop and get the most out of your Hive data warehouses. This book is your go-to resource for using Hive: authors Scott Shaw, Ankur Gupta, David Kjerrumgaard, and Andreas Francois Vermeulen take you through learning HiveQL, the SQL-like language specific to Hive, to analyze, export, and massage the data stored across your Hadoop environment. From deploying Hive on your hardware or virtual machine and setting up its initial configuration to learning how Hive interacts with Hadoop, MapReduce, Tez and other big data technologies, Practical Hive gives you a detailed treatment of the software. In addition, this book discusses the value of open source software, Hive performance tuning, and how to leverage semi-structured and unstructured data. What You Will Learn Install and configure Hive for new and existing datasets Perform DDL operations Execute efficient DML operations Use tables, partitions, buckets, and user-defined functions Discover performance tuning tips and Hive best practices Who This Book Is For Developers, companies, and professionals who deal with large amounts of data and could use software that can efficiently manage large volumes of input. It is assumed that readers have the ability to work with SQL.

Pro T-SQL Programmer's Guide is your guide to making the best use of the powerful, Transact-SQL programming language that is built into Microsoft SQL Server's database engine. This edition is updated to cover the new, in-memory features that are part of SQL Server 2014. Discussing new and existing features, the book takes you on an expert guided tour of Transact-SQL functionality. Fully functioning examples and downloadable source code bring technically accurate and engaging treatment of Transact-SQL into your own hands. Step-by-step explanations ensure clarity, and an advocacy of best-practices will steer you down the road to success. Transact-SQL is the language developers and DBAs use to interact with SQL Server. It's used for everything from querying data, to writing stored procedures, to managing the database. Support for in-memory stored procedures running queries against in-memory tables is new in the language and gets coverage in this edition. Also covered are must-know features such as window functions and data paging that help in writing fast-performing database queries. Developers and DBAs alike can benefit from the expressive power of T-SQL, and Pro T-SQL Programmer's Guide is your roadmap to success in applying this increasingly important database language to everyday business and technical tasks. Covers the newly-introduced, in-memory database features Shares the best practices used by experienced professionals Goes deeply into the subject matter an advanced book for the serious reader

Pranayama, the practice of breath control, is detailed here in an easy-to-understand and even easier-to-practise format. Professional yoga instructor Scott Shaw introduces 16 breathing exercises and shows you how to get the best benefit from each of the forms by training, refining and witnessing your breath. Try one of the calming breaths, Nadi Sudi or the Nerve Purifying Breath. Have a long day ahead with no breaks until after dinner? Allow Ujayi or the Hissing Breath to work its miracles. Here you will learn how to breathe while moving, standing and leaning and how these variations can affect your breathing practice. Use the instruction offered in "The Little Book of Yoga Breathing" to feel more focused and energized.

Pro T--SQL 2012 Programmer's Guide is every developer's key to making full use of SQL Server 2012's powerful, built--in Transact--SQL language. Discussing new and existing features, the book takes you on an expert guided tour of Transact--SQL functionality. Fully functioning examples and downloadable source code bring technically accurate and engaging treatment of Transact--SQL into your own hands. Step--by--step explanations ensure clarity, and an advocacy of best--practices will steer you down the road to success. Transact--SQL is the language developers and DBAs use to interact with SQL Server. It's used for everything from querying data, to writing stored procedures, to managing the database. New features in T-SQL 2012 include full support for window functions, stored sequences, the ability to throw errors, data paging, and more. All these important new features are covered in this book. Developers and DBAs alike can benefit from the expressive power of Transact-SQL, and Pro T-SQL 2012 Programmer's Guide provides the gateway to success in applying this increasingly important database language to everyday business and technical tasks.What you'll learn * Take full advantage of window functions and other new features in T-SQL 2012 * Move business logic into the database via procedures and functions * Develop using advanced features such as encryption and full-text search * Store and retrieve XML data using XQuery and XPath * Debug and Optimize T-SQL Execution * Build ADO.NET Client Applications Who this book is for Pro T--SQL 2012 Programmer's Guide is written for SQL Server and Transact--SQL developers who want to implement best--practices and take full advantage of all that SQL Server has to offer. NET programmers will find the book helpful in showing how to run .NET code within SQL Server. Database administrators who need to write triggers and the occasional stored procedure will also benefit from the book.

Your Wedding, Your Way is a resourceful handbook for modern couples who want to celebrate their marriage in a way that feels true to them and is financially reasonable, whether that's an elegant dinner party, a weekend camping trip in a national park, or a road trip to Vegas.

Nowadays, more and more couples are eschewing tradition for a wedding celebration that feels more reflective of who they are and what they value. Whether it's a courthouse ceremony or a weeklong destination trip, there are so many ways to celebrate a union that don't require a big white dress, months of stressful planning, and an inflated budget.

For couples who want to do things a little differently, Your Wedding, Your Way is a resourceful guide full of helpful advice and how-tos, fun sidebars and listicles, and anecdotes from real couples who did it themselves. Modern couples of all ages and sexualities who are uninterested in the traditional wedding hoopla and are looking for alternative ways to celebrate will appreciate this practical handbook, and particularly millennials and Gen-Zers who reevaluated their priorities in recent years; who feel disconnected from antiquated traditions; who are getting married later and financing their wedding themselves; and who prefer meaningful experiences over things.

Perfect for:

• Couples who are interested in having a nontraditional wedding
• Millennial and Gen-Z couples who want an intimate celebration that doesn't drain the bank
• LGBTQ+ couples
• People who have been married before/are celebrating a second wedding or vow renewal
• Modern couples who prefer experiences over things

Wild flowers of KwaZulu Natal is a book written and illustrated by Joan Walker. The book showcases the magnificent wild flowers of KwaZulu Natal and would be of interest to botanists, horticulturists, home graders and nature enthusiasts. Each species includes a water colour illustration, scientific name, common name, Zulu name and various details on the species.

Taekwondo Basics teaches you all the fundamentals of this martial art form in a clear and easy-to-understand manner! This basic introductory survey contains the following vital information: The origins of Taekwondo its philosophy, history, and different skills; How to find a teacher and a class that are right for you; Getting ready for your first class what happens in a Taekwondo class?; The essential elements stances, blocks, hand and arm strikes and kicks; How to complement your Taekwondo training with other conditioning exercises, such as running and biking; Powerful ways to improve your technique through target training, partner training, competitive training, free-sparring, and more; Resources that can help you further develop your Taekwondo training. Whether you're just getting started, or you've already been training for a year or two, Taekwondo Basics offers an easy to read, and yet comprehensive introduction to the sport.

Beginning T-SQL 2012 is the first step toward learning the T-SQL language that underlies Microsoft's SQL Server database engine. T-SQL is essential in writing SQL statements to get data into and out of a database. T-SQL is the foundation for business logic embedded in the database in the form of stored procedures and functions. Beginning T-SQL 2012 starts you on the path to mastering T-SQL, with an emphasis on best practices and sound coding techniques. Beginning T-SQL 2012 begins with an introduction to databases, normalization, and to SQL Server Management Studio. Each subsequent chapter teaches an aspect of T-SQL, building on the skills learned in previous chapters. Exercises in each chapter give readers an opportunity for the hands-on practice that leads to true learning and distinguishes the competent professional.* Imparts best practices for writing T-SQL * Helps you avoid common errors * Shows how to write scalable code for good performance What you'll learn * The fundamentals of relational theory, upon which Transact-SQL is based * How to write accurate queries that are scalable and perform well * How to combine set-based and procedural processing, obtaining the best from both worlds * How to embed business logic in your database through stored procedures and functions * How to simplify your work with new and advanced features, such as common table expressions and virtual tables * How to enhance performance by knowing when to apply features such table value parameters, and when not to Who this book is for Beginning T-SQL 2012 is for developers and database administrators who will be writing database applications against SQL Server databases.