[HIVE-12218] Unable to create a like table for an hbase backed table

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.2.1
• Fix Version/s: 1.3.0, 2.0.0
• Component/s: Query Processor
• Assignee: Chaoyu Tang
• Reporter: Chaoyu Tang
• Created: 20/Oct/15 22:15
• Updated: 16/Feb/16 23:50
• Resolved: 21/Oct/15 21:44

Description

For an HBase backed table:

CREATE TABLE hbasetbl (key string, state string, country string, country_id int)
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES (
"hbase.columns.mapping" = "info:state,info:country,info:country_id"
);

Create its like table using query such as
create table hbasetbl_like like hbasetbl;

It fails with error:
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. org.apache.hadoop.hive.ql.metadata.HiveException: must specify an InputFormat class