[jira] [Created] (TRAFODION-2034) Cannot output bad records in the loaded file even if specified file for storing bad records

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

zhangliang created TRAFODION-2034:
-------------------------------------

             Summary: Cannot output bad records in the loaded file even if specified file for storing bad records
                 Key: TRAFODION-2034
                 URL: https://issues.apache.org/jira/browse/TRAFODION-2034
             Project: Apache Trafodion
          Issue Type: Bug
          Components: db-utility-odb
         Environment: centos6.7 HBase 1.0.0-cdh5.4.8
            Reporter: zhangliang
            Priority: Minor


This issue is from mantis 330.
Load file where is bad record in it, with option bad=output_data/bad_records to hold the bad records, but the result is the file output_data/bad_records generated but it is empty lines.

[root@suse-1 odb_test]# ./odb64luo -u trafodion -p traf123 -d traf -l src=output_data/ext_person3.csv:pre=@scripts/ddl_person3.sql:tgt=trafodion.odb_test.person3:max=1000:rows=5000:parallel=5:loadcmd=UL:fs=\|:sq=\":bad=output_data/bad_records
odb [2016-04-25 19:17:05]: starting ODBC connection(s)... 0 1 2 3 4 5
[0.0.0]Executing: 'drop table TRAFODION.odb_test.person3;'
[0.0.0]--- command executed in 7.279s (prep 0.001s, exec 7.278s, fetch 0.000s/0.000s)
[0.0.1]Executing: 'CREATE TABLE TRAFODION.odb_test."PERSON3" (
PID BIGINT SIGNED NOT NULL
,FNAME CHAR(20) NOT NULL
,LNAME CHAR(20) NOT NULL
,COUNTRY VARCHAR(40) NOT NULL
,CITY VARCHAR(40) NOT NULL
,BDATE DATE NOT NULL
,SEX CHAR(1) NOT NULL
,EMAIL VARCHAR(40) NOT NULL
,SALARY NUMERIC(9,2) NOT NULL
,EMPL VARCHAR(40) NOT NULL
,NOTES VARCHAR(80)
,LOADTS TIMESTAMP(0)
,PRIMARY KEY (PID)
);'
[0.0.1]--- command executed in 1.388s (prep 0.002s, exec 1.386s, fetch 0.000s/0.000s)
Connected to Trafodion
[1] odb [Oloadbuff(9438)] - Error loading row 5 (State: 23000, Native 0)
[Trafodion ODBC Driver] GENERAL ERROR. Null Value in a non nullable column. Row: 5 Column: 1
[1] 999 records inserted [commit]
[0] odb version 1.1.0 Load statistics:
        [0] Target table: TRAFODION.ODB_TEST.PERSON3
        [0] Source: output_data/ext_person3.csv
        [0] Pre-loading time: 10.920 s (00:00:10.920)
        [0] Loading time: 0.127 s(00:00:00.127)
        [0] Total records read: 1,000
        [0] Total records inserted: 999
        [0] Total number of columns: 12
        [0] Total bytes read: 180,517
        [0] Average input row size: 180.5 B
        [0] ODBC row size: 341 B (data) + 96 B (len ind)
        [0] Rowset size: 1,000
        [0] Rowset buffer size: 426.76 KiB
        [0] Load throughput (real data): 1,388.080 KiB/s
        [0] Load throughput (ODBC): 2,619.487 KiB/s
        [0] Reader Total/Wait Cycles: 1/0
odb [2016-04-25 19:17:16]: exiting. Session Elapsed time 11.060 seconds (00:00:11.060)


SQL>showddl person3;

 
CREATE TABLE TRAFODION.ODB_TEST.PERSON3
  (
    PID LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
      SERIALIZED
  , FNAME CHAR(20) CHARACTER SET ISO88591 COLLATE
      DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE SERIALIZED
  , LNAME CHAR(20) CHARACTER SET ISO88591 COLLATE
      DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE SERIALIZED
  , COUNTRY VARCHAR(40) CHARACTER SET ISO88591 COLLATE
      DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE SERIALIZED
  , CITY VARCHAR(40) CHARACTER SET ISO88591 COLLATE
      DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE SERIALIZED
  , BDATE DATE NO DEFAULT NOT NULL NOT DROPPABLE NOT
      SERIALIZED
  , SEX CHAR(1) CHARACTER SET ISO88591 COLLATE
      DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE SERIALIZED
  , EMAIL VARCHAR(40) CHARACTER SET ISO88591 COLLATE
      DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE SERIALIZED
  , SALARY NUMERIC(9, 2) NO DEFAULT NOT NULL NOT
      DROPPABLE SERIALIZED
  , EMPL VARCHAR(40) CHARACTER SET ISO88591 COLLATE
      DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE SERIALIZED
  , NOTES VARCHAR(80) CHARACTER SET ISO88591 COLLATE
      DEFAULT DEFAULT NULL SERIALIZED
  , LOADTS TIMESTAMP(0) DEFAULT NULL NOT SERIALIZED
  , PRIMARY KEY (PID ASC)
  )
;

--- SQL operation complete.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)