[
https://issues.apache.org/jira/browse/TRAFODION-1278?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15282972#comment-15282972
]
Barry Fritchman commented on TRAFODION-1278:
--------------------------------------------
Yes, I think so. The primary problem was that no error was given even though
the statement failed, and that is no longer the case. Regarding the need for
this to work to support Update Statistics on Hive tables, I'm working on a
different approach that won't require it.
> 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)
