[ https://issues.apache.org/jira/browse/TRAFODION-2103?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
liu ming updated TRAFODION-2103: -------------------------------- Assignee: zhangliang > Load data with " as sp and " as fs in linux failed > -------------------------------------------------- > > Key: TRAFODION-2103 > URL: https://issues.apache.org/jira/browse/TRAFODION-2103 > Project: Apache Trafodion > Issue Type: Bug > Components: db-utility-odb > Environment: centos6.7 > HBase 1.0.0 - cdh 5.4.8 > Reporter: zhangliang > Assignee: zhangliang > Priority: Trivial > > load data with " as sp and " as fs failed. > It is because the sp of first colume and the fs of second one matched, and > odb consider it is colume 2 and is a null string, meawhile, the table define > that colume 2 cannot be null. > logs here: > Usecase : load with " as sp > Command : ./odb64luo -u trafodion -p traf123 -d traf -l > src=odb_auto_loadfile/load_data_11:pre=@scripts/ddl_person3.sql:tgt=trafodion.odb_test.person3:max=1000:rows=5000:parallel=5:loadcmd=UL:fs=\":sq=\" > Result : failed > During : 36s > Details : > odb [2016-07-07 16:50:16]: 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 16.653s (prep 0.002s, exec 16.651s, 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.435s (prep 0.002s, exec 1.433s, fetch > 0.000s/0.000s) > Connected to Trafodion > [1] odb [Oloadbuff(9438)] - Error loading row 1 (State: 23000, Native 0) > [Trafodion ODBC Driver] GENERAL ERROR. Null Value in a non nullable column. > Row: 1 Column: 2 > >>> 1""Liang"""Yu"""Japan"""Beijing > [1] odb [Oloadbuff(9438)] - Error loading row 1 (State: 23000, Native 0) > [Trafodion ODBC Driver] GENERAL ERROR. Null Value in a non nullable column. > Row: 1 Column: 4 > >>> 1""Liang"""Yu"""Japan"""Beijing > [1] odb [Oloadbuff(9438)] - Error loading row 1 (State: 23000, Native 0) > [Trafodion ODBC Driver] GENERAL ERROR. Null Value in a non nullable column. > Row: 1 Column: 5 > >>> 1""Liang"""Yu"""Japan"""Beijing > [1] odb [Oloadbuff(9438)] - Error loading row 1 (State: 23000, Native 0) > [Trafodion ODBC Driver] GENERAL ERROR. Null Value in a non nullable column. > Row: 1 Column: 7 > >>> 1""Liang"""Yu"""Japan"""Beijing > ... > [1] 0 records inserted [commit] > [0] odb version 1.1.0 Load statistics: > [0] Target table: TRAFODION.ODB_TEST.PERSON3 > [0] Source: odb_auto_loadfile/load_data_11 > [0] Pre-loading time: 21.300 s (00:00:21.300) > [0] Loading time: 15.028 s(00:00:15.028) > [0] Total records read: 1,000 > [0] Total records inserted: 0 > [0] Total number of columns: 12 > [0] Total bytes read: 262,144 > [0] Average input row size: 262.1 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): 17.035 KiB/s > [0] Load throughput (ODBC): 0.000 KiB/s > [0] Reader Total/Wait Cycles: 1/0 > odb [2016-07-07 16:50:52]: exiting. Session Elapsed time 36.339 seconds > (00:00:36.339) -- This message was sent by Atlassian JIRA (v6.3.4#6332)