You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@phoenix.apache.org by Ns G <ns...@gmail.com> on 2015/09/22 14:39:41 UTC

REG: Query not working correctly

Hi Team,

I have a column with unsigned_int as the data type.
when i try to use not in clause with limit, it is not working. The outer
query is fetching the records that satisfy the query in not in condition.

Can any one suggest if this is bug?

I am using cloudera and Phoenix 4.5.1 version.

When i tried in 4.3.1 version of phoenix in cloudera it is working
correctly, but not in 4.5.1 version.

Since, the data is confidential, i am unable to share the query and data.

Thanks,
Satya.

Re: REG: Query not working correctly

Posted by Ns G <ns...@gmail.com>.
Hi James,

I have raised JIRA 2296 for the same.

Thanks,
Durgaprasad
On 22-Sep-2015 8:17 pm, "James Taylor" <ja...@apache.org> wrote:

> Hi Satya,
> It sounds like a bug from your description, but we'll need more
> information to fix it. How about a standalone test where you anonymize the
> column names?
> Thanks,
> James
>
> On Tuesday, September 22, 2015, Ns G <ns...@gmail.com> wrote:
>
>> Hi Team,
>>
>> I have a column with unsigned_int as the data type.
>> when i try to use not in clause with limit, it is not working. The outer
>> query is fetching the records that satisfy the query in not in condition.
>>
>> Can any one suggest if this is bug?
>>
>> I am using cloudera and Phoenix 4.5.1 version.
>>
>> When i tried in 4.3.1 version of phoenix in cloudera it is working
>> correctly, but not in 4.5.1 version.
>>
>> Since, the data is confidential, i am unable to share the query and data.
>>
>> Thanks,
>> Satya.
>>
>

Re: REG: Query not working correctly

Posted by James Taylor <ja...@apache.org>.
Hi Satya,
It sounds like a bug from your description, but we'll need more information
to fix it. How about a standalone test where you anonymize the column names?
Thanks,
James

On Tuesday, September 22, 2015, Ns G <ns...@gmail.com> wrote:

> Hi Team,
>
> I have a column with unsigned_int as the data type.
> when i try to use not in clause with limit, it is not working. The outer
> query is fetching the records that satisfy the query in not in condition.
>
> Can any one suggest if this is bug?
>
> I am using cloudera and Phoenix 4.5.1 version.
>
> When i tried in 4.3.1 version of phoenix in cloudera it is working
> correctly, but not in 4.5.1 version.
>
> Since, the data is confidential, i am unable to share the query and data.
>
> Thanks,
> Satya.
>