retrieving date from Hive to talend Illegal conversion timestamp

[Anonymous]

Hello,

can someone help me with the following issue?

I get this error in my tHiveInput:
java.sql.SQLException: Illegal conversion
at org.apache.hive.jdbc.HiveBaseResultSet.getTimestamp(HiveBaseResultSet.java:577)
at routines.system.JDBCUtil.getDate(JDBCUtil.java:61)

I've already checked up the discussion "retrieving date from Hive to talend Illegal conversion issue" but didn't find the solution for the Timestamp issue.

My mapping_Hive.xml for the date type it' the following:

<talendType type="id_Date">
<dbType type="TIMESTAMP"/>
<dbType type="DATE" default="true"/>
</talendType>

[...]

<dbType type="TIMESTAMP">
<talendType type="id_Date" default="true"/>
</dbType>
<dbType type="DATE">
<talendType type="id_Date" default="true"/>
</dbType>

[manodwhb]

@Moe,check the below link will help you fix this issue.

https://community.talend.com/t5/Design-and-Development/retrieving-date-from-Hive-to-talend-Illegal-c...

[dhazarihazari]

@Manohar B​  and @Giacomo Munaretti​ and @Xiaodi Shi​ 

I'm facing same issue which is Hive(Timestamp) datatype -->converting to Talend(Date) datatype.

The solution link mentioned before did not help me since it shows WHERE to change the other datatype in talend hive config, but I need to know WHAT exact value to be changed in hive config for handling Hive(Timestamp) to Talend(Date) -- illegal conversion error.

Can you please help me this, I really need it for a demo today, thank you.

Deepti.