Hi Hive Users, I noticed that the setting hive.strict.checks.type.safety is being honored in predicates:
set hive.mapred.mode=strict; set hive.strict.checks.type.safety=true; select * from all_types_table1 where col_bigint='3523524643643634634636553656563'; Throws the following error as expected Unsafe compares between different types are disabled for safety reasons There is no error for a query which compares varchar and bigint within a join condition though: select a.col_tinyint as x from example.all_types_table1 a join example.all_types_table2 b where a.col_bigint = b.col_varchar; Any recommendations on how to prevent unsafe comparisons on join conditions from our users? We are using hive 2.3.6 release. -- Arup Malakar