[
https://issues.apache.org/jira/browse/TRAFODION-1503?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14941577#comment-14941577
]
Qifan Chen commented on TRAFODION-1503:
---------------------------------------
The fix is to properly rewind ComDiags area within
NATable::fetchObjectUIDForNativeTable() and NATable::lookupObjectUid(), when
hitting error 1389.
> Error 7001 can occur with an UPSERT when the source is from a HIVE table.
> -------------------------------------------------------------------------
>
> Key: TRAFODION-1503
> URL: https://issues.apache.org/jira/browse/TRAFODION-1503
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp
> Affects Versions: 1.2-incubating
> Reporter: Qifan Chen
> Assignee: Qifan Chen
>
> Error 7001 can occur with an UPSERT when the source is from a HIVE table and
> there is no stats created for the TRAF table.
> >>upsert into T select * from hive.hive.T;
> *** ERROR[7001] Default value 0 is not valid for column
> TRAFODION.IR.T.SITETYPE_ID.
> *** ERROR[8822] The statement was not prepared.
> DDL for TRAF:
> CREATE TABLE T(
> Site_ID int default 0 NOT NULL,
> SiteType_ID int default 0 NOT NULL,
> CONSTRAINT PK_IMI_Site PRIMARY KEY (Site_Id));
> DDL for HIVE:
> CREATE external TABLE T(
> Site_ID int ,
> SiteType_ID int )
> row format delimited fields terminated by '\t'
> location '/hive/ir/T';
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
