[jira] [Created] (TRAFODION-2939) odb copied data exceeds the max size specified by max option when copying data from oracle to Trafodion

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

苏锦佩 created TRAFODION-2939:
------------------------------

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


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)