Hortonworks Docs
»
Hortonworks Data Platform 3.1.5
»
Apache Hive overview
Apache Hive overview
Also available as:
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
Creating a table
Escaping db.table references
Casting timestamps
Renaming tables
Checking compatibility of column changes
Dropping partitions
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