https://community.qlik.com/t5/Talend-Studio/Illegal-conversion-BIGDECIMAL-error-for-extracting-hive-table/m-p/2362452#M126590 Hive does not support the method getBigDecimal and so throw exception. I changed my data schema (using double instead of Bigdecimal). This works. Fri, 24 Feb 2017 12:51:38 GMT _AnonymousUser 2017-02-24T12:51:38Z https://community.qlik.com/t5/Talend-Studio/Illegal-conversion-BIGDECIMAL-error-for-extracting-hive-table/m-p/2362450#M126588 Hi,<BR />I am getting below error when I tried running my job which extracts the data from hive table using tHiveConnection and passing to tLogRow.<BR />Details of connection are:- Version Distribution:- Amazon EMR ,Version:EMR4.0.0(HIVE 1.0.0) and HIVE SERVER: Hive 2<BR /><B><U>Error message:-</U></B><BR />Starting job j300_Ext_Agency_Hive_To_DataVault at 10:52 10/06/2016.<BR /> connecting to socket on port 3358<BR /> connected<BR /> connecting to socket on port 4796<BR /> connected<BR />Exception in component tHiveInput_1<BR />java.sql.SQLException: Illegal conversion<BR />at org.apache.hive.jdbc.HiveBaseResultSet.getBigDecimal(HiveBaseResultSet.java:122)<BR />at bi_poc_mi.j300_ext_agency_hive_to_datavault_0_1.j300_Ext_Agency_Hive_To_DataVault.tHiveInput_1Process(j300_Ext_Agency_Hive_To_DataVault.java:3333)<BR />at bi_poc_mi.j300_ext_agency_hive_to_datavault_0_1.j300_Ext_Agency_Hive_To_DataVault.tHiveConnection_1Process(j300_Ext_Agency_Hive_To_DataVault.java:499)<BR />at bi_poc_mi.j300_ext_agency_hive_to_datavault_0_1.j300_Ext_Agency_Hive_To_DataVault.runJobInTOS(j300_Ext_Agency_Hive_To_DataVault.java:4896)<BR />at bi_poc_mi.j300_ext_agency_hive_to_datavault_0_1.j300_Ext_Agency_Hive_To_DataVault.main(j300_Ext_Agency_Hive_To_DataVault.java:4746)<BR /> disconnected<BR /> disconnected<BR />Job j300_Ext_Agency_Hive_To_DataVault ended at 10:52 10/06/2016. <BR />Any idea on this error please? Fri, 10 Jun 2016 11:23:00 GMT https://community.qlik.com/t5/Talend-Studio/Illegal-conversion-BIGDECIMAL-error-for-extracting-hive-table/m-p/2362450#M126588 Anonymous 2016-06-10T11:23:00Z https://community.qlik.com/t5/Talend-Studio/Illegal-conversion-BIGDECIMAL-error-for-extracting-hive-table/m-p/2362451#M126589 Any ideas on the above issue please? Mon, 13 Jun 2016 14:17:04 GMT https://community.qlik.com/t5/Talend-Studio/Illegal-conversion-BIGDECIMAL-error-for-extracting-hive-table/m-p/2362451#M126589 Anonymous 2016-06-13T14:17:04Z https://community.qlik.com/t5/Talend-Studio/Illegal-conversion-BIGDECIMAL-error-for-extracting-hive-table/m-p/2362452#M126590 Hive does not support the method getBigDecimal and so throw exception. I changed my data schema (using double instead of Bigdecimal). This works. Fri, 24 Feb 2017 12:51:38 GMT https://community.qlik.com/t5/Talend-Studio/Illegal-conversion-BIGDECIMAL-error-for-extracting-hive-table/m-p/2362452#M126590 _AnonymousUser 2017-02-24T12:51:38Z