Illegal conversion SQL exception in tImapla_Input

Anonymous — Sat, 16 Nov 2024 10:26:35 GMT

In my job, I create a table which has some string fields and one bigdecimal field. I load data from a file into it. Everything runs fine.
After loading data, the table looks this is:
| network_level_1_name | network_level_1_id | network_level_1_hash |
+----------------------+--------------------+----------------------+------------------
| abc | 1:abc | 4437926507370143399 |
network_level_1_hash is of type bigdecimal and other two are of type string.
When I try to retrieve that data using tImpala_Input with this query:
"select * from <TABLE NAME> order by day "
It gives me this error:
Exception in component tImpalaInput_1
java.sql.SQLException: Illegal conversion
at org.apache.hive.jdbc.HiveBaseResultSet.getBigDecimal(HiveBaseResultSet.java:128)
at tImpalaInput_1Process(comcast_woa_test_rtm.java:6446)

I am using Talend Big Data 6.2.1.
Can someone tell me why it is getting issues in retrieving a Big Decimal field?

Re: Illegal conversion SQL exception in tImapla_Input

Anonymous — Mon, 22 Aug 2016 04:49:53 GMT

Hi,
It seems that t he problem is a mismatch between the Java type of a schema column and the actual returned value from the query.
Would you mind showing us your schema setting screenshot of tImpalaInput component ?
Best regards
Sabrina

topic Re: Illegal conversion SQL exception in tImapla_Input in Talend Studio

Illegal conversion SQL exception in tImapla_Input

Re: Illegal conversion SQL exception in tImapla_Input