You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "zhangliang (JIRA)" <ji...@apache.org> on 2016/06/07 02:46:21 UTC
[jira] [Updated] (TRAFODION-2030) Copy data from Oracle to
Trafodion no data copied and no error occur
[ https://issues.apache.org/jira/browse/TRAFODION-2030?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
zhangliang updated TRAFODION-2030:
----------------------------------
Summary: Copy data from Oracle to Trafodion no data copied and no error occur (was: Copy data from Oracle to Trafodion no data copied and no error occuer )
> Copy data from Oracle to Trafodion no data copied and no error occur
> ---------------------------------------------------------------------
>
> Key: TRAFODION-2030
> URL: https://issues.apache.org/jira/browse/TRAFODION-2030
> Project: Apache Trafodion
> Issue Type: Bug
> Components: db-utility-odb
> Environment: centos 6.7 HBase 1.0.0-cdh5.4.8
> odb.exe on windows 7-64 bits
> Reporter: zhangliang
>
> 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 there 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)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)