[ 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)