Try this as a workaround: select * from account_service_history where TO_CHAR(ash_id) LIKE '217%'
Thanks, James On Mon, Jun 9, 2014 at 10:28 AM, James Taylor <jamestay...@apache.org> wrote: > Please file a JIRA here: https://issues.apache.org/jira/browse/PHOENIX > and include the query plus your create table statement. > Thanks, > James > > On Mon, Jun 9, 2014 at 1:33 AM, Ramya S <ram...@suntecgroup.com> wrote: >> >> Tried the same query using CAST but it shows type mismatch error as : Type >> mismatch. INTEGER and VARCHAR for ASH_ID >> >> Please help to solve... >> >> >> >> Thanks >> Ramya.S >> >> >> ________________________________ >> >> From: James Taylor [mailto:jamestay...@apache.org] >> Sent: Mon 6/9/2014 10:46 AM >> To: user >> Subject: Re: LIKE operator in Phoenix >> >> >> >> You can do the following instead: >> >> select * from account_service_history where CAST(ash_id AS VARCHAR) >> LIKE '217%'; >> >> If this is a common operation, might be better to use VARCHAR instead >> of INTEGER for your column type. >> >> Thanks, >> James >> >> On Sun, Jun 8, 2014 at 10:08 PM, Ramya S <ram...@suntecgroup.com> wrote: >>> Hi, >>> >>> >>> Consider the below query as an example, where the ASH_ID column is INTEGER >>> type. >>> >>> select * from account_service_history where ash_id LIKE '217%'; >>> >>> >>> While firing such a query in phoenix gives a type mismatch error. >>> >>> Does phoenix handles type cast of Integer/Double to a string internally? >>> >>> >>> >>> Thanks >>> >>> Ramya.S >>> >>> >>> ________________________________ >>> >>> From: James Taylor [mailto:jamestay...@apache.org] >>> Sent: Mon 6/9/2014 9:48 AM >>> To: user >>> Subject: Re: LIKE operator in Phoenix >>> >>> >>> >>> Can you give an example of what you mean? LIKE is for strings, but you >>> can cast an Integer/Double to a string. >>> >>> Thanks, >>> James >>> >>> On Sun, Jun 8, 2014 at 9:02 PM, Ramya S <ram...@suntecgroup.com> wrote: >>>> >>>> >>>> Does the LIKE operator in phoenix support Integer/Double column values ? >>>> >>>> >>>> >>>> Thanks >>>> Ramya.S >>>> >>>> >>> >>> >> >>
