Six Stars

retrieving date from Hive to talend Illegal conversion issue

can anyone please tell me where I need to change this settings with screenshots,

Metadata of Talendtype for the Bigdecimal as "id_Long" as true.
<dbType type="BIGINT">
<talendType type="id_BigDecimal"/>
<talendType type="id_Byte"/>
<talendType type="id_Integer"/>
<talendType type="id_Long" default="true"/>
</dbType>
 I'm facing same similar issue while converting to Bigint and other data types (like float and double) from Hive to Talend and to sql server target.

also can anyone explain is detail of Mapping tables between hive type and Talend data type in talend

Tags (1)
1 REPLY
Moderator

Re: retrieving date from Hive to talend Illegal conversion issue

Hello,

In your Studio, you  can click Project setting icon in the tools bar to open the Project setting window, then expand General > Metadata of TalendType

You'll find the metadata Mapping to resolve DataType to TalendType.

Please refer to this article for more details https://community.talend.com/t5/Migration-Configuration-and/Changing-the-default-data-type-mapping/t...

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.