Hortonworks Docs » Hortonworks Data Platform 3.1.4 » Apache Hive overview

Apache Hive overview

Also available as:

PDF

loading table of contents...

What's new in this release: Apache Hive
Apache Hive 3 architectural overview
Apache Hive 3 upgrade process
- Changes after upgrading to Apache Hive 3
- Hive Semantic and Syntax Changes
Install the Hive service
Apache Hive content roadmap

Hive Semantic and Syntax Changes

Creating a table
To improve useability and functionality, Hive 3 significantly changed table creation.
Escaping db.table references
You need to change queries that use db.table references to prevent Hive from interpreting the entire db.table string as the table name.
Casting timestamps
Results of applications that cast numerics to timestamps differ from Hive 2 to Hive 3. Apache Hive changed the behavior of CAST to comply with the SQL Standard, which does not associate a time zone with the TIMESTAMP type.
Renaming tables
To harden the system, Hive data can be stored in HDFS encryption zones. RENAME has been changed to prevent moving a table outside the same encryption zone or into a no-encryption zone.
Checking compatibility of column changes
A default configuration change can cause applications that change column types to fail.
Dropping partitions
The OFFLINE and NO_DROP keywords in the CASCADE clause for dropping partitions causes performance problems and is no longer supported.

Parent topic: Apache Hive 3 upgrade process

© 2012–2019, Hortonworks, Inc.

Document licensed under the Creative Commons Attribution ShareAlike 4.0 License.

Hortonworks.com | Documentation | Support | Community