title: Left join did not working properly in Azure Stream Analytics
body: <p>I'm trying to create a simple left join between two inputs (event hubs), the source of inputs is an app function that process a rabbitmq queue and send to a event hub.</p>
  
  <p>In my eventhub1 I have this data:</p>
  
  <pre><code>[{
      "user": "user_aa_1"
  }, {
      "user": "user_aa_2"
  }, {
      "user": "user_aa_3"
  }, {
      "user": "user_cc_1"
  }]
  </code></pre>
  
  <p>In my eventhub2 I have this data:</p>
  
  <pre><code>[{
      "user": "user_bb_1"
  }, {
      "user": "user_bb_2"
  }, {
      "user": "user_bb_3
  }, {
      "user": "user_cc_1"
  }]
  </code></pre>
  
  <p>I use that sql to create my left join</p>
  
  <pre><code>select hub1.[user] h1,hub2.[user] h2 
  into thirdTestDataset
  from hub1 
      left join hub2 
          on hub2.[user] = hub1.[user]
          and datediff(hour,hub1,hub2) between 0 and 5
  </code></pre>
  
  <p>and test result looks ok... </p>
  
  <p><a href="https://i.stack.imgur.com/xuIn0.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/xuIn0.png" alt="test result"></a></p>
  
  <p>the problem is when I try it on job running... I got this result in power bi dataset...</p>
  
  <p><a href="https://i.stack.imgur.com/XJKbE.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/XJKbE.png" alt="power bi result"></a></p>
  
  <p>Any idea why my left isn't working like any sql query?</p>