How to query Hive to do timestamp range search

[#1]

[#2 · Accepted solution]

You need to put single quotes around your timestamps.

Example) select * from dev_synchrophasor.si_co where `timestamp` between '2017-03-01 00:00:03.00' and '2017-03-01 00:00:10.0'

Hope that helps!

[#3]

[#4]

Thanks, Ryan. It works.