Error Reported When a Divisor in SQL Statements Is 0
Symptom
The SQL statement select max(o_bigint%o_int) from tpch_flat_orc_date_100.data_type_test_orc; returns NULL in Hive that is pushed down. Error message:
1 | io.prestosql.spi.PrestoException: Division by zero |
Key Process and Cause Analysis
The two engines use different computing mechanisms.
Conclusion and Solution
Although the native Hive returns a result, the returned result is incorrect. This error does not affect the running of Hive and can be ignored.
Parent topic: Troubleshooting