[jira] [Commented] (TRAFODION-1503) Error 7001 can occur with an UPSERT when the source is from a HIVE table.

["Qifan Chen (JIRA)" <ji...@apache.org>]

    [ 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)