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:

  1. I config the dbeaver connecting the hbase using phoenix.
  2. 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.

  1. 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

error

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)

Most upvoted comments

For some reason DBeaver didn’t read list of phoenix schemas.