retrieving date from Hive to talend Illegal conversion issue

[TamilM]

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

[Anonymous · Accepted solution]

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