[ 
https://issues.apache.org/jira/browse/PHOENIX-2159?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Samarth Jain updated PHOENIX-2159:
----------------------------------
    Attachment: PHOENIX-2159.patch

Patch with the changes.

A column declared as ROW_TIMESTAMP in the CREATE TABLE statement will be used 
for surfacing the HBase cell timestamp.

Below are the examples of supported syntaxes:

- CREATE TABLE T1 
(PK1 VARCHAR *ROW_TIMESTAMP* NOT NULL, 
PK2 VARCHAR NOT NULL,
KV1 VARCHAR 
CONSTRAINT PK PRIMARY KEY(PK1, PK2))

- CREATE TABLE T 
(PK1 VARCHAR *ROW_TIMESTAMP* NOT NULL PRIMARY KEY,
 KV1 VARCHAR)

Restrictions:
- Only primary key column can be declared as ROW_TIMESTAMP
- One one primary key column can be declared as ROW_TIMESTAMP
- A column can be declared as ROW_TIMESTAMP only during the CREATE TABLE time 
i.e. ALTER TABLE ADD <COL_NAME> <DATA_TYPE> ROW_TIMESTAMP is *NOT* allowed


[~jamestaylor] - please review when you get a chance. Thanks!




> Grammar changes and DDL support for surfacing native HBase timestamp
> --------------------------------------------------------------------
>
>                 Key: PHOENIX-2159
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-2159
>             Project: Phoenix
>          Issue Type: Sub-task
>            Reporter: Samarth Jain
>            Assignee: Samarth Jain
>         Attachments: PHOENIX-2159.patch
>
>




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

Reply via email to