sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jarek Jarcec Cecho (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (SQOOP-1823) Sqoop2: Fix Derby schema documenation
Date Tue, 02 Dec 2014 22:47:12 GMT

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

Jarek Jarcec Cecho commented on SQOOP-1823:
-------------------------------------------

I've actually went through the exercise to get latest derby repository and tried to see the
table structure using {{ij}} utility, just to find out that there is no way how to get the
foreign key configuration from Derby back (or at least I did not find that way :().  Based
on the queries it seems that you are correct and hence +1 n the patch.

> Sqoop2: Fix Derby schema documenation
> -------------------------------------
>
>                 Key: SQOOP-1823
>                 URL: https://issues.apache.org/jira/browse/SQOOP-1823
>             Project: Sqoop
>          Issue Type: Bug
>          Components: sqoop2-derby-repository
>    Affects Versions: 1.99.4
>            Reporter: Abraham Elmahrek
>            Assignee: Abraham Elmahrek
>             Fix For: 1.99.5
>
>         Attachments: SQOOP-1823.0.patch
>
>
> There are a few places where there foreign keys are inaccurately listed. For example:
> {noformat}
>  *    +------------------------------+
>  *    | SQ_CONNECTOR_DIRECTIONS      |
>  *    +------------------------------+
>  *    | SQCD_ID: BIGINT PK AUTO-GEN  |
>  *    | SQCD_CONNECTOR: BIGINT       |FK SQCD_CONNECTOR(SQC_ID)
>  *    | SQCD_DIRECTION: BIGINT       |FK SQCD_DIRECTION(SQD_ID)
>  *    +------------------------------+
> {noformat}
> In the above snippet, FK SQCD_CONNECTOR(SQC_ID) should be FK _SQ_CONFIGURABLE(SQC_ID).



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message