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 <jamestay...@apache.org>
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 <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
> > >
> >
>
