[resolved] HiveDB Connection needs my own SerDe

[Anonymous]

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

[Anonymous · Accepted solution]

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.