Mailing-List: contact sqoop-dev-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: sqoop-dev@incubator.apache.org
Date: Mon, 5 Mar 2012 22:43:57 +0000 (UTC)
From: "Bilung Lee (Commented) (JIRA)" <jira@apache.org>
To: sqoop-dev@incubator.apache.org
Message-ID: 
 <939064756.24325.1330987437391.JavaMail.tomcat@hel.zones.apache.org>
In-Reply-To: 
 <1914867978.2677.1330519437051.JavaMail.tomcat@hel.zones.apache.org>
Subject: [jira] [Commented] (SQOOP-448) boolean fields get nullified during
 postgres direct import into hive.
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


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

Bilung Lee commented on SQOOP-448:
----------------------------------

Thanks for your contribution!  The patch will eventually be committed into the trunk, and thus the convention is to base the patch on the version of code in the trunk.

                
> boolean fields get nullified during postgres direct import into hive.
> ---------------------------------------------------------------------
>
>                 Key: SQOOP-448
>                 URL: https://issues.apache.org/jira/browse/SQOOP-448
>             Project: Sqoop
>          Issue Type: Bug
>          Components: connectors/postgresql
>    Affects Versions: 1.3.0
>            Reporter: Boris Partensky
>            Assignee: Boris Partensky
>              Labels: patch
>             Fix For: 1.3.0
>
>         Attachments: sqoop.patch
>
>
> These diffs address this issue - https://issues.cloudera.org/browse/SQOOP-43.
> I changed DirectPostgresManager.java to special-case rewrite COPY.... command for boolean fields so that hive sees "true"/"false". The only shortcoming with my patch is that because PG jdbc driver can not tell bit data types from booleans, direct import will break with SQL cast errors if someone has real bit fields. Not sure how often people use those, but it will break direct import for that one person who does. If you have an idea on how I can make this better, let me know. Diffs are attached

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira