framework/resources/Functional/hive/hive_functions/hex_floor.q

select hex(floor(cast(24710.35 as double))) from hive.tpch01_parquet_nodate.lineitem limit 1;