Hortonworks Docs
»
»
Also available as:
Apache Hive Performance Tuning
Optimizing an Apache Hive data warehouse
LLAP ports
Preparations for tuning performance
Setting up LLAP
Enable YARN preemption
Enable interactive query
Set up multiple HiveServer Interactives for high availability
Configure an llap queue
Add a Hive proxy
Configure other LLAP properties
Configure the HiveServer heap size
Save LLAP settings and restart services
Run an interactive query
Use HiveServer Interactive UI
Connect a JDBC client to LLAP
Configuring YARN queues for Hive
Configure a queue for batch processing
Configure a custom LLAP queue
Set up multiple HiveServer instances
Key components of Hive warehouse processing
Query result cache and metastore cache
Tez execution engine properties
Monitoring Apache Hive performance
Monitoring LLAP resources
Maximizing storage resources using ORC
Advanced ORC properties
Improving performance using partitions
Handling bucketed tables
Improving performance using the cost-based optimizer
Set up the cost-based optimizer and statistics
Generate and view Apache Hive statistics
Statistics generation and viewing commands
Optimization and planning properties
© 2012-2019, Hortonworks, Inc.
Document licensed under the
Creative Commons Attribution ShareAlike 4.0 License
.
Hortonworks.com
|
Documentation
|
Support
|
Community
