[HIVE-27814] Support VIEWs in the metadata federation

• Type: Sub-task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 4.0.0-beta-1
• Component/s: Standalone Metastore
• Labels: pull-request-available
• Assignee: Naveen Gangam
• Reporter: Naveen Gangam
• Created: 19/Oct/23 19:01
• Updated: 09/Jan/24 00:20

Description

Currently, we only federate the TABLE type objects from the remote datasource. We should be able to pull in VIEW type objects as well.

It appears we can currently create a JDBC-storage handler based table in Hive that points to a view in the remote DB server. I do not see a reason to not include this in the list of federated objects we pull in.

Issue Links

• links to: GitHub Pull Request #4822