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?