title: Hive: Joining tables with different scenarios
body: <p>I have a question on joining tables in a different scenario. Please find the sample tables below.</p>
  
  <p>Capacity of expected table row 3-5 should be repeated as table 2 does not have those fields.</p>
  
  <p>could anyone please help to get expected table?</p>
  
  <h1>Table 1:</h1>
  
  <p>No  ProjectID   Capacity</p>
  
  <p>1   514 4</p>
  
  <p>2   418 10</p>
  
  <p>3   418 30</p>
  
  <p>4   401 40</p>
  
  <p>5   502 41</p>
  
  <h1>Table2:</h1>
  
  <p>NO  ProjectID   Capacity1   Capacity2</p>
  
  <p>1   514 4   10</p>
  
  <p>2   418 10  20</p>
  
  <h1>Expected Table:</h1>
  
  <p>NO  ProjectID   Capacity1   Capacity2</p>
  
  <p>1   514 4   10</p>
  
  <p>2   418 10  20</p>
  
  <p>3   418 30  30</p>
  
  <p>4   401 40  40</p>
  
  <p>5   502 41  41</p>