Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi, maybe you don't have the good version of your jdbc driver.
Send me love and kudos
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.
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
I can't help unless I have more of an idea what you have I'm afraid.
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.
Hi ,
Can someone please suggest ?
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 ?