topic IllegalConversion error in Talend in Talend Studio

IllegalConversion error in Talend

RP1629548713 — Fri, 15 Nov 2024 23:16:14 GMT

Hi All,

I get this error in my tHiveInput:

java.sql.SQLException: Illegal conversion

at org.apache.hive.jdbc.HiveBaseResultSet.getTimestamp

I have already visited the below discussion forums,but they havent been concluded as expected:

https://community.talend.com/s/feed/0D53p00007vCqDfCAK?language=en_US

https://community.talend.com/s/question/0D53p00007vCjgACAS/retrieving-date-from-hive-to-talend-illegal-conversion-timestamp.

Can someone please help? I tried the above steps too , I changed the timestamp to DAte in the "DATE" field in the xml but I am still getting this error.

Please suggest

Re: IllegalConversion error in Talend

gjeremy1617088143 — Wed, 26 Jan 2022 14:12:21 GMT

Hi, maybe you don't have the good version of your jdbc driver.

Send me love and kudos

Re: IllegalConversion error in Talend

Anonymous — Wed, 26 Jan 2022 14:48:06 GMT

Can you show your schema configuration for this component and also show your query? It would be useful to see the schema of the table that you are querying.

Re: IllegalConversion error in Talend

RP1629548713 — Wed, 26 Jan 2022 15:46:59 GMT

I have been through the schema . All the data types are in the source and tgt are same.

And i am using a simple lookup which consists of the keys from the lookup table

Re: IllegalConversion error in Talend

Anonymous — Wed, 26 Jan 2022 17:32:18 GMT

I can't help unless I have more of an idea what you have I'm afraid.

Re: IllegalConversion error in Talend

RP1629548713 — Wed, 26 Jan 2022 18:53:42 GMT

I am just trying to join the source and a lookup hive table .I had removed all my date columns too and tried running the job i got exactly the same error.

Re: IllegalConversion error in Talend

RP1629548713 — Thu, 27 Jan 2022 13:06:44 GMT

Hi ,

Can someone please suggest ?

Re: IllegalConversion error in Talend

gjeremy1617088143 — Thu, 27 Jan 2022 13:29:52 GMT

could you send the screenshot of your error, and look the first row referenced in your exception go to the code window and send a screenshot a the first line mentioned by the exception ?