vonng / hbase_fdw

PostgreSQL HBase FDW based on multicorn.

Hi 👋, I'm Vonng

Profile | Bio | Posts | WeChat | PG Notes | DDIA | PG Internal | Capslock | Pigsty

💻 PostgreSQL expert, Full-stack engineer, Individual open source contributor, Founder

🐘 Author of Pigsty, Open-Source RDS Alternative, Battery-Included PostgreSQL Distribution

⌨️ Author of Capslock, transform ⇪CapsLock into a new powerful ✱ Hyper modifier

🀄️ Translator of two books: 《Designing Data Intensive Application]》 & 《PG Internal》

hbase_fdw's Issues

connect error

my pg version10.9, thrift version 0.9, hbase use thrift1,
while i found a connect error:
ERROR: Error in python: TTransportException
DETAIL: TTransportException(message='TSocket read 0 bytes', type=4)

Then i modified the happybase_fdw.py at row 102:
self.conn = happybase.Connection(self.host, self.port)
I add two parameters:
self.conn = happybase.Connection(self.host, self.port, protocol='compact',transport='framed')

Then it works well.

some bugs i meet

error message like below：
ERROR: Error in python: TTransportException
DETAIL: TTransportException(message='TSocket read 0 bytes', type=4)

que:
why there has no error when i use happybase only by phton script but show error like top by hbase_fdw?
other error eg:
insert 1000 rows,but can find only 900 rows in hbase,but have no tip in postgresql.