I'd suspect that a SQL-based tool that diffs metadata could be driven from the DatabaseMetadata APIs[1], which Phoenix supports. It doesn't sound like that's the case for the one you mentioned, but perhaps there are others that work this way? One "poor mans" way to get this would be to set sqlline to output as CSV, then do a !describe <table name> against two tables and diff the CSV files.
Thanks, James [1] http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html On Fri, Aug 21, 2015 at 4:50 PM, Saurabh Malviya (samalviy) < [email protected]> wrote: > Hi, > > > > I am looking for sql diff tool for apache phoenix sql format, Just like > http://apgdiff.com/ availalbe for postgresql. > > > > Any pointer ? > > > > *Another PostgreSQL Diff Tool (also known as apgdiff)* is free PostgreSQL > diff tool that is useful for comparison/diffing of database schemas. The > tool compares two database dump files and creates output with DDL > statements that can be used to update old database schema to new one or to > see in what exactly both databases differ. It is already being used by many > developers all over the world. > > > > Thanks, > > Saurabh > > >
