Have you seen this: http://phoenix.apache.org/faq.html#Can_phoenix_work_on_tables_with_arbitrary_timestamp_as_flexible_as_HBase_API
Also see these other relevant JIRAs: PHOENIX-914 and PHOENIX-590 On Wed, Jun 17, 2015 at 7:40 AM, Buntu Dev <[email protected]> wrote: > Thanks for the info, I've read about integration efforts with Apache > Calcite. > > I noticed that one can't query based column timestamp and queries always > access data with the latest timestamp via Hive. Is this something Phoenix > already/will address? Is there a work around for such use cases? > > > On Wed, Jun 17, 2015 at 6:19 PM, Riesland, Zack <[email protected]> > wrote: >> >> At HadoopSummit, Hortonworks hinted at a solution for this coming later in >> the year. >> >> >> >> I think the idea is a single driver that can interact with Hive, HBase, >> Phoenix, and others, and supports joining data across the connections. >> >> >> >> They didn’t provide very solid specifics, but there will probably be >> something on the website in the near future. >> >> >> >> From: 김영우 [mailto:[email protected]] >> Sent: Wednesday, June 17, 2015 2:36 AM >> To: [email protected] >> Subject: Re: Phoenix and Hive >> >> >> >> Looks like Hive SH for Phoenix is WIP, >> >> https://issues.apache.org/jira/browse/PHOENIX-331 >> >> https://github.com/nmaillard/Phoenix-Hive >> >> >> >> HTH >> >> - Youngwoo >> >> >> >> On Wed, Jun 17, 2015 at 3:26 PM, Buntu Dev <[email protected]> wrote: >> >> I got quite a bit of data in a Hive managed tables and I looking for ways >> to join those tables with the one I create in Phoenix. I'm aware of HBase >> and Hive integration but not sure if there is any current support for >> Phoenix and Hive integration. Please let me know. >> >> >> >> Thanks! >> >> > >
