https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-query-Hive-to-do-timestamp-range-search/m-p/63927#M73772 <P>You need to put single quotes around your timestamps.</P><P>&nbsp;</P><P>Example) select * from dev_synchrophasor.si_co where `timestamp` between <STRONG>'2017-03-01 00:00:03.00'</STRONG> and <STRONG>'2017-03-01 00:00:10.0'</STRONG></P><P>&nbsp;</P><P>Hope that helps!</P> Tue, 23 Jan 2018 17:19:15 GMT RyanKeen 2018-01-23T17:19:15Z https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-query-Hive-to-do-timestamp-range-search/m-p/63923#M73771 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Hive_timestamp2.png" style="width: 600px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/3792i49752047562C75CB/image-size/large?v=v2&amp;px=999" role="button" title="Hive_timestamp2.png" alt="Hive_timestamp2.png" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Hive_timestamp.png" style="width: 600px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/3791i7A7494E642C362FD/image-size/large?v=v2&amp;px=999" role="button" title="Hive_timestamp.png" alt="Hive_timestamp.png" /></span></P> Tue, 21 Apr 2026 13:44:47 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-query-Hive-to-do-timestamp-range-search/m-p/63923#M73771 INVBAT 2026-04-21T13:44:47Z https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-query-Hive-to-do-timestamp-range-search/m-p/63927#M73772 <P>You need to put single quotes around your timestamps.</P><P>&nbsp;</P><P>Example) select * from dev_synchrophasor.si_co where `timestamp` between <STRONG>'2017-03-01 00:00:03.00'</STRONG> and <STRONG>'2017-03-01 00:00:10.0'</STRONG></P><P>&nbsp;</P><P>Hope that helps!</P> Tue, 23 Jan 2018 17:19:15 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-query-Hive-to-do-timestamp-range-search/m-p/63927#M73772 RyanKeen 2018-01-23T17:19:15Z https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-query-Hive-to-do-timestamp-range-search/m-p/63929#M73773 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Hive_timestamp3.png" style="width: 600px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/3794i59C266CF6D8FDF74/image-size/large?v=v2&amp;px=999" role="button" title="Hive_timestamp3.png" alt="Hive_timestamp3.png" /></span></P> Tue, 23 Jan 2018 18:04:20 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-query-Hive-to-do-timestamp-range-search/m-p/63929#M73773 INVBAT 2018-01-23T18:04:20Z https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-query-Hive-to-do-timestamp-range-search/m-p/63930#M73774 Thanks, Ryan. It works. Tue, 23 Jan 2018 18:04:54 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-query-Hive-to-do-timestamp-range-search/m-p/63930#M73774 INVBAT 2018-01-23T18:04:54Z