Sign in
 
HomeOnline20132010Other VersionsRelated ProductsLibraryForumsGallery
TechCenter >
> 
> 
FAST Search 2010 - merge the results from two jdbc connectors

Unanswered FAST Search 2010 - merge the results from two jdbc connectors

  • Friday, July 27, 2012 2:39 PM
     
     
    Sign In to Vote
    0

    Hi,

    I am using 2 JDBC connectors to crawl external data. Both JDBC connectors are crawling the same database but they are returning different results. They have in common an ID field.

    In the FAST search center if I am searching for a particular ID, I will have two results from those two JDBC connectors.

    Is there any way to merge those two results in one result?

    Thanks in advance for your answer.

    MCITP|MCTS SharePoint| SharePoint Performance blog

     

All Replies

  • Monday, July 30, 2012 7:49 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi Boqdan,

    For this issue, I suggest you to just create one JDBC connectors which include the query of the two JDBC connectors. Because they have a same column field ID, based on ID field you can use left join as the statement. More information about “combine result set”: http://www.velocityreviews.com/forums/t133712-combining-resultsets.html

    If it’s the issue, please provide more information about why you should use two JDBC Connectors. What’s your exact requirement?

    Best Regards.

     
  • Monday, July 30, 2012 9:33 AM
     
     
    Sign In to Vote
    0

    Hi,

    Thank you for your answer.

    I am using multiple select and inner joins in each query that is utilized by each connector. I cannot mix the queries because it will be huge a query that will take days\weeks to finish because of the amount of data.

    Also, I am using multiple JDBC connectors to index different type of information for the same product ID and at the end I want to merge the results in one result. Is there any way to do this, without having only one query?

    Kind regards,

    MCITP|MCTS SharePoint| SharePoint Performance blog