avro-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "E. Sammer (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (AVRO-1269) AVRO is converting ORACLE,Netezza,Teradata decmials & long integers to Strings.
Date Mon, 04 Mar 2013 07:55:12 GMT

    [ https://issues.apache.org/jira/browse/AVRO-1269?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13592048#comment-13592048
] 

E. Sammer commented on AVRO-1269:
---------------------------------

Prasad: I'm pretty sure this is a bug in Sqoop. Specifically, it's Sqoop that decides which
Avro type to use based on the database column type. Avro just writes the types it's asked
to write, according to the schema.
                
> AVRO is converting ORACLE,Netezza,Teradata decmials & long integers to Strings.
> -------------------------------------------------------------------------------
>
>                 Key: AVRO-1269
>                 URL: https://issues.apache.org/jira/browse/AVRO-1269
>             Project: Avro
>          Issue Type: Bug
>    Affects Versions: 1.7.1
>            Reporter: Prasad Dasari
>
> I  tried to sqoop ORALCE,NETEZZA,TERADATA tables with AVRO foramt using plain JDBC (without
using Cloudera connectors). I can see DECIMAL & NUMERIC data types are being converted
to AVRO Strings.
> Oracle         --    NUMBER &  INTEGER  data types  are being converted to AVRO String
format.
> NETEZZA        --   DECIMAL,NUMERIC data types are converted to AVRO String format.
> Teradata       --  DECIMAL AND LONG data types are converted to AVRO String format.
>  When i tried with map-columns to BigDecimal,BigInteger i can see AVRO does not support
BigDecimal error message.
> Thanks,
> Prasad Dasari.

--
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

Mime
View raw message