From dev-return-56878-archive-asf-public=cust-asf.ponee.io@phoenix.apache.org Thu Jun 6 11:21:06 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 E75ED18062B for ; Thu, 6 Jun 2019 13:21:05 +0200 (CEST) Received: (qmail 70442 invoked by uid 500); 6 Jun 2019 11:21:01 -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 70427 invoked by uid 99); 6 Jun 2019 11:21: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:21: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 E23ABE2D22 for ; Thu, 6 Jun 2019 11:21:00 +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 4549A245A6 for ; Thu, 6 Jun 2019 11:21:00 +0000 (UTC) Date: Thu, 6 Jun 2019 11:21:00 +0000 (UTC) From: "Rajeshbabu Chintaguntla (JIRA)" To: dev@phoenix.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (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 updated PHOENIX-675: -------------------------------------------- Reporter: huchen (was: chrajeshbabu) > 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: huchen > > 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)