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

Understanding HiveServer2 properties


By default, HiveServer2 is started with default configurations. The configurations are mainly related to the port and host on which the server is going to start and number of threads that could be configured for client and background operations.

How to do it…

You can change the default properties for HiveServer2 by overriding the value in hive-site.xml in the conf folder of Hive package.

Property

Default Value

Description

hive.server2.thrift.port

10000

HiveServer2 thrift interface

hive.server2.thrift.bind.host

localhost

HiveServer2 bind host

hive.server2.thrift.min.worker.threads

5

Minimum thrift worker threads

hive.server2.thrift.max.worker.threads

500

Maximum thrift worker threads

hive.server2.authentication

None

None/LDAP/KERBEROS/PAM/NOSASL

hive.server2.authentication.kerberos.keytab

""

A keytab file for kerberos principal

hive.server2.authentication.kerberos.principal

""

The Kerberos principal

hive.server2.enable.doAs

true

...