Hello! Yes, you are right, according to https://issues.apache.org/jira/browse/IGNITE-11472 TIMESTAMP WITH TIME ZONE not supported by Ignite.
I think you will have to work around this quirky behavior. I have left a comment about this issue specifically. Regards, -- Ilya Kasnacheev пн, 27 апр. 2020 г. в 15:15, dbutkovic <[email protected]>: > Hi Ilya, > > thnx for replay, I think that Ignite CURRENT_TIMESTAMP() is NOT TIMESTAMP > WITH TIME ZONE. > > Below it test with inserting CURRENT_TIMESTAMP in two tables, one with data > type TIMESTAMP and second with TIMESTAMP WITH TIME ZONE. > > First of all, > in Ignite documentation I can't find that CURRENT_TIMESTAMP() returns > TIMESTAMP WITH TIME ZONE. > > In H2 documentation we can see that H2 have two data types: > TIMESTAMP and TIMESTAMP WITH TIME ZONE > http://www.h2database.com/html/datatypes.html#timestamp_with_time_zone_type > > In H2 CURRENT_TIMESTAMP returns the current timestamp with time zone. > > I think that in Ignite CURRENT_TIMESTAMP is ONLY CURRENT_TIMESTAMP without > TIME ZONE. > > https://apacheignite-sql.readme.io/docs/current_timestamp > > > 0: jdbc:ignite:thin://192.168.50.95/> SELECT CURRENT_TIMESTAMP(); > +--------------------------------+ > | CURRENT_TIMESTAMP() | > +--------------------------------+ > | 2020-04-27 13:59:39.814 | > +--------------------------------+ > > In first table insert of CURRENT_TIMESTAMP() in data type timestamp is OK. > > CREATE TABLE TEST1 > ( > id varchar(10), > time1 timestamp, > PRIMARY KEY (id) > ) WITH "CACHE_NAME=TEST1, DATA_REGION=PersistDataRegion, > TEMPLATE=REPLICATED, BACKUPS=1"; > > 0: jdbc:ignite:thin://192.168.50.95/> INSERT INTO TEST1 (id, time1) values > ('a', CURRENT_TIMESTAMP()); > 1 row affected (0.051 seconds) > > > In second table insert of CURRENT_TIMESTAMP() in data type timestamp with > time zone is NOT OK. > > CREATE TABLE TEST2 > ( > id varchar(10), > time1 timestamp with time zone, > PRIMARY KEY (id) > ) WITH "CACHE_NAME > > > 0: jdbc:ignite:thin://192.168.50.95/> INSERT INTO TEST2 (id, time1) values > ('a', CURRENT_TIMESTAMP()); > Error: class org.apache.ignite.IgniteException: Failed to execute SQL > query. > Hexadecimal string with odd number of characters: "2020-04-27 > 13:59:00.599"; > SQL statement: > SELECT > TABLE.ID, > TABLE.TIME1 > FROM TABLE(ID VARCHAR(10)=('a',), TIME1 OTHER=(CURRENT_TIMESTAMP(),)) > [90003-197] (state=50000,code=1) > java.sql.SQLException: class org.apache.ignite.IgniteException: Failed to > execute SQL query. Hexadecimal string with odd number of characters: > "2020-04-27 13:59:00.599"; SQL statement: > SELECT > TABLE.ID, > TABLE.TIME1 > FROM TABLE(ID VARCHAR(10)=('a',), TIME1 OTHER=(CURRENT_TIMESTAMP(),)) > [90003-197] > at > > org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.sendRequest(JdbcThinConnection.java:750) > at > > org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute0(JdbcThinStatement.java:212) > at > > org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute(JdbcThinStatement.java:475) > at sqlline.Commands.execute(Commands.java:823) > at sqlline.Commands.sql(Commands.java:733) > at sqlline.SqlLine.dispatch(SqlLine.java:795) > at sqlline.SqlLine.begin(SqlLine.java:668) > at sqlline.SqlLine.start(SqlLine.java:373) > at sqlline.SqlLine.main(SqlLine.java:265) > > > Please, do you know why I can't insert CURRENT_TIMESTAMP() in data type > timestamp with time zone. > > > Best regards > > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >
