Part 4: The Connect XE Drivers : The Driver for Apache Hive : Limitations on Apache Hive Functionality

Limitations on Apache Hive Functionality
The following restrictions are based on using Apache Hive 0.10.0:
For a more complete listing of Apache Hive known issues and limitations for your version of Hive, refer to the Apache Hive user documentation:
https://cwiki.apache.org/confluence/display/Hive/Home
Note that Apache Hive is not designed for OLTP workloads and does not offer real-time queries or row-level updates. Instead, Hive is designed for batch type jobs over large data sets with high latency. This means that queries such as "SELECT * FROM mytable" return quickly. However, other SELECT statements are much slower.
Because Apache HiveServer1 servers do not currently handle multiple connections well, consider using a single Apache HiveServer1 for each connection.

© 2013 Progress Software Corporation and/or its subsidiaries or affiliates.