[ https://issues.apache.org/jira/browse/TRAFODION-1278?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15282860#comment-15282860 ]
liu ming commented on TRAFODION-1278: ------------------------------------- With latest build and test: >>create table testit like hive.hive.item; *** ERROR[1010] The statement just entered is currently not supported. --- SQL operation failed with errors. >> So can we close this JIRA? > 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)