From dev-return-56880-archive-asf-public=cust-asf.ponee.io@phoenix.apache.org Thu Jun 6 11:28:03 2019 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [207.244.88.153]) by mx-eu-01.ponee.io (Postfix) with SMTP id AF4F8180763 for ; Thu, 6 Jun 2019 13:28:02 +0200 (CEST) Received: (qmail 75335 invoked by uid 500); 6 Jun 2019 11:28:02 -0000 Mailing-List: contact dev-help@phoenix.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@phoenix.apache.org Delivered-To: mailing list dev@phoenix.apache.org Received: (qmail 75324 invoked by uid 99); 6 Jun 2019 11:28:01 -0000 Received: from mailrelay1-us-west.apache.org (HELO mailrelay1-us-west.apache.org) (209.188.14.139) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 06 Jun 2019 11:28:01 +0000 Received: from jira-lw-us.apache.org (unknown [207.244.88.139]) by mailrelay1-us-west.apache.org (ASF Mail Server at mailrelay1-us-west.apache.org) with ESMTP id 197E3E2D2D for ; Thu, 6 Jun 2019 11:28:01 +0000 (UTC) Received: from jira-lw-us.apache.org (localhost [127.0.0.1]) by jira-lw-us.apache.org (ASF Mail Server at jira-lw-us.apache.org) with ESMTP id 28432245A6 for ; Thu, 6 Jun 2019 11:28:00 +0000 (UTC) Date: Thu, 6 Jun 2019 11:28:00 +0000 (UTC) From: "Rajeshbabu Chintaguntla (JIRA)" To: dev@phoenix.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Assigned] (PHOENIX-675) Support specifying index details at the time of CREATE TABLE query MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/PHOENIX-675?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rajeshbabu Chintaguntla 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: Tony Stevenson > 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)