[PHOENIX-4622] Phoenix 4.13 order by issue

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Duplicate
• Affects Version/s: 4.13.1

Environment

phoenix 4.13

hbase 1.2.5

• Assignee: Unassigned
• Reporter: tom thmas
• Created: 21/Feb/18 14:05
• Updated: 07/Mar/21 00:51
• Resolved: 07/Mar/21 00:51

Description

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:

org.apache.phoenix.exception.PhoenixIOException: org.apache.hadoop.hbase.DoNotRetryIOException: TEST2,,1519221167250.813e4ce0510965a7a7898413da2a17ad.: null

 

Issue Links

• is duplicated by: PHOENIX-4933 DELETE FROM throws NPE when a local index is present