Viewing data in Hive tables inside Talend

Five Stars

Viewing data in Hive tables inside Talend

Hi All,

 

What are the different ways to view Hive tables in Integration perspective.

 

Also, can we also view the hive tables in profiling perspective?


Accepted Solutions
Moderator

Re: Viewing data in Hive tables inside Talend

Hello,

The databases you can analyze from the Studio include Hive.

You can analyze the content of a database to have an overview of the number of tables in the database, rows per table and indexes and primary keys. So far, you can not display the key details of tables in a Hive connection.

TalendHelpCenter: Profiling database content

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

All Replies
Moderator

Re: Viewing data in Hive tables inside Talend

Hello,

Please refer to this online document about:TalendHelpCenter: Supported Hive distributions for profiling data

Let us know if it is what you are looking for.

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

Re: Viewing data in Hive tables inside Talend

Hi Sabrina,

 

My query is how to view the data in the Hive data inside the Integration and Profiling perspective?

 

Is there an option to right click some component and preview data?

 

Thanks

Moderator

Re: Viewing data in Hive tables inside Talend

Hello,

If you often need to use a database table from Hive, then you may want to centralize the connection information to the Hive database and the table schema details in the Metadata folder in the Repository tree view.

Please have a look at this online document about:TalendHelpCenter:Centralizing Hive metadata and feel free to let us know if it is what you are looking for.

Best regards

Sabrina

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Highlighted
Five Stars

Re: Viewing data in Hive tables inside Talend

Hi, Partially I got what I was looking for. However, is it also possible to view Hive data in Profiling perspective?

 

The solution you have suggested is for Integration perspective. 

Moderator

Re: Viewing data in Hive tables inside Talend

Hello,

The databases you can analyze from the Studio include Hive.

You can analyze the content of a database to have an overview of the number of tables in the database, rows per table and indexes and primary keys. So far, you can not display the key details of tables in a Hive connection.

TalendHelpCenter: Profiling database content

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now