You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@trafodion.apache.org by "Alice Chen (JIRA)" <ji...@apache.org> on 2015/07/22 20:21:08 UTC

[jira] [Created] (TRAFODION-1278) LP Bug: 1465899 - Create table LIKE hive table fails silently

Alice Chen created TRAFODION-1278:
-------------------------------------

             Summary: LP Bug: 1465899 - Create table LIKE hive table fails silently
                 Key: TRAFODION-1278
                 URL: https://issues.apache.org/jira/browse/TRAFODION-1278
             Project: Apache Trafodion
          Issue Type: Bug
            Reporter: Barry Fritchman
            Priority: Critical
             Fix For: 2.0-incubating


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.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)