Users may see an error message when introspecting tables from Apache Hive data source in TIBCO Data Virtualization Studio.
Article ID: KB0074065
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | All Supported Versions |
Description
When a data source connection is created with Hive database using Apache Hive 2.x data source adapter in TDV Studio, the below error message may be returned while introspecting some tables after successful connection with the database:
ServerError: MetaException(message:Got exception: org.apache.hadoop.hive.metastore.api.MetaException No such database row)
Root cause:
The error message is returned while trying to introspect a table from the database on which the user does not have permission or access.
ServerError: MetaException(message:Got exception: org.apache.hadoop.hive.metastore.api.MetaException No such database row)
Root cause:
The error message is returned while trying to introspect a table from the database on which the user does not have permission or access.
Issue/Introduction
An error message may be returned when introspecting tables from Apache Hive data source in TIBCO Data Virtualization Studio.
Environment
All supported Operating Systems
Resolution
To resolve the issue, verify that the user used to create the data source connection in TDV Studio with Hive database has appropriate READ permission to access the table.
Feedback
Yes
No
Powered by
