[
https://issues.apache.org/jira/browse/TRAFODION-2937?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
苏锦佩 reassigned TRAFODION-2937:
------------------------------
Assignee: 苏锦佩
> the actual copied data is less than expected when copying data from MySQL to
> Trafodion
> --------------------------------------------------------------------------------------
>
> Key: TRAFODION-2937
> URL: https://issues.apache.org/jira/browse/TRAFODION-2937
> Project: Apache Trafodion
> Issue Type: Bug
> Components: db-utility-odb
> Reporter: 苏锦佩
> Assignee: 苏锦佩
> Priority: Major
>
> C:\Users\pengpeng.yang\Desktop\odb>odb.exe -u odb:trafodion -p odb:traf123 -d
> mysql:traf -cp
> src=odb_copy_customer4:tgt=TRAFODION.ODB_COPY.mysql_copy_customer4:pwhere="ID>5":splitby=ID:parallel=1:loadcmd=UL
> Connected to MySQL
> odb [2017-10-30 17:22:13]: starting ODBC connection(s)... 0 >1 >2
> Connected to Trafodion
> [1] 4 records copied [commit]
> [0] odb version 1.1.0 Copy statistics:
> [0] Source: ODB_COPY_CUSTOMER4
> [0] Target: TRAFODION.ODB_COPY.mysql_copy_customer4
> [0] Total number of columns: 2
> [0] ODBC row size: 44 B (data) + 16 B (len ind)
> [0] Rowset size: 100
> [0] Rowset buffer size: 5.86 KiB
> [0] Pre-copy time: 3.212 s (00:00:03.212)
> [0] Copy time: 0.119 s (00:00:00.119)
> [0] Total records copied: 4 (0.034 krec/s)
> [0] Copy throughput (ODBC): 0.001 MiB/s (0.005 GiB/h)
> [0] Total/Wait cycles: 1/0
> [0>1] 4 records copied in 0.119 (00:00:00.119 s)
> [0>2] 0 records copied in 0.000 (00:00:00.000 s)
> odb [2017-10-30 17:22:17]: exiting. Session Elapsed time 3.348 seconds
> (00:00:03.348)
> C:\Users\pengpeng.yang\Desktop\odb>
> ODB_COPY_CUSTOMER4 ddl and dml:
> create table odb_copy_customer4(id int, name varchar(32));
> insert into odb_copy_customer4 values (1, 'hadoop');
> insert into odb_copy_customer4 values (2, 'hive');
> insert into odb_copy_customer4 values (3, 'hdfs');
> insert into odb_copy_customer4 values (4, 'yarn');
> insert into odb_copy_customer4 values (5, 'sentry');
> insert into odb_copy_customer4 values (6, 'oozie');
> insert into odb_copy_customer4 values (7, 'zakaban');
> insert into odb_copy_customer4 values (8, 'sqoop');
> insert into odb_copy_customer4 values (9, 'spark');
> insert into odb_copy_customer4 values (10, 'flume')
> TRAFODION.ODB_COPY.mysql_copy_customer4 ddl:
> CREATE TABLE TRAFODION.ODB_COPY.MYSQL_COPY_CUSTOMER4
> (
> 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)
