Index
A
- Access Control List (ACL)
- about / Securing Hadoop
- Accumulo
- working with / Working with Accumulo, Getting ready, How it works…
- analytical functions
- defining / How to do it…
- apache maven binaries, for Linux
- URL / Getting ready
- Apache Spark
- working with / Working with Apache Spark, Getting ready
- Atomicity, Consistency, Isolation, Durability (ACID)
- about / Updating data
- authorization mode
B
- Beeline
- about / Beeline
- command options / Beeline command options
- bucketing
- defining / Bucketing, How to do it…, How it works…
- bucket map join
- using / Using a bucket map join, Getting ready
- buckets
- creating, in Hive / Creating buckets in Hive, How to do it…
- bucket sort merge map join
- built-in functions
- using / Using built-in functions
- mathematical functions / Mathematical functions
- collection functions / Collection functions
- type conversion functions / Type conversion functions
- date functions / Date functions
- string functions / String functions
- built-in User defined Aggregation Function (UDAF)
- built-in User Defined Table Function (UDTF)
C
- Cartesian product
- about / Using a cross join
- collection data types
- about / Using complex data types
- defining / Using complex data types
- collection functions
- defining / Collection functions, Collection functions
- column statistics, in Hive
- defining / Column statistics in Hive, How to do it…, How it works…
- Command-line Interface (CLI)
- about / Getting ready
- complex data types
- using / Using complex data types
- conditional functions
- defining / Conditional functions
- configurations
- changing, at runtime / Changing configurations at runtime
- create table
- displaying / Showing create table, How to do it…
- Create Table As Select (CTAS)
- about / How it works
- cross join
- using / Using a cross join, How to do it…, How it works…
- CSVSerDe
- defining / CSVSerDe, There's more…
- URL / See also
- custom User-Defined Functions (UDF)
D
- data
- inserting, into dynamic partitions / Inserting data into dynamic partitions, How it works…, There's more…
- writing, into files from queries / Writing data into files from queries, Getting ready
- updating / Updating data, How to do it...
- deleting / Deleting data, Getting ready
- database schema
- creating / Creating a database schema, How to do it…
- dropping / Dropping a database schema, How to do it…
- altering / Altering a database schema
- using / Using a database schema
- displaying / Showing database schemas, How to do it…
- defining / Describing a database schema
- Data Definition Language (DDL)
- about / Introduction, Introduction
- Data Manipulation Language (DDL or DML)
- about / Hive with a remote metastore
- Data Manipulation Language (DML)
- about / Introduction
- data sampling
- defining / Sampling
- sampling bucketed table / Sampling bucketed table
- block sampling / Block sampling
- length literal / Length literal
- row count / Row count, How it works…
- data types
- defining / Introducing data types
- primitive data types / Primitive data types
- complex data types / Complex data types
- about / Serialization and deserialization formats and data types
- Date/Time data type
- using / Using Date/Time data types
- date formats, Hive
- URL / See also
- date functions
- defining / Date functions, Date functions
- Distinguished Name (DN)
- about / LDAP
- dynamic partitioning
- about / Loading data in a managed partitioned table
- properties / Loading data in a managed partitioned table
- dynamic partitions
- data, inserting into / Inserting data into dynamic partitions, How it works…, There's more…
E
- external table
- partitioning / Partitioning an external table
F
- file formats
- defining / File formats, How to do it…
- types / File formats
- files
- loading, into tables / Loading files into tables, How it works…
- Finer Access Control Lists (FACL)
- about / How to do it…
- FIRST_VALUE function
- about / FIRST_VALUE
G
- Google Drill
- working with / Working with Google Drill, How it works…
H
- Hadoop
- securing / Securing Hadoop, How to do it…, How it works…
- read and write access, giving / Giving read and write access to user mike
- user access, revoking / Revoking the access of the user mike
- URL / See also
- Hadoop cluster
- Hive, deploying on / Deploying Hive on a Hadoop cluster, Deploying Hive Metastore, Getting ready, How to do it…
- Hadoop Distributed File System (HDFS)
- about / Introduction, How it works…, Securing Hadoop
- HBase
- working with / Working with HBase, Getting ready, How to do it…, How it works…
- HCatalog
- configuring / Configuring HCatalog
- command-line options / Getting ready
- defining / HCatalog
- DMLs / HCatalog DMLs
- high availability
- configuring, of metastore service / Configuring high availability of metastore service
- Hive
- deploying, on Hadoop cluster / Deploying Hive on a Hadoop cluster, Deploying Hive Metastore, Getting ready, How to do it…
- references / Getting ready, How to do it..., Hive with a remote metastore, How to do it..., See also
- installing / Installing Hive, Hive with an embedded metastore, Hive with a local metastore, Hive with a remote metastore
- with embedded metastore / Hive with an embedded metastore
- with local metastore / Hive with a local metastore
- with remote metastore / Hive with a remote metastore
- compiling, from source / Compiling Hive from source, How to do it...
- prerequisites, installing / Getting ready
- debugging / Debugging Hive, How to do it...
- running / Running Hive
- configuring, with Hue / Configuring Hive with Hue
- accessing, with Hue / Accessing Hive with Hue
- database, creating / How to do it…
- transactions, enabling / Enabling transactions in Hive, How to do it…
- buckets, creating / Creating buckets in Hive, How to do it…
- metastore view, of bucketing / Metastore view of bucketing
- analytics functions / Analytics functions in Hive, How to do it…, See also
- specifications, defining / How to do it…
- table and partition statistics / Table and partition statistics in Hive, How to do it…
- predicate pushdown optimizations, enabling / Enabling predicate pushdown optimizations in Hive, How to do it…, How it works…
- sampling ways / Getting ready
- authorizing / Authorizing Hive, How to do it…
- HCatalog API / Authorizing Hive
- Command Line Interface (CLI) / Authorizing Hive
- ODBC/JDBC / Authorizing Hive
- legacy mode / Default authorization–legacy mode
- storage-based authorization / Storage-based authorization
- SQL standards-based authorization / SQL standards-based authorization
- authenticating / Authenticating Hive
- anonymous, with SASL / Anonymous with SASL (default no authentication)
- anonymous, without SASL / Anonymous without SASL
- Kerberos / Kerberos
- JDBC client, configuring for Kerberos authentication / Configuring the JDBC client for Kerberos authentication
- accessing / Configuring the JDBC client for Kerberos authentication
- LDAP, defining / LDAP
- Pluggable Authentication Modules (PAM) / Pluggable Authentication Modules
- custom mode, using / Custom
- hive-json-serde-02.jar
- URL / JSONSerDe
- Hive built-in aggregate functions
- URL / See more
- Hive clients
- about / Hive clients
- Hive CLI / Hive CLI
- Beeline / Getting ready
- Hive components
- defining / Understanding different components of Hive
- HiveServer / HiveServer
- HiveServer2 / HiveServer2
- Hive clients / Hive clients
- Hive Data Definition Language
- about / Hive with a remote metastore
- Hive mathematical functions
- URL / See also
- Hive metastore service
- defining / Introducing the Hive metastore service, How it works…
- Hive modules
- using / How to do it...
- Hive packages
- defining / Hive packages, How to do it...
- Hive partitioning
- about / Hive partitioning
- static partitioning / Static partitioning
- dynamic partitioning / Dynamic partitioning
- Hive Query Language (HQL)
- about / Introduction
- Hive roles
- HiveServer
- about / HiveServer
- Hive metastore / Hive metastore
- HiveServer2
- about / HiveServer2, Authenticating Hive
- defining / Introducing HiveServer2, How to do it…, See also
- authentication options / How to do it…
- HiveServer2 Clients
- using / Using HiveServer2 clients
- Beeline / Beeline
- JDBC / JDBC
- other clients / Other clients
- HiveServer2 high availability
- configuring / Configuring HiveServer2 high availability, How to do it…
- HiveServer2 properties
- defining / Understanding HiveServer2 properties, How it works…
- Hive string functions
- URL / See also
- Hive tables
- data inserting, from queries / Inserting data into Hive tables from queries, Getting ready, How it works…
- Hive transactions
- URL / Getting ready
- Hive Wiki
- URL / How to do it…
- Hue
- defining / Introducing Hue
- prepare dependencies / Prepare dependencies
- downloading / Downloading and installing Hue
- installing / Downloading and installing Hue
- Hive, configuring with / Configuring Hive with Hue
- starting / Starting Hue
- Hive, accessing with / Accessing Hive with Hue
I
- in-built SerDes
- indexes
- defining / Exploring indexes
- Input Pruning
- about / How it works…
J
- Java Database Connectivity (JDBC)
- Java Pluggable Authentication Modules (JPAM)
- Java SE environment
- URL / Getting ready
- Java System Property
- about / Getting ready
- JDBC
- about / JDBC
- client sample code, eclipse used / JDBC client sample code using Eclipse
- JDBC datatypes
- defining / JDBC datatypes
- JDBC sample code
- running, from command line / Running the JDBC sample code from the command-line
- join
- defining / Understanding the joins concept, How it works…
- JSONSerDe
- defining / JSONSerDe
L
- LAG function
- about / LAG
- LAST_VALUE function
- about / LAST_VALUE
- URL / See also
- LazySimpleSerDe
- defining / LazySimpleSerDe
- LEAD function
- about / LEAD
- left/right/full outer join
- left semi join
- using / Using a left semi join, How to do it…, How it works…
- Lightweight Directory Access Protocol (LDAP)
- about / LDAP
- local metastore
- about / How to do it…
M
- managed table
- partitioning / Partitioning a managed table, How to do it…
- map-side join
- using / Using a map-side join, How it works…
- mathematical functions
- defining / Mathematical functions, Mathematical functions
- miscellaneous data types
- using / Using miscellaneous data types
- miscellaneous functions
- defining / Miscellaneous functions
- mysql-connector jar
N
- numeric data types
- using / Using numeric data types, How to do it…
O
- Open Database Connectivity (ODBC)
- about / How to do it...
- operators
- using / Using operators
- relational operators, using / Using relational operators, How to do it…
- arithmetic operators, using / Using arithmetic operators, How to do it…
- logical operators, using / Using logical operators, How to do it…
- complex operators, using / Using complex operators, How to do it…
- optimizations
- used, for reducing map number / Optimizations to reduce the number of map, How to do it…
- Optimized Row Columnar (ORC)
- about / How to do it…
P
- PAM authentication
- configuring / Pluggable Authentication Modules
- partition filters
- about / How to do it…
- partitioning
- about / Introduction
- defining / Partitioning, How to do it…
- partitions
- adding / Adding new partitions
- renaming / Renaming partitions
- exchanging / Exchanging partitions
- dropping / Dropping the partitions
- data, loading in managed partitioned table / Loading data in a managed partitioned table
- displaying / Showing partitions
- Pluggable Authentication Modules (PAM)
- about / Pluggable Authentication Modules
- POSIX model
- about / Securing Hadoop
- privilege types
- Python
- URL / Other clients
Q
- queries
- data writing, into files from / Writing data into files from queries, Getting ready
R
- Record Columnar File
- about / How to do it…
- references / How to do it…
- RegexSerDe
- defining / RegexSerDe
- remote metastore
- about / How to do it…
- Row Columnar (RC)
- about / How to do it…
- Ruby Client
- URL / Other clients
S
- SerDes
- Simple Authentication and Security Layer (SASL)
- about / How to do it…
- skew join
- using / Using a skew join, How it works…
- SQL
- values inserting, into tables from / Inserting values into tables from SQL, How it works…, There's more…
- SQL standards-based authorization
- configuring / Configuring the SQL standards-based authorization, Getting Started, How to do it…
- existing roles, listing out / To list out all existing roles
- role, creating / creating a role
- role, deleting / Deleting a role
- list of current roles, displaying / Showing list of current roles
- role, setting / Setting a role
- role, granting / Granting a role
- role, revoking / Revoking a role
- roles, checking / Checking roles of a user/role
- principles of role, checking / Checking principles of a role
- privileges, granting / Granting privileges
- privileges, revoking / Revoking privileges
- privileges, checking / Checking privileges of a user or role
- static partitioning / Static partitioning
- statistics, in Hive
- bringing / Bringing statistics in to Hive, How to do it…
- for partitioned table / Statistics for a partitioned table
- storage-based authorization
- properties / Storage-based authorization
- string data types
- using / Using string data types, How it works…
- string functions
- defining / String functions, String functions, There's more
T
- table-generating functions
- examples / How to do it…
- table properties
- altering / Altering table properties
- displaying / Show the table properties
- tables
- creating / Creating tables, How it works
- table LIKE, creating / Create table LIKE
- dropping / Dropping tables, How to do it…
- truncating / Truncating tables
- renaming / Renaming tables, How to do it…
- displaying / Showing tables, How to do it…
- files, loading into / Loading files into tables, How it works…
- Templeton
- about / Getting ready
- timestamp data type
- about / Using Date/Time data types
- top K statistics, in Hive
- defining / Top K statistics in Hive, How to do it…
- transactions
- enabling, in Hive / Enabling transactions in Hive, How to do it…
- type conversion functions
- defining / Type conversion functions, Type conversion functions
U
- User-Defined Aggregate (UDA)
- about / Using string data types
- User-Defined Function (UDF)
- about / Using string data types
V
- values
- inserting into tables, from SQL / Inserting values into tables from SQL, How it works…, There's more…
- view
- creating / Creating views, Getting ready
- altering, as select / Altering the view as select
- view properties
- altering / Altering the view properties
- views
- dropping / Dropping views, Getting ready
- defining / Exploring views, How it works…
W
- WebHCat
- windowing
- about / Introduction
- in Hive / Windowing in Hive, How to do it…
- in Hive, specifications / Windowing in Hive
- windowing functions
- implementing / How to do it…
Y
- Yet Another Resource Negotiator (YARN)
- about / Deploying Hive Metastore