You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by Juan Pablo Gardella <ga...@gmail.com> on 2018/08/25 04:07:26 UTC
Empty row when using OFFSET + LIMIT
Hi all,
Today I faced a bug -I think-. I'm using Phoenix shipped
<https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.3/bk_release-notes/content/patch_phoenix.html>at
HDP 2.6.3
<https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.3/index.html>. I
have a table defined as:
create table test (
id VARCHAR not null primary key,
json VARCHAR,
nifi_capture_ts TIMESTAMP
)
It has 2559774 rows. If I execute the following query, it returns a row
with a null value.
select * from
(
SELECT ID
FROM test
LIMIT 100000 OFFSET 100000
)
where ID is null
I was reviewing the git logs and I didn't see any commit related to
that[1]. Notice the query for OFFSET and LIMIT lowers than 10000 does not
fail. I've attached a capture of the query results.
[image: image.png]
Notice if I execute SELECT ID FROM test WHERE ID IS NULL returns an empty
result as expected.
[image: image.png]
Let me know if I should file a ticket at JIRA. For now I'm unable to verify
with a newer server, but AFAIK there is no commit related to that from
today until version 4.7.0.
Thanks in advance,
Juan
[1] Similar but not equal is PHOENIX-3422
<https://issues.apache.org/jira/browse/PHOENIX-3342>. The results is no
data instead of null row.
Re: Empty row when using OFFSET + LIMIT
Posted by Juan Pablo Gardella <ga...@gmail.com>.
Done at https://issues.apache.org/jira/browse/PHOENIX-4869
On Sat, 25 Aug 2018 at 15:32 Thomas D'Silva <td...@salesforce.com> wrote:
> Juan,
>
> Can you please create a JIRA that allows us to repro this in a test?
>
> Thanks,
> Thomas
>
> On Fri, Aug 24, 2018 at 9:12 PM, Juan Pablo Gardella <
> gardellajuanpablo@gmail.com> wrote:
>
>> Hi all,
>>
>> Today I faced a bug -I think-. I'm using Phoenix shipped
>> <https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.3/bk_release-notes/content/patch_phoenix.html>at
>> HDP 2.6.3
>> <https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.3/index.html>. I
>> have a table defined as:
>>
>> create table test (
>>
>> id VARCHAR not null primary key,
>>
>> json VARCHAR,
>>
>> nifi_capture_ts TIMESTAMP
>>
>> )
>>
>>
>> It has 2559774 rows. If I execute the following query, it returns a row
>> with a null value.
>>
>>
>> select * from
>>
>> (
>>
>> SELECT ID
>>
>> FROM test
>>
>> LIMIT 100000 OFFSET 100000
>>
>> )
>>
>> where ID is null
>>
>>
>> I was reviewing the git logs and I didn't see any commit related to
>> that[1]. Notice the query for OFFSET and LIMIT lowers than 10000 does not
>> fail. I've attached a capture of the query results.
>>
>> [image: image.png]
>> Notice if I execute SELECT ID FROM test WHERE ID IS NULL returns an
>> empty result as expected.
>>
>> [image: image.png]
>> Let me know if I should file a ticket at JIRA. For now I'm unable to
>> verify with a newer server, but AFAIK there is no commit related to that
>> from today until version 4.7.0.
>>
>> Thanks in advance,
>> Juan
>>
>> [1] Similar but not equal is PHOENIX-3422
>> <https://issues.apache.org/jira/browse/PHOENIX-3342>. The results is no
>> data instead of null row.
>>
>>
>
>
Re: Empty row when using OFFSET + LIMIT
Posted by Thomas D'Silva <td...@salesforce.com>.
Juan,
Can you please create a JIRA that allows us to repro this in a test?
Thanks,
Thomas
On Fri, Aug 24, 2018 at 9:12 PM, Juan Pablo Gardella <
gardellajuanpablo@gmail.com> wrote:
> Hi all,
>
> Today I faced a bug -I think-. I'm using Phoenix shipped
> <https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.3/bk_release-notes/content/patch_phoenix.html>at
> HDP 2.6.3
> <https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.3/index.html>. I
> have a table defined as:
>
> create table test (
>
> id VARCHAR not null primary key,
>
> json VARCHAR,
>
> nifi_capture_ts TIMESTAMP
>
> )
>
>
> It has 2559774 rows. If I execute the following query, it returns a row
> with a null value.
>
>
> select * from
>
> (
>
> SELECT ID
>
> FROM test
>
> LIMIT 100000 OFFSET 100000
>
> )
>
> where ID is null
>
>
> I was reviewing the git logs and I didn't see any commit related to
> that[1]. Notice the query for OFFSET and LIMIT lowers than 10000 does not
> fail. I've attached a capture of the query results.
>
> [image: image.png]
> Notice if I execute SELECT ID FROM test WHERE ID IS NULL returns an empty
> result as expected.
>
> [image: image.png]
> Let me know if I should file a ticket at JIRA. For now I'm unable to
> verify with a newer server, but AFAIK there is no commit related to that
> from today until version 4.7.0.
>
> Thanks in advance,
> Juan
>
> [1] Similar but not equal is PHOENIX-3422
> <https://issues.apache.org/jira/browse/PHOENIX-3342>. The results is no
> data instead of null row.
>
>
Empty row when using OFFSET + LIMIT
Posted by Juan Pablo Gardella <ga...@gmail.com>.
Hi all,
Today I faced a bug -I think-. I'm using Phoenix shipped
<https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.3/bk_release-notes/content/patch_phoenix.html>at
HDP 2.6.3
<https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.3/index.html>. I
have a table defined as:
create table test (
id VARCHAR not null primary key,
json VARCHAR,
nifi_capture_ts TIMESTAMP
)
It has 2559774 rows. If I execute the following query, it returns a row
with a null value.
select * from
(
SELECT ID
FROM test
LIMIT 100000 OFFSET 100000
)
where ID is null
I was reviewing the git logs and I didn't see any commit related to
that[1]. Notice the query for OFFSET and LIMIT lowers than 10000 does not
fail. I've attached a capture of the query results.
[image: image.png]
Notice if I execute SELECT ID FROM test WHERE ID IS NULL returns an empty
result as expected.
[image: image.png]
Let me know if I should file a ticket at JIRA. For now I'm unable to verify
with a newer server, but AFAIK there is no commit related to that from
today until version 4.7.0.
Thanks in advance,
Juan
[1] Similar but not equal is PHOENIX-3422
<https://issues.apache.org/jira/browse/PHOENIX-3342>. The results is no
data instead of null row.