hivedbeaverdatabase-metadatadata-lake

Dbeaver doesn't display metadata from one of our hive instances. How to fix?


We use the DBeaver to connect to our hive datalake. I've found a very strange behavior. We have a test and a production datalake.

In our test datalake it correctly displays the tables metadata in the Project tab (the left column). Here it is:

Metadata correctly displayed

But when I go to the our hive production connection, and click in the small arrow beside the schema, no metadata is displayed:

No metadata displayed

The weirdest thing is that if I execute the command show tables or describe table_name, the metadata is correctly displayed. So I have all the permissions to display it.

I've compared all configurations that I've found trying to debug this problem, but don't know what to do any more. A datalake admin helped me since I don't have all the permissions to it.

We use kerberos and a Jdbc connection to Hive.

How to make dbeaver display my metadata ? What should I check to try to fix this?


Solution

  • I changed the driver from Uber jdbc to Cloudera's ODBC Hive Driver and now everything is working fine. I can see the tables metadata and it looks like the connection is quicker.

    When configuring your Hive ODBC Data Source, open the Advanced Options and be sure that Get Tables With Query checkbox is marked.

    Check Get Tables With Query option