Details
-
Bug
-
Status: Closed
-
Trivial
-
Resolution: Won't Fix
-
None
-
None
-
None
-
centos6.7
HBase 1.0.0 - cdh 5.4.8
Description
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)