[
https://issues.apache.org/jira/browse/SQOOP-1096?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
thomastechs updated SQOOP-1096:
-------------------------------
Description:
To reproduce this error, execute the sqoop query connecting to DB2 with the
option WITH UR and number of mappers > 1 and a split by column:
{code:title=Sample query|borderStyle=solid}
sqoop import --connect jdbc:db2://<host>/hadoopguide --username <uname>
--password <password> --query 'SELECT A_I,B_I,C_I,D_I FROM A where $CONDITIONS
WITH UR' --split-by A_I -m 8 --target-dir /user/sample/test_with_ur;
{code}
was:
To reproduce this error, execute the sqoop query connecting to DB2 with the
option WITH UR and number of mappers > 1
> Sqoop generates boundary queries with synatx error, when the number of
> mappers is greater than 1 and there is WITH UR option in the query for DB2
> -------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: SQOOP-1096
> URL: https://issues.apache.org/jira/browse/SQOOP-1096
> Project: Sqoop
> Issue Type: Bug
> Components: build, connectors/generic
> Affects Versions: 1.4.2
> Reporter: thomastechs
> Labels: sqoop
>
> To reproduce this error, execute the sqoop query connecting to DB2 with the
> option WITH UR and number of mappers > 1 and a split by column:
> {code:title=Sample query|borderStyle=solid}
> sqoop import --connect jdbc:db2://<host>/hadoopguide --username <uname>
> --password <password> --query 'SELECT A_I,B_I,C_I,D_I FROM A where
> $CONDITIONS WITH UR' --split-by A_I -m 8 --target-dir
> /user/sample/test_with_ur;
> {code}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
