You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@phoenix.apache.org by "tom thmas (JIRA)" <ji...@apache.org> on 2018/02/21 14:06:00 UTC

[jira] [Created] (PHOENIX-4622) Phoenix 4.13 order by issue

tom thmas created PHOENIX-4622:
----------------------------------

             Summary: 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


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