[
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
