Inaccurate query results for Hive data sources in Data Virtualization
Last updated: Mar 17, 2025
If you run queries against Hive data sources Version 3.0 or higher, these queries
might return results of
rows and tables.0
Symptoms
You add a connection to a Hive data sources Version 3.0 or higher and the connection is added successfully. You click Virtualize on the service menu; however, you get unexpected zero tables from the Hive connection.
Resolving the problem
To solve this issue, complete one of the following options:
- Set the server parameter on the Hive data source
-
- Go to the hive_site.xml file on the server of the Hive data source.
- Set the following parameter in the hive_site.xml
file.
metastore.storage.schema.reader.impl=org.apache.hadoop.hive.metastore.SerDeStorageSchemaReader
- Restart the Hive data source.
- Add the connection parameter for the Hive data source
-
- In the Data Virtualization web client, navigate to the Data sources page, then select your Hive connection.
- Select Edit connection from the overflow menu (...), then select .
- Add the following parameter in the text
box.
CatalogMode=query
Was the topic helpful?
0/1000