Return-Path: X-Original-To: apmail-hive-dev-archive@www.apache.org Delivered-To: apmail-hive-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 6B3EA9B3B for ; Mon, 24 Dec 2012 02:06:13 +0000 (UTC) Received: (qmail 11593 invoked by uid 500); 24 Dec 2012 02:06:12 -0000 Delivered-To: apmail-hive-dev-archive@hive.apache.org Received: (qmail 11536 invoked by uid 500); 24 Dec 2012 02:06:12 -0000 Mailing-List: contact dev-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@hive.apache.org Delivered-To: mailing list dev@hive.apache.org Received: (qmail 11526 invoked by uid 500); 24 Dec 2012 02:06:12 -0000 Delivered-To: apmail-hadoop-hive-dev@hadoop.apache.org Received: (qmail 11522 invoked by uid 99); 24 Dec 2012 02:06:12 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 24 Dec 2012 02:06:12 +0000 Date: Mon, 24 Dec 2012 02:06:12 +0000 (UTC) From: "Zhenxiao Luo (JIRA)" To: hive-dev@hadoop.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Created] (HIVE-3834) Support hive: alter view ... as .. MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 Zhenxiao Luo created HIVE-3834: ---------------------------------- Summary: Support hive: alter view ... as .. Key: HIVE-3834 URL: https://issues.apache.org/jira/browse/HIVE-3834 Project: Hive Issue Type: New Feature Reporter: Zhenxiao Luo Assignee: Zhenxiao Luo Hive supports "alter view" on setting property, add/drop partition etc but not "as". If you want to change "as" part, you have to drop view, recreate it and backfill partition etc. pretty painful. It will be nice to support this. The reference is mysql syntax http://dev.mysql.com/doc/refman/5.0/en/alter-view.html -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira