My 2 cents : 1- Map your table to a Hive table and do the export using Sqoop. 2- Export <http://hbase.apache.org/book/ops_mgt.html#export> the table to a file first, and then export it using Sqoop.
Warm Regards, Tariq cloudfront.blogspot.com On Wed, Aug 28, 2013 at 7:12 PM, Shahab Yunus <[email protected]>wrote: > Taking what Ravi Kiran mentioned a level higher, you can also use Pig. It > has DBStorage. Very easy to rad from HBase and dump to MySQL if your data > porting does not require complex transformation (even which can be handled > in Pig too.) > > > http://pig.apache.org/docs/r0.11.0/api/org/apache/pig/piggybank/storage/DBStorage.html > > Regards, > Shahab > > > On Wed, Aug 28, 2013 at 1:26 AM, Ravi Kiran <[email protected] > >wrote: > > > If you would like to have greater control on what data / which columns > > from HBase should be going into MySQL tables , you can write a simple MR > > job and use the DBOutputFormat . It is a simple one and works great for > > us. > > > > Regards > > Ravi > > > > > > > > On Wed, Aug 28, 2013 at 10:42 AM, ch huang <[email protected]> wrote: > > > > > i use hive ,maybe it's a way ,let me try it > > > > > > On Wed, Aug 28, 2013 at 11:21 AM, James Taylor <[email protected] > > > >wrote: > > > > > > > Or if you'd like to be able to use SQL directly on it, take a look at > > > > Phoenix (https://github.com/forcedotcom/phoenix). > > > > > > > > James > > > > > > > > On Aug 27, 2013, at 8:14 PM, Jean-Marc Spaggiari > > > > <[email protected]> wrote: > > > > > > > > > Take a look at sqoop? > > > > > Le 2013-08-27 23:08, "ch huang" <[email protected]> a écrit : > > > > > > > > > >> hi,all: > > > > >> any good idea? thanks > > > > >> > > > > > > > > > >
