FU

Friday, February 12th, 2021 4:00 PM

Import Hive data into Collibra

Has anyone had luck importing Hive data into Collibra? I have a JDBC connection working with Squirrel. When I try the “generic” driver option as well as Cloudera or Hortonworks I get a message: “Empty ingestion results have been returned for schema”. There’s no error message, it’s just an empty dictionary. In contacting Collibra support they mentioned they only support Hive v2 and we’re running Hive v3 (via CDP). However, with a generic JDBC driver, it should at least be able to pull in the tables and columns no?

Thanks

1.2K Messages

3 years ago

If you mean Hive metadata, we bring in the metadata for several databases and tables from CDH 6.3 into DGC. If you mean actual data inside the tables, we don’t do that, but I imagine that would Mule or some such integration engine. DGC does not have the ability to bring in data from inside tables, to my knowledge. Happy to be corrected.

1.2K Messages

3 years ago

Hi Patrick - There is marketplace driver for HIVE - https://marketplace.collibra.com/listings/jdbc-driver-for-cloudera-hive/, these are typically fully supported and tested.

Loading...