3 Replies Latest reply on Nov 6, 2018 12:22 AM by Deepak Rai

    Cross Database Join -- Primary and Secondary Data Sources

    Vivek Nayagam

      Does having a data source as primary or secondary in a cross data base join have any impact?

       

      1. I have Google sheet as primary and Presto table as secondary and do a right outer join.

      2. I have Presto table as primary and Google sheet as secondary and do a left outer join.

       

      In #1 I see that it doesn't behave like a right outer join. #2 behaves as expected. Why is it so? Am I missing something?

       

       

      Thanks,

      Vivek