5.2. Known Issues for Hive

If hive.auto.convert.join=true, queries with MapJoin will fail with the following message:

FAILED: SemanticException [Error 10227]: Not all clauses are supported with mapjoin hint. Please remove mapjoin hint.

If this property is set to false, most queries (except for the union and union_all operations) will accept MapJoin hints.

If hive.auto.convert.join=true, for queries with union operations, it will result in the SemanticException error as shown above.

Hive ORC files currently do not work with HCatalog. For more details, see HCATALOG-632.

The Hive ORC file format in this Alpha release is NOT guaranteed to be compatible with future versions of Hive. A future version of Hive might not be able to read an ORC file created with the Hive version in this Alpha release.

There is no intent to provide upgraders to convert ORC files from this Alpha release to the format used in the future. Future compatibility of ORC file formats will be supported after Hive is formally released by Apache.

Queries with OVER and LEAD currently fail.

Queries with a window specification (ie. using ROWS BETWEEN or RANGE BETWEEN) might return incorrect results.

Queries with multiple ORDER BY columns in a window specification return incorrect results.

Some queries with an OVER clause might take a long time to execute.

Currently Windowing_Checkin_2 test fails.

For the OVER clause, some queries with GROUP BY, ORDER BY, and OVER clause produce incorrect results.

Currently Hive provides incorrect default window frame in queries like: select avg(a) over (partition by b order by c);.

The workaround is to rewrite the query as select avg(a) over (partition by b order by c rows unbounded preceding);.

This query is semantically equivalent and produces correct results. For more details, see HIVE-4190