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