[resolved] HiveDB Connection needs my own SerDe

Anonymous — Sat, 16 Nov 2024 11:02:27 GMT

Hi. I'm trying to connect Open studio to Hive.

In Hive i have table with custom defined fields.
Open studio find table without problems, but if I try to Retrieve Schema i get such error:

pasteboard.co/NKgzjal.png

And in talend log i get:

!ENTRY org.talend.platform.logging 4 0 2015-09-21 10:49:12.375
!MESSAGE 2015-09-21 10:49:12,372 ERROR org.talend.commons.exception.CommonExceptionHandler  - java.lang.reflect.InvocationTargetException

!STACK 0
java.sql.SQLException: java.lang.reflect.InvocationTargetException
	at org.talend.metadata.managment.hive.EmbeddedHiveDataBaseMetadata.getColumns(EmbeddedHiveDataBaseMetadata.java:401)
	at org.talend.core.model.metadata.builder.database.manager.ExtractManager.getColumnsResultSet(ExtractManager.java:844)
	at org.talend.core.model.metadata.builder.database.manager.ExtractManager.extractColumns(ExtractManager.java:641)
	at org.talend.core.model.met

To see the whole post, download it here

Re: [resolved] HiveDB Connection needs my own SerDe

Anonymous — Tue, 06 Oct 2015 10:14:08 GMT

Hi
I solved this problem.
I changed Hive connection settings from Embedded to standalone.
By default standalone connection is trying to read/write to Hive metastore. But all settings points on Hiveserver2. So i got this java.lang.reflect.InvocationTargetException
With standalone it uses Hiveserver2.

topic [resolved] HiveDB Connection needs my own SerDe in Talend Studio

[resolved] HiveDB Connection needs my own SerDe

Re: [resolved] HiveDB Connection needs my own SerDe