This is the documentation for CDH 4.6.0.
Documentation for other versions is available at Cloudera Documentation.

Apache Hive

— HBaseStorageHandler does not work with HBase 0.92

When integrating HBase with Hive, currently HBase handler works with HBase 0.89, but does not work with HBase 0.92

Bug: HIVE-2077

Severity: Medium

Resolution: Fixed in CDH4 Beta 2

Workaround: Use HBase 0.8.

— Predicate Selection returns NULL on Union Views.

When doing predicate selection over a view, which is defined as a union of tables, NULL is returned.

Bug: HIVE-2783

Severity: Medium

Resolution: Fixed in CDH4 Beta 2

Workaround: Do not use Union Views, instead union the results of predicate selection over tables.

— Executing a query with a "TABLESAMPLE(x percent)" clause generates a NPE

A NullPointerException is generated when executing a query with a "TABLESAMPLE(x percent)" clause.

Bug: HIVE-2784

Severity: Medium

Resolution: Fixed in CDH4 Beta 2

Workaround: None.

— Grouping on constant expressions produces NULL results.

Grouping on table column names works, while Grouping on constant expressions produces NULL results.

The following query works:

FROM src SELECT src.key, count(src.value) GROUP BY src.key;

While the following query produces NULL results:

FROM src SELECT 10 GROUP BY 10;

Bug: HIVE-2790

Severity: Medium

Resolution: Fixed in CDH4 Beta 2

Workaround: None.