Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!

TDC harvest Cloudera Data Platform Hadoop Hive Database

100% helpful (1/1)
cancel
Showing results for 
Search instead for 
Did you mean: 
TalendSolutionExpert
Contributor II
Contributor II

TDC harvest Cloudera Data Platform Hadoop Hive Database

Last Update:

Feb 9, 2024 2:55:50 PM

Updated By:

Jamie_Gregory

Created date:

Nov 10, 2023 3:52:37 AM

[Background]
-TDC 8.0.1
-CDP 7.1.7

[Requirent]
-How to create a Cloudera Data Platform Hadoop Hive Database model in TDC

Create a hive model, The configuration details of each parameter are shown in the following figure:
0EM5b00000E5atF.png


Hive is not a relational database, so it requires many JDBC dependencies that we cannot locate one by one, so I used Talens studio to create a job with a design like this: tHiveConnection->tJAVA(OnSubjobOK), then build this job create all libraries for hive connection, put it this folder to Java library directory of Hive model.
0EM5b00000E5asl.png

0EM5b00000E5aqa.png

Then we can harvest Hive database structure:
0EM5b00000E5avB.png
Labels (1)
Version history
Last update:
‎2024-02-09 02:55 PM
Updated by: