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

["Steve Senior (JIRA)" <ji...@apache.org>]

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)