title: Why doesn't it pads the space characters correctly when there are foreign characters?
body: <p>My goal is to export a file with fixed-width columns. I have the following HQL:</p>
  
  <pre><code>insert overwrite table destination_table
  select concat(rpad(p.artist_name,40," "),rpad(p.release_name,40," "))
  from source_table;
  </code></pre>
  
  <p>"destination_table" is an external table which writes to a file. When artist_name and release_name contains normal English characters, no problem, the result is the following:</p>
  
  <pre><code>paulo kuong[29 space characters]I am terribly stuck album
  </code></pre>
  
  <p>I got 40 charaters fixed width columns. However, when the strings are not English, I got:</p>
  
  <pre><code>장재인[31 space characters]다른 누구도 아닌 너에게       
  </code></pre>
  
  <p>Which suppose to be 37 space characters. LPAD seems not able to pad the spaces correctly. When I do "length(장재인)" it returns 3 characters.. So there is something weird going on with lpad and rpad in HIVE </p>
  
  <p>Any idea? </p>