I am trying to connect remote hive. I configured the hive metastore and Dremio can I access it- I see my schemas and tables.
When I am trying to query data from the tables I get the error of
VALIDATION ERROR: TABLE ‘HIVE.SCHEMA.TABLE’ IS NOT FOUND.
I copied hive-site.xml and site-core.xml to conf dir of Dremio.
Is there anything else I might forgot doing?
Can you share the query profile? There may be a more obvious error mentioned in the stacktrace - https://www.dremio.com/tutorials/share-query-profile-dremio/
I am working in a secured network, So it might be hard doing so.