title: Hive timestamp query
body: <p>I created a hive table that has timestamp column (data type is timestamp) in the following format: </p>
  
  <p>2017-01-23 21:23:17.261456</p>
  
  <p>However when I do select like so. It does not work properly. It will select dates after the time stamp. Should the column be a string or I am using the query wrong?  </p>
  
  <pre><code>select * from example where time_created &lt; '2017-01-01 22:30:57.375117'
  </code></pre>