[jira] [Commented] (PHOENIX-2493) ROW_TIMESTAMP mapping not functional with UNSIGNED_LONG column type

["James Taylor (JIRA)" <ji...@apache.org>]

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

James Taylor commented on PHOENIX-2493:
---------------------------------------

[~samarthjain] - was this fixed? If so, please set fixedVersion and close it.

> ROW_TIMESTAMP mapping not functional with UNSIGNED_LONG column type
> -------------------------------------------------------------------
>
>                 Key: PHOENIX-2493
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-2493
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.6.0
>         Environment: java version "1.7.0_79"
> OpenJDK Runtime Environment (IcedTea 2.5.6) (7u79-2.5.6-0ubuntu1.14.04.1)
>            Reporter: Pierre Lacave
>
> Hi,
> Using the ROW_TIMESTAMP feature on an UNSIGNED_LONG column doesn't work on 4.6.
> It does work as expected if the column type is BIGINT however.
> Thanks
> {noformat}
> 0: jdbc:phoenix:hadoop1-dc:2181:/hbase> CREATE TABLE TEST (t UNSIGNED_LONG NOT NULL CONSTRAINT pk PRIMARY KEY (t ROW_TIMESTAMP) );
> No rows affected (1.654 seconds)
> 0: jdbc:phoenix:hadoop1-dc:2181:/hbase> UPSERT INTO TEST (t) VALUES (1449161081000000001);
> Error: ERROR 201 (22000): Illegal data. Value of a column designated as ROW_TIMESTAMP cannot be less than zero (state=22000,code=201)
> java.sql.SQLException: ERROR 201 (22000): Illegal data. Value of a column designated as ROW_TIMESTAMP cannot be less than zero
> at org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:396)
> at org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:145)
> at org.apache.phoenix.schema.IllegalDataException.<init>(IllegalDataException.java:38)
> at org.apache.phoenix.compile.UpsertCompiler.setValues(UpsertCompiler.java:135)
> at org.apache.phoenix.compile.UpsertCompiler.access$400(UpsertCompiler.java:114)
> at org.apache.phoenix.compile.UpsertCompiler$3.execute(UpsertCompiler.java:882)
> at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:322)
> at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:314)
> at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
> at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:312)
> at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1435)
> at sqlline.Commands.execute(Commands.java:822)
> 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)
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)