You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Alice Chen (JIRA)" <ji...@apache.org> on 2015/07/22 20:20:34 UTC
[jira] [Created] (TRAFODION-1252) LP Bug: 1460717 - upsert using
load generator error when default values used
Alice Chen created TRAFODION-1252:
-------------------------------------
Summary: LP Bug: 1460717 - upsert using load generator error when default values used
Key: TRAFODION-1252
URL: https://issues.apache.org/jira/browse/TRAFODION-1252
Project: Apache Trafodion
Issue Type: Bug
Components: sql-cmp
Reporter: Suresh Subbiah
Assignee: Suresh Subbiah
Priority: Critical
Fix For: 2.0-incubating
upsert using load into BR_PHONE_T_PX(CITY_CODE, RES_ID, INST_ID, PHONE_NUMERIC, SERVICE_KIND, NUMERIC_TYPE, RESHOUSE_CODE, STOCK_STATUS, NO_COOP_FLAG, MAJOR_TYPE, BEFOREHAND_FEE, NUM_RULE_KIND, IF_VIRTUAL, IN_OPTION, OUT_OPTION) Values('910',11111111,11111111,'2',3,3,3,3,3,3,3,3,3,3,3);
gives this error
*** ERROR[7000] An internal error occurred in the code generator in file ../generator/Generator.cpp at line 1777:
ValueId 8 (TRAFODION.SEABASE.BR_PHONE_T_PX.BELONGS_TO...) not found in MapTable 0x7f678363a8b0. [2015-05-30 22:15:39]
*** ERROR[2235] Compiler Internal Error: An unknown error, originated from file ../generator/Generator.cpp at line 2142. [2015-05-30 22:15:39]
Issue has been worked around by providing the default value NULL explicitly in the values clause.
DDL is
CREATE TABLE TRAFODION.SEABASE.BR_PHONE_T_PX
(
CITY_CODE VARCHAR(8 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
, RES_ID NUMERIC(9, 0) NO DEFAULT NOT NULL NOT
DROPPABLE
, INST_ID NUMERIC(12, 0) NO DEFAULT NOT NULL NOT
DROPPABLE
, PHONE_NUMERIC VARCHAR(15 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
, SERVICE_KIND NUMERIC(4, 0) NO DEFAULT NOT NULL NOT
DROPPABLE
, NUMERIC_TYPE NUMERIC(2, 0) DEFAULT 0
, RESHOUSE_CODE NUMERIC(9, 0) DEFAULT NULL
, BELONGS_TO VARCHAR(30 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT NULL
, STOCK_STATUS NUMERIC(4, 0) NO DEFAULT NOT NULL NOT
DROPPABLE
, NO_COOP_FLAG NUMERIC(2, 0) DEFAULT 0
, USED_DATE TIMESTAMP(6) DEFAULT NULL
, OPERATE_DATE TIMESTAMP(6) DEFAULT NULL
, OPERATOR VARCHAR(64 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT NULL
, NOTE VARCHAR(60 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT NULL
, MAJOR_TYPE NUMERIC(1, 0) DEFAULT 0 NOT NULL NOT
DROPPABLE
, YIDI_ACCEPT NUMERIC(4, 0) DEFAULT NULL
, ADJUST_KIND NUMERIC(2, 0) DEFAULT NULL
, ADJUST_MONTHS NUMERIC(4, 0) DEFAULT NULL
, ADJUST_PERIOD NUMERIC(4, 0) DEFAULT NULL
, ADJUST_FEE NUMERIC(122, 0) DEFAULT NULL
, F_LEVEL NUMERIC(2, 0) DEFAULT NULL
, BEFOREHAND_FEE NUMERIC(122, 0) DEFAULT NULL
, NUM_RULE_KIND NUMERIC(8, 0) DEFAULT NULL
, IF_VIRTUAL NUMERIC(2, 0) DEFAULT NULL
, IN_OPTION NUMERIC(4, 0) DEFAULT NULL
, OUT_OPTION NUMERIC(4, 0) DEFAULT NULL
, PRIMARY KEY (INST_ID ASC, PHONE_NUMERIC ASC, CITY_CODE ASC, STOCK_STATUS
ASC)
)
SALT USING 2 PARTITIONS
ON (INST_ID)
;
CREATE INDEX BR_PHONE_BELONGS_I_PX ON TRAFODION.SEABASE.BR_PHONE_T_PX
(
BELONGS_TO ASC
, CITY_CODE ASC
)
HBASE_OPTIONS
(
DATA_BLOCK_ENCODING = 'FAST_DIFF',
COMPRESSION = 'GZ'
)
salt like table;
CREATE INDEX BR_PHONE_BLNGS_FLG_I_PX ON TRAFODION.SEABASE.BR_PHONE_T_PX
(
BELONGS_TO ASC
, CITY_CODE ASC
, STOCK_STATUS ASC
, NO_COOP_FLAG ASC
, IF_VIRTUAL ASC
)
HBASE_OPTIONS
(
DATA_BLOCK_ENCODING = 'FAST_DIFF',
COMPRESSION = 'GZ'
)
salt like table;
CREATE INDEX BR_PHONE_I_PX ON TRAFODION.SEABASE.BR_PHONE_T_PX
(
INST_ID ASC
)
HBASE_OPTIONS
(
DATA_BLOCK_ENCODING = 'FAST_DIFF',
COMPRESSION = 'GZ'
)
salt like table;
CREATE INDEX BR_PHONE_II_PX ON TRAFODION.SEABASE.BR_PHONE_T_PX
(
PHONE_NUMERIC ASC
)
HBASE_OPTIONS
(
DATA_BLOCK_ENCODING = 'FAST_DIFF',
COMPRESSION = 'GZ'
)
salt like table;
CREATE INDEX BR_PHONE_III_PX ON TRAFODION.SEABASE.BR_PHONE_T_PX
(
RESHOUSE_CODE ASC
, CITY_CODE ASC
)
HBASE_OPTIONS
(
DATA_BLOCK_ENCODING = 'FAST_DIFF',
COMPRESSION = 'GZ'
)
salt like table;
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)