[
https://issues.apache.org/jira/browse/SQOOP-1361?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14060792#comment-14060792
]
Sai Karthik Ganguru commented on SQOOP-1361:
--------------------------------------------
The complete error that we get is as follows:
14/07/03 18:57:09 INFO manager.SqlManager: Executing SQL statement: SELECT
COMMAND_TYPE$,VALUE_TYPE$,COMMIT_SCN$,COMMIT_TIME$,SYNC_ACTIVITY_ID,SYNC_ID,SPORT_ACTIVITY_ID,CREATE_DATE,UPDATE_DATE,DEVICE_CONFIG_GROUP_ID
FROM MSP_CDC.SYNC_ACTIVITY_CDC WHERE 1=0
14/07/03 18:57:09 ERROR sqoop.Sqoop: Got exception running Sqoop:
org.apache.avro.SchemaParseException: Illegal character in: COMMAND_TYPE$
org.apache.avro.SchemaParseException: Illegal character in: COMMAND_TYPE$
at org.apache.avro.Schema.validateName(Schema.java:1042)
at org.apache.avro.Schema.access$200(Schema.java:78)
at org.apache.avro.Schema$Field.<init>(Schema.java:366)
at org.apache.avro.Schema$Field.<init>(Schema.java:361)
at
org.apache.sqoop.orm.AvroSchemaGenerator.generate(AvroSchemaGenerator.java:66)
at
org.apache.sqoop.mapreduce.DataDrivenImportJob.configureMapper(DataDrivenImportJob.java:76)
at org.apache.sqoop.mapreduce.ImportJobBase.runImport(ImportJobBase.java:220)
at org.apache.sqoop.manager.SqlManager.importTable(SqlManager.java:555)
at com.quest.oraoop.OraOopConnManager.importTable(OraOopConnManager.java:260)
at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:403)
at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:476)
at org.apache.sqoop.Sqoop.run(Sqoop.java:145)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229)
at org.apache.sqoop.Sqoop.main(Sqoop.java:238)
> When a special character like '$' is encountered in the column names then the
> Sqoop script fails
> ------------------------------------------------------------------------------------------------
>
> Key: SQOOP-1361
> URL: https://issues.apache.org/jira/browse/SQOOP-1361
> Project: Sqoop
> Issue Type: Bug
> Components: connectors
> Affects Versions: 1.4.3
> Reporter: Sai Karthik Ganguru
> Priority: Minor
>
> If any of the characters like '$' are present in one of the column names that
> we are trying to Sqoop (as an Avro data file using the option
> --as-avrodatafile) then the Sqoop script fails with an exception.
> Trying to Sqoop a table (using the --as-avrodatafile option) whose column
> names are as follows: Name$, Age$, Profession$
--
This message was sent by Atlassian JIRA
(v6.2#6252)
