[ https://issues.apache.org/jira/browse/HIVE-18202?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16338265#comment-16338265 ]
Aihua Xu commented on HIVE-18202: --------------------------------- [~ngangam] Seems we need to double quote the table name and columns for postgres. Sorry about that. Attached the addendum. > Automatically migrate hbase.table.name to > hbase.mapreduce.hfileoutputformat.table.name for hbase-based table > ------------------------------------------------------------------------------------------------------------ > > Key: HIVE-18202 > URL: https://issues.apache.org/jira/browse/HIVE-18202 > Project: Hive > Issue Type: Sub-task > Components: HBase Handler > Affects Versions: 3.0.0 > Reporter: Aihua Xu > Assignee: Aihua Xu > Priority: Major > Fix For: 3.0.0 > > Attachments: HIVE-18202.1.patch, HIVE-18202.patch.addendum > > > The property name for Hbase table mapping is changed from hbase.table.name to > hbase.mapreduce.hfileoutputformat.table.name in HBase 2. > We can include such upgrade for existing hbase-based tables in DB upgrade > script to automatically change such values. > For the new tables, the query will be like: > create table hbase_table(key int, val string) stored by > 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' with serdeproperties > ('hbase.columns.mapping' = ':key,cf:val') tblproperties > ('hbase.mapreduce.hfileoutputformat.table.name' = > 'positive_hbase_handler_bulk') -- This message was sent by Atlassian JIRA (v7.6.3#76005)