Please file a JIRA if you haven't already (ideally with a reproducible test
case).
Thanks,
James
On Thursday, May 28, 2015, Marek Wiewiorka <marek.wiewio...@gmail.com>
wrote:
> Hi,
> I experienced exactly the same issue yesterday.
> I tried to run query with IN operator - I tested it in sqlline and it was
> fine.
> When I tried to run it over jdbc I got strange exception in the log.
> I end up rewriting the query into series of conditions joined with AND/OR
> operators.
>
> Marek
>
> 2015-05-28 11:47 GMT+02:00 divye sheth <divs.sh...@gmail.com
> <javascript:;>>:
>
> > Hi,
> >
> > I am trying to integrate Mondrian with Phoenix and face some issues:
> > Mondrian version: 4.3
> > Phoenix Version: 4.4
> > Hbase: 0.98
> >
> > Mondrian is able to get data from Phoenix in most of the cases but fails
> > when there is an IN operator involved.
> >
> > I verified using the sqlline cli, Phoenix works fine when the IN clause
> is
> > applied to INTEGERS or one STRING
> > e.g.
> > select emp_id from employee where emp_id IN (1,2,3,4); //this works fine
> >
> > select name from employee where name IN ('divye'); //even this works fine
> >
> > *select name from employee where name IN ('divye', 'sheth');* //no result
> > returned
> >
> > when a list of STRINGs are given to the IN clause, phoenix does not
> return
> > any result. I have verified that the values are present and are in proper
> > case as well.
> >
> > I am trying to figure out how mondrian generates sql from mdx so that I
> can
> > modify the IN clause to a series of OR conditions, so far I have not been
> > able to figure that out.
> >
> > In the meantime if someone can throw some light on how can I have phoenix
> > accept STRINGS in the IN clause that would be very helpful.
> >
> > Thanks
> > Divye Sheth
> >
>
