Float equality comparison in Hive:

[shireesha chandra]

Hi,

I am new to Hive. Just wanted a small clarification on the Float equality
comparison.
For instance, to check if A is equal to 3.5, is the usage of "A>3.49 and
A<3.51" in the WHERE clause of SELECT statement correct. Or do I have to
use the following:
"(NOT (A<3.5) AND NOT(A>3.5))"
What is the standard procedure for float comparison?

Any pointers is greatly appreciated.

Thanks,
-Shiree