Dear Wiki user, You have subscribed to a wiki page or wiki category on "Hadoop Wiki" for change notification.
The "Hive/HBaseIntegration" page has been changed by JohnSichi. http://wiki.apache.org/hadoop/Hive/HBaseIntegration?action=diff&rev1=13&rev2=14 -------------------------------------------------- == Illegal: Hive Primitive to HBase Column Family == - Table definitions such as the following should be avoided because a + Table definitions such as the following are illegal because a - Hive column mapped to a column family must have MAP type: + Hive column mapped to an entire column family must have MAP type: {{{ CREATE TABLE hbase_table_1(key int, value string) @@ -251, +251 @@ WITH SERDEPROPERTIES ( "hbase.columns.mapping" = "cf:" ); + FAILED: Error in metadata: java.lang.RuntimeException: MetaException(message:org.apache.hadoop.hive.serde2.SerDeException org.apache.hadoop.hive.hbase.HBaseSerDe: hbase column family 'cf:' should be mapped to map<string,?> but is mapped to string) }}} - Currently, the CREATE TABLE will succeed, but attempts to insert data - will fail with this internal error: - - {{{ - java.lang.RuntimeException: org.apache.hadoop.hive.serde2.lazy.objectinspector.primitive.LazyStringObjectInspector cannot be cast to org.apache.hadoop.hive.serde2.objectinspector.MapObjectInspector - }}} - - An improvement would be to catch this at CREATE TABLE time and reject - it as invalid. = Key Uniqueness =
