You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Swaroopa Kadam (JIRA)" <ji...@apache.org> on 2019/07/16 21:05:00 UTC
[jira] [Assigned] (PHOENIX-675) Support specifying index details at
the time of CREATE TABLE query
[ https://issues.apache.org/jira/browse/PHOENIX-675?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Swaroopa Kadam reassigned PHOENIX-675:
--------------------------------------
Assignee: (was: 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: Tony Stevenson
>
> 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.14#76016)