[AVRO-1269] AVRO is converting ORACLE,Netezza,Teradata decmials & long integers to Strings.

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.7.1
• Component/s: java
• Assignee: Unassigned
• Reporter: Prasad Dasari
• Created: 01/Mar/13 20:47
• Updated: 30/Dec/18 05:50

Description

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.