Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have successfully connected Talend to Hive, I can see the database, and I pulled data from a table in the database to a file via my Talend job.
When I attempt to retrieve schemas in the JDBC connection, I can click the database name but no tables are listed. It just fills the box next to the database name.
What permissions are needed in Hive for Talend to be able to see all the tables and retrieve schemas?
Apache Hive
3.1.3000.7.1.7.1000-141
HiveJDBC
02.06.13.1016
@Shicong Hong @Xiaodi Shi Any ideas?
Hello,
It looks like this connection check has been done already and it is working from your side.
What is the error you are facing while retrieving schema? Could you please attach the screenshot and also the complete error log?
Is there seems to be latency when retrieving the schema?
Best regards
Sabrina
The connection completes, there is no error.
There is not much to see, the tables names just don't show up under the database name.
I am pretty sure its a lack of permission, but don't know what Talend needs access to in order to request the permission.
I found this:
There are four system tables that contain metadata about the tables accessible through the HCatalog Connector:
Hello,
There will be some error messages in log if it is a permission issue.
Could you please open the error log generated automatically by the Studio to see whether you have error stack trace there; if you do, we will appreciate it a lot if you can paste it here.
About how to open this error log: in your Studio, click Window to open the menu, then select Show View->General->Error Log. Once you see an error, double click it.
Best regards
Sabrina