[Cloudera][JDBC](10140) Error converting value to long

Hello, I’m getting the above error when running this query.

select count(*) from table where created_on >= date_sub(current_date(),100));

I tried casting the count to int, then I get the same error with “int” in place of “long”.

If I remove the where clause, it works just fine.

If I execute the same query in hue, I get the results back without error.

Any ideas on why this is happening and any workarounds?

Thank you.