Book Image

Apache Hive Cookbook

Book Image

Apache Hive Cookbook

Overview of this book

Hive was developed by Facebook and later open sourced in Apache community. Hive provides SQL like interface to run queries on Big Data frameworks. Hive provides SQL like syntax also called as HiveQL that includes all SQL capabilities like analytical functions which are the need of the hour in today’s Big Data world. This book provides you easy installation steps with different types of metastores supported by Hive. This book has simple and easy to learn recipes for configuring Hive clients and services. You would also learn different Hive optimizations including Partitions and Bucketing. The book also covers the source code explanation of latest Hive version. Hive Query Language is being used by other frameworks including spark. Towards the end you will cover integration of Hive with these frameworks.
Table of Contents (19 chapters)
Apache Hive Cookbook
Credits
About the Authors
About the Reviewer
www.PacktPub.com
Preface
Index

Using operators


Hive supports various built-in operators. There are four types of operator in Hive:

  • Relational operators

  • Arithmetic operators

  • Logical operators

  • Complex operators

Using relational operators

Relational operators are used to compare two operands. The output of comparison produces TRUE or FALSE depending on the comparison of operands.

The following table describes relational operators available in Hive:

Operator

Operand Type

Description

A = B

All primitive data types

This returns True if primitives are equal, otherwise False.

A != B

All primitive data types

This returns True if primitive A is not equal to B, False otherwise. It would return Null if A or B is NULL.

A <=> B

All primitive data types

This returns the same result as the EQUAL operator for non-null primitives. It would return TRUE if both A and B are NULL, FALSE if one of the primitives among A and B is NULL.

A <> B

All primitive data types

This returns the same result as the NOT EQUAL (!=) operator...