Return-Path: X-Original-To: apmail-avro-dev-archive@www.apache.org Delivered-To: apmail-avro-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 7B0F1DB08 for ; Mon, 4 Mar 2013 07:55:17 +0000 (UTC) Received: (qmail 19036 invoked by uid 500); 4 Mar 2013 07:55:16 -0000 Delivered-To: apmail-avro-dev-archive@avro.apache.org Received: (qmail 18749 invoked by uid 500); 4 Mar 2013 07:55:15 -0000 Mailing-List: contact dev-help@avro.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@avro.apache.org Delivered-To: mailing list dev@avro.apache.org Received: (qmail 18665 invoked by uid 99); 4 Mar 2013 07:55:12 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 04 Mar 2013 07:55:12 +0000 Date: Mon, 4 Mar 2013 07:55:12 +0000 (UTC) From: "E. Sammer (JIRA)" To: dev@avro.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (AVRO-1269) AVRO is converting ORACLE,Netezza,Teradata decmials & long integers to Strings. MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ 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