[jira] [Created] (SQOOP-3087) Dollar ($) in Oracle schema name causes sqoop to avro to throw exception

[Steve Senior (JIRA)]

Steve Senior created SQOOP-3087:
-----------------------------------

             Summary: Dollar ($) in Oracle schema name causes sqoop to avro to 
throw exception
                 Key: SQOOP-3087
                 URL: https://issues.apache.org/jira/browse/SQOOP-3087
             Project: Sqoop
          Issue Type: Bug
    Affects Versions: 1.4.6
            Reporter: Steve Senior


Created an Oracle table called {{SH_$.TEST}} and attempt to Sqoop import as 
Avro ({{--as-avrodatafile}}) throws:

{code}
16/12/21 11:56:09 ERROR sqoop.Sqoop: Got exception running Sqoop: 
org.apache.avro.SchemaParseException: Illegal character in: SH_$_TEST
org.apache.avro.SchemaParseException: Illegal character in: SH_$_TEST
{code}

Command line is:

{code}
sqoop import --connect jdbc:oracle:thin:@localhost:1521/ORA11204 --username xxx 
--password $'gluent_app' --table SH_$.TEST --target-dir=/user/oracle/sh.db/test 
--delete-target-dir -m2 --direct --fetch-size=5000 --as-avrodatafile 
--outdir=/tmp
{code}

Can a schema conversion parameter be added to Sqoop to remove the {{$}} from 
the {{name}} field stored in the Avro schema in the Avro data file?



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)