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

Posted to user@phoenix.apache.org by pierre lacave <pi...@lacave.me> on 2015/12/04 19:21:40 UTC

Row timestamp support in 4.6

Hi,

I am trying to use the ROW_TIMESTAMP mapping featured in 4.6 as described
in https <https://phoenix.apache.org/rowtimestamp.html>://
<https://phoenix.apache.org/rowtimestamp.html>phoenix.apache.org
<https://phoenix.apache.org/rowtimestamp.html>/
<https://phoenix.apache.org/rowtimestamp.html>rowtimestamp.html
<https://phoenix.apache.org/rowtimestamp.html>

However when inserting a timestamp in nanosecond I get the following
exception saying the value cannot be less than zero?

Inserting micros,micros or sec result in same result?

Any idea what's happening?

Thanks

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)

Re: Row timestamp support in 4.6

Posted by pierre lacave <pi...@lacave.me>.

Thanks Samarth,

It does work with BIGINT, which is fine for my use case.

I raised https://issues.apache.org/jira/browse/PHOENIX-2493 for the
UNSIGNED_LONG issue

*Pierre Lacave*
171 Skellig House, Custom House, Lower Mayor street, Dublin 1, Ireland
Phone :       +353879128708

On Fri, Dec 4, 2015 at 8:04 PM, Samarth Jain <sa...@apache.org> wrote:

> Pierre,
>
> Thanks for reporting this. Do you mind filing a JIRA? Also, as a
> workaround, can you check if changing the data type from UNSIGNED_LONG to
> BIGINT resolves the issue?
>
> -Samarth
>
>
> On Friday, December 4, 2015, pierre lacave <pi...@lacave.me> wrote:
>
>>
>> Hi,
>>
>> I am trying to use the ROW_TIMESTAMP mapping featured in 4.6 as described
>> in https <https://phoenix.apache.org/rowtimestamp.html>://
>> <https://phoenix.apache.org/rowtimestamp.html>phoenix.apache.org
>> <https://phoenix.apache.org/rowtimestamp.html>/
>> <https://phoenix.apache.org/rowtimestamp.html>rowtimestamp.html
>> <https://phoenix.apache.org/rowtimestamp.html>
>>
>> However when inserting a timestamp in nanosecond I get the following
>> exception saying the value cannot be less than zero?
>>
>> Inserting micros,micros or sec result in same result?
>>
>> Any idea what's happening?
>>
>> Thanks
>>
>> 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)
>>
>

Re: Row timestamp support in 4.6

Posted by Samarth Jain <sa...@apache.org>.

Pierre,

Thanks for reporting this. Do you mind filing a JIRA? Also, as a
workaround, can you check if changing the data type from UNSIGNED_LONG to
BIGINT resolves the issue?

-Samarth

On Friday, December 4, 2015, pierre lacave <pi...@lacave.me> wrote:

>
> Hi,
>
> I am trying to use the ROW_TIMESTAMP mapping featured in 4.6 as described
> in https <https://phoenix.apache.org/rowtimestamp.html>://
> <https://phoenix.apache.org/rowtimestamp.html>phoenix.apache.org
> <https://phoenix.apache.org/rowtimestamp.html>/
> <https://phoenix.apache.org/rowtimestamp.html>rowtimestamp.html
> <https://phoenix.apache.org/rowtimestamp.html>
>
> However when inserting a timestamp in nanosecond I get the following
> exception saying the value cannot be less than zero?
>
> Inserting micros,micros or sec result in same result?
>
> Any idea what's happening?
>
> Thanks
>
> 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)
>