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)
