[
https://issues.apache.org/jira/browse/HIVE-27814?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17777561#comment-17777561
]
zhangbutao edited comment on HIVE-27814 at 10/20/23 4:43 AM:
-------------------------------------------------------------
[~ngangam] All the data connectors we have implemented are JDBC type, and I
think it is no problem to add the jdbc VIEW as hms remote table. I can't think
of connctor which should be excluded. Let's implement it first.
was (Author: zhangbutao):
[~ngangam] All the data connectors we have implemented are JDBC type, and I
think it is no problem to add the jdbc VIEW as hms remote table. I can't think
of connctor which should exclude. Let's implement it first.
> Support VIEWs in the metadata federation
> ----------------------------------------
>
> Key: HIVE-27814
> URL: https://issues.apache.org/jira/browse/HIVE-27814
> Project: Hive
> Issue Type: Sub-task
> Components: Standalone Metastore
> Affects Versions: 4.0.0-beta-1
> Reporter: Naveen Gangam
> Assignee: Naveen Gangam
> Priority: Major
>
> 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.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
