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 numeric data types


Hive supports a set of data types that can be used for table columns, expression values, and function arguments, and return values.

In the following table, primitive numeric data types are listed with sizes and examples:

Data Type

Size

Example

TINYINT

1-byte signed integer

50

SMALLINT

2-byte signed integer

20,000

INT

4-byte signed integer

1,000

BIGINT

8-byte signed integer

50,000

FLOAT

4-byte single-precision floating point

400.50

DOUBLE

8-byte double-precision floating point

20,000.50

DECIMAL

17-byte precision up to 38 digits

DECIMAL(20,2)

By default, all integral literals are treated as the INT values until they cross the range of INT values. If some integral literal crosses the range of the INT value, then it is treated as the BIGINT value. There is a mechanism of postfix, which is used to specify an integral literal as TINYINT, SMALLINT, and BIGINT.

To specify an integral literal as TINYINT, the postfix Y is used. For example, you can specify...