You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "苏锦佩 (JIRA)" <ji...@apache.org> on 2018/01/31 08:19:00 UTC
[jira] [Assigned] (TRAFODION-2939) odb copied data exceeds the max
size specified by max option when copying data from oracle to Trafodion
[ https://issues.apache.org/jira/browse/TRAFODION-2939?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
苏锦佩 reassigned TRAFODION-2939:
------------------------------
Assignee: 苏锦佩
> odb copied data exceeds the max size specified by max option when copying data from oracle to Trafodion
> -------------------------------------------------------------------------------------------------------
>
> Key: TRAFODION-2939
> URL: https://issues.apache.org/jira/browse/TRAFODION-2939
> Project: Apache Trafodion
> Issue Type: Bug
> Reporter: 苏锦佩
> Assignee: 苏锦佩
> Priority: Major
>
> C:\Users\pengpeng.yang\Desktop>odb.exe -u odb:trafodion -p odb:traf123 -d oracle:traf -cp src=odb_copy_customer10:tgt=TRAFODION.ODB_COPY.oracle_copy_customer10:pwhere="ID>5":parallel=2:max=3:commit=auto:rows=5000:loadcmd=UL
> Connected to Oracle
> odb [2017-10-30 16:56:29]: starting ODBC connection(s)... 0 >1 >2 3 >4 >5
> Connected to Trafodion
> [4] 2 records copied [commit]
> [1] 3 records copied [commit]
> [0] odb version 1.1.0 Copy statistics:
> [0] Source: ODB_COPY_CUSTOMER10
> [0] Target: TRAFODION.ODB_COPY.oracle_copy_customer10
> [0] Total number of columns: 2
> [0] ODBC row size: 74 B (data) + 16 B (len ind)
> [0] Rowset size: 3
> [0] Rowset buffer size: 0.26 KiB
> [0] Pre-copy time: 4.111 s (00:00:04.111)
> [0] Copy time: 0.150 s (00:00:00.150)
> [0] Total records copied: 5 (0.033 krec/s)
> [0] Copy throughput (ODBC): 0.002 MiB/s (0.008 GiB/h)
> [0] Total/Wait cycles: 1/0
> [0>1] 3 records copied in 0.150 (00:00:00.150 s)
> [0>2] 0 records copied in 0.015 (00:00:00.015 s)
> [3] Total/Wait cycles: 1/0
> [3>4] 2 records copied in 0.135 (00:00:00.135 s)
> [3>5] 0 records copied in 0.015 (00:00:00.015 s)
> odb [2017-10-30 16:56:34]: exiting. Session Elapsed time 4.293 seconds (00:00:04.293)
> odb_copy_customer10 ddl and dml:
> create table odb_copy_customer10(id int, name varchar(32));
> insert into odb_copy_customer10 values (1, 'hadoop');
> insert into odb_copy_customer10 values (2, 'hive');
> insert into odb_copy_customer10 values (3, 'hdfs');
> insert into odb_copy_customer10 values (4, 'yarn');
> insert into odb_copy_customer10 values (5, 'sentry');
> insert into odb_copy_customer10 values (6, 'oozie');
> insert into odb_copy_customer10 values (7, 'zakaban');
> insert into odb_copy_customer10 values (8, 'sqoop');
> insert into odb_copy_customer10 values (9, 'spark');
> insert into odb_copy_customer10 values (10, 'flume');
> TRAFODION.ODB_COPY.oracle_copy_customer10 ddl:
> CREATE TABLE TRAFODION.ODB_COPY.ORACLE_COPY_CUSTOMER10
> (
> ID INT DEFAULT NULL NOT SERIALIZED
> , NAME VARCHAR(32) CHARACTER SET ISO88591 COLLATE
> DEFAULT DEFAULT NULL NOT SERIALIZED
> )
> ATTRIBUTES ALIGNED FORMAT NAMESPACE 'TRAF_1500000'
> ;
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)