You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@sqoop.apache.org by "mark monroe (Resolved) (JIRA)" <ji...@apache.org> on 2012/04/04 21:40:22 UTC
[jira] [Resolved] (SQOOP-446) sqoop column terminator
"fields-terminated-by" needs to work with any of the following '\007',
'0x7', '^G'
[ https://issues.apache.org/jira/browse/SQOOP-446?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
mark monroe resolved SQOOP-446.
-------------------------------
Resolution: Fixed
Fix Version/s: 1.4.1-incubating
just tested this in version 1.4.1 and it works
> sqoop column terminator "fields-terminated-by" needs to work with any of the following '\007', '0x7', '^G'
> ----------------------------------------------------------------------------------------------------------
>
> Key: SQOOP-446
> URL: https://issues.apache.org/jira/browse/SQOOP-446
> Project: Sqoop
> Issue Type: Bug
> Components: tools
> Affects Versions: 1.3.0
> Environment: currently using sqoop 1.3.x our data is UTF8 and since we have columns with most of the ascii keyboard char, it would be best to use the Bell char '\007'
> Reporter: mark monroe
> Priority: Minor
> Fix For: 1.4.1-incubating
>
>
> here is the command
> sqoop export -conf /opt/hadoop/sqoop/sqoop-pdw-1.0/conf/pdwp.xml -libjars $SQOOP_HOME/lib/commons-net-2.2.jar -Dmapreduce.task.classpath.user.precedence=true --connect pdw://10.230.25.1 --username ETL_TEST --password ***** --table OPS_TEST_DB.dbo.PROTO_TEST_FAILING_PINS_sqoop -m 1 --export-dir /tmp/mm_test3 --input-fields-terminated-by "\007"
> here is the error....
> 12/02/24 12:11:43 ERROR tool.ExportTool: Encountered IOException running export job: org.apache.hadoop.ipc.RemoteException: java.io.IOException: java.lang.RuntimeException: org.xml.sax.SAXParseException: Character reference "" is an invalid XML character.
> at org.apache.hadoop.mapred.JobTracker.submitJob(JobTracker.java:3766)
> at sun.reflect.GeneratedMethodAccessor18.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at org.apache.hadoop.ipc.RPC$Server.call(RPC.java:557)
> at org.apache.hadoop.ipc.Server$Handler$1.run(Server.java:1434)
> at org.apache.hadoop.ipc.Server$Handler$1.run(Server.java:1430)
> at java.security.AccessController.doPrivileged(Native Method)
> at javax.security.auth.Subject.doAs(Subject.java:396)
> at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1127)
> at org.apache.hadoop.ipc.Server$Handler.run(Server.java:1428)
> Caused by: java.lang.RuntimeException: org.xml.sax.SAXParseException: Character reference "" is an invalid XML character.
> at org.apache.hadoop.conf.Configuration.loadResource(Configuration.java:1393)
> at org.apache.hadoop.conf.Configuration.loadResources(Configuration.java:1261)
> at org.apache.hadoop.conf.Configuration.getProps(Configuration.java:1192)
> at org.apache.hadoop.conf.Configuration.get(Configuration.java:415)
> at org.apache.hadoop.mapred.JobConf.checkAndWarnDeprecation(JobConf.java:1957)
> at org.apache.hadoop.mapred.JobConf.<init>(JobConf.java:386)
> at org.apache.hadoop.mapred.JobInProgress.<init>(JobInProgress.java:414)
> at org.apache.hadoop.mapred.JobTracker.submitJob(JobTracker.java:3764)
> ... 10 more
> Caused by: org.xml.sax.SAXParseException: Character reference "" is an invalid XML character.
> at com.sun.org.apache.xerces.internal.parsers.DOMParser.parse(DOMParser.java:249)
> at com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderImpl.parse(DocumentBuilderImpl.java:284)
> at javax.xml.parsers.DocumentBuilder.parse(DocumentBuilder.java:124)
> at org.apache.hadoop.conf.Configuration.loadResource(Configuration.java:1313)
> ... 17 more
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira