Reply
New Contributor
Posts: 3
Registered: ‎11-15-2017

Cannnot migrate data from RDBMS int Phoenix/Hbase

[ Edited ]

I am trying migrate data from RDBMS into Phoenix with multithreading using JDBC API and Mybatis ORM. Each time when I run my java program, I could insert 2~7 mln rows of data int Phoenix/hbase database and in the end my program get just stuck with no inserts. The following is debug info. I played a lot with hbase/phoenix and zookeeper configurations, so far no result.

2017-12-18 20:06:35 DEBUG ClientCnxn:717 - Got ping response for sessionid: 0x360694b1fff000e after 6ms 2017-12-18 20:06:55 DEBUG ClientCnxn:717 - Got ping response for sessionid: 0x360694b1fff000e after 5ms 2017-12-18 20:07:15 DEBUG ClientCnxn:717 - Got ping response for sessionid: 0x360694b1fff000e after 5ms 2017-12-18 20:07:35 DEBUG ClientCnxn:717 - Got ping response for sessionid: 0x360694b1fff000e after 6ms 2017-12-18 20:07:55 DEBUG ClientCnxn:717 - Got ping response for sessionid: 0x360694b1fff000e after 4ms 2017-12-18 20:08:15 DEBUG ClientCnxn:717 - Got ping response for sessionid: 0x360694b1fff000e after 9ms 2017-12-18 20:08:35 DEBUG ClientCnxn:717 - Got ping response for sessionid: 0x360694b1fff000e after 4ms 2017-12-18 20:08:55 DEBUG ClientCnxn:717 - Got ping response for sessionid: 0x360694b1fff000e after 6ms 2017-12-18 20:09:15 DEBUG ClientCnxn:717 - Got ping response for sessionid: 0x360694b1fff000e after 5ms 2017-12-18 20:09:35 DEBUG ClientCnxn:717 - Got ping response for sessionid: 0x360694b1fff000e after 4ms 2017-12-18 20:09:55 DEBUG ClientCnxn:717 - Got ping response for sessionid: 0x360694b1fff000e after 5ms 2017-12-18 20:10:15 DEBUG ClientCnxn:717 - Got ping response for sessionid: 0x360694b1fff000e after 5ms 2017-12-18 20:10:35 DEBUG ClientCnxn:717 - Got ping response for sessionid: 0x360694b1fff000e after 6ms 2017-12-18 20:10:55 DEBUG ClientCnxn:717 - Got ping response for sessionid: 0x360694b1fff000e after 6ms 2017-12-18 20:11:15 DEBUG ClientCnxn:717 - Got ping response for sessionid: 0x360694b1fff000e after 4ms 2017-12-18 20:11:35 DEBUG ClientCnxn:717 - Got ping response for sessionid: 0x360694b1fff000e after 6ms 2017-12-18 20:11:55 DEBUG ClientCnxn:717 - Got ping response for sessionid: 0x360694b1fff000e after 6ms 2017-12-18 20:12:15 DEBUG ClientCnxn:717 - Got ping response for sessionid: 0x360694b1fff000e after 4ms 2017-12-18 20:12:35 DEBUG ClientCnxn:717 - Got ping response for sessionid: 0x360694b1fff000e after 5ms 2017-12-18 20:12:55 DEBUG ClientCnxn:717 - Got ping response for sessionid: 0x360694b1fff000e after 5ms 2017-12-18 20:13:15 DEBUG ClientCnxn:717 - Got ping response for sessionid: 0x360694b1fff000e after 4ms 2017-12-18 20:13:35 DEBUG ClientCnxn:717 - Got ping response for sessionid: 0x360694b1fff000e after 5ms 2017-12-18 20:13:55 DEBUG ClientCnxn:717 - Got ping response for sessionid: 0x360694b1fff000e after 5ms 2017-12-18 20:14:15 DEBUG ClientCnxn:717 - Got ping response for sessionid: 0x360694b1fff000e after 6ms