Return-Path: Delivered-To: apmail-hadoop-hive-dev-archive@minotaur.apache.org Received: (qmail 85081 invoked from network); 18 Feb 2010 19:42:58 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 18 Feb 2010 19:42:58 -0000 Received: (qmail 99135 invoked by uid 500); 18 Feb 2010 19:42:57 -0000 Delivered-To: apmail-hadoop-hive-dev-archive@hadoop.apache.org Received: (qmail 99082 invoked by uid 500); 18 Feb 2010 19:42:57 -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 99072 invoked by uid 99); 18 Feb 2010 19:42:57 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 18 Feb 2010 19:42:57 +0000 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; Thu, 18 Feb 2010 19:42:48 +0000 Received: from brutus.apache.org (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id E0AA529A0016 for ; Thu, 18 Feb 2010 11:42:27 -0800 (PST) Message-ID: <1380319562.367191266522147918.JavaMail.jira@brutus.apache.org> Date: Thu, 18 Feb 2010 19:42:27 +0000 (UTC) From: "Carl Steinbach (JIRA)" To: hive-dev@hadoop.apache.org Subject: [jira] Commented: (HIVE-1180) Support Common Table Expressions (CTEs) in Hive In-Reply-To: <1865479488.366681266521427925.JavaMail.jira@brutus.apache.org> 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/HIVE-1180?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12835361#action_12835361 ] Carl Steinbach commented on HIVE-1180: -------------------------------------- [PostgreSQL's CTE Readme | http://wiki.postgresql.org/wiki/CTEReadme] > Support Common Table Expressions (CTEs) in Hive > ----------------------------------------------- > > Key: HIVE-1180 > URL: https://issues.apache.org/jira/browse/HIVE-1180 > Project: Hadoop Hive > Issue Type: Improvement > Components: Query Processor > Reporter: Jeff Hammerbacher > > I've seen some presentations from the PostgreSQL recently expounding the utility of CTEs (http://en.wikipedia.org/wiki/Common_table_expressions). Should we try to support these in Hive? I've never used them in practice, so curious to hear if the community would find them useful. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.