Multifiles with Join

What is behavior of join with multifiles if I use Join via common key in both files and if the key is different what is the result?

Showing Answers 1 - 2 of 2 Answers

  • May 2nd, 2017

Use the override-key option in join parameter, but the key should be of same data type. It will perform as per join type you mentioned

  Was this answer useful?  Yes


  • May 12th, 2017

As per my understanding there will be two scenarios here, if multi-files are partitioned based don key to be joined upon then by join key with same data type it will produce normal join results depending upon the type of join.
In second case, if files are not partitioned by key and directly joined the output will be partial results restricted to data from corresponding partition of both multi-files.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions