phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "JeongMin Ju (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-4622) Phoenix 4.13 order by issue
Date Tue, 27 Feb 2018 07:08:00 GMT

    [ https://issues.apache.org/jira/browse/PHOENIX-4622?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16378149#comment-16378149
] 

JeongMin Ju commented on PHOENIX-4622:
--------------------------------------

In version 4.13, the [preStoreScannerOpen|https://github.com/apache/phoenix/blob/v4.13.2-cdh5.11.2/phoenix-core/src/main/java/org/apache/phoenix/coprocessor/BaseScannerRegionObserver.java#L361-L375]
method has been added to the BaseScannerRegionObserver class.

This was the cause of the error.

Even if the plan is a reverse scan, a StoreScanner is created and returned. But in case of
reverse scan, ReverseStoreScanner should be returned.

This is fixed when the scan.isReversed () condition is added to the if statement.

 
{code:java}
if (scan.isRaw() || scan.isReversed () || ScanInfoUtil.isKeepDeletedCells(store.getScanInfo())
|| scan.getTimeRange().getMax() == HConstants.LATEST_TIMESTAMP || TransactionUtil.isTransactionalTimestamp(scan.getTimeRange().getMax()))
{
    return s;
}
{code}
 

I hope to be corrected soon.

I can not upgrade because of this problem.

 

> Phoenix 4.13 order by issue
> ---------------------------
>
>                 Key: PHOENIX-4622
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-4622
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.13.1
>         Environment: phoenix 4.13
> hbase 1.2.5
>            Reporter: tom thmas
>            Priority: Critical
>
> *1.create table and insert data.*
> create table test2
> (
>  id varchar(200) primary key,
>  cardid varchar(200),
>  ctime date 
> )
> upsert into test2 (id,cardid,ctime) values('a1','123',to_date('2017-12-01 17:42:45'))
> *2.query sql like this:*
> select id,ctime from test2  where cardid='123' order by ctime
> error log:
> {color:#FF0000}org.apache.phoenix.exception.PhoenixIOException: org.apache.hadoop.hbase.DoNotRetryIOException:
TEST2,,1519221167250.813e4ce0510965a7a7898413da2a17ad.: null{color}
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message