Return-Path: Delivered-To: apmail-hadoop-hive-dev-archive@locus.apache.org Received: (qmail 32825 invoked from network); 28 Nov 2008 22:39:05 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 28 Nov 2008 22:39:05 -0000 Received: (qmail 6923 invoked by uid 500); 28 Nov 2008 22:39:16 -0000 Delivered-To: apmail-hadoop-hive-dev-archive@hadoop.apache.org Received: (qmail 6896 invoked by uid 500); 28 Nov 2008 22:39:16 -0000 Mailing-List: contact hive-dev-help@hadoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: hive-dev@hadoop.apache.org Delivered-To: mailing list hive-dev@hadoop.apache.org Received: (qmail 6885 invoked by uid 99); 28 Nov 2008 22:39:16 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 28 Nov 2008 14:39:16 -0800 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.140] (HELO brutus.apache.org) (140.211.11.140) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 28 Nov 2008 22:37:57 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 967E9234C2A2 for ; Fri, 28 Nov 2008 14:38:44 -0800 (PST) Message-ID: <106914128.1227911924615.JavaMail.jira@brutus> Date: Fri, 28 Nov 2008 14:38:44 -0800 (PST) From: "David Phillips (JIRA)" To: hive-dev@hadoop.apache.org Subject: [jira] Commented: (HIVE-31) Hive: support CREATE TABLE xxx SELECT yyy.* FROM yyy MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/HIVE-31?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12651676#action_12651676 ] David Phillips commented on HIVE-31: ------------------------------------ This is commonly known as "CREATE TABLE AS SELECT" or "CTAS". Do we want to require the "AS" keyword? MySQL: optional Oracle: required PostgreSQL: required SQLite: required > Hive: support CREATE TABLE xxx SELECT yyy.* FROM yyy > ---------------------------------------------------- > > Key: HIVE-31 > URL: https://issues.apache.org/jira/browse/HIVE-31 > Project: Hadoop Hive > Issue Type: Bug > Reporter: Zheng Shao > > We should allow users to create a table using query result, without specifying the column names and column types. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.