[HIVE-16883] HBaseStorageHandler Ignores Case for HBase Table Name

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 1.2.1
• Component/s: HBase Handler

Environment

Hortonworks HDP 2.6.0.3, CentOS 7.0, VMWare ESXI

• Assignee: Bing Li
• Reporter: Shawn Weeks
• Created: 12/Jun/17 10:39
• Updated: 05/Jul/17 15:16

Description

Currently the HBaseStorageHandler is lower casing the HBase Table name. This prevent use of the storage handler with existing HBase tables that are not all lower case. Looking at the source this was done intentionally but I haven't found any documentation about why on the wiki. To prevent a change in the default behavior I'd suggest adding an additional property to the serde.

create 'TestTable', 'd'

create external table `TestTable` (
    id bigint,
    hash String,
    location String,
    name String
    )
    stored by "org.apache.hadoop.hive.hbase.HBaseStorageHandler"
    with serdeproperties (
        "hbase.columns.mapping" = ":key,d:hash,d:location,d:name",
        "hbase.table.name" = "TestTable"
        );