Viewing data in Hive tables inside Talend

[Anonymous]

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?

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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. 

[Anonymous · Accepted solution]

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