title: Output column mismatch. User defined SQL query in Source Qualifier
body: <p>I think I’m missing something obvious here. I'm tasked to duplicate a mapping that works fine, by changing ONLY the source qualifier portion.</p>
  
  <p>The original mapping looks like this,</p>
  
  <p><a href="https://i.stack.imgur.com/XSGY8.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/XSGY8.png" alt="OriginalMapping"></a></p>
  
  <p>First of all, I don’t understand how the original mapping simply connects from the Source Qualifier to the Expression.
  The column names are supposed to be changed completely because of the user defined query. </p>
  
  <p>eg.</p>
  
  <pre><code>INSERT_DM to max(HVOLE.INSERT_DM)
  </code></pre>
  
  <p>In my new duplicated mapping, my new Source qualifier is giving me this error when I click "Validate",</p>
  
  <p><a href="https://i.stack.imgur.com/AK9ae.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/AK9ae.png" alt="enter image description here"></a></p>
  
  <p>It's weird that it mentions "exactly 3 fields", when my query actually outputs 5 separate columns.</p>
  
  <p>Note that I've created o_BEADHEIGHT1 and o_BEADHEIGHT2 for the columns that don't exist. These columns are newly created by my user-defined query. </p>