title: how to format int number output with thousand separator in hive sql
body: <p>Do you know how to format the output of a number in hive with thousand separator? For example:</p>
  
  <p>data:146452664</p>
  
  <p>output:146,452,664</p>
  
  <p>I use this in Teradata, but don't know how to achieve in Hive.</p>
  
  <pre><code>cast(cast(cast(number as integer) as format'ZZZ,ZZZ,ZZZ,ZZ9') as char(11)) 
  </code></pre>