Yes, please still file a JIRA (ideally with a simple reproducer). Thanks! James
On Thu, May 28, 2015 at 11:06 PM, divye sheth <[email protected]> wrote: > I was able to get the IN operator working on STRING's. The issue was on my > end, while creating the table I used CHAR instead of VARCHAR as the > datatype. > > The IN operator works fine when the datatype is VARCHAR but fails to return > a value if it is CHAR. Mondrian returns a result with values when VARCHAR > is used but the issue persists when used with CHAR. I verified one another > thing, if I have a single character in the field declared as CHAR(50) the > IN operator works fine, also it works well when there is only one string in > the CHAR(50) field. > > Should I still go ahead and raise a Jira? > > Thanks! > Divye Sheth > > On Thu, May 28, 2015 at 11:14 PM, James Taylor <[email protected]> > wrote: > >> Please file a JIRA if you haven't already (ideally with a reproducible test >> case). >> Thanks, >> James >> >> On Thursday, May 28, 2015, Marek Wiewiorka <[email protected]> >> 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 <[email protected] >> > <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 >> > > >> > >>
