Hi Jeetendra, Unless you are considering to use Phoenix (https://phoenix.apache.org) or Trafodion (https://wiki.trafodion.org/wiki/index.php/Main_Page) for data access to HBase there is no single path to migrate a production application from PostgreSQL to HBase, also you will have to validate all SQL statements you use or generate in your application since there might be differences across SQL implementations (the same you would have to do if migration to another RDBMS). Replicating the data from PostgreSQL to HBase shouldn't be that hard if your client implements hooks and you could write on both platforms at the time, if thats not possible you might need to plug into the PostgreSQL WAL infrastructure to replicate the edits in real time to HBase. (I think FB or others have done something similar from MySQL to HBase).
cheers, esteban. -- Cloudera, Inc. On Mon, Jul 27, 2015 at 8:57 AM, Jeetendra Gangele <[email protected]> wrote: > Yes. > > On 27 July 2015 at 21:02, Ted Yu <[email protected]> wrote: > > > By PSQL did you mean PostgreSQL ? > > > > Cheers > > > > On Mon, Jul 27, 2015 at 12:39 AM, Jeetendra Gangele < > [email protected]> > > wrote: > > > > > I have a production data in PSQL and i want ti migrant the data to > Hbase. > > > Also if there are any changes in my PSQL data , I wanted to update the > > > Hbase. > > > > > > Since I am migrating from production, i don't wanted to hit too many > > > request to my server, also this Hbase data should always be sync with > > PSQL > > > data. > > > > > > Scoop won't work here any other alternatives? > > > > > >
