Thank you Samarth That is so cool. I did look at PointInTimeQueryIT. It doe not look like test actually testing something DDL in time kind of thing.
Do we have something like SET SCHEMA_VERSION ts ? something to set it through SQL and not connection properties? Any commands do be able to see actually history and DDL for different versions? delete schema ? rollback? is it something you would consider worse to file JIRA (or two) ? I am trying to figure out some solution form zero downtime schema upgrade so that where all those questions come... Thank you On Fri, Mar 27, 2015 at 7:03 PM, Samarth Jain <samarth.j...@gmail.com> wrote: > Hi Sergey, > > Take a look at the tests in PointInTimeQueryIT. For point in time schema > and query, you essentially need to set the timestamp in your > PhoenixConnection by setting the PhoenixRuntime.CURRENT_SCN_ATTRIB > property. Once that property is set, Phoenix will recognize the schema of > the table that was present at that timestamp as well as the data that was > created up to that timestamp. > > HTH. > - Samarth > > On Fri, Mar 27, 2015 at 3:51 PM, Sergey Belousov < > sergey.belou...@gmail.com> > wrote: > > > Hi all > > > > On PHOENIX website in SCHEMA section mentioned that: > > <http://phoenix.apache.org/index.html> > > > > All schema is versioned, and prior versions are stored forever. Thus, > > snapshot queries over older data will pick up and use the correct schema > > for each row. > > Is it anywhere I can get more info that? > > Doe it mean I can specify version of the view I doing SELECT from ? > > Can I list existent schema versions ? > > Can I revert to the previous version? > > > > Is it something would be useful (possible) to have? > > > > Thank you > > SB > > >
