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?

1 ACCEPTED SOLUTION

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.
5 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.
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.