sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bilung Lee (Commented) (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (SQOOP-448) boolean fields get nullified during postgres direct import into hive.
Date Thu, 08 Mar 2012 21:02:00 GMT

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

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

This might be related to how you generate your patch.

Below are the steps you may follow:

1. Check out the code from the trunk as shown in the link below:
http://cwiki.apache.org/confluence/display/SQOOP/Setting+up+Development+Environment#SettingupDevelopmentEnvironment-BuildingtheSources

2. After making the changes, generate the patch as shown in the link below:
http://cwiki.apache.org/confluence/display/SQOOP/How+to+Contribute#HowtoContribute-ProvidingPatches

3. Upload the patch to the review board:
- If you are using SVN to generate patch, choose "Sqoop" as repository and type in "." as
base directory.
- If you are using GIT to generate patch, choose "sqoop-git" as repository.

                
> 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

        

Mime
View raw message