[jira] [Created] (TRAFODION-2937) the actual copied data is less than expected when copying data from MySQL to Trafodion

["苏锦佩 (JIRA)" <ji...@apache.org>]

苏锦佩 created TRAFODION-2937:
------------------------------

             Summary: 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: 苏锦佩


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)