One Star

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?
2 REPLIES
One Star

Re: Illegal conversion BIGDECIMAL error for extracting hive table job

Any ideas on the above issue please?
One Star

Re: Illegal conversion BIGDECIMAL error for extracting hive table job

Hive does not support the method getBigDecimal and so throw exception. I changed my data schema (using double instead of Bigdecimal). This works.