[
https://issues.apache.org/jira/browse/PHOENIX-2364?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15085186#comment-15085186
]
Hadoop QA commented on PHOENIX-2364:
------------------------------------
{color:red}-1 overall{color}. Here are the results of testing the latest
attachment
http://issues.apache.org/jira/secure/attachment/12780693/PHOENIX-2364.patch
against master branch at commit 3f9d5a87ed37d109bc406b928f599ca5a0f04f1b.
ATTACHMENT ID: 12780693
{color:green}+1 @author{color}. The patch does not contain any @author
tags.
{color:green}+1 tests included{color}. The patch appears to include 3 new
or modified tests.
{color:green}+1 javac{color}. The applied patch does not increase the
total number of javac compiler warnings.
{color:red}-1 javadoc{color}. The javadoc tool appears to have generated
33 warning messages.
{color:green}+1 release audit{color}. The applied patch does not increase
the total number of release audit warnings.
{color:green}+1 lineLengths{color}. The patch does not introduce lines
longer than 100
{color:red}-1 core tests{color}. The patch failed these unit tests:
org.apache.phoenix.query.OrderByTest
{color:red}-1 core zombie tests{color}. There are 1 zombie test(s):
at
org.apache.hadoop.hdfs.TestSetrepIncreasing.testSetrepIncreasing(TestSetrepIncreasing.java:80)
Test results:
https://builds.apache.org/job/PreCommit-PHOENIX-Build/213//testReport/
Javadoc warnings:
https://builds.apache.org/job/PreCommit-PHOENIX-Build/213//artifact/patchprocess/patchJavadocWarnings.txt
Console output:
https://builds.apache.org/job/PreCommit-PHOENIX-Build/213//console
This message is automatically generated.
> timestamp type primary key desc error
> -------------------------------------
>
> Key: PHOENIX-2364
> URL: https://issues.apache.org/jira/browse/PHOENIX-2364
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.6.0
> Reporter: soyoon park
> Fix For: 4.7.0
>
> Attachments: PHOENIX-2364.patch
>
>
> I wanted to see that I don't have to use reverse scan(HBase) by using PHOENIX
> query(constraint pk primary key DESC).
> But it did not work.
> **TESTED PHOENIX query :
> CREATE TABLE TEST_DESC (
> TIME TIMESTAMP NOT NULL,
> NAME VARCHAR
> CONSTRAINT PK PRIMARY KEY (TIME DESC)
> );
> **sample data
> UPSERT INTO TEST_DESC (TIME,NAME) VALUES (TO_TIMESTAMP(current_date()|| ' '
> || current_time()) ,'a');
> UPSERT INTO TEST_DESC (TIME,NAME) VALUES (TO_TIMESTAMP('2003-12-13
> 10:13:18',),'b');
> UPSERT INTO TEST_DESC (TIME,NAME) VALUES (CAST(current_date() AS TIMESTAMP)
> ,'c');
> SELECT * FROM TEST_DESC;
> **and then sqlline shows me error like below(sqlline)
> 0: jdbc:phoenix:data01> select * from TEST_DESC;
> +------------------------------------------+------------------------------------------+
> | TIME | NAME
> |
> +------------------------------------------+------------------------------------------+
> java.lang.IllegalArgumentException: offset (8) + length (4) exceed the
> capacity of the array: 4
> at
> org.apache.hadoop.hbase.util.Bytes.explainWrongLengthOrOffset(Bytes.java:605)
> at org.apache.hadoop.hbase.util.Bytes.toInt(Bytes.java:775)
> at org.apache.hadoop.hbase.util.Bytes.toInt(Bytes.java:761)
> at
> org.apache.phoenix.schema.types.PUnsignedInt$UnsignedIntCodec.decodeInt(PUnsignedInt.java:162)
> at
> org.apache.phoenix.schema.types.PTimestamp.toObject(PTimestamp.java:108)
> at
> org.apache.phoenix.schema.types.PTimestamp.toObject(PTimestamp.java:32)
> at
> org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:984)
> at
> org.apache.phoenix.compile.ExpressionProjector.getValue(ExpressionProjector.java:75)
> at
> org.apache.phoenix.jdbc.PhoenixResultSet.getString(PhoenixResultSet.java:601)
> at sqlline.Rows$Row.<init>(Rows.java:183)
> at sqlline.IncrementalRows.hasNext(IncrementalRows.java:63)
> at sqlline.TableOutputFormat.print(TableOutputFormat.java:33)
> at sqlline.SqlLine.print(SqlLine.java:1653)
> at sqlline.Commands.execute(Commands.java:833)
> at sqlline.Commands.sql(Commands.java:732)
> at sqlline.SqlLine.dispatch(SqlLine.java:808)
> at sqlline.SqlLine.begin(SqlLine.java:681)
> at sqlline.SqlLine.start(SqlLine.java:398)
> at sqlline.SqlLine.main(SqlLine.java:292)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
