[HIVE-26015] CREATE HBase table fails when SERDEPROPERTIES contain special characters

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-2
• Labels: pull-request-available
• Assignee: Steve Carlin
• Reporter: Steve Carlin
• Created: 08/Mar/22 20:08
• Updated: 16/Nov/22 13:50
• Resolved: 22/Mar/22 21:39

Description

A Create table statement is failing for HBase going through Ranger.

The stack trace shows a problem with the getURIForAuth method.

The table is creating someting like this:

CREATE EXTERNAL TABLE `mytesttbl`( `field1` string COMMENT 'from deserializer',`field2` string COMMENT 'from deserializer',`field3` string COMMENT 'from deserializer',`field4` string COMMENT 'from deserializer',`field5` string COMMENT 'from deserializer',`field6` int COMMENT 'from deserializer', `field7` string COMMENT 'from deserializer', `field8` int COMMENT 'from deserializer') ROW FORMAT SERDE   'org.apache.hadoop.hive.hbase.HBaseSerDe' STORED BY    'org.apache.hadoop.hive.hbase.HBaseStorageHandler'  WITH SERDEPROPERTIES (   'hbase.columns.mapping'=':key,field1,field2,field3,field4,field5#b,field6,cf:field7#b','serialization.format'='1')  TBLPROPERTIES (   'hbase.table.name'='mytesttbl');

Essentially, the SERDEPROPERTIES contain hash tabs which is causing a problem when creating a URI

Issue Links

• is depended upon by: HIVE-26139 URL Encoding from HIVE-26015 was a bit too aggressive
• is related to: HIVE-26230 Option to URL encode special chars in hbase.column.mapping that are valid HBase column family chars
• links to: GitHub Pull Request #3084