Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

How to query Hive to do timestamp range search

avatar
Explorer

Hive_timestamp2.png

Hive_timestamp.png

1 ACCEPTED SOLUTION

avatar
Explorer

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!

View solution in original post

3 REPLIES 3

avatar
Explorer

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!

avatar
Explorer

Hive_timestamp3.png

avatar
Explorer
Thanks, Ryan. It works.