[
https://issues.apache.org/jira/browse/SQOOP-602?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13454924#comment-13454924
]
Sudhakar Vankamamidi edited comment on SQOOP-602 at 9/14/12 1:45 AM:
---------------------------------------------------------------------
1. Sqoop version sqoop-1.4.2.bin__hadoop-2.0.0-alpha
2. Connector type Progress Database
3. sh sqoop import --driver com.ddtek.jdbc.openedge.OpenEdgeDriver --connect
"jdbc:datadirect:openedge://kan.ironmountain.com:xxxxx;databaseName=sox"
--query "select * from table where \$CONDITIONS" -m 18 --split-by \"MY-COL\"
--target-dir /user
12/09/13 10:04:35 INFO mapred.LocalJobRunner: OutputCommitter set in config null
12/09/13 10:04:35 INFO mapred.JobClient: Running job: job_local_0001
12/09/13 10:04:35 INFO mapred.LocalJobRunner: OutputCommitter is
org.apache.hadoop.mapreduce.lib.output.FileOutputCommitter
12/09/13 10:04:35 WARN mapreduce.Counters: Group
org.apache.hadoop.mapred.Task$Counter is deprecated. Use
org.apache.hadoop.mapreduce.TaskCounter instead
12/09/13 10:04:35 INFO util.ProcessTree: setsid exited with exit code 0
12/09/13 10:04:35 INFO mapred.Task: Using ResourceCalculatorPlugin :
org.apache.hadoop.util.LinuxResourceCalculatorPlugin@60dc4c81
query2 select * from pub.box where ( MY-COL >= ' 2751 11' ) AND ( MY-COL < '
2751' )
java.sql.SQLException: [DataDirect][OpenEdge JDBC Driver][OpenEdge] Column "MY"
cannot be found or is not specified for query. (13865)
12/09/13 10:04:35 ERROR db.DBRecordReader: Top level exception:
java.sql.SQLException: [DataDirect][OpenEdge JDBC Driver][OpenEdge] Column "MY"
cannot be found or is not specified for query. (13865)
at
com.ddtek.jdbc.openedge.client.OpenEdgeClientRequest.prepareProcessReply(Unknown
Source)
at com.ddtek.jdbc.openedge.client.OpenEdgeClientRequest.prepare(Unknown
Source)
at com.ddtek.jdbc.openedge.OpenEdgeImplStatement.prepare(Unknown Source)
at com.ddtek.jdbc.base.BaseImplStatement.prepare(Unknown Source)
at com.ddtek.jdbc.base.BasePreparedStatement.prepareSQL(Unknown Source)
at com.ddtek.jdbc.base.BaseStatement.preProcessSQL(Unknown Source)
at com.ddtek.jdbc.base.BasePreparedStatement.<init>(Unknown Source)
at com.ddtek.jdbc.base.BaseConnection.prepareStatement(Unknown Source)
at
org.apache.sqoop.mapreduce.db.DBRecordReader.executeQuery(DBRecordReader.java:102)
at
org.apache.sqoop.mapreduce.db.DBRecordReader.nextKeyValue(DBRecordReader.java:239)
at
org.apache.hadoop.mapred.MapTask$NewTrackingRecordReader.nextKeyValue(MapTask.java:458)
at
org.apache.hadoop.mapreduce.task.MapContextImpl.nextKeyValue(MapContextImpl.java:76)
at
org.apache.hadoop.mapreduce.lib.map.WrappedMapper$Context.nextKeyValue(WrappedMapper.java:85)
at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:139)
at
org.apache.sqoop.mapreduce.AutoProgressMapper.run(AutoProgressMapper.java:182)
at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:645)
at org.apache.hadoop.mapred.MapTask.run(MapTask.java:325)
at
org.apache.hadoop.mapred.LocalJobRunner$Job.run(LocalJobRunner.java:263)
12/09/13 10:04:35 INFO mapreduce.AutoProgressMapper: Auto-progress thread is
finished. keepGoing=false
12/09/13 10:04:35 WARN mapred.LocalJobRunner: job_local_0001
java.io.IOException: SQLException in nextKeyValue
at
org.apache.sqoop.mapreduce.db.DBRecordReader.nextKeyValue(DBRecordReader.java:269)
at
org.apache.hadoop.mapred.MapTask$NewTrackingRecordReader.nextKeyValue(MapTask.java:458)
at
org.apache.hadoop.mapreduce.task.MapContextImpl.nextKeyValue(MapContextImpl.java:76)
at
org.apache.hadoop.mapreduce.lib.map.WrappedMapper$Context.nextKeyValue(WrappedMapper.java:85)
at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:139)
at
org.apache.sqoop.mapreduce.AutoProgressMapper.run(AutoProgressMapper.java:182)
at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:645)
at org.apache.hadoop.mapred.MapTask.run(MapTask.java:325)
at
org.apache.hadoop.mapred.LocalJobRunner$Job.run(LocalJobRunner.java:263)
Caused by: java.sql.SQLException: [DataDirect][OpenEdge JDBC Driver][OpenEdge]
Column "MY" cannot be found or is not specified for query. (13865)
at
com.ddtek.jdbc.openedge.client.OpenEdgeClientRequest.prepareProcessReply(Unknown
Source)
at com.ddtek.jdbc.openedge.client.OpenEdgeClientRequest.prepare(Unknown
Source)
at com.ddtek.jdbc.openedge.OpenEdgeImplStatement.prepare(Unknown Source)
at com.ddtek.jdbc.base.BaseImplStatement.prepare(Unknown Source)
at com.ddtek.jdbc.base.BasePreparedStatement.prepareSQL(Unknown Source)
at com.ddtek.jdbc.base.BaseStatement.preProcessSQL(Unknown Source)
at com.ddtek.jdbc.base.BasePreparedStatement.<init>(Unknown Source)
at com.ddtek.jdbc.base.BaseConnection.prepareStatement(Unknown Source)
at
org.apache.sqoop.mapreduce.db.DBRecordReader.executeQuery(DBRecordReader.java:102)
at
org.apache.sqoop.mapreduce.db.DBRecordReader.nextKeyValue(DBRecordReader.java:239)
... 8 more
was (Author: svankamamidi):
1. Sqoop version sqoop-1.4.2.bin__hadoop-2.0.0-alpha
2. Connector type Progress Database
3. sh sqoop import --driver com.ddtek.jdbc.openedge.OpenEdgeDriver --connect
"jdbc:datadirect:openedge://kan.ironmountain.com:xxxxx;databaseName=sox"
--query "select * from table where \$CONDITIONS" -m 18 --split-by \"MY-COL\"
--target-dir /user
12/09/13 10:04:35 INFO mapred.LocalJobRunner: OutputCommitter set in config null
12/09/13 10:04:35 INFO mapred.JobClient: Running job: job_local_0001
12/09/13 10:04:35 INFO mapred.LocalJobRunner: OutputCommitter is
org.apache.hadoop.mapreduce.lib.output.FileOutputCommitter
12/09/13 10:04:35 WARN mapreduce.Counters: Group
org.apache.hadoop.mapred.Task$Counter is deprecated. Use
org.apache.hadoop.mapreduce.TaskCounter instead
12/09/13 10:04:35 INFO util.ProcessTree: setsid exited with exit code 0
12/09/13 10:04:35 INFO mapred.Task: Using ResourceCalculatorPlugin :
org.apache.hadoop.util.LinuxResourceCalculatorPlugin@60dc4c81
query2 select * from pub.box where ( BX-PLUSID >= ' 2751 11' ) AND (
BX-PLUSID < ' 2751' )
java.sql.SQLException: [DataDirect][OpenEdge JDBC Driver][OpenEdge] Column "BX"
cannot be found or is not specified for query. (13865)
12/09/13 10:04:35 ERROR db.DBRecordReader: Top level exception:
java.sql.SQLException: [DataDirect][OpenEdge JDBC Driver][OpenEdge] Column "BX"
cannot be found or is not specified for query. (13865)
at
com.ddtek.jdbc.openedge.client.OpenEdgeClientRequest.prepareProcessReply(Unknown
Source)
at com.ddtek.jdbc.openedge.client.OpenEdgeClientRequest.prepare(Unknown
Source)
at com.ddtek.jdbc.openedge.OpenEdgeImplStatement.prepare(Unknown Source)
at com.ddtek.jdbc.base.BaseImplStatement.prepare(Unknown Source)
at com.ddtek.jdbc.base.BasePreparedStatement.prepareSQL(Unknown Source)
at com.ddtek.jdbc.base.BaseStatement.preProcessSQL(Unknown Source)
at com.ddtek.jdbc.base.BasePreparedStatement.<init>(Unknown Source)
at com.ddtek.jdbc.base.BaseConnection.prepareStatement(Unknown Source)
at
org.apache.sqoop.mapreduce.db.DBRecordReader.executeQuery(DBRecordReader.java:102)
at
org.apache.sqoop.mapreduce.db.DBRecordReader.nextKeyValue(DBRecordReader.java:239)
at
org.apache.hadoop.mapred.MapTask$NewTrackingRecordReader.nextKeyValue(MapTask.java:458)
at
org.apache.hadoop.mapreduce.task.MapContextImpl.nextKeyValue(MapContextImpl.java:76)
at
org.apache.hadoop.mapreduce.lib.map.WrappedMapper$Context.nextKeyValue(WrappedMapper.java:85)
at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:139)
at
org.apache.sqoop.mapreduce.AutoProgressMapper.run(AutoProgressMapper.java:182)
at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:645)
at org.apache.hadoop.mapred.MapTask.run(MapTask.java:325)
at
org.apache.hadoop.mapred.LocalJobRunner$Job.run(LocalJobRunner.java:263)
12/09/13 10:04:35 INFO mapreduce.AutoProgressMapper: Auto-progress thread is
finished. keepGoing=false
12/09/13 10:04:35 WARN mapred.LocalJobRunner: job_local_0001
java.io.IOException: SQLException in nextKeyValue
at
org.apache.sqoop.mapreduce.db.DBRecordReader.nextKeyValue(DBRecordReader.java:269)
at
org.apache.hadoop.mapred.MapTask$NewTrackingRecordReader.nextKeyValue(MapTask.java:458)
at
org.apache.hadoop.mapreduce.task.MapContextImpl.nextKeyValue(MapContextImpl.java:76)
at
org.apache.hadoop.mapreduce.lib.map.WrappedMapper$Context.nextKeyValue(WrappedMapper.java:85)
at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:139)
at
org.apache.sqoop.mapreduce.AutoProgressMapper.run(AutoProgressMapper.java:182)
at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:645)
at org.apache.hadoop.mapred.MapTask.run(MapTask.java:325)
at
org.apache.hadoop.mapred.LocalJobRunner$Job.run(LocalJobRunner.java:263)
Caused by: java.sql.SQLException: [DataDirect][OpenEdge JDBC Driver][OpenEdge]
Column "BX" cannot be found or is not specified for query. (13865)
at
com.ddtek.jdbc.openedge.client.OpenEdgeClientRequest.prepareProcessReply(Unknown
Source)
at com.ddtek.jdbc.openedge.client.OpenEdgeClientRequest.prepare(Unknown
Source)
at com.ddtek.jdbc.openedge.OpenEdgeImplStatement.prepare(Unknown Source)
at com.ddtek.jdbc.base.BaseImplStatement.prepare(Unknown Source)
at com.ddtek.jdbc.base.BasePreparedStatement.prepareSQL(Unknown Source)
at com.ddtek.jdbc.base.BaseStatement.preProcessSQL(Unknown Source)
at com.ddtek.jdbc.base.BasePreparedStatement.<init>(Unknown Source)
at com.ddtek.jdbc.base.BaseConnection.prepareStatement(Unknown Source)
at
org.apache.sqoop.mapreduce.db.DBRecordReader.executeQuery(DBRecordReader.java:102)
at
org.apache.sqoop.mapreduce.db.DBRecordReader.nextKeyValue(DBRecordReader.java:239)
... 8 more
> Unable to import data when table column has - in its name
> ---------------------------------------------------------
>
> Key: SQOOP-602
> URL: https://issues.apache.org/jira/browse/SQOOP-602
> Project: Sqoop
> Issue Type: Bug
> Reporter: Sudhakar Vankamamidi
>
> unable to import a table with a column such as Customer-ID
--
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
