question Re: [Cloudera][JDBC](10140) Error converting value to long in Support Questions

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

LDAP — Wed, 02 Apr 2025 12:47:10 GMT

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.

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

cjervis — Wed, 02 Apr 2025 16:16:39 GMT

Welcome to the community @LDAP . While you are waiting for someone more knowledgable than me to reply, can you perhaps add some more context here? For instance what versions of Spark and JDBC are you using?

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

LDAP — Wed, 02 Apr 2025 17:10:24 GMT

Correction - I’m using cloudera hive jdbc driver 2.6.21.1025

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

caio_contente — Mon, 07 Apr 2025 22:46:07 GMT

Hi @LDAP , since you mentioned that the same query is working fine on Hue, could you try to set UseNativeQuery=1 on your driver configuration and retry the query.

Reference: https://docs.cloudera.com/documentation/other/connectors/hive-jdbc/2-6-26/Cloudera-JDBC-Connector-for-Apache-Hive-Install-Guide.pdf (page 109)