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

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: any
• Component/s: db-utility-odb
• Assignee: Unassigned
• Reporter: pengpeng.yang
• Created: 28/Jun/17 02:13
• Updated: 23/Oct/17 08:45

Description

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.