KB423415: Known limitations when using MicroStrategy 9.x with Hive 0.5x

Listed below are the known missing features in HiveQL and server related limitations with Hive 0.5x. HiveQL stands for Hive Query Language which is similar to SQL and allows users that are familiar with SQL to query data from Hive.
 
Known missing features in HiveQL:

• Support of sub-queries (EXISTS/IN clause). A workaround for implementing sub-queries is to modify the SQL to use LEFT SEMI JOIN. The LEFT SEMI JOIN syntax is currently not supported by Strategy when creating reports.
• Support for INSERT INTO TABLE VALUES (...)
• Support for INSERT INTO TABLE using SELECT..., FROM...
• Support for UNION ALL queries without the extra (SELECT *)
• Support for HAVING clause
• Support for BETWEEN
• Support for ORDER BY ordinal

Hive server related limitations:
 
By default, the Hive server is not threadsafe. Simultaneous connections to the same Hive server are not possible. Therefore, Hive in embedded mode has a limitation of 1 active user at a time. Following are two recommendations for this issue:

• Spawn multiple Hive servers.
• Run Derby as a Network Server thereby allowing multiple users to access it simultaneously from different system.

Further reading:

• KB33853: How to configure Strategy 9.0.0-9.0.2 products to work with Hive/Hadoop database platform
• KB33856: How to configure the Hive ODBC driver on Linux for connectivity to a Hive database

Third Party Software Installation WARNING
The third-party product(s) discussed in this technical note is manufactured by vendors independent of Strategy. Strategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability.