phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <jamestay...@apache.org>
Subject Re: Mondrian with Phoenix
Date Mon, 01 Jun 2015 23:54:58 GMT
Yes, please still file a JIRA (ideally with a simple reproducer).
Thanks!
James

On Thu, May 28, 2015 at 11:06 PM, divye sheth <divs.sheth@gmail.com> 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 <jamestaylor@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.wiewiorka@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.sheth@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
>> > >
>> >
>>

Mime
View raw message