You can translate the question and the replies:

Unable to create Base View (Cannot find columns)

It seems that I am unable to create base views from hive external tables in VDP. The error thrown states that they are unable to find the columns associated with the external table. Any reason for this? (com.denodoutil.exceptions.InternalErrorException: Unable to find columns) . . (Base views created on normal hive tables are fine)
user
21-10-2020 21:46:53 -0400

1 Answer

Hi, I am able to successfully create a base view from the hive external tables by creating a [JDBC datasource](https://community.denodo.com/docs/html/browse/latest/vdp/administration/creating_data_sources_and_base_views/jdbc_sources/jdbc_sources#jdbc-sources). Hence i would suggest you to check the VDP.log file for additional information. Additionally, you can check the version of the Database Adapter matches the JDBC driver you have used. Also, i would recommend you to try connecting to the Hive datasource from the other third party client tool (such as DBViusalizer) using the same JDBC driver and try executing the select on top of external table you are referring to. By the way you can isolate whether the problem is related to the JDBC driver or Denodo Platform. Suppose, If you still need help and if you are a user with valid support access then you can raise a support case in [Denodo Support Site](https://support.denodo.com/) so that our support team can assist you. Hope this helps!
Denodo Team
22-10-2020 03:39:15 -0400
You must sign in to add an answer. If you do not have an account, you can register here