[
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)
