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

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

Qifan Chen created TRAFODION-1503:
-------------------------------------

             Summary: 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


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)