Illegal conversion BIGDECIMAL error for extracting hive table job
Hi, I am getting below error when I tried running my job which extracts the data from hive table using tHiveConnection and passing to tLogRow. Details of connection are:- Version Distribution:- Amazon EMR ,Version:EMR4.0.0(HIVE 1.0.0) and HIVE SERVER: Hive 2 Error message:- Starting job j300_Ext_Agency_Hive_To_DataVault at 10:52 10/06/2016. connecting to socket on port 3358 connected connecting to socket on port 4796 connected Exception in component tHiveInput_1 java.sql.SQLException: Illegal conversion at org.apache.hive.jdbc.HiveBaseResultSet.getBigDecimal(HiveBaseResultSet.java:122) 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) 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) 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) 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) disconnected disconnected Job j300_Ext_Agency_Hive_To_DataVault ended at 10:52 10/06/2016. Any idea on this error please?
