[
https://issues.apache.org/jira/browse/TRAFODION-2671?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
pengpeng.yang updated TRAFODION-2671:
-------------------------------------
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.
was:
When not setting "Threading=1" in odbcinst.ini, I find the rows for trafodion
table is less than expected at sometimes.
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.
> 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)
