title: Create HIVE Table with fixedrecord length
body: <p>How to create hive table with fixed record length for specific column? </p>
  
  <p>My data is:</p>
  
  <pre><code>ROW1~|`900~|`3103~|`2015~|`AA~|`1002003829
  
  ROW2~|`900~|`3103~|`2015~|`BB~|`1002005103
  
  ROW3~|`900~|`3103~|`2015~|`CC~|`1002003829
  
  ROW4~|`900~|`3103~|`2015~|`DD~|`1002003829
  
  ROW5~|`900~|`3103~|`2015~|`FF~|`1002003829    
  </code></pre>