[
https://issues.apache.org/jira/browse/PHOENIX-4069?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16119466#comment-16119466
]
Ankit Singhal commented on PHOENIX-4069:
----------------------------------------
It is as per HBase semantics, so if you have row deleted and inserted at the
same timestamp then deleted row will override the inserted row and nothing will
be returned by the scanner.
> When use row timestamp table,del row1 by 'delete from table' , and I get
> failed by upsert row1 into the table.
> -----------------------------------------------------------------------------------------------------------------
>
> Key: PHOENIX-4069
> URL: https://issues.apache.org/jira/browse/PHOENIX-4069
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.10.0
> Reporter: tian.yang
>
> 0: jdbc:phoenix:> CREATE TABLE IF NOT EXISTS T1(
> . . . . . . . . > C_DAY BIGINT NOT NULL,
> . . . . . . . . > C_KEY VARCHAR NOT NULL,
> . . . . . . . . > C_VAL BIGINT
> . . . . . . . . > CONSTRAINT PK_T1 PRIMARY KEY(C_DAY ROW_TIMESTAMP,C_KEY));
> No rows affected (2.467 seconds)
> 0: jdbc:phoenix:> UPSERT INTO T1 (C_DAY,C_KEY,C_VAL) VALUES
> (1502095662895,'A',9);
> 1 row affected (0.013 seconds)
> 0: jdbc:phoenix:> SELECT * FROM T1;
> +----------------+--------+--------+
> | C_DAY | C_KEY | C_VAL |
> +----------------+--------+--------+
> | 1502095662895 | A | 9 |
> +----------------+--------+--------+
> 1 row selected (0.029 seconds)
> 0: jdbc:phoenix:> DELETE FROM T1;
> 1 row affected (0.011 seconds)
> 0: jdbc:phoenix:> SELECT * FROM T1;
> +--------+--------+--------+
> | C_DAY | C_KEY | C_VAL |
> +--------+--------+--------+
> +--------+--------+--------+
> No rows selected (0.028 seconds)
> 0: jdbc:phoenix:> UPSERT INTO T1 (C_DAY,C_KEY,C_VAL) VALUES
> (1502095662895,'A',9);
> 1 row affected (0.009 seconds)
> 0: jdbc:phoenix:> SELECT * FROM T1;
> +--------+--------+--------+
> | C_DAY | C_KEY | C_VAL |
> +--------+--------+--------+
> +--------+--------+--------+
> No rows selected (0.027 seconds)
> 0: jdbc:phoenix:>
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
