Reply
Highlighted
New Contributor
Posts: 4
Registered: ‎11-27-2017
Accepted Solution

How to query Hive to do timestamp range search

[ Edited ]

Hive_timestamp2.png

Hive_timestamp.png

New Contributor
Posts: 4
Registered: ‎10-05-2016

Re: How to query Hive to do timestamp range search

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!

New Contributor
Posts: 4
Registered: ‎11-27-2017

Re: How to query Hive to do timestamp range search

Hive_timestamp3.png

New Contributor
Posts: 4
Registered: ‎11-27-2017

Re: How to query Hive to do timestamp range search

Thanks, Ryan. It works.
Announcements