phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ns G <nsgns...@gmail.com>
Subject REG: Issue when querying using ilike
Date Mon, 10 Aug 2015 17:00:36 GMT
Hi All,

I am using Apache phoenix 4.3.1 version of Cloudera labs.

I have one of the column in a table like below

Name

FUR EARMUFFS BLACK ONE V
FUR EARMUFFS BLACK ONE V
T ROSE GOLD LARIAT MULTI ONE
T ROSE GOLD LARIAT MULTI ONE
UNISEX SNUGGLER IVORY ONE NV
UNISEX SNUGGLER IVORY ONE NV

so when i query like
 select * from table1 where Name ilike '%gold%';

I expect a resultset of 2 but I am always getting only one record as
output. Is this an issue previously raised?

Thanks,
Satya

Mime
View raw message