Illegal conversion BIGDECIMAL error for extracting hive table job

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?
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.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download