dbeaver: Bug: dbeaver connect hbase using phoenix,click the table Data button,throw the error.
Env: dbeaver: 4.0.5 phoenix: phoenix-4.11-HBase-1.2 hbase: 1.2.0(CDH5.11)
Steps:
- I config the dbeaver connecting the hbase using phoenix.
- I create the schema and table in the script of dbeaver.
CREATE SCHEMA JYDW;
CREATE TABLE JYDW.USERINFO(id bigint not null primary key, name varchar null,age integer null, address varchar null) ;
upsert into JYDW.USERINFO(id,name,age,address) values(1,'name1',11,'china1');
SELECT * from JYDW.USERINFO ;
These create and upsert and select sql are successful. And I create spark project with scala, operating the table “JYDW.USERINFO”, also is successful.
- But, I select the connection(HBase) and refresh, and I find that the table name is “USERINFO” without the schema info ,instead of “JYDW.USERINFO”.
4.Then I click the “USERINFO” table, and again click the “Data” button, throw the error: SQL Error [1012] [42M03]: ERROR 1012 (42M03): Table undefined. tableName=USERINFO org.apache.phoenix.schema.TableNotFoundException: ERROR 1012 (42M03): Table undefined. tableName=USERINFO

5.I think that the table is lost the schema info in Dbeaver,so that leads to this error. @serge-rider Please help to see it, thankyou.
About this issue
- Original URL
- State: closed
- Created 7 years ago
- Comments: 16 (8 by maintainers)
For some reason DBeaver didn’t read list of phoenix schemas.