phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Swaroopa Kadam (JIRA)" <j...@apache.org>
Subject [jira] [Assigned] (PHOENIX-675) Support specifying index details at the time of CREATE TABLE query
Date Thu, 07 Mar 2019 18:30:01 GMT

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

Swaroopa Kadam reassigned PHOENIX-675:
--------------------------------------

    Assignee: Swaroopa Kadam

> Support specifying index details at the time of CREATE TABLE query
> ------------------------------------------------------------------
>
>                 Key: PHOENIX-675
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-675
>             Project: Phoenix
>          Issue Type: Task
>            Reporter: chrajeshbabu
>            Assignee: Swaroopa Kadam
>
> We can support specifying index details during table creation as well(which is supported
in some databases). This also helps in Hindex integration where we can avoid unnecessary disable
and enable of table every time while creating index.
> Ex:
> CREATE TABLE test (
>     id         INT NOT NULL,
>     last_name  CHAR(30) NOT NULL,
>     first_name CHAR(30) NOT NULL,
>     PRIMARY KEY (id),
>     INDEX name (last_name,first_name)
> );



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message