topic Re: Viewing data in Hive tables inside Talend in Talend Studio

Viewing data in Hive tables inside Talend

Anonymous — Sat, 16 Nov 2024 08:51:54 GMT

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?

Re: Viewing data in Hive tables inside Talend

Anonymous — Tue, 16 Jan 2018 07:47:43 GMT

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

Re: Viewing data in Hive tables inside Talend

Anonymous — Tue, 16 Jan 2018 08:44:49 GMT

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

Re: Viewing data in Hive tables inside Talend

Anonymous — Wed, 17 Jan 2018 03:28:51 GMT

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

Re: Viewing data in Hive tables inside Talend

Anonymous — Wed, 17 Jan 2018 05:21:00 GMT

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.

Re: Viewing data in Hive tables inside Talend

Anonymous — Thu, 18 Jan 2018 03:00:49 GMT

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