You can translate the question and the replies:

FK/PK constraints in Hive3

Hi denodo team i have a question about denodo and hive3. I heard that hive3 will be add into official support source database in next denodo updates. And will denodo collect releationships(PK/FK) automatically when create several base view from hive like other db(mysql)? you know transactional features was reinforced in hive3. Hive3 support FK/PK constraints now. I want to confim that if this feature(hive relationship automatic collect) will be released in next updates.
user
12-08-2021 09:42:22 -0400
code

1 Answer

Hi, At the moment, Hive 2.0 is supported as the data source in Denodo. You can take a look at the [Supported JDBC Data Sources](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/appendix/supported_jdbc_data_sources/supported_jdbc_data_sources) section of the Virtual DataPort Administration Guide for more information. Additionally, if you still need clarifications regarding Hive 3 support in future Denodo Platform updates and if you are a user with valid support access then you can create a support case in [Denodo Support Site](https://support.denodo.com/) so that our support team will assist you further. Hope this helps!
Denodo Team
13-08-2021 08:00:01 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here