Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Getting error as Below:
Starting job hw_prod_individual at 17:32 21/07/2017.
[statistics] connecting to socket on port 3857
[statistics] connected
Exception in component tHiveInput_1
java.sql.SQLException: Illegal conversion
at org.apache.hive.jdbc.HiveBaseResultSet.getBigDecimal(HiveBaseResultSet.java:135)
at local_project.hw_prod_individual_0_1.hw_prod_individual.tHiveInput_1Process(hw_prod_individual.java:4099)
at local_project.hw_prod_individual_0_1.hw_prod_individual.tNetezzaInput_1Process(hw_prod_individual.java:2214)
at local_project.hw_prod_individual_0_1.hw_prod_individual.runJobInTOS(hw_prod_individual.java:4762)
at local_project.hw_prod_individual_0_1.hw_prod_individual.main(hw_prod_individual.java:4619)
[statistics] disconnected
Job hw_prod_individual ended at 17:32 21/07/2017. [exit code=1]
Please check the issue and help to resolve this issue.
Thanks in Advance
This looks like the code is trying to convert a field in your Hive table to BigDecimal and throwing an error: double-check all your fields to make sure you aren't trying to convert a String to a numeric value.
Good luck!
David
Hi,
Are you using method getBigDecimal in hive? Could you please try to change your data schema (using double instead of Bigdecimal) to see if it works?
Best regards
Sabrina
Thanks David for your Reply and suggestion to change the data type by using shell script and the Hive CLI.
Can you please give the sample shell script to change the table data type by using shell script and the Hive CLI.
Thanks in Advance.