Reply
Explorer
Posts: 11
Registered: ‎07-28-2016

How to do Module operation in Apache phoenix?

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...

Cloudera Employee
Posts: 88
Registered: ‎01-08-2014

Re: How to do Module operation in Apache phoenix?

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