[TRAFODION-1278] LP Bug: 1465899 - Create table LIKE hive table fails silently

• Type: Bug
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Component/s: sql-general
• External issue URL: https://bugs.launchpad.net/bugs/1465899
• Assignee: Qifan Chen
• Reporter: Barry Fritchman
• Created: 22/Jul/15 18:20
• Updated: 06/Mar/18 16:18

Description

When using the CREATE TABLE <tbl1> LIKE <tbl2> syntax with a hive table as <tbl2>, the statement appears to execute successfully, but the table is in fact not created:

>>create table traf_orders like hive.hive.orders;

— SQL operation complete.
>>invoke traf_orders;

• • • ERROR[4082] Object TRAFODION.SEABASE.TRAF_ORDERS does not exist or is inaccessible.

— SQL operation failed with errors.
>>

The problem seems to occur only when a Hive table is the source. This problem causes an error when attempting to update statistics for a hive table using sampling, because the sample table is not created.