Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Duplicate
-
None
-
None
-
None
-
centos 6.7 HBase 1.0.0-cdh5.4.8
odb.exe on windows 7-64 bits
Description
Copy data from Oracle to Trafodion by odb.exe on windows using the command below:
odb.exe -u zale:trafodion -p 123456:traf123 -d orac:traf -cp src=test:tgt=trafodion.ODB_TEST.MYTEST:rows=m2:truncate:parallel=2 -T 6 -v
The oracle table test and trafodion table trafodion.ODB_TEST.MYTEST both exist and their formats are same. Also the table test has been inserted some data.
But no data copied and no error occuer.
Log:
C:\odb_test>odb.exe -u zale:trafodion -p 123456:traf123 -d orac:traf -cp src=test:tgt=trafodion.ODB_TEST.MYTEST:rows=m2:truncate:parallel=2 -T 6 -v
Connected to Oracle
odb [2016-05-30 17:34:05]: starting ODBC connection(s)... 0 >1 >2 3 >4 >5
Connected to Trafodion
odb: Now truncating target table (DELETE FROM trafodion.ODB_TEST.MYTEST)
NO data copyed , and no error occuer.
[1.0.0]--- 0 row(s) deleted in 0.161s (prep 0.071s, exec 0.090s, fetch 0.000s/0.000s)
[0] odb [Ocopy(10552)] - SOURCE statement: SELECT * FROM TEST WHERE MOD(ORA_HASH(ROWID), 2) = 0
[3] odb [Ocopy(10552)] - SOURCE statement: SELECT * FROM TEST WHERE MOD(ORA_HASH(ROWID), 2) = 1
[3] odb [Ocopy(10897)] - TARGET statement: INSERT INTO trafodion.ODB_TEST.MYTEST VALUES (?,?)
[0] odb [Ocopy(10897)] - TARGET statement: INSERT INTO trafodion.ODB_TEST.MYTEST VALUES (?,?)
odb: thread 4 closing connection...
odb: thread 5 closing connection...
odb: thread 3 closing connection...
odb: thread 3 is ending...
odb: thread 4 is ending...
odb: thread 5 is ending...
odb: thread 2 closing connection...
[0] odb version 1.1.0 Copy statistics:
[0] Source: TEST
[0] Target: trafodion.ODB_TEST.MYTEST
odb: thread 1 closing connection...
[0] Total number of columns: 2
[0] ODBC row size: 297 B (data) + 16 B (len ind)
[0] Rowset size: 6,700
[0] Rowset buffer size: 2,047.95 KiB
[0] Pre-copy time: 3.285 s (00:00:03.285)
[0] Copy time: 0.001 s (00:00:00.001)
[0] Total records copied: 0 (0.000 krec/s)
[0] Copy throughput (ODBC): 0.000 MiB/s (0.000 GiB/h)
[0] Total/Wait cycles: 0/0
[0>1] 0 records copied in 0.001 (00:00:00.001 s)
[0>2] 0 records copied in 0.001 (00:00:00.001 s)
[3] Total/Wait cycles: 0/0
[3>4] 0 records copied in 0.001 (00:00:00.001 s)
[3>5] 0 records copied in 0.001 (00:00:00.001 s)
odb: thread 0 closing connection...
odb: thread 0 is ending...
odb: thread 1 is ending...
odb: thread 2 is ending...
odb [2016-05-30 17:34:09]: exiting. Session Elapsed time 3.365 seconds (00:00:03.365)