[jira] [Commented] (TRAFODION-2671) when I copy data from oracle table to trafodion table, the rows for trafodion table is less than expected.

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

    [ https://issues.apache.org/jira/browse/TRAFODION-2671?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16214826#comment-16214826 ] 

苏锦佩 commented on TRAFODION-2671:
--------------------------------

I tried to reproduce this issue, but it seems can't be reproduced in the latest version of odb.

> when I copy data from oracle table to trafodion table, the rows for trafodion table is less than expected.
> ----------------------------------------------------------------------------------------------------------
>
>                 Key: TRAFODION-2671
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-2671
>             Project: Apache Trafodion
>          Issue Type: Bug
>          Components: db-utility-odb
>    Affects Versions: any
>            Reporter: pengpeng.yang
>
> When not setting "Threading=1" in odbcinst.ini, I find the rows for trafodion table is less than expected at sometimes. Howerver I set  "Threading=1" in odbcinst.ini， the result for trafodion table is normal.
> Example
> odb64luo -u oracle_username:trafodion_username -p oracle_passwd:trafodion_passwd -d oracle_schema:trafodion_schema -cp src=CUSTOMER_ADDRESS:tgt=TRAFODION.ODB_COPY.CUSTOMER_ADDRESS_4:pwhere='CA_ADDRESS_SK>100000':parallel=4 -v
> When I set parallel=4, the rows for trafodion table is less than expected.And missing 100 rows for my test.
> However when I set parallel=2, the rows for trafodion table is normal.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)