Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

How to do Module operation in Apache phoenix?

How to do Module operation in Apache phoenix?

Explorer

SELECT * from test123.test3 where id2%10 <>0;

 

 

but, it is giving me an error as 

 

ERROR 203 (22005): Type mismatch. DOUBLE for (ID2 % 10) (state=22005,code=203)

 

 

Please help me resolve...

1 REPLY 1

Re: How to do Module operation in Apache phoenix?

Expert Contributor
the modulus operator doesn't work on DOUBLE fields. the error looks
like your "ID2" field is a double.