Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Learning Hub

Free Learning

You're reading from Apache Hive Essentials Essential techniques to help you process, and get unique insights from, big data

Product type Paperback

Published in Jun 2018

Publisher Packt

ISBN-13 9781788995092

Length 210 pages

Edition 2nd Edition

Languages

Java

Tools

Hive

Concepts

Big Data

Author (1):

Dayong Du

View More author details

Table of Contents (12) Chapters

Preface

1. Overview of Big Data and Hive FREE CHAPTER

2. Setting Up the Hive Environment

3. Data Definition and Description

4. Data Correlation and Scope

5. Data Manipulation

6. Data Aggregation and Sampling

7. Performance Considerations

8. Extensibility Considerations

9. Security Considerations

10. Working with Other Tools

11. Other Books You May Enjoy

Leave a review - let other readers know what you think

Using the Hive IDE

Besides the command-line interface, there are other Integrated Development Environment (IDE) tools available to support Hive. One of the best is Oracle SQL Developer, which leverages the powerful functionalities of the Oracle IDE and is totally free to use. Since Oracle SQL Developer supports general JDBC connections, it is quite convenient to switch between Hive and other JDBC-supported databases in the same IDE. Oracle SQL Developer has supported Hive since v4.0.3. Configuring it to work with Hive is quite straightforward:

Download Oracle SQL Developer (http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html).
Download the Hive JDBC drivers (https://www.cloudera.com/downloads/connectors/hive/jdbc.html).
Unzip the driver file to a local directory.
Start Oracle SQL Developer and navigate to Preferences | Database | Third Party JDBC...

The rest of the chapter is locked

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at $19.99/month. Cancel anytime

Authors (1)

Dayong Du

Dayong Du has all his career dedicated to enterprise data and analytics for more than 10 years, especially on enterprise use case with open source big data technology, such as Hadoop, Hive, HBase, Spark, etc. Dayong is a big data practitioner as well as author and coach. He has published the 1st and 2nd edition of Apache Hive Essential and coached lots of people who are interested to learn and use big data technology. In addition, he is a seasonal blogger, contributor, and advisor for big data start-ups, co-founder of Toronto big data professional association.

See other products by Dayong Du