title: Timestamp in Hive tables keeps changing
body: <p>I have a HIVE table which stores timestamp in yyyy-MM-dd HH:mm::ss.S format. But I have noticed that The value in such columns keeps changing, e.g. the value that I sqooped was '2016-01-<strong>25 00</strong>:00:00.0' but sometimes (not always) this value is shown as '2016-01-<strong>24 19</strong>:00:00.0'.</p>
  
  <p>To make matters worse, this does not happen in all tables at the same time. Sometimes <em>table1</em> would have the correct format and <em>table2</em>, the incorrect one (2016-01-<strong>24 19</strong>:00:00.0) and vice versa</p>
  
  <p>I don't know if this is relevant, but we recently moved from ORACLE to HIVE. In the oracle table the date column was of type 'DATE' which stored datda as <strong>25-JAN-16</strong> but in HIVE the column is of type 'TIMESTAMP' and stores data as <strong>2016-01-25 00:00:00.0</strong>.</p>
  
  <p><em>The timestamp is correct when I sqoop the data but is sometimes incorrect when I check it out later.</em></p>
  
  <p>Could someone please tell me how I could fix or work around this problem?</p>