Support Questions
Find answers, ask questions, and share your expertise

How to query Hive to do timestamp range search

New Contributor

Hive_timestamp2.png

Hive_timestamp.png

1 ACCEPTED SOLUTION

Accepted Solutions

Re: How to query Hive to do timestamp range search

New Contributor

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

Re: How to query Hive to do timestamp range search

New Contributor

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

Re: How to query Hive to do timestamp range search

New Contributor

Hive_timestamp3.png

Re: How to query Hive to do timestamp range search

New Contributor
Thanks, Ryan. It works.