title: epoch with milliseconds to timestamp with milliseconds conversion in Hive
body: <p>How can I convert unix epoch with milliseconds to timestamp with milliseconds In Hive?
  Neither cast() nor from_unixtime() function is working to get the timestamp with milliseconds.</p>
  <p>I tried <code>.SSS</code> but the function just increases the year and doesn't take it as a part of millisecond.</p>
  <pre><code>scala&gt; spark.sql(&quot;select from_unixtime(1598632101000, 'yyyy-MM-dd hh:mm:ss.SSS')&quot;).show(false)
  +-----------------------------------------------------+
  |from_unixtime(1598632101000, yyyy-MM-dd hh:mm:ss.SSS)|
  +-----------------------------------------------------+
  |52628-08-20 02:00:00.000                             |
  +-----------------------------------------------------+
  
  </code></pre>