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

["Suresh Subbiah (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/TRAFODION-1278?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Suresh Subbiah updated TRAFODION-1278:
--------------------------------------
       Assignee: Qifan Chen
    Component/s: sql-general

> 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
>          Components: sql-general
>            Reporter: Barry Fritchman
>            Assignee: Qifan Chen
>            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)