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