[jira] [Assigned] (OODT-336) xmlps should omit joining of tables that are unnecessary to fulfill query

["Chris A. Mattmann (Assigned) (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/OODT-336?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Chris A. Mattmann reassigned OODT-336:
--------------------------------------

    Assignee: Chris A. Mattmann
    
> xmlps should omit joining of tables that are unnecessary to fulfill query
> -------------------------------------------------------------------------
>
>                 Key: OODT-336
>                 URL: https://issues.apache.org/jira/browse/OODT-336
>             Project: OODT
>          Issue Type: Improvement
>          Components: xmlps
>    Affects Versions: 0.4
>            Reporter: Ricky Nguyen
>            Assignee: Chris A. Mattmann
>             Fix For: 0.4
>
>         Attachments: rickdn-oodt-336.patch
>
>
> Suppose we have tables A, B and C.  If we are only querying and returning fields from A and B, then the inclusion of table C in the SQL join statement will produce repeated entries of matching rows.  It would be beneficial if XMLPS could intelligently select the required join tables from the fields in the query.
> In CHLA's specific case, table C causes millions of repeated rows (and subsequently OutOfMemory java heap space error).
> I have a proposed fix that I can upload shortly.

--
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