Solved

How to connect to Hive Warehouse Connector?

  • 25 March 2024
  • 4 replies
  • 61 views

Userlevel 3
Badge +1

We want to profile Hive managed tables in our Cloudera data lake. This is only possible if the Hive managed table is defined as non transactional. However to turn of that feature you need to rebuild the table. We had a discussion with our architecture team and they don't want to turn off this functionality.

The other option then is using Hive Warehouse Connector. It is known that this has some performance costs. But we want to test this anyway.

Is there any documentation on using this feature?

icon

Best answer by Marcel-Jan 15 April 2024, 15:09

View original

4 replies

Badge

Hi @Marcel-Jan ,

Please find the documentation https://docs.ataccama.com/one-desktop/latest/databases/connect-to-hortonworks-hive.html . 

Hope this helps.

Thanks,

Srija 

Userlevel 3
Badge +1

Hi @srija piratla 

We already have a connection to Hive. We can profile external Hive tables, no problem.

But we can't profile (transactional) Hive managed tables. That's why we need the Hive Warehouse Connector. And this documentation does not mention that.

Userlevel 3
Badge +1

There currently is no documentation for this.

Userlevel 6
Badge +7

Hi @Marcel-Jan, I’ve passed on your feedback to our documentation team and will be sure to let you know if there are any updates on the documentation 👍

Reply