[jira] [Commented] (HIVE-27814) Support VIEWs in the metadata federation
[ https://issues.apache.org/jira/browse/HIVE-27814?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=1561#comment-1561 ] zhangbutao commented on HIVE-27814: --- [~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)
[jira] [Commented] (HIVE-27814) Support VIEWs in the metadata federation
[ https://issues.apache.org/jira/browse/HIVE-27814?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=1440#comment-1440 ] Naveen Gangam commented on HIVE-27814: -- [~zhangbutao] What do you think of this? Can you think of any datasources that we should exclude from such support? > 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)