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
