and any reason why PERCENTILE supports floats but PERCENTILEEST works on longs/ints only ?

PERCENTILEEST uses the QuantileDigest data structure to estimate the percentile, which only takes integral numbers. floating numbers will be converted to integral numbers. For floating numbers, you can use PERCENTILETDIGEST instead.

When I tried it it didn’t convert, just failed with exception.