[
https://issues.apache.org/jira/browse/TRAFODION-1278?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15284906#comment-15284906
]
Anoop Sharma commented on TRAFODION-1278:
-----------------------------------------
create like a hive table is not supported.
But one can do:
create table test_item no load as select * from hive.hive.item;
This will create a traf table like hive.hive.item but not load data into it.
One can also use 'primary key' clause during CTAS stmt to specify
pkey columns for the tgt table.
> 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)
